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