public ActionResult GETEMPLOYEEATTENDTIMEINSERT(string FACTORY_CD, String LINE_CODE, string HR_MAX_TIME_DIFFERENCE, string HR_REFRESH_INTERVAL)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
string result = DashboardBLL.GETEMPLOYEEATTENDTIMEINSERT(FACTORY_CD, LINE_CODE, HR_MAX_TIME_DIFFERENCE, HR_REFRESH_INTERVAL);
return(Content(result));
}
public ActionResult BASICINFORMATIONView(string FACTORY_CD, string LINE_CODE)
{
FACTORY_CD_Param = FACTORY_CD;
LINE_CODE_Param = LINE_CODE;
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
string preferredLang;
ViewData["FACTORY_CD"] = DashboardBLL.Get_FactoryCD_List("%");
ViewData["GARMENT_TYPE"] = DashboardBLL.Get_GARMENT_TYPE_List();
ViewData["LINE_CD"] = DashboardBLL.Get_LINECD_List("%", "%");
ViewData["SHIFT_CODE"] = DashboardBLL.Get_SHIFT_CODE_List("%");
COMMONPROCESS ReadAndWrite_File = new COMMONPROCESS(FACTORY_CD_Param, LINE_CODE_Param);
BASICINFORMATION_DATA BASICINFORMATION_DATA = ReadAndWrite_File.Read_BASICINFORMATION_File();
preferredLang = BASICINFORMATION_DATA.LANGUAGE;
//if (string.IsNullOrEmpty(preferredLang) || string.IsNullOrWhiteSpace(preferredLang))
//Request.("LANGUAGE");
IEnumerable <MvcDashBoard.Model.DASHBOARD.Models.OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION> data = DashboardBLL.PROC_GET_DASHBOARD_FORM_DEFINITION("BASICINFORMATION", preferredLang);
foreach (MvcDashBoard.Model.DASHBOARD.Models.OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION item in data)
{
ViewData[item.CONTROLLER_ID.ToString()] = (item.CONTROLLER_DESC == null ? "" : item.CONTROLLER_DESC.ToString());
}
return(View(BASICINFORMATION_DATA));
}
public ActionResult EMPLOYEEATTENDTIMEView(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
ViewData["FACTORY_CD"] = DashboardBLL.Get_FactoryCD_List("%");
ViewData["GARMENT_TYPE"] = DashboardBLL.Get_GARMENT_TYPE_List();
ViewData["LINE_CD"] = DashboardBLL.Get_LINECD_List("%", "%");
ViewData["SHIFT_CODE"] = DashboardBLL.Get_SHIFT_CODE_List("%");
EMPLOYEE_ATTENDTIME EMPLOYEE_ATTENDTIME = new EMPLOYEE_ATTENDTIME();
List <DASHBOARD_EMPLOYEE_ATTENDTIME> DASHBOARD_EMPLOYEE_ATTENDTIME = DashboardBLL.Get_DASHBOARD_EMPLOYEE_ATTENDTIME_List(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE);
EMPLOYEE_ATTENDTIME_QUERY_CRITERIA EMPLOYEE_ATTENDTIME_QUERY_CRITERIA = new EMPLOYEE_ATTENDTIME_QUERY_CRITERIA();
EMPLOYEE_ATTENDTIME_QUERY_CRITERIA.FACTORY_CD = FACTORY_CD;
EMPLOYEE_ATTENDTIME_QUERY_CRITERIA.PRODUCTION_LINE_CD = LINE_CODE;
EMPLOYEE_ATTENDTIME_QUERY_CRITERIA.SHIFT = SHIFT_CODE;
EMPLOYEE_ATTENDTIME_QUERY_CRITERIA.TRX_DATE = TRX_DATE;
EMPLOYEE_ATTENDTIME.EMPLOYEE_ATTENDTIME_list = DASHBOARD_EMPLOYEE_ATTENDTIME;
EMPLOYEE_ATTENDTIME.EMPLOYEE_ATTENDTIME_Query_Criteria = EMPLOYEE_ATTENDTIME_QUERY_CRITERIA;
string preferredLang = Request["LANGUAGE"];
IEnumerable <OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION> data = DashboardBLL.PROC_GET_DASHBOARD_FORM_DEFINITION("EMPLOYEEATTENDTIME", preferredLang);
foreach (OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION item in data)
{
ViewData[item.CONTROLLER_ID.ToString()] = (item.CONTROLLER_DESC == null ? "" : item.CONTROLLER_DESC.ToString());
}
return(View(EMPLOYEE_ATTENDTIME));
}
public ActionResult UPDATE_ATTENDTIME(string FACTORY_CD, string SEQNO, String SHIFT, string TRX_DATE, string PRODUCTION_LINE_CD)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
string result;
result = DashboardBLL.UPDATE_ATTENDTIME(SEQNO, SHIFT, TRX_DATE, PRODUCTION_LINE_CD);
return(Content(result));
}
private void GetHFStudentValues()
{
Hashtable ht = new Hashtable();
DataTable dt = DASHBOARDBLL.GetStudentCount(ht);
if (dt.Rows.Count > 0)
{
lblTS.Text = dt.Rows[0]["TotalStudents"].ToString();
lblNA.Text = dt.Rows[0]["NewAdmission"].ToString();
lblIS.Text = dt.Rows[0]["InactiveStudents"].ToString();
}
}
private void GetFeeSummary()
{
Hashtable ht = new Hashtable();
DataTable dt = DASHBOARDBLL.GetFeeSummary(ht);
if (dt.Rows.Count > 0)
{
lblCategory.Text = dt.Rows[0]["Fee Category"].ToString();
//lblFee.Text = dt.Rows[0]["Fee Collected"].ToString();
// int n = Convert.ToInt32(dt.Rows[0]["Fee Collected"].ToString());
// lblFee.Text = n.ToString("N0"); /// for commas in money format
// int m = Convert.ToInt32(dt.Rows[0]["Expense"].ToString());
// lblExpense.Text = m.ToString("N0");
}
}
public ActionResult DASHBOARDLINESHIFTSETTINGView()
{
ViewData["FACTORY_CD"] = Request["FACTORY_CD"];
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(Request["FACTORY_CD"]);
ViewData["FACTORY_CD_L"] = DashboardBLL.Get_FactoryCD_List("%");
ViewData["SHIFT_CODE_L"] = DashboardBLL.Get_SHIFT_CODE_List("%");
ViewData["SHIFT_CODE"] = Request["SHIFT_CODE"];
string preferredLang = Request["LANGUAGE"];
//preferredLang = "CN";
IEnumerable <OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION> data = DashboardBLL.PROC_GET_DASHBOARD_FORM_DEFINITION("DASHBOARDLINESHIFT", preferredLang);
foreach (OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION item in data)
{
ViewData[item.CONTROLLER_ID.ToString()] = (item.CONTROLLER_DESC == null ? "" : item.CONTROLLER_DESC.ToString());
}
return(View());
}
public ActionResult DASHBOARDSHOWView()
//public ActionResult DASHBOARDSHOWView(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime? TRX_DATE, string REFRESH)
{
ViewData["FACTORY_CD_Param"] = Request["factory"];
ViewData["LINE_CODE_Param"] = Request["line"];
string FACTORY_CD = Request["factory"];
string LINE_CODE = Request["line"];
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(Request["factory"]);
DASHBOARD_SHOW_DATA DASHBOARD_SHOW_data = new DASHBOARD_SHOW_DATA();
DASHBOARD_SHOW_data = DashboardBLL.Get_DashBoard_Data_List(FACTORY_CD, LINE_CODE, null, null, null); //(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, REFRESH);
if (DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION == null)
{
return(View());
}
string preferredLang = DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.LANGUAGE;
IEnumerable <OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION> data = DashboardBLL.PROC_GET_DASHBOARD_FORM_DEFINITION("DASHBOARDSHOW", preferredLang);
foreach (MvcDashBoard.Model.DASHBOARD.Models.OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION item in data)
{
ViewData[item.CONTROLLER_ID.ToString()] = (item.CONTROLLER_DESC == null ? "" : item.CONTROLLER_DESC.ToString());
}
return(View(DASHBOARD_SHOW_data));
}
// private ApplicationDbContext db = new ApplicationDbContext();
public ActionResult InquiryAttendTime(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.Get_DASHBOARD_EMPLOYEE_ATTENDTIME(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE)));
}
public ActionResult DeleteSHIFTData(string FACTORY_CD, string SHIFT_CODE, string SEQNO)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.DeleteSHIFTData(FACTORY_CD, SHIFT_CODE, SEQNO)));
}
public ActionResult UpdateShiftData(int SEQNO, string FACTORY_CD, string SHIFT_CODE, string SHIFT_DESC, int SHIFT_SEQ, string SHIFT_FROM, string SHIFT_TO, decimal TIME_INTERVAL, string ACTIVE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.UpdateShiftData(SEQNO, FACTORY_CD, SHIFT_CODE, SHIFT_DESC, SHIFT_SEQ, SHIFT_FROM, SHIFT_TO, TIME_INTERVAL, ACTIVE)));
}
public ActionResult InquirySHIFTData(string FACTORY_CD, string SHIFT_CODE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.InquirySHIFTData(FACTORY_CD, SHIFT_CODE)));
}
public ActionResult PROC_DASHBOARD_GET_EMPLOYEE_ATTENDTIME(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE, string ONLY1LINE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.PROC_DASHBOARD_GET_EMPLOYEE_ATTENDTIME(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, ONLY1LINE)));
}
public ActionResult PROC_DASHBOARD_GET_PRODUCTION_QTY(string FACTORY_CD, String LINE_CODE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.PROC_DASHBOARD_GET_PRODUCTION_QTY(FACTORY_CD, LINE_CODE)));
}
public ActionResult DASHBOARDSHOWInquiry(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE)
{
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);
return(Content(DashboardBLL.DASHBOARDSHOWInquiry(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE)));
}