public ActionResult NewSale(FormCollection form)
{
var user = User.Identity;
var a = 0;
var salesHead = new Sales_Header();
var sellerName = context.Users.Find(user.GetUserId()).UserName;
var buyerName = context.Users.Find(user.GetUserId()).UserName;
salesHead.Sale_Date = DateTime.Now;
salesHead.Seller_Id = user.GetUserId();
salesHead.Seller_Name = sellerName;
salesHead.Buyer_Name = buyerName;
context.Sales_Headers.Add(salesHead);
context.SaveChanges();
a = 1;
//Sale Detail Process
string[] itemNamesArr, itemPrcsArr, itemQtyArr, itemIdArr;
itemNamesArr = form["ItemName"].Split(',');
itemPrcsArr = form["ItemPrice"].Split(',');
itemQtyArr = form["QtyRqstd"].Split(',');
itemIdArr = form["ItemId"].Split(',');
var itemCount = itemNamesArr.Count();
var saleDetail = new Sales_Detail();
var saleDetailList = new List <Sales_Detail>();
for (int i = 0; i < itemCount; i++)
{
saleDetail.ItemName = itemNamesArr[i];
saleDetail.Qty = Convert.ToInt32(itemQtyArr[i]);
saleDetail.Price = Convert.ToDecimal(itemPrcsArr[i]);
saleDetail.Sales_Header_id = salesHead.Id;
saleDetail.Item_id = Convert.ToInt32(itemIdArr[i]);
context.Sales_Details.Add(saleDetail);
context.SaveChanges();
}
a = 2;
return(RedirectToAction("Index", "Users"));
}
public HttpResponseMessage Sale(Sales_Detail sale)
{
try
{
var dt = sale.Sale_Date;
db.Sales_Detail.Add(sale);
var x = db.Items.FirstOrDefault(xn => xn.Item_No == sale.Item_No);
x.Quantity = x.Quantity - sale.Item_Quantity;
db.Entry(x).State = EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, sale));
}catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
