public ActionResult DbSearchresult(Tax_CalculationModel tax_calculation)
{
//Queue q = new Queue();
if (tax_calculation.way_bill_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
join ist in db.Importing_Status on i.importing_status_id equals ist.importing_status_id
where i.importing_status_id != 1 && w.way_bill_code.StartsWith(tax_calculation.way_bill_code)
select new Tax_CalculationModel { way_bill_code = w.way_bill_code, import_code = i.import_code, ship_arrival_code = sa.ship_arrival_code, importing_status = ist.importing_status, importing_status_id = i.importing_status_id, way_bill_id = w.way_bill_id }).Distinct();
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
public ActionResult DbSearchresult(Tax_CalculationModel tax_calculation)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (!z.Contains(14) && z.Contains(26))
{
var user_id = Convert.ToInt32(Session["user_id"]);
if (tax_calculation.way_bill_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
join ist in db.Importing_Status on i.importing_status_id equals ist.importing_status_id
where (i.importing_status_id == 19 || i.importing_status_id == 21 || i.importing_status_id == 18) && w.way_bill_code.StartsWith(tax_calculation.way_bill_code)
select new Tax_CalculationModel { way_bill_code = w.way_bill_code, import_code = i.import_code, ship_arrival_code = sa.ship_arrival_code, importing_status = ist.importing_status, importing_status_id = i.importing_status_id, way_bill_id = w.way_bill_id }).Distinct();
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
else if(z.Contains(14))
{
//Queue q = new Queue();
if (tax_calculation.way_bill_code != null)
{
var end_date = Convert.ToDateTime("9999-12-31");
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
join ist in db.Importing_Status on i.importing_status_id equals ist.importing_status_id
join sub in (from aw in db.Assign_Way_Bill
join u in db.Users on aw.user_id equals u.user_id
join e in db.Employees on u.employee_id equals e.employee_id
where aw.end_date == end_date
select new { way_bill_id = aw.way_bill_id, username = e.first_name + " " + e.middle_name + " " + e.last_name }) on w.way_bill_id equals sub.way_bill_id into x
from l in x.DefaultIfEmpty()
where (i.importing_status_id == 6 || i.importing_status_id == 7 || i.importing_status_id == 8 || i.importing_status_id == 9 || i.importing_status_id == 10 || i.importing_status_id == 12 || i.importing_status_id == 3 || i.importing_status_id == 18 || i.importing_status_id == 19 || i.importing_status_id == 21 || i.importing_status_id == 22) && w.way_bill_code.StartsWith(tax_calculation.way_bill_code)
select new Tax_CalculationModel { way_bill_code = w.way_bill_code, import_code = i.import_code, ship_arrival_code = sa.ship_arrival_code, importing_status = ist.importing_status, importing_status_id = i.importing_status_id, way_bill_id = w.way_bill_id, assigned_to = l.username }).Distinct();
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
