public ActionResult DbSearchresult(Bolleto_DogonaleModel bollete_dogonale) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(37)) { //Queue q = new Queue(); if (bollete_dogonale.importer_name != null && bollete_dogonale.way_bill_code != null) { var result = (from c in db.E_Calculated_Levi join w in db.E_Way_Bill on c.way_bill_id equals w.e_way_bill_id join e in db.Exports on w.export_id equals e.export_id join ir in db.Importers on e.exporter_id equals ir.importer_id join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id where (ir.importer_first_name + " " + ir.importer_middle_name + " " + ir.importer_last_name).Contains(bollete_dogonale.importer_name) && w.e_way_bill_code.StartsWith(bollete_dogonale.way_bill_code) select new Bolleto_DogonaleModel { way_bill_code = w.e_way_bill_code, import_code = e.export_code, ship_arrival_code = sd.ship_departure_code, bolleto_dogonale_code = e.e_bollete_dogonale_code, way_bill_id = w.e_way_bill_id }).Distinct(); return View("Index", result.ToList()); } else if (bollete_dogonale.importer_name != null && bollete_dogonale.way_bill_code == null) { var result = (from c in db.E_Calculated_Levi join w in db.E_Way_Bill on c.way_bill_id equals w.e_way_bill_id join e in db.Exports on w.export_id equals e.export_id join ir in db.Importers on e.exporter_id equals ir.importer_id join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id where (ir.importer_first_name + " " + ir.importer_middle_name + " " + ir.importer_last_name).Contains(bollete_dogonale.importer_name) select new Bolleto_DogonaleModel { way_bill_code = w.e_way_bill_code, import_code = e.export_code, ship_arrival_code = sd.ship_departure_code, bolleto_dogonale_code = e.e_bollete_dogonale_code, way_bill_id = w.e_way_bill_id }).Distinct(); return View("Index", result.ToList()); } else if (bollete_dogonale.importer_name == null && bollete_dogonale.way_bill_code != null) { var result = (from c in db.E_Calculated_Levi join w in db.E_Way_Bill on c.way_bill_id equals w.e_way_bill_id join e in db.Exports on w.export_id equals e.export_id join ir in db.Importers on e.exporter_id equals ir.importer_id join sd in db.Ship_Departure on e.ship_departure_id equals sd.ship_departure_id where w.e_way_bill_code.StartsWith(bollete_dogonale.way_bill_code) select new Bolleto_DogonaleModel { way_bill_code = w.e_way_bill_code, import_code = e.export_code, ship_arrival_code = sd.ship_departure_code, bolleto_dogonale_code = e.e_bollete_dogonale_code, way_bill_id = w.e_way_bill_id }).Distinct(); return View("Index", result.ToList()); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult DbSearchresult(Bolleto_DogonaleModel bollete_dogonale) { //Queue q = new Queue(); if (bollete_dogonale.bolleto_dogonale_code != null && bollete_dogonale.way_bill_code != null) { var result = (from c in db.Calculated_Levi join w in db.Way_Bill on c.way_bill_id equals w.way_bill_id 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.bollete_dogonale_code.StartsWith(bollete_dogonale.bolleto_dogonale_code) && w.way_bill_code.StartsWith(bollete_dogonale.way_bill_code) select new Bolleto_DogonaleModel { way_bill_code = w.way_bill_code, import_code = i.import_code, ship_arrival_code = sa.ship_arrival_code, bolleto_dogonale_code = i.bollete_dogonale_code, way_bill_id = w.way_bill_id }).Distinct(); return View("Index", result.ToList()); } else if (bollete_dogonale.bolleto_dogonale_code != null && bollete_dogonale.way_bill_code == null) { var result = (from c in db.Calculated_Levi join w in db.Way_Bill on c.way_bill_id equals w.way_bill_id 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.bollete_dogonale_code.StartsWith(bollete_dogonale.bolleto_dogonale_code) select new Bolleto_DogonaleModel { way_bill_code = w.way_bill_code, import_code = i.import_code, ship_arrival_code = sa.ship_arrival_code, bolleto_dogonale_code = i.bollete_dogonale_code, way_bill_id = w.way_bill_id }).Distinct(); return View("Index", result.ToList()); } else if (bollete_dogonale.bolleto_dogonale_code == null && bollete_dogonale.way_bill_code != null) { var result = (from c in db.Calculated_Levi join w in db.Way_Bill on c.way_bill_id equals w.way_bill_id 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.StartsWith(bollete_dogonale.way_bill_code) select new Bolleto_DogonaleModel { way_bill_code = w.way_bill_code, import_code = i.import_code, ship_arrival_code = sa.ship_arrival_code, bolleto_dogonale_code = i.bollete_dogonale_code, way_bill_id = w.way_bill_id }).Distinct(); return View("Index", result.ToList()); } return RedirectToAction("Index"); }