Save query is not working

Question

Hello Team I have CreatedBy column in sales table which suppose to save userId in CreatedBy column anytime data save but is not working public JsonResult SaveInvoiceSale(tblSale sale List salesDetail) { MasterMVCPOS.Helper.AppHelper.ReturnMessage retMessage = new AppHelper.ReturnMessage(); ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities(); retMessage.IsSuccess = true; foreach (var item in salesDetail) { sale.tblSalesDetails.Add(new tblSalesDetail { ProductId = item.ProductId UnitPrice = item.UnitPrice Quantity = item.Quantity LineTotal = item.LineTotal }); var prd = db.tblProductStocks.Where(x => x.ProductId == item.ProductId && x.Quantity > 0).FirstOrDefault(); prd.Quantity = prd.Quantity - item.Quantity; db.Entry(prd).State = EntityState.Modified; } db.tblSales.Add(sale); retMessage.Message = Save successfully!; try { db.SaveChanges(); retMessage.Data = Convert.ToString(sale.SalesId); } catch (Exception) { retMessage.IsSuccess = false; } return Json(retMessage JsonRequestBehavior.AllowGet); }

Vishal Joshi · Answer

Hello The code looks good for saving the data. you might need to check the class definition and property declaration. try to add a debugger and check the detail error. I think when you have added a new property called CreatedBy it got duplicated in the class definition and now it's stopped working. It might be missed when updating the entity framework. Thanks Vishal Joshi

Emmmanuel FIADUFE · Answer

Thank you team things are working now due to key duplication

Jayraj Chhaya · Answer

Problem The issue reported is that the CreatedBy column in the tblSale table is not being populated with the userId when data is saved. Cause I noticed that no code snippet assigns the userId to the CreatedBy column in the tblSale table. This is the reason why the column remains empty. Solution To fix this issue you need to modify the code to assign the userId to the CreatedBy column in the tblSale table. Assuming you have access to the userId value you can add the following line of code before saving the sale object: sale.CreatedBy = userId; Make sure to replace userId with the actual value of the user ID. Here's the updated code: public JsonResult SaveInvoiceSale(tblSale sale List salesDetail) { MasterMVCPOS.Helper.AppHelper.ReturnMessage retMessage = new AppHelper.ReturnMessage(); ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities(); retMessage.IsSuccess = true; foreach (var item in salesDetail) { sale.tblSalesDetails.Add(new tblSalesDetail { ProductId = item.ProductId UnitPrice = item.UnitPrice Quantity = item.Quantity LineTotal = item.LineTotal }); var prd = db.tblProductStocks.Where(x => x.ProductId == item.ProductId && x.Quantity > 0).FirstOrDefault(); prd.Quantity = prd.Quantity - item.Quantity; db.Entry(prd).State = EntityState.Modified; } // Assign the userId to the CreatedBy column sale.CreatedBy = userId; db.tblSales.Add(sale); retMessage.Message = Save successfully!; try { db.SaveChanges(); retMessage.Data = Convert.ToString(sale.SalesId); } catch (Exception) { retMessage.IsSuccess = false; } return Json(retMessage JsonRequestBehavior.AllowGet); }