public JsonResult SerializeFormData(FormCollection _collection, string Total, string Discount, string GrandTotal)
{
if (_collection != null)
{
string[] _stockID, _qty, _rate, _amt;
//for salesItem
_stockID = _collection["StockID"].Split(',');
_qty = _collection["Qty"].Split(',');
_rate = _collection["Rate"].Split(',');
_amt = _collection["Amount"].Split(',');
//for sales
decimal _total = Convert.ToDecimal(Total);
decimal _discount = Convert.ToDecimal(Discount);
decimal _grandTotal = Convert.ToDecimal(GrandTotal);
DateTime _date = DateTime.Now;
//instance of the global class
// MvcApplication app = new MvcApplication();
DataAccess.Sale _sales = new DataAccess.Sale()
{
Date = _date,
Amount = _total,
Discount = _discount,
GrandTotal = _grandTotal,
Tax = 0,
SaleUser = User.Identity.Name,
Remarks = "-"
};
//insert into sales, sales-items, stock
int salesID = slsrepo.InsertSales(_sales);
slsrepo.InsertSalesItem(salesID, _stockID, _qty, _rate, _amt);
slsrepo.UpdateStock(_stockID, _qty);
return(Json(salesID));
}
return(Json("null"));
}
public int InsertSales(Sales _sales)
{
return(repo.InsertSales(_sales));
}