Inserting data into two database tables through Table tbody

Hamza Shah

What I'm trying to do is when I select number of products from dropdown it appears in below table. Now when I click Save button below the table, I want data to be inserted in two Database table i.e Sales and SaleItems. Well Data is inserting in Sales table but I don't know how to insert in another table SaleItems. Please help me how can I do that?

Here's my code

"table" class="table">
"col">Product Id
"col">Company
"col">Product Name
"col">User Name
"col">User Mobile
"col">Price per product
"col">Quantity
"col">Total Price
"2">Grand Total : "GrandTotal">

3 Replies

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

Sachin Singh5y ago
when you have done at one place then why not the apply the same for other
$(".table tbody tr").each(function () {
var row = $(this);
var Sale = {};
var SaleItem={};
Sale.UserName = row.find("td").eq(3).html();
Sale.UserMobile = row.find("td").eq(4).html();
Sale.NetTotal = row.find("td").eq(8).html();
Sale.ProductQuantity = row.find("td").eq(5).val();
sales.push(Sale);





SaleItem.ProductId= row.find("td").eq(0).html();
----
-----
SaleItems.Push(SaleItems);
});
The one thing left is SaleId that you will get in Action After adding Sales
public void Save(SalesVM model)
{
    List sales=model.sales;
    List items=new SaleItems();
_Context.Sales.AddRange(sales);
    _Context.SaveChanges();
var SaleIds = Sales.Select(x => x.Id).Tolist();
int Counter=0;
    Foreach(var item in model.saleItems)
    {
        SaleItem si=new SaleItem();
        si.SaleId=  SaleIds[counter];
        si.ProductName=model.SaleItems.ProductName;
        ____---

        items.Add(si);
        Counter++;
    }
    _Context.SalesItems.AddRange(items);
    Context.SaveChanges();

}
Hamza Shah5y ago
Sachin sir i want to add following values in SaleItems
1.SaleId
2. ProductId
3.ProductQuantity
4.ProductName

So how can add these?
Sachin Singh5y ago
Your complete code should look like below
$("body").on("click", "#btnSave", function () {
//Loop through the Table rows and build a JSON array.
var sales = new Array();
$(".table tbody tr").each(function () {
var row = $(this);
var Sale = {};
Sale.UserName = row.find("td").eq(3).html();
Sale.UserMobile = row.find("td").eq(4).html();
Sale.NetTotal = row.find("td").eq(8).html();
Sale.ProductQuantity = row.find("td").eq(5).val();
sales.push(Sale);
});
var model = {
            sales:sales
        };
        $.ajax({
            type: "post",
            url:"/home/Save",
            dataType: "json",
            contentType: "application/json;charset=utf-8",
            data: JSON.stringify(model),
            traditional: true,
            cache: false,
            success:function(){}
        })
})

public class SalesVM
{
    public List Sales { get; set; }
}

public class Sale
{
    public string UserName{ get; set; }
    public int UserMobile{ get; set; }
    public int NetTotal{ get; set; }
    public int ProductQuantity{ get; set; }
}

public void Save(SalesVM model)
{
    List sales=model.sales;
    List items=new SaleItems();
    Foreach(var item in model.sales)
    {
        SaleItem si=new SaleItem();
        si.UserName=item.UserName;
        si.UserMobile=item.UserMobile;
        si.NetTotal=item.NetTotal;
        si.ProductQuantity=item.ProductQuantity;

        items.Add(si);
    }
    _Context.SalesItems.AddRange(items);
    Context.SaveChanges();
     _Context.Sales.AddRange(sales);
    _Context.SaveChanges();
}