Save query is not working

Emmmanuel FIADUFE

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);
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi2y ago
Accepted 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
+1
Emmmanuel FIADUFE2y ago
Thank you team, things are working now, due to key duplication
+1

Jayraj Chhaya2y ago

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);
}