public ActionResult Edit(Way_BillModel way_billModel)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(13) || z.Contains(24))
{
Way_Bill_Details way_bill_details = new Way_Bill_Details();
int id = Convert.ToInt32(TempData["id"]);
if (ModelState.IsValid)
{
way_bill_details.way_bill_details_id = id;
way_bill_details.way_bill_id = Convert.ToInt32(TempData["way_bill_id"]);
way_bill_details.goods_id = way_billModel.goods_id;
way_bill_details.unit_of_measure_id = way_billModel.unit_of_measure_id;
way_bill_details.total_quantity = way_billModel.total_quantity;
way_bill_details.currency_id = way_billModel.currency_id;
way_bill_details.is_damaged = way_billModel.is_damaged;
db.Entry(way_bill_details).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Details", new { way_bill_id = way_bill_details.way_bill_id });
}
return RedirectToAction("Details", new { way_bill_id = way_bill_details.way_bill_id });
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
//
// GET: /Manage_Way_Bill/Edit/5
public ActionResult Edit(int id = 0)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(13) || z.Contains(24))
{
Way_Bill_Details way_bill_details = db.Way_Bill_Details.Find(id);
Way_BillModel way_billModel = new Way_BillModel();
if (way_bill_details == null)
{
return HttpNotFound();
}
var import_code = from w in db.Way_Bill
join wd in db.Way_Bill_Details on w.way_bill_id equals wd.way_bill_id
join i in db.Imports on w.import_id equals i.import_id
where wd.way_bill_details_id == way_bill_details.way_bill_details_id
select new { i.import_id, i.import_code };
ViewBag.import = new SelectList(import_code, "import_id", "import_code");
var way_bill_master_details = (from w in db.Way_Bill
where w.way_bill_id == way_bill_details.way_bill_id
select new { w.way_bill_name, w.import_id, w.importer_id, w.is_calculated, w.way_bill_code, w.way_bill_id, w.mark }).First();
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_id == way_bill_details.goods_id
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_id == way_bill_details.unit_of_measure_id
select u;
ViewBag.unit_of_measure = new SelectList(unit_id, "unit_id", "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_id", "goods_name");
TempData["id"] = way_bill_details.way_bill_details_id;
TempData["way_bill_id"] = way_bill_details.way_bill_id;
ViewBag.categories = new HomeController().Category();
ViewBag.currency = new HomeController().Currency();
way_billModel.way_bill_code = way_bill_master_details.way_bill_code;
way_billModel.import_id = way_bill_master_details.import_id;
way_billModel.mark = way_bill_master_details.mark;
way_billModel.goods_category_id = goods.First().goods_category_id;
way_billModel.goods_subcategory_id = goods.First().goods_subcategory_id;
way_billModel.goods_type_id = goods.First().goods_type_id;
way_billModel.goods_id = way_bill_details.goods_id;
way_billModel.unit_of_measure_id = way_bill_details.unit_of_measure_id;
way_billModel.is_damaged = way_bill_details.is_damaged;
way_billModel.total_quantity = Convert.ToInt32(way_bill_details.total_quantity);
return View(way_billModel);
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult DbSearchresult_new(Way_BillModel way_bill)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(13) || z.Contains(24))
{
var way_bill_id = Convert.ToInt32(Session["way_bill_id"]);
if (way_bill.goods != null)
{
var result = (from w in db.Way_Bill
join wd in db.Way_Bill_Details on w.way_bill_id equals wd.way_bill_id
join imps in db.Imports on w.import_id equals imps.import_id
join i in db.Importers on w.importer_id equals i.importer_id
join g in db.Goods on wd.goods_id equals g.goods_id
join u in db.Unit_Of_Measure on wd.unit_of_measure_id equals u.unit_id
where g.goods_name.Contains(way_bill.goods) && wd.way_bill_id == way_bill_id
select new Way_BillModel { way_bill_id = w.way_bill_id, importer_name = i.importer_first_name, way_bill_code = w.way_bill_code, way_bill_name = w.way_bill_name, goods = g.goods_name, unit_of_measure = u.unit_code, total_quantity = wd.total_quantity, import_status_id = imps.importing_status_id, goods_id = wd.goods_id, way_bill_details_id = wd.way_bill_details_id, is_damaged = wd.is_damaged });
TempData["importer"] = (from w in db.Way_Bill
join i in db.Importers on w.importer_id equals i.importer_id
where w.way_bill_id == way_bill_id
select i.importer_first_name + " " + i.importer_middle_name + " " + i.importer_last_name).First();
return View("Details", result.ToList());
}
return RedirectToAction("Details", new { way_bill_id = way_bill_id });
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult DbSearchresult(Way_BillModel way_bill)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(13))
{
//Queue q = new Queue();
if ( way_bill.way_bill_code != null && way_bill.import_code != null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where w.way_bill_code.Contains(way_bill.way_bill_code) && i.import_code.Contains(way_bill.import_code) && sa.ship_arrival_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code != null && way_bill.import_code != null && way_bill.ship_arrival_code == null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where w.way_bill_code.Contains(way_bill.way_bill_code) && i.import_code.Contains(way_bill.import_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code != null && way_bill.import_code == null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where w.way_bill_code.Contains(way_bill.way_bill_code) && sa.ship_arrival_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code != null && way_bill.import_code == null && way_bill.ship_arrival_code == null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where w.way_bill_code.Contains(way_bill.way_bill_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code == null && way_bill.import_code != null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where i.import_code.Contains(way_bill.import_code) && sa.ship_arrival_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code == null && way_bill.import_code != null && way_bill.ship_arrival_code == null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where i.import_code.Contains(way_bill.import_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code == null && way_bill.import_code == null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.Way_Bill
join i in db.Imports on w.import_id equals i.import_id
join sa in db.Ship_Arrival on i.ship_arrival_id equals sa.ship_arrival_id
where sa.ship_arrival_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.way_bill_code, import_name = i.import_code, ship_arrival_code = sa.ship_arrival_code, import_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult Create_Way_Bill(Way_BillModel way_billModel)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(13) || z.Contains(24))
{
Way_Bill_Details way_bill_details = new Way_Bill_Details();
var way_bill_id = Convert.ToInt32(Session["way_bill_id"]);
if (ModelState.IsValid)
{
way_bill_details.way_bill_id = way_bill_id;
way_bill_details.goods_id = way_billModel.goods_id;
way_bill_details.unit_of_measure_id = way_billModel.unit_of_measure_id;
way_bill_details.total_quantity = way_billModel.total_quantity;
way_bill_details.is_damaged = way_billModel.is_damaged;
db.Way_Bill_Details.Add(way_bill_details);
db.SaveChanges();
return RedirectToAction("Details", new { way_bill_id = way_bill_id });
}
return RedirectToAction("Details", new { way_bill_id = way_bill_id });
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult DbSearchresult(Way_BillModel way_bill)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(31))
{
//Queue q = new Queue();
if (way_bill.way_bill_code != null && way_bill.import_code != null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where w.e_way_bill_code.Contains(way_bill.way_bill_code) && e.export_code.Contains(way_bill.import_code) && sd.ship_departure_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code != null && way_bill.import_code != null && way_bill.ship_arrival_code == null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where w.e_way_bill_code.Contains(way_bill.way_bill_code) && e.export_code.Contains(way_bill.import_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code != null && way_bill.import_code == null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where w.e_way_bill_code.Contains(way_bill.way_bill_code) && sd.ship_departure_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code != null && way_bill.import_code == null && way_bill.ship_arrival_code == null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where w.e_way_bill_code.Contains(way_bill.way_bill_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code == null && way_bill.import_code != null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where e.export_code.Contains(way_bill.import_code) && sd.ship_departure_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code == null && way_bill.import_code != null && way_bill.ship_arrival_code == null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where e.export_code.Contains(way_bill.import_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
else if (way_bill.way_bill_code == null && way_bill.import_code == null && way_bill.ship_arrival_code != null)
{
var result = (from w in db.E_Way_Bill
join e in db.Exports on w.export_id equals e.export_id
join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id
where sd.ship_departure_code.Contains(way_bill.ship_arrival_code)
select new Way_BillModel { way_bill_code = w.e_way_bill_code, import_name = e.export_code, ship_arrival_code = sd.ship_departure_code, import_status_id = e.exporting_status_id, way_bill_id = w.e_way_bill_id, mark = w.mark });
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
