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");
}
}
