public ActionResult ClosingdayConfirmation() { decimal Bal = 0; Opening_ClosingDays openclosOBj = new Opening_ClosingDays(); foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString().Equals(DateTime.Now.ToShortDateString()) && !item.isClosed) { Bal = item.Opening_Balance; openclosOBj = item; break; } } foreach (var item in db.Transaction.ToList().Where(m => m.Opening_ClosingDays == openclosOBj)) { if (item.status) { if (item.Debit > 0) { Bal -= item.Debit; } else if (item.Credit > 0) { Bal += item.Credit; } } } return(View(Bal)); }
public ActionResult AddInitialOpenningDay(Opening_ClosingDays obj) { obj.Closing_Balance = 0; obj.Date = DateTime.Now; obj.isClosed = false; obj.status = true; db.Opening_ClosingDays.Add(obj); db.SaveChanges(); return(RedirectToAction("Index", "Factories")); }
public ActionResult ViewTransactionByOpeningDay(int id) { Opening_ClosingDays opcd = db.Opening_ClosingDays.Find(id); if (opcd != null) { return(View(db.Transaction.Where(m => m.Opening_ClosingDays.Opening_ClosingDays_id == opcd.Opening_ClosingDays_id).ToList())); } else { return(HttpNotFound()); } }
public ActionResult ClosingdayConfirmation(FormCollection form) { if (form["Yes"] != null) { decimal Bal = 0; Opening_ClosingDays openclosOBj = null; foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString().Equals(DateTime.Now.ToShortDateString()) && !item.isClosed) { Bal = item.Opening_Balance; openclosOBj = item; break; } } if (openclosOBj != null) { foreach (var item in db.Transaction.ToList().Where(m => m.Opening_ClosingDays == openclosOBj)) { if (item.status) { if (item.Debit > 0) { Bal -= item.Debit; } else if (item.Credit > 0) { Bal += item.Credit; } } } openclosOBj.Closing_Balance = Bal; openclosOBj.isClosed = true; db.Entry(openclosOBj).State = EntityState.Modified; db.SaveChanges(); Opening_ClosingDays newDay = new Opening_ClosingDays(); newDay.Closing_Balance = 0; newDay.Date = DateTime.Now; newDay.isClosed = false; newDay.Opening_Balance = Bal; newDay.status = true; db.Opening_ClosingDays.Add(newDay); db.SaveChanges(); } } return(RedirectToAction("ViewToday", "Transaction")); }
public ActionResult ViewToday() { var transactions = new List <Transaction>(); Opening_ClosingDays openclosOBj = new Opening_ClosingDays(); foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString().Equals(DateTime.Now.ToShortDateString()) && !item.isClosed) { openclosOBj = item; break; } } foreach (var item in db.Transaction.ToList().Where(m => m.Opening_ClosingDays == openclosOBj).OrderByDescending(m => m.Transaction_DateTime)) { if (item.status) { transactions.Add(item); } } return(View(transactions)); }
public JsonResult CheckIntialOpening() { var Opening_ClosingDays = db.Opening_ClosingDays.ToList(); if (Opening_ClosingDays.Count() == 0) { return(Json(1, JsonRequestBehavior.AllowGet)); } bool day_det = false; foreach (var item in Opening_ClosingDays) { if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed) { day_det = true; break; } } if (!day_det) { decimal Bal = 0; Opening_ClosingDays openclosOBj = db.Opening_ClosingDays.Find(Opening_ClosingDays.Max(m => m.Opening_ClosingDays_id)); if (openclosOBj != null && !openclosOBj.isClosed) { Bal = openclosOBj.Opening_Balance; foreach (var item in db.Transaction.ToList().Where(m => m.Opening_ClosingDays == openclosOBj)) { if (item.status) { if (item.Debit > 0) { Bal -= item.Debit; } else if (item.Credit > 0) { Bal += item.Credit; } } } openclosOBj.Closing_Balance = Bal; openclosOBj.isClosed = true; db.Entry(openclosOBj).State = EntityState.Modified; db.SaveChanges(); Opening_ClosingDays newDay = new Opening_ClosingDays(); newDay.Closing_Balance = 0; newDay.Date = DateTime.Now; newDay.isClosed = false; newDay.Opening_Balance = Bal; newDay.status = true; db.Opening_ClosingDays.Add(newDay); db.SaveChanges(); } else { return(Json(1, JsonRequestBehavior.AllowGet)); } } return(Json(0, JsonRequestBehavior.AllowGet)); }