How to load value of last employeeid + 1 in add action

Question

0.00/5 (No votes)

See more:

, +

I have controller name emp have action add
i need when action add view loaded display last value increased by one in employeeid textbox
meaning suppose i have in datbase employeeid 1 then when action add view loaded employeeid must have 2
so that how to do that please ?
in action what i write
[httpget]

 public IActionResult Create()
        {
what i write here
}
on view add 
what i write

What I have tried:

<pre>  var results = _context.GetAll().Where(Employee => Employee.EmployeeId> Employee.EmployeeId).OrderBy(Employee => Employee.EmployeeId).FirstOrDefault();

Posted 6-Jan-19 16:55pm

ahmed_sa

Updated 6-Jan-19 20:21pm

Add a Solution

Comments

Bryian Tan 6-Jan-19 23:36pm

Just curious, employeeId not auto increment in the table?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2019-01-06T17:51:00

If the idea is to define a value for a key for a new record in the database, normally the application does not do this. Instead the database assigns the key when a record is added.

For example if two users are adding a row at the same time, based on your code they could try to use the same ID value for an employee. This would result into key violation or to a duplicate record, depending on your schema definitions.

If this is a SQL Server application, you could utilize IDENTITY (Property) (Transact-SQL) - SQL Server | Microsoft Docs[^] for the Id column to define it as auto-incremented. After the insert, you can get the inserted calue using @@IDENTITY (Transact-SQL) - SQL Server | Microsoft Docs[^]

Patrice T · Answer 2 · 2019-01-06T20:21:00

Quote:
How to load value of last employeeid + 1 in add action

The whole idea is wrong because an SQL server is multi-user, and if 2 users are adding a new employee at same time, both are ending with same new id.
The only solution is to have the server generate the new id.
this specific request is done by make the id 'auto increment'
SQL AUTO INCREMENT a Field[^]

How to load value of last employeeid + 1 in add action

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0