public JsonResult addSellsOrderItems(SellsOrderItems soi)
{
//Adding the SellsOrderItems
soiAdd.addSellsOrderItems(soi);
var response = " Sucessfully Save SellsOrderItems No : " + soi.Invoice_Id;
return(Json(response, JsonRequestBehavior.AllowGet));
}
public void updateSellsOrderItems(SellsOrderItems soi)
{
string command = "dbo.spInsertProductType";
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Invoice_Id", soi.Invoice_Id);
param[1] = new SqlParameter("@product_Id", soi.product_Id);
param[2] = new SqlParameter("@quantity", soi.quantity);
param[3] = new SqlParameter("@unit_price", soi.unit_price);
param[4] = new SqlParameter("@discount_price", soi.discount_price);
param[5] = new SqlParameter("@total_ammount", soi.total_price);
param[6] = new SqlParameter("@CreatedAt", soi.CreatedAt);
da.InsertSP(param, command);
}
public void addSellsOrderItems(SellsOrderItems soi)
{
string command = "dbo.spInsertSellOrderItems";
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Invoice_Id", soi.Invoice_Id);
param[1] = new SqlParameter("@Invoice_number", soi.Invoice_number);
param[2] = new SqlParameter("@product_id", soi.product_Id);
param[3] = new SqlParameter("@quantity", soi.quantity);
param[4] = new SqlParameter("@unit_price", soi.unit_price);
param[5] = new SqlParameter("@discount_price", soi.discount_price);
param[6] = new SqlParameter("@total_ammount", soi.total_price);
da.InsertSP(param, command);
}