public ActionResult Create_Tally_Sheet(Tally_SheetModel tally_sheetModel) { Tally_Sheet_Details tally_sheet_details = new Tally_Sheet_Details(); var tally_sheet_id = Convert.ToInt32(Session["tally_sheet_id"]); if (ModelState.IsValid) { tally_sheet_details.tally_sheet_id = tally_sheet_id; tally_sheet_details.way_bill_code = tally_sheetModel.way_bill_code; tally_sheet_details.goods_name = tally_sheetModel.goods; tally_sheet_details.units = tally_sheetModel.units; tally_sheet_details.quantity = tally_sheetModel.quantity; tally_sheet_details.unit_of_measure = tally_sheetModel.unit_of_measure; tally_sheet_details.total_quantity = tally_sheetModel.total_quantity; db.Tally_Sheet_Details.Add(tally_sheet_details); db.SaveChanges(); return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_id }); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_id }); }
public ActionResult DbSearchresult(Tally_SheetModel tally_sheet) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(38)) { //Queue q = new Queue(); if (tally_sheet.ship_arrival_code != null && tally_sheet.tally_sheet_code != null) { var result = (from t in db.E_Tally_Sheet join sd in db.Ship_Departure on t.ship_departure_id equals sd.ship_departure_id join e in db.Employees on t.employee_id equals e.employee_id where sd.ship_departure_code.Contains(tally_sheet.ship_arrival_code) && t.tally_sheet_code.Contains(tally_sheet.tally_sheet_code) select new Tally_SheetModel { tally_sheet_code = t.tally_sheet_code, ship_arrival_code = sd.ship_departure_code, tally_sheet_id = t.tally_sheet_id, employee_name = e.first_name + " " + e.middle_name + " " + e.last_name }).Distinct(); return View("Index", result.ToList()); } else if (tally_sheet.ship_arrival_code != null && tally_sheet.tally_sheet_code == null) { var result = (from t in db.E_Tally_Sheet join sd in db.Ship_Departure on t.ship_departure_id equals sd.ship_departure_id join e in db.Employees on t.employee_id equals e.employee_id where sd.ship_departure_code.Contains(tally_sheet.ship_arrival_code) select new Tally_SheetModel { tally_sheet_code = t.tally_sheet_code, ship_arrival_code = sd.ship_departure_code, tally_sheet_id = t.tally_sheet_id, employee_name = e.first_name + " " + e.middle_name + " " + e.last_name }).Distinct(); return View("Index", result.ToList()); } else if (tally_sheet.ship_arrival_code == null && tally_sheet.tally_sheet_code != null) { var result = (from t in db.E_Tally_Sheet join sd in db.Ship_Departure on t.ship_departure_id equals sd.ship_departure_id join e in db.Employees on t.employee_id equals e.employee_id where t.tally_sheet_code.Contains(tally_sheet.tally_sheet_code) select new Tally_SheetModel { tally_sheet_code = t.tally_sheet_code, ship_arrival_code = sd.ship_departure_code, tally_sheet_id = t.tally_sheet_id, employee_name = e.first_name + " " + e.middle_name + " " + e.last_name }).Distinct(); return View("Index", result.ToList()); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult Edit(Tally_SheetModel tally_sheetModel) { int id = Convert.ToInt32(TempData["id"]); Tally_Sheet_Details tally_sheet_details = new Tally_Sheet_Details(); if (ModelState.IsValid) { tally_sheet_details.tally_sheet_details_id = id; tally_sheet_details.tally_sheet_id = Convert.ToInt32(TempData["tally_sheet_id"]); tally_sheet_details.way_bill_code = tally_sheetModel.way_bill_code; tally_sheet_details.goods_name = tally_sheetModel.goods; tally_sheet_details.units = tally_sheetModel.units; tally_sheet_details.quantity = tally_sheetModel.quantity; tally_sheet_details.unit_of_measure = tally_sheetModel.unit_of_measure; tally_sheet_details.total_quantity = tally_sheetModel.total_quantity; db.Entry(tally_sheet_details).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); }
// // GET: /Manage_Tally_Sheet/Edit/5 public ActionResult Edit(int id = 0) { Tally_Sheet_Details tally_sheet_details = db.Tally_Sheet_Details.Find(id); Tally_SheetModel tally_sheetModel = new Tally_SheetModel(); if (tally_sheet_details == null) { return HttpNotFound(); } var ship_arrival_code = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id join sa in db.Ship_Arrival on t.ship_arrival_id equals sa.ship_arrival_id where td.tally_sheet_details_id == tally_sheet_details.tally_sheet_details_id select new { sa.ship_arrival_id, sa.ship_arrival_code }; ViewBag.ship_arrivals = new SelectList(ship_arrival_code, "ship_arrival_id", "ship_arrival_code"); TempData["id"] = tally_sheet_details.tally_sheet_details_id; TempData["tally_sheet_id"] = tally_sheet_details.tally_sheet_id; var tally_sheet_code = from t in db.Tally_Sheet where t.tally_sheet_id == tally_sheet_details.tally_sheet_id select t.tally_sheet_code; tally_sheetModel.tally_sheet_code = tally_sheet_code.First(); tally_sheetModel.ship_arrival_id = ship_arrival_code.First().ship_arrival_id; tally_sheetModel.way_bill_code = tally_sheet_details.way_bill_code; tally_sheetModel.goods = tally_sheet_details.goods_name; tally_sheetModel.units = tally_sheet_details.units; tally_sheetModel.quantity = tally_sheet_details.quantity; tally_sheetModel.unit_of_measure = tally_sheet_details.unit_of_measure; tally_sheetModel.total_quantity = tally_sheet_details.total_quantity; return View(tally_sheetModel); }
public ActionResult Edit(Tally_SheetModel tally_sheetModel) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(12)) { int id = Convert.ToInt32(TempData["id"]); Tally_Sheet_Details tally_sheet_details = new Tally_Sheet_Details(); if (ModelState.IsValid) { tally_sheet_details.tally_sheet_details_id = id; tally_sheet_details.tally_sheet_id = Convert.ToInt32(TempData["tally_sheet_id"]); tally_sheet_details.way_bill_code = tally_sheetModel.way_bill_code; tally_sheet_details.importer_name = tally_sheetModel.importer_name; tally_sheet_details.goods_name = tally_sheetModel.goods; tally_sheet_details.unit_of_measure = tally_sheetModel.unit_of_measure; tally_sheet_details.total_quantity = tally_sheetModel.total_quantity; tally_sheet_details.is_damaged = tally_sheetModel.is_damaged; db.Entry(tally_sheet_details).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
// // GET: /Manage_Tally_Sheet/Edit/5 public ActionResult Edit(int id = 0) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(12)) { Tally_Sheet_Details tally_sheet_details = db.Tally_Sheet_Details.Find(id); Tally_SheetModel tally_sheetModel = new Tally_SheetModel(); if (tally_sheet_details == null) { return HttpNotFound(); } var ship_arrival_code = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id join sa in db.Ship_Arrival on t.ship_arrival_id equals sa.ship_arrival_id where td.tally_sheet_details_id == tally_sheet_details.tally_sheet_details_id select new { sa.ship_arrival_id, sa.ship_arrival_code, td.importer_name }; ViewBag.ship_arrivals = new SelectList(ship_arrival_code, "ship_arrival_id", "ship_arrival_code"); ViewBag.importer = new SelectList(ship_arrival_code, "importer_name", "importer_name"); TempData["id"] = tally_sheet_details.tally_sheet_details_id; TempData["tally_sheet_id"] = tally_sheet_details.tally_sheet_id; var goods = from g in db.Goods join gt in db.Goods_Type on g.goods_type_id equals gt.goods_type_id join gs in db.Goods_Subcategory on gt.goods_subcategory_id equals gs.goods_subcategory_id join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where g.goods_name == tally_sheet_details.goods_name select new { g.goods_id, g.goods_name, gt.goods_type_id, gt.goods_type_name, gs.goods_subcategory_id, gs.goods_subcategory_name, gc.goods_category_id }; var unit_id = from u in db.Unit_Of_Measure where u.unit_code == tally_sheet_details.unit_of_measure select u; ViewBag.unit_of_measure = new SelectList(unit_id, "unit_code", "unit_code"); ViewBag.subcategories = new SelectList(goods, "goods_subcategory_id", "goods_subcategory_name"); ViewBag.goods_type = new SelectList(goods, "goods_type_id", "goods_type_name"); ViewBag.goods = new SelectList(goods, "goods_name", "goods_name"); ViewBag.categories = new HomeController().Category(); var tally_sheet_code = from t in db.Tally_Sheet where t.tally_sheet_id == tally_sheet_details.tally_sheet_id select t.tally_sheet_code; tally_sheetModel.tally_sheet_code = tally_sheet_code.FirstOrDefault(); tally_sheetModel.ship_arrival_id = ship_arrival_code.FirstOrDefault().ship_arrival_id; tally_sheetModel.way_bill_code = tally_sheet_details.way_bill_code; tally_sheetModel.importer_name = tally_sheet_details.importer_name; tally_sheetModel.goods_category_id = goods.First().goods_category_id; tally_sheetModel.goods_subcategory_id = goods.First().goods_subcategory_id; tally_sheetModel.goods_type_id = goods.First().goods_type_id; tally_sheetModel.goods = tally_sheet_details.goods_name; tally_sheetModel.unit_of_measure = tally_sheet_details.unit_of_measure; tally_sheetModel.total_quantity = Convert.ToInt32(tally_sheet_details.total_quantity); tally_sheetModel.is_damaged = tally_sheet_details.is_damaged; return View(tally_sheetModel); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult DbSearchresult(Tally_SheetModel tally_sheet) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(12)) { //Queue q = new Queue(); if (tally_sheet.ship_arrival_code != null && tally_sheet.tally_sheet_code != null) { var result = (from t in db.Tally_Sheet join sa in db.Ship_Arrival on t.ship_arrival_id equals sa.ship_arrival_id where sa.ship_arrival_code.Contains(tally_sheet.ship_arrival_code) && t.tally_sheet_code.Contains(tally_sheet.tally_sheet_code) select new Tally_SheetModel { tally_sheet_code = t.tally_sheet_code, ship_arrival_code = sa.ship_arrival_code, tally_sheet_id = t.tally_sheet_id }).Distinct(); return View("Index", result.ToList()); } else if (tally_sheet.ship_arrival_code != null && tally_sheet.tally_sheet_code == null) { var result = (from t in db.Tally_Sheet join sa in db.Ship_Arrival on t.ship_arrival_id equals sa.ship_arrival_id where sa.ship_arrival_code.Contains(tally_sheet.ship_arrival_code) select new Tally_SheetModel { tally_sheet_code = t.tally_sheet_code, ship_arrival_code = sa.ship_arrival_code, tally_sheet_id = t.tally_sheet_id }).Distinct(); return View("Index", result.ToList()); } else if (tally_sheet.ship_arrival_code == null && tally_sheet.tally_sheet_code != null) { var result = (from t in db.Tally_Sheet join sa in db.Ship_Arrival on t.ship_arrival_id equals sa.ship_arrival_id where t.tally_sheet_code.Contains(tally_sheet.tally_sheet_code) select new Tally_SheetModel { tally_sheet_code = t.tally_sheet_code, ship_arrival_code = sa.ship_arrival_code, tally_sheet_id = t.tally_sheet_id }).Distinct(); return View("Index", result.ToList()); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }