public IHttpActionResult Insert(Rp3.Test.Common.Models.Transaction transaction) { //Complete the code using (DataService service = new DataService()) { Rp3.Test.Data.Models.Transaction model = new Test.Data.Models.Transaction(); model.TransactionId = service.Transactions.GetMaxValue <int>(p => p.TransactionId, 0) + 1; service.Transactions.Insert(model); service.SaveChanges(); } return(Ok()); }
public IHttpActionResult Delete(int id) { //Complete the code using (DataService service = new DataService()) { Rp3.Test.Data.Models.Transaction model = new Test.Data.Models.Transaction { TransactionId = id }; service.Transactions.Delete(model); service.SaveChanges(); } return(Ok()); }
public IHttpActionResult Insert(Rp3.Test.Common.Models.Transaction transaction) { //Complete the code using (DataService service = new DataService()) { Rp3.Test.Data.Models.Transaction model = new Test.Data.Models.Transaction(); model.TransactionTypeId = transaction.TransactionTypeId; model.CategoryId = transaction.CategoryId; model.AccountId = transaction.AccountId; model.RegisterDate = DateTime.Now; model.ShortDescription = transaction.ShortDescription; model.Amount = transaction.Amount; model.Notes = transaction.Notes; model.TransactionId = service.Transactions.GetMaxValue <int>(p => p.TransactionId, 0) + 1; service.Transactions.Insert(model); service.SaveChanges(); } return(Ok(true)); }
public IHttpActionResult Update(Rp3.Test.Common.Models.Transaction transaction) { using (DataService service = new DataService()) { Rp3.Test.Data.Models.Transaction transactionModel = new Test.Data.Models.Transaction(); transactionModel.RegisterDate = transaction.RegisterDate; transactionModel.Amount = transaction.Amount; transactionModel.Notes = transaction.Notes; transactionModel.TransactionTypeId = transaction.TransactionTypeId; transactionModel.CategoryId = transaction.CategoryId; transactionModel.TransactionId = transaction.TransactionId; transactionModel.ShortDescription = transaction.ShortDescription; transactionModel.DateUpdate = transaction.DateUpdate; transactionModel.UserId = transaction.UserId; service.Transactions.Update(transactionModel); service.SaveChanges(); } return(Ok(true)); }