public ActionResult personnel_transaction()
{
try
{
var model = new data_report {
EOS_reson = new EOS_type(), trans_type = new transaction_type()
};
ViewBag.empll = dbcontext.Employee_Profile.Where(m => m.Active == true).ToList().Select(m => new { Code = m.Code + "------[" + m.Full_Name + ']', ID = m.ID });
ViewBag.job_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID });
ViewBag.location_desc = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
ViewBag.cadre = dbcontext.job_level_setup.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
ViewBag.Organization_Chart = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID });
ViewBag.cost = dbcontext.CostCenter.ToList().Select(m => new { Code = m.CostCenterCode + "->" + m.CostCenterDesc, ID = m.ID });
ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "->" + m.Name, ID = m.ID });
return(View(model));
}
catch (Exception)
{
return(RedirectToAction("index"));
}
}
public ActionResult personnel_transaction(data_report mydata, FormCollection form)
{
try
{
ViewBag.empll = dbcontext.Employee_Profile.Where(m => m.Active == true).ToList().Select(m => new { Code = m.Code + "------[" + m.Full_Name + ']', ID = m.ID });
ViewBag.job_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID });
ViewBag.location_desc = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
ViewBag.cadre = dbcontext.job_level_setup.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
ViewBag.Organization_Chart = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID });
ViewBag.cost = dbcontext.CostCenter.ToList().Select(m => new { Code = m.CostCenterCode + "->" + m.CostCenterDesc, ID = m.ID });
ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "->" + m.Name, ID = m.ID });
var all_request = dbcontext.personnel_transaction.ToList();
var my_report = new List <personnel_transaction>();
if (mydata.trans_date_from != null || mydata.trans_date_to != null)
{
if (mydata.trans_date_from > mydata.trans_date_to)
{
TempData["Message"] = "Error in request date";
return(View(mydata));
}
else
{
my_report.AddRange(all_request.Where(m => m.transaction_date >= mydata.trans_date_from && m.transaction_date <= mydata.trans_date_to).ToList());
}
}
if (mydata.effective_date_from != null || mydata.effective_date_to != null)
{
if (mydata.effective_date_from > mydata.effective_date_to)
{
TempData["Message"] = "Error in effective date";
return(View(mydata));
}
else
{
var E_d = all_request.Where(m => Convert.ToDateTime(m.Effective_date) >= mydata.effective_date_from && Convert.ToDateTime(m.Effective_date) <= mydata.effective_date_to).ToList();
foreach (var item in E_d)
{
if (!my_report.Contains(item))
{
my_report.Add(item);
}
}
}
}
if (mydata.end_of_Service_date_from != null || mydata.end_of_Service_date_to != null)
{
if (mydata.end_of_Service_date_from > mydata.end_of_Service_date_to)
{
TempData["Message"] = "Error in end of Service date";
return(View(mydata));
}
else
{
var E_d = all_request.Where(m => Convert.ToDateTime(m.End_of_service_date) >= mydata.end_of_Service_date_from && Convert.ToDateTime(m.End_of_service_date) <= mydata.end_of_Service_date_to).ToList();
foreach (var item in E_d)
{
if (!my_report.Contains(item))
{
my_report.Add(item);
}
}
}
}
if (mydata.last_working_date_from != null || mydata.last_working_date_to != null)
{
if (mydata.last_working_date_from > mydata.last_working_date_to)
{
TempData["Message"] = "Error in last working date";
return(View(mydata));
}
else
{
var E_d = all_request.Where(m => Convert.ToDateTime(m.Last_working_date) >= mydata.last_working_date_from && Convert.ToDateTime(m.Last_working_date) <= mydata.last_working_date_to).ToList();
foreach (var item in E_d)
{
if (!my_report.Contains(item))
{
my_report.Add(item);
}
}
}
}
//=======================================
var Employee = form["em"].Split(char.Parse(","));
var Status = form["status"].Split(char.Parse(","));
var job = form["job_"].Split(char.Parse(","));
var loaction = form["loaction_"].Split(char.Parse(","));
var cadre = form["cadre_"].Split(char.Parse(","));
var unit = form["unit_"].Split(char.Parse(","));
var Cost = form["cost_"].Split(char.Parse(","));
var Shift = form["shift_"].Split(char.Parse(","));
var Eos_reson = form["EOS_reson"].Split(char.Parse(","));
var Transaction_type = form["trans_type"].Split(char.Parse(","));
var List = form["List_Display"].Split(char.Parse(","));
var flag1 = new Boolean[12];
for (var i = 0; i < 12; i++)
{
flag1[i] = false;
}
foreach (var item in List)
{
if (item != "")
{
var index = int.Parse(item);
flag1[index] = true;
}
}
foreach (var item in Employee)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == em_id);
var E_d_ = all_request.Where(m => m.Employee == emp).ToList();
foreach (var item2 in E_d_)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in job)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == em_id);
var E_d_2 = all_request.Where(m => m.job_title_cards == emp).ToList();
foreach (var item2 in E_d_2)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in loaction)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.work_location.FirstOrDefault(m => m.ID == em_id);
var E_d_2 = all_request.Where(m => m.work_location == emp).ToList();
foreach (var item2 in E_d_2)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in cadre)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.job_level_setup.FirstOrDefault(m => m.ID == em_id);
var E_d_2 = all_request.Where(m => m.job_level_setup == emp).ToList();
foreach (var item2 in E_d_2)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in unit)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == em_id);
var E_d_2 = all_request.Where(m => m.Organization_ChartId == emp.ID.ToString()).ToList();
foreach (var item2 in E_d_2)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in Cost)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.CostCenter.FirstOrDefault(m => m.ID == em_id);
var E_d_2 = all_request.Where(m => m.cost_center_id == emp.ID).ToList();
foreach (var item2 in E_d_2)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in Shift)
{
if (item != "")
{
var em_id = int.Parse(item);
var emp = dbcontext.Shift_setup.FirstOrDefault(m => m.ID == em_id);
var E_d_2 = all_request.Where(m => m.shift_id == emp.ID).ToList();
foreach (var item2 in E_d_2)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in Transaction_type)
{
if (item != "")
{
var em_id = int.Parse(item);
var so = all_request.Where(m => m.Transaction_type == (transaction_type)em_id).ToList();
foreach (var item2 in so)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in Eos_reson)
{
if (item != "")
{
var em_id = int.Parse(item);
var so = all_request.Where(m => m.EOS_reasons == (EOS_type)em_id).ToList();
foreach (var item2 in so)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
foreach (var item in Status)
{
if (item != "")
{
var em_id = int.Parse(item);
var so = all_request.Where(m => m.status.statu == (check_status)em_id).ToList();
foreach (var item2 in so)
{
if (!my_report.Contains(item2))
{
my_report.Add(item2);
}
}
}
}
var my_repo = new report_tran {
flag = flag1, my_list = my_report
};
return(View("show_report", my_repo));
}
catch (Exception)
{
return(RedirectToAction("index"));
}
}