示例#1
0
        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));
        }
示例#3
0
        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));
        }
示例#4
0
        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");
            }
        }
示例#7
0
        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());
        }
示例#8
0
        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));
        }
示例#9
0
        // 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)));
        }
示例#10
0
        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)));
        }
示例#11
0
        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)));
        }
示例#12
0
        public ActionResult InquirySHIFTData(string FACTORY_CD, string SHIFT_CODE)
        {
            DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(FACTORY_CD);

            return(Content(DashboardBLL.InquirySHIFTData(FACTORY_CD, SHIFT_CODE)));
        }
示例#13
0
        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)));
        }
示例#14
0
        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)));
        }
示例#15
0
        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)));
        }