public ActionResult GetManPowerList(MPFilterModel Filter)
{
//Filter.DateTo = Filter.DateTo.AddHours(23).AddMinutes(59).AddSeconds(59);
//Server Side Parameter
int start = (Convert.ToInt32(Request["start"]) == 0) ? 0 : (Convert.ToInt32(Request["start"]) / Convert.ToInt32(Request["length"])); //Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
string sortDirection = Request["order[0][dir]"];
if (Filter.Section == null)
{
if (user.CostCode != null)
{
Filter.Section = (from c in db.M_Cost_Center_List where c.Cost_Center == user.CostCode select c.GroupSection).FirstOrDefault();
}
}
string section = (Filter.Section == null)?"":Filter.Section;
// string CostCode = (from d in db.M_Cost_Center_List where d.GroupSection == section select d.Cost_Center).FirstOrDefault();
if (Filter.Shift != "Day" && Filter.Shift != "Night")
{
db.Database.CommandTimeout = 0;
List <GET_RP_MPCMonitoringv2_Result> list = new List <GET_RP_MPCMonitoringv2_Result>();
ObjectParameter totalCount = new ObjectParameter("TotalCount", typeof(int));
long shift = Convert.ToInt64(Filter.Shift);
list = db.GET_RP_MPCMonitoringv2(Filter.DateFrom, Filter.DateTo, shift, Filter.Line, Filter.Process, section, start, length, searchValue, Filter.Certified, totalCount).ToList();
//GET_RP_MPCMonitoringv2_Count_Result totalcount = db.GET_RP_MPCMonitoringv2_Count(Filter.DateFrom, Filter.DateTo, shift, Filter.Line, Filter.Process, section, searchValue).FirstOrDefault();
System.Web.HttpContext.Current.Session["MPresult"] = Filter;
int?totalrows = Convert.ToInt32(totalCount.Value); //list.Count;
int?totalrowsafterfiltering = Convert.ToInt32(totalCount.Value); //list.Count;
var jsonResult = Json(new { data = list, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
else
{
db.Database.CommandTimeout = 0;
List <GET_RP_MPCMonitoringv2ALLShift_Result> list = new List <GET_RP_MPCMonitoringv2ALLShift_Result>();
ObjectParameter totalCount = new ObjectParameter("TotalCount", typeof(int));
list = db.GET_RP_MPCMonitoringv2ALLShift(Filter.DateFrom, Filter.DateTo, Filter.Shift, Filter.Line, Filter.Process, section, start, length, searchValue, Filter.Certified, totalCount).ToList();
System.Web.HttpContext.Current.Session["MPresult"] = Filter;
int?totalrows = Convert.ToInt32(totalCount.Value); //list.Count;
int?totalrowsafterfiltering = Convert.ToInt32(totalCount.Value); //list.Count;
var jsonResult = Json(new { data = list, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
}
public ActionResult GetManPowerGraph(MPFilterModel Filter)
{
Filter.Shift = (Filter.Shift == null) ? "" : Filter.Shift;
switch (Filter.Certified)
{
case "Certified":
Filter.Certified = "Green";
break;
case "Uncertified":
Filter.Certified = "Red";
break;
}
if (Filter.Section == null)
{
if (user.CostCode != null)
{
Filter.Section = (from c in db.M_Cost_Center_List where c.Cost_Center == user.CostCode select c.GroupSection).FirstOrDefault();
}
}
string section = (Filter.Section == null) ? "" : Filter.Section;
TimeSpan ts = new TimeSpan(23, 00, 0);
Filter.DateTo = Filter.DateTo = Filter.DateTo.AddHours(23).AddMinutes(59).AddSeconds(59);
if (Filter.Shift != "Day" && Filter.Shift != "Night" && Filter.Shift != "")
{
long shift = Convert.ToInt64(Filter.Shift);
db.Database.CommandTimeout = 0;
List <GET_RPMonitoring_Graphv2_Result> graphlist = db.GET_RPMonitoring_Graphv2(Filter.DateFrom, Filter.DateTo, shift, Filter.Line, Filter.Process, section, Filter.Certified).ToList();
var jsonResult = Json(new { graphlist = graphlist }, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
else
{
db.Database.CommandTimeout = 0;
List <GET_RPMonitoring_Graphv2ALLShift_Result> graphlist = db.GET_RPMonitoring_Graphv2ALLShift(Filter.DateFrom, Filter.DateTo, Filter.Shift, Filter.Line, Filter.Process, section, Filter.Certified).ToList();
var jsonResult = Json(new { graphlist = graphlist }, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
}
public ActionResult ExportMP(string Section)
{
try
{
string templateFilename = "ManPowerMonitoring.xlsx";
string dir = Path.GetTempPath();
string datetimeToday = DateTime.Now.ToString("yyMMddhhmmss");
string filename = string.Format("ManPowerMonitoring{0}_{1}.xlsx", datetimeToday, Section);
FileInfo newFile = new FileInfo(Path.Combine(dir, filename));
string apptemplatePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"TemplateFiles\ExportReports\", templateFilename);
FileInfo templateFile = new FileInfo(apptemplatePath);
using (ExcelPackage package = new ExcelPackage(newFile, templateFile)) //-- With template.
{
MPFilterModel Filter = (MPFilterModel)System.Web.HttpContext.Current.Session["MPresult"];
string section = (Filter.Section == null) ? "" : Filter.Section;
List <GET_RP_MPCMonitoringv2_Result> list = new List <GET_RP_MPCMonitoringv2_Result>();
List <GET_RP_MPCMonitoringv2ALLShift_Result> list2 = new List <GET_RP_MPCMonitoringv2ALLShift_Result>();
ObjectParameter totalCount = new ObjectParameter("TotalCount", typeof(int));
if (Filter.Shift != "Day" && Filter.Shift != "Night")
{
db.Database.CommandTimeout = 0;
long shift = Convert.ToInt64(Filter.Shift);
list = db.GET_RP_MPCMonitoringv2(Filter.DateFrom, Filter.DateTo, shift, Filter.Line, Filter.Process, section, 0, 1000000, "", Filter.Certified, totalCount).ToList();
ExcelWorksheet ExportData = package.Workbook.Worksheets["Sheet1"];
int start = 2;
for (int i = 0; i < list.Count; i++)
{
ExportData.Cells["A" + start].Value = list[i].Rownum;
ExportData.Cells["B" + start].Value = list[i].InDate;
ExportData.Cells["C" + start].Value = list[i].TimeIn;
ExportData.Cells["D" + start].Value = list[i].InDateOut;
ExportData.Cells["E" + start].Value = list[i].TimeOut;
ExportData.Cells["F" + start].Value = list[i].Shift;
ExportData.Cells["G" + start].Value = list[i].Line;
ExportData.Cells["H" + start].Value = list[i].Skill;
ExportData.Cells["I" + start].Value = list[i].EmpNo;
ExportData.Cells["J" + start].Value = list[i].EmployeeName;
ExportData.Cells["K" + start].Value = list[i].Date_Hired;
ExportData.Cells["L" + start].Value = list[i].DateCertified;
ExportData.Cells["M" + start].Value = list[i].Status;
start++;
}
return(File(package.GetAsByteArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", filename));
}
else
{
list2 = db.GET_RP_MPCMonitoringv2ALLShift(Filter.DateFrom, Filter.DateTo, Filter.Shift, Filter.Line, Filter.Process, section, 0, 1000000, "", Filter.Certified, totalCount).ToList();
ExcelWorksheet ExportData = package.Workbook.Worksheets["Sheet1"];
int start = 2;
for (int i = 0; i < list2.Count; i++)
{
ExportData.Cells["A" + start].Value = list2[i].Rownum;
ExportData.Cells["B" + start].Value = list2[i].InDate;
ExportData.Cells["C" + start].Value = list2[i].TimeIn;
ExportData.Cells["D" + start].Value = list2[i].InDateOut;
ExportData.Cells["E" + start].Value = list2[i].TimeOut;
ExportData.Cells["F" + start].Value = list2[i].Shift;
ExportData.Cells["G" + start].Value = list2[i].Line;
ExportData.Cells["H" + start].Value = list2[i].Skill;
ExportData.Cells["I" + start].Value = list2[i].EmpNo;
ExportData.Cells["J" + start].Value = list2[i].EmployeeName;
ExportData.Cells["K" + start].Value = list2[i].Date_Hired;
ExportData.Cells["L" + start].Value = list2[i].DateCertified;
ExportData.Cells["M" + start].Value = list2[i].Status;
start++;
}
return(File(package.GetAsByteArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", filename));
}
}
}
catch (Exception err) { }
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
