how to keep old data record while updating asp .net mvc 5

asp.net-mvc c# database entity-framework-6 sql-server

Question

I am creating a financial application using with Asp .net mvc5 with EF6.I have a big puzzle about updating database. What I want is that I have Person table (e.g. firstname, lastname, address, salary, tax, and so on). For the first time, I entered a record (e.g. John, Smith, US, 3500.00,). When John Smith gets promotion, I will update his salary as 4000.00 while I am still wanting to keep his old salary 3500.00. If I don't keep his 3500.00, his tax and other deductible fees from his 3500.00 salary won't reflect correctly upto the last day that he earned 3500.00. Data of his tax all along getting 3500.00 will lose and will reflect based on 4000.00.

Can anyone guide me on how to solve this, please? Appreciate if you can share any resources or links that I can study for this kind of problem. Thank in advance.

1
0
4/22/2015 5:58:18 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

you need to create a table corresponding to the main table Person lets call it Person_log (e.g. firstname, lastname, address, salary, tax,Entry_Date_On_Log and so on)

Process 1:

create a trigger for insert,update and insert record to the Person_log table on insert and every update on Person table.

Process 2:

you can manually(using query code) enter the records to the Person_log table on every and each entry to the Person table.

Now, whenever you want to calculate the Tax or anything else corresponding to a date for a Person, you can easily find the Salary or any other records for a Person from Person_log table using the Date filter(Entry_Date_On_Log).

1
4/22/2015 5:34:04 AM

Related Questions

Populating multiselect list with data MVC 3 .NET

I have been searching a lot on Google and Stackoverflow for soltuions on how to Populate a Multiselect box with values that can be selected. But no luck....public class PriceObj { public int ID { get; set; } public decimal Price { get; set; } public string Name { get; set; } public string Description { get; set; } public virtual...
asp.net asp.net-mvc c# entity-framework sql-server
asked by Gunnar

ASP .NET MVC 4: WebSecurity.CreateUserAndAccount how to set UserId

Yes, you would do this by passing in the properties to set. For example:...WebSecurity.CreateUserAndAccount("elena", "password", new { UserId = 1 }); ...Of course, you would need to make sure the UserId column was not set to be an identity column, and you would have to change your UsersContext schema to add that as well....[Table("UserProfile")] p...
.net asp.net-mvc entity-framework
asked by Erik Funkenbusch

C# - MVC application How to update and delete a record from the database

Delete...myEntities.Friend.Remove(f); myEntities.SaveChanges(); ...Update...Friend f = myEntities.Friend.FirstOrDefault(x => x.Id = MyId); f.Name = NewName; myEntities.SaveChanges();
asp.net asp.net-mvc c# ef-code-first entity-framework
asked by Alexandr Sulimov

How to create SecurityStamp for AspNetUser in ASP .NET MVC 5

The security stamp can be anything you want. It is often mistaken to be a timestamp, but it is not. It will be overriden by ASP.NET Identity if something changes on the user entity. If you're working on the context directly the best way would to generate a new Guid and use it as the stamp. Here's a simple example:...var users = new List<Application...
asp.net-identity asp.net-mvc c# entity-framework seed
asked by Horizon_Net

How to Update/Edit multiple records using Entity Framework in ASP.NET MVC

I need to update multiple records, this is how far I could get...First, I tried this...foreach (var Product in Products) { Product.Price = Price; db.Entry(Product).State = EntityState.Modified; db.SaveChanges(); } ...But, I'm getting this error...Store update, insert, or delete statement affected an unexpected number of rows (0). E...
asp.net-mvc c# entity-framework
asked by Ahmed

Updating the Record with EntityState.Modified but its inserting the new row rather than update

This is happening because Entity Framework is "unaware" of this entity of yours. You are passing just a view model and even though you know it has a PK or FK, there's no way EF knows what to do, so it creates a new one. See that you create a ...new Product()...? This line, creates a new Product and since it is new, EF will treat its state as Added....
c# entity-framework-6
asked by jpgrassi

Update db record in foreach loop with Entity Framework in asp.net mvc 6

I know there are similar questions, but in my case something is wrong. Just trying to update each row, but it does nothing for some reason and no errors. ...Thanks....public ActionResult Index() { using (var db = new DoskaUsContext()) { foreach (var category in db.Categories) { category.Count = 25; db...
asp.net asp.net-mvc c# entity-framework entity-framework-6
asked by Igor Levashov

How to avoid update conflict when updating the same record at the same time

Read more about Retry Pattern (...here... is my post about it). With it you can detect conflicts and make a desicion what to do (rewrite, merge or throw error to user)....Example of usage:...var retryCount = 3; var currentRetry = 0; using (var context = new DbContext(ConnectionString)) { var user = context.Set<User>().First(o => o.Id == 1); ...
asp.net c# entity-framework entity-framework-6 sql-server
asked by Backs

How to update multiple models at the same time in ASP.NET MVC 5 Entity Framework

I think Umesh answer is correct. After changing your loop, how are you setting your Html.TextBoxFor, HiddenFor and so on?...It should be:...@Html.HiddenFor(m => m.ContentFields[i].Id)
asp.net-mvc entity-framework-6
asked by Emanuele Buccelli

Update Record by using ajax in Entity Framework MVC

I have solved my problem. I was updating my data in wrong variable i.e. ...upFirstName... & ...upLastName.... That was my mistake. I should update my data in same variable i.e. ...FirstName... & ...LastName.... Just write below code...var student = { "FirstName" : $("#name").val(), "LastName" : $("#lname").val(), } ...Instead of this....
ajax asp.net-ajax asp.net-mvc entity-framework-4 entity-framework-6
asked by nabia saroosh

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow