public ActionResult UpdateOpeningStock() { var model = new OpeningStockVM(); int companyId = Convert.ToInt32(Session["CompanyID"]); model.Products = db.Products .Where(x => x.IsActive == true && x.Company_Id == companyId) .ToList(); var year_id = Convert.ToInt32(Session["FinancialYearID"]); model.FinancialYear = db.FinancialYears .Where(x => x.Id == year_id) .FirstOrDefault(); model.Transactions = db.Transactions .Where(x => x.FinancialYear_Id == year_id) .ToList(); return(View(model)); }
public ActionResult UpdateOpeningStock(List <Transaction> Transactions) { if (ModelState.IsValid) { try { var CompanyId = Convert.ToInt32(Session["CompanyID"]); var year_id = Convert.ToInt32(Session["FinancialYearID"]); var t = db.Transactions .Where(x => x.FinancialYear_Id == year_id) .ToList(); foreach (var item in Transactions) { var product = t .Where(x => x.product_id == item.product_id) .Where(x => x.FinancialYear_Id == year_id) .FirstOrDefault(); if (product == null) { db.Transactions.Add(new Transaction() { product_id = item.product_id, Type = "opening stock", FinancialYear_Id = year_id, Company_Id = CompanyId, Created = DateTime.Now, Updated = DateTime.Now, Quantity = item.Quantity }); } else { product.Quantity = item.Quantity; product.Updated = DateTime.Now; db.Entry(product).State = EntityState.Modified; } } db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { } } var model = new OpeningStockVM(); int companyId = Convert.ToInt32(Session["CompanyID"]); model.Products = db.Products .Where(x => x.IsActive == true && x.Company_Id == companyId) .ToList(); var yid = Convert.ToInt32(Session["FinancialYearID"]); model.FinancialYear = db.FinancialYears .Where(x => x.Id == yid) .FirstOrDefault(); model.Transactions = db.Transactions .Where(x => x.FinancialYear_Id == yid) .ToList(); return(View(model)); }