//Hien thi trang khai bao ban quyen phan mem
        public ActionResult ListSoftWare(int?page, string searching)
        {
            if (page == null)
            {
                page = 1;
            }
            int     pageSize   = 15;
            int     pageNumber = (page ?? 1);
            NewCode nCode      = new NewCode();
            var     session    = (UserLogin)Session[CommonConstants.USER_SESSION];
            var     emp        = session.UserID.Trim();
            bool    checkLv    = nCode.checkLevel(emp, "ITNETWORK");

            if (checkLv)
            {
                var model = nCode.listDeclare(searching);

                var mod = from m in model select m;

                //var modelSea =model.Data_ .Where(x => x.APPNO.Contains(searching) || searching == null || x.ApplicantNo.Contains(searching) || x.USERNAME.Contains(searching) || x.AppContent.Contains(searching) || x.APPREASON.Contains(searching));
                //var modelSear = modelSea.OrderByDescending(m => m.APPNO).ToList();
                return(View(model.ToPagedList(pageNumber, pageSize)));
            }
            else
            {
                return(RedirectToAction("WaitingForYourApproval", "APP_ESIGN"));
            }
        }
        public ActionResult Form_signing(string appNo)
        {
            NewCode         newCode    = new NewCode();
            FORM_IT_01Model fORM_IT_01 = newCode.getDataToModel(appNo);


            return(View(fORM_IT_01));
        }
예제 #3
0
        public void TestMethodNewCode()
        {
            var l   = new NewCode();
            var url = NewCode.MakeUrl("MSFT",
                                      new DateTime(2000, 9, 15),
                                      new DateTime(2000, 10, 18)
                                      );
            var res = l.GetResult(url);

            var closerate = l.DateMaxClose(res);

            Assert.IsTrue(closerate.Item2 > 20);
        }
        public ActionResult CreateAppForm()
        {
            NewCode newCode = new NewCode();

            if (Session["dislayFormName"] == null)
            {
                return(RedirectToAction("CreateForm", "ApplicationType", new { area = "Employee" }));
            }
            string          formSS = Session["dislayFormName"].ToString();
            int             formID = newCode.getFormID(formSS);
            FORM_IT_01Model mode   = newCode.setDataForm(6);

            return(View(mode));
        }
        // GET: Employee/APP_ESIGN
        //[OutputCache(Location = System.Web.UI.OutputCacheLocation.Client, Duration = 3600 * 24)]
        public ActionResult Index(int?page, string searching)
        {
            if (page == null)
            {
                page = 1;
            }
            int     pageSize   = 10;
            int     pageNumber = (page ?? 1);
            NewCode newCode    = new NewCode();
            var     model      = newCode.ListIssue();
            var     modelSea   = db.DATA_APP_ESIGN.Where(x => x.APPNO.Contains(searching) || searching == null || x.ApplicantNo.Contains(searching) || x.Title.Contains(searching) || x.ApplicantName.Contains(searching)).ToList();
            var     modelSear  = modelSea.OrderByDescending(m => m.APPID).ToList();

            return(View(modelSear.ToPagedList(pageNumber, pageSize)));
        }
        public ActionResult CreateForm(CreateNewForm createNewForm)
        {
            NewCode newCode = new NewCode();

            var    session = (UserLogin)Session[CommonConstants.USER_SESSION];
            string creator = session.UserID;
            string ahihi   = createNewForm.Site.Trim();

            string formName = "FORM_" + createNewForm.Department.Trim() + "_" + DateTime.Now.ToString("yyyyMMddHHmmss");

            newCode.insertForm(formName.Trim(), createNewForm.Department.Trim(), createNewForm.FormDisplayName, createNewForm.Site.Trim(), creator.Trim());
            Session["dislayFormName"] = formName.Trim();

            setViewSite();
            setViewDepart();
            return(RedirectToAction("CreateAppForm", "ApplicationType", new { area = "Employee" }));
        }
        public ActionResult signingProcess(string appNo)
        {
            FORM_IT_01Model fORM_IT_01 = new FORM_IT_01Model();

            List <ApprovalAppModel> listAppro = new List <ApprovalAppModel>();
            var formID  = Session["formName"].ToString();
            var newCode = new NewCode();

            //fORM_IT_01.AppNo = DateTime.Now.ToString("yyyyMMddHHmmss");
            //Session["APPNO"] = fORM_IT_01.AppNo;
            fORM_IT_01.FormID = newCode.getFormID(formID);

            string    sqlQuery      = @"select * from SubmitSign where FormID = '" + fORM_IT_01.FormID + "' order by SignNo asc";
            DataTable tbSignProcess = new DataTable();

            tbSignProcess = dbHelpers.DoSQLSelect(sqlQuery);
            string signEmpNo1  = "";
            string SignName1   = "";
            string statusName1 = "";
            int    step1       = 0;
            string agent       = "";



            if (tbSignProcess.Rows.Count > 0)
            {
                for (int i = 0; i < tbSignProcess.Rows.Count; i++)
                {
                    step1       = i;
                    statusName1 = tbSignProcess.Rows[i]["SignName"].ToString();

                    listAppro.Add(new ApprovalAppModel
                    {
                        step       = step1,
                        statusName = statusName1,
                        signEmpNo  = "",
                        SignName   = ""
                    });
                }
            }

            fORM_IT_01.approvalApps = listAppro;

            return(View(fORM_IT_01));
        }
        // [OutputCache(Location = System.Web.UI.OutputCacheLocation.Client, Duration = 3600 * 24)]
        public ActionResult WaitingForYourApproval(int?page, string searching)
        {
            //string sqlDB =
            if (page == null)
            {
                page = 1;
            }
            int     pageSize   = 10;
            int     pageNumber = (page ?? 1);
            var     session    = (UserLogin)Session[CommonConstants.USER_SESSION];
            var     emp        = session.UserID.Trim();
            NewCode newCod     = new NewCode();
            var     mod        = newCod.listWating(emp);
            var     modelSea   = db.DATA_APP_ESIGN.Where(x => x.APPNO.Contains(searching) || searching == null || x.ApplicantNo.Contains(searching) || x.Title.Contains(searching) || x.ApplicantName.Contains(searching)).ToList();
            var     modelS     = modelSea.Where(x => x.Checkwait.Contains(emp)).ToList();
            var     modelSear  = modelS.OrderByDescending(m => m.APPID).ToList();

            return(View(modelSear.ToPagedList(pageNumber, pageSize)));
        }
        public ActionResult signingProcess(FORM_IT_01Model fORM_IT_01s)
        {
            var formID  = Session["formName"].ToString();
            var newCode = new NewCode();

            //fORM_IT_01.AppNo = DateTime.Now.ToString("yyyyMMddHHmmss");
            //Session["APPNO"] = fORM_IT_01.AppNo;
            fORM_IT_01s.FormID = newCode.getFormID(formID);
            fORM_IT_01s.AppNo  = Session["APPNO"].ToString();

            string    sqlQuery      = @"select * from SubmitSign where FormID = '" + fORM_IT_01s.FormID + "' order by SignNo asc";
            DataTable tbSignProcess = new DataTable();

            tbSignProcess = dbHelpers.DoSQLSelect(sqlQuery);
            string signEmpNo1  = "";
            string SignName1   = "";
            string statusName1 = "";
            int    step1       = 0;
            string agent       = "";



            if (tbSignProcess.Rows.Count > 0)
            {
                for (int i = 0; i < tbSignProcess.Rows.Count; i++)
                {
                    step1       = i;
                    statusName1 = tbSignProcess.Rows[i]["SignName"].ToString();
                    signEmpNo1  = fORM_IT_01s.approvalApps[i].signEmpNo.ToString();
                    SignName1   = fORM_IT_01s.approvalApps[i].SignName.ToString();

                    newCode.insertListSign(fORM_IT_01s.AppNo, signEmpNo1, SignName1, statusName1, step1);
                }
            }

            return(View("appITForm02"));
        }
        public ActionResult NewCreate(DepartmentNo appNew)
        {
            if(ModelState.IsValid)
            {
                    var sessionLay = (UserLogin)Session[CommonConstants.USER_SESSION];
                    var empLay = sessionLay.UserID.Trim();

                    NewCode nCode = new NewCode();
                    setViewDepartment();
                    string dropVa = appNew.FormName;
                    Session["formName"] = dropVa;
                    string ReDirAction = "";
                    string ReDirControll = "";

                    string listLink = "";
                    DataTable dataTable = tBleForm(dropVa);
                    if(dataTable.Rows.Count > 0)
                    {
                        listLink = dataTable.Rows[0]["LinkForm"].ToString();
                        string[] listRedi = listLink.Split(';');
                        if(listRedi.Length > 1)
                        {
                            ReDirAction = listRedi[0].ToString();
                            ReDirControll = listRedi[1].ToString();
                            return RedirectToAction(ReDirAction, ReDirControll, new { area = "Employee" });
                        }                       
                    }
                    else
                    {
                        ViewBag.ErrorType = " 表单正在开发,请再次进入 / Mẫu đơn đang được phát triển, vui lòng quay lại sau ";
                        return View("NewCreate");
                    }                  
                    //return RedirectToAction("FORM_IT_01", "ApplicationType", new { area = "Employee" });                
            }
            ViewBag.ErrorType = " 表单正在开发,请再次进入 / Mẫu đơn đang được phát triển, vui lòng quay lại sau ";
            return View("NewCreate");
        }
        public ActionResult EditApp(ApprovalApp approvals, string ApprovalButton)
        {
            var subM    = new Submit();
            var newCode = new NewCode();

            switch (ApprovalButton)
            {
            case "Approval":
            {
                //string no1 = approvals.NoteApproval;
                //string no3 = approvals.EmpModels.APPNO;

                //subM.checkStateApp("Approval", no3, no1);

                bool kqNow = subM.SigningApp(approvals.EmpModels.APPNO, "ok");
                //string no2 = "Reject";
                break;
            }

            case "Reject":
            {
                //string no1 = approvals.NoteApproval;
                //string no3 = approvals.EmpModels.APPNO;

                //subM.checkStateApp("Reject", no3, no1);
                //string no2 = "Reject";
                newCode.getDataToModel("20200731094049");
                break;
            }

            case "Submit":
            {
                //var files = Request.Files["file"];
                //string no3 = approvals.EmpModels.APPNO;
                //string no1 = approvals.NoteApproval;
                //if (files != null)
                //{
                //    subM.checkStateApp("Submit", no3, no1);
                //    String FileExt = Path.GetExtension(files.FileName).ToUpper();
                //    if (FileExt == ".PDF" || FileExt == ".XLSX" || FileExt == ".XLS")
                //    {

                //        string _fileName = approvals.EmpModels.APPNO + Path.GetFileName(files.FileName);

                //        String filePath = "/UploadFiles/" + _fileName;
                //        string _path = Path.Combine(Server.MapPath("~/UploadFiles"), _fileName);
                //        //Stream str = files.InputStream;
                //        //BinaryReader Br = new BinaryReader(str);
                //        //Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
                //        //files.SaveAs(MapPath(filePath));
                //        files.SaveAs(_path);
                //        //files.SaveAs(MapPath)
                //        approvals.EmpModels.FileName = files.FileName;
                //        approvals.EmpModels.Username = filePath;
                //        //appEmp.TIMECREATE = DateTime.Now;
                //        //CreateApplication(appEmp);
                //        var session = (UserLogin)Session[CommonConstants.USER_SESSION];
                //        var signList = newCode.getListManager(session.UserID.Trim());
                //        string[] signemp = signList.Split(';');
                //        string signemp1 = signemp[0];
                //        string signemp2 = signemp[1];
                //        var signname11 = newCode.getNameEmp(signemp1);
                //        var signname22 = newCode.getNameEmp(signemp2);
                //        approvals.EmpModels.APPSTATES = "020";
                //        approvals.EmpModels.Signer1No = signemp1;
                //        approvals.EmpModels.Signer1Name = signname11;
                //        approvals.EmpModels.Checkwait = approvals.EmpModels.Signer1No;
                //        approvals.EmpModels.CHECKWAITNAME = approvals.EmpModels.Signer1Name;
                //        approvals.EmpModels.APPSTATUS = "Waiting...";


                //        approvals.EmpModels.Signer2No = signemp2;
                //        approvals.EmpModels.Signer2Name = signname22;
                //        newCode.UpdatenewAppFormIT02(approvals, no3);
                //        break;
                //    }
                //    else
                //    {
                //        //ViewBag.FileStatus = "Invalid file format!";
                //        SetAlert("Invalid file format!", "danger");
                //        return View();
                //    }
                //}
                //else
                //{

                //    //string no3 = approvals.EmpModels.APPNO;

                //    subM.checkStateApp("Submit", no3, no1);
                //    var session = (UserLogin)Session[CommonConstants.USER_SESSION];
                //    var signList = newCode.getListManager(session.UserID.Trim());
                //    string[] signemp = signList.Split(';');
                //    string signemp1 = signemp[0];
                //    string signemp2 = signemp[1];
                //    var signname11 = newCode.getNameEmp(signemp1);
                //    var signname22 = newCode.getNameEmp(signemp2);
                //    approvals.EmpModels.APPSTATES = "020";
                //    approvals.EmpModels.Signer1No = signemp1;
                //    approvals.EmpModels.Signer1Name = signname11;
                //    approvals.EmpModels.Checkwait = approvals.EmpModels.Signer1No;
                //    approvals.EmpModels.CHECKWAITNAME = approvals.EmpModels.Signer1Name;
                //    approvals.EmpModels.APPSTATUS = "Waiting...";


                //    approvals.EmpModels.Signer2No = signemp2;
                //    approvals.EmpModels.Signer2Name = signname22;

                //    newCode.Update1newAppFormIT02(approvals, no3);

                break;
                //}
            }
            }
            if (ApprovalButton == "Approval")
            {
                return(RedirectToAction("Index"));
            }
            else
            {
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult CreateAppForm(FORM_IT_01Model mode)
        {
            string ve = "";

            NewCode newCode = new NewCode();
            //if (Session["dislayFormName"] == null)
            //{
            //    return RedirectToAction("CreateForm", "ApplicationType", new { area = "Employee" });
            //}
            string formName = Session["dislayFormName"].ToString();

            mode.FormID = newCode.getFormID(formName);

            if (mode.Title0Content == null)
            {
                mode.Title0Content = "";
            }

            if (mode.Title1Content == null)
            {
                mode.Title1Content = "";
            }

            if (mode.Title2Content == null)
            {
                mode.Title2Content = "";
            }

            if (mode.Title3Content == null)
            {
                mode.Title3Content = "";
            }

            if (mode.Title4Content == null)
            {
                mode.Title4Content = "";
            }

            if (mode.Title5Content == null)
            {
                mode.Title5Content = "";
            }

            if (mode.Title6Content == null)
            {
                mode.Title6Content = "";
            }

            if (mode.Title7Content == null)
            {
                mode.Title7Content = "";
            }

            if (mode.Title8Content == null)
            {
                mode.Title8Content = "";
            }

            if (mode.Title9Content == null)
            {
                mode.Title9Content = "";
            }

            if (mode.Title10Content == null)
            {
                mode.Title10Content = "";
            }

            if (mode.Title11Content == null)
            {
                mode.Title11Content = "";
            }

            if (mode.Title12Content == null)
            {
                mode.Title12Content = "";
            }

            if (mode.Title13Content == null)
            {
                mode.Title13Content = "";
            }

            if (mode.Title14Content == null)
            {
                mode.Title14Content = "";
            }

            if (mode.Title15Content == null)
            {
                mode.Title15Content = "";
            }

            if (mode.Title16Content == null)
            {
                mode.Title16Content = "";
            }


            if (mode.Title17Content == null)
            {
                mode.Title17Content = "";
            }

            if (mode.Title18Content == null)
            {
                mode.Title18Content = "";
            }

            if (mode.Title19Content == null)
            {
                mode.Title19Content = "";
            }

            if (mode.Title20Content == null)
            {
                mode.Title20Content = "";
            }

            if (mode.Title21Content == null)
            {
                mode.Title21Content = "";
            }

            if (mode.Title22Content == null)
            {
                mode.Title22Content = "";
            }


            if (mode.Title23Content == null)
            {
                mode.Title23Content = "";
            }

            if (mode.Title24Content == null)
            {
                mode.Title24Content = "";
            }

            if (mode.Title25Content == null)
            {
                mode.Title25Content = "";
            }

            if (mode.Title26Content == null)
            {
                mode.Title26Content = "";
            }


            if (mode.Title0 == null)
            {
                mode.Title0 = "";
            }

            if (mode.Title1 == null)
            {
                mode.Title1 = "";
            }

            if (mode.Title2 == null)
            {
                mode.Title2 = "";
            }

            if (mode.Title3 == null)
            {
                mode.Title3 = "";
            }

            if (mode.Title4 == null)
            {
                mode.Title4 = "";
            }

            if (mode.Title5 == null)
            {
                mode.Title5 = "";
            }

            if (mode.Title6 == null)
            {
                mode.Title6 = "";
            }

            if (mode.Title7 == null)
            {
                mode.Title7 = "";
            }

            if (mode.Title8 == null)
            {
                mode.Title8 = "";
            }

            if (mode.Title9 == null)
            {
                mode.Title9 = "";
            }

            if (mode.Title10 == null)
            {
                mode.Title10 = "";
            }

            if (mode.Title11 == null)
            {
                mode.Title11 = "";
            }

            if (mode.Title12 == null)
            {
                mode.Title12 = "";
            }

            if (mode.Title13 == null)
            {
                mode.Title13 = "";
            }

            if (mode.Title14 == null)
            {
                mode.Title14 = "";
            }

            if (mode.Title15 == null)
            {
                mode.Title15 = "";
            }

            if (mode.Title16 == null)
            {
                mode.Title16 = "";
            }


            if (mode.Title17 == null)
            {
                mode.Title17 = "";
            }

            if (mode.Title18 == null)
            {
                mode.Title18 = "";
            }

            if (mode.Title19 == null)
            {
                mode.Title19 = "";
            }

            if (mode.Title20 == null)
            {
                mode.Title20 = "";
            }

            if (mode.Title21 == null)
            {
                mode.Title21 = "";
            }

            if (mode.Title22 == null)
            {
                mode.Title22 = "";
            }


            if (mode.Title23 == null)
            {
                mode.Title23 = "";
            }

            if (mode.Title24 == null)
            {
                mode.Title24 = "";
            }

            if (mode.Title25 == null)
            {
                mode.Title25 = "";
            }

            if (mode.Title26 == null)
            {
                mode.Title26 = "";
            }



            string dataTiltle = mode.Title0 + ";" + mode.Title1 + ";" + mode.Title2 + ";" + mode.Title3 + ";" + mode.Title4 + ";";

            dataTiltle += mode.Title5 + ";" + mode.Title6 + ";" + mode.Title7 + ";" + mode.Title8 + ";" + mode.Title9 + ";";
            dataTiltle += mode.Title10 + ";" + mode.Title11 + ";" + mode.Title12 + ";" + mode.Title13 + ";" + mode.Title14 + ";";
            dataTiltle += mode.Title15 + ";" + mode.Title16 + ";" + mode.Title17 + ";" + mode.Title18 + ";" + mode.Title19 + ";";
            dataTiltle += mode.Title20 + ";" + mode.Title21 + ";" + mode.Title22 + ";" + mode.Title23 + ";" + mode.Title24 + ";" + mode.Title25 + ";" + mode.Title26;

            string dataContent = mode.Title0Content + ";" + mode.Title1Content + ";" + mode.Title2Content + ";" + mode.Title3Content + ";" + mode.Title4Content + ";";

            dataContent += mode.Title5Content + ";" + mode.Title6Content + ";" + mode.Title7Content + ";" + mode.Title8Content + ";" + mode.Title9Content + ";";
            dataContent += mode.Title10Content + ";" + mode.Title11Content + ";" + mode.Title12Content + ";" + mode.Title13Content + ";" + mode.Title14Content + ";";
            dataContent += mode.Title15Content + ";" + mode.Title16Content + ";" + mode.Title17Content + ";" + mode.Title18Content + ";" + mode.Title19Content + ";";
            dataContent += mode.Title20Content + ";" + mode.Title21Content + ";" + mode.Title22Content + ";" + mode.Title23Content + ";" + mode.Title24Content + ";" + mode.Title25Content + ";" + mode.Title26Content;

            string[] listTitle = dataTiltle.Split(';');
            string   err       = "error";

            string[] listContent = dataContent.Split(';');
            string   tit         = "";

            for (int i = 0; i < listTitle.Length; i++)
            {
                bool kqtt = newCode.insertTitleForm(mode.FormID, listTitle[i], i, tit, listContent[i]);
                if (kqtt == false)
                {
                    err += "error" + listTitle[i].ToString();
                }
            }
            string kqTe = HttpContext.Request.Form["testKQ"].ToString();

            //string kqTe1 = HttpContext.Request.Form["testKQ1"].ToString();
            //string kqTe2 = HttpContext.Request.Form["testKQ2"].ToString();

            string[] nameKQ = kqTe.Split(',');
            //string[] nameKQ1 = kqTe1.Split(',');
            //string[] nameKQ2 = kqTe2.Split(',');

            for (int i = 0; i < nameKQ.Length; i++)
            {
                if (nameKQ[i].Equals(""))
                {
                    break;
                }
                else
                {
                    bool insertSubmitSign = newCode.insertSigning(mode.FormID, i, nameKQ[i]);
                    if (insertSubmitSign == false)
                    {
                        err = "error" + listTitle[i].ToString();
                    }
                }
            }

            if (err.Trim() != "error")
            {
                return(RedirectToAction("errorShow", "Home", new { area = "" }));
            }
            return(RedirectToAction("Index", "APP_ESIGN", new { area = "Employee" }));
        }
        public ActionResult appITForm02(EmpModel appEmp, HttpPostedFileBase files)
        {
            var newCode = new NewCode();

            appEmp.APPNO  = DateTime.Now.ToString("yyyyMMddHHmmss");
            appEmp.FormID = newCode.getFormID("FORM_IT_02");

            //int formId = appEmp.FormID;
            appEmp.Daycreate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
            DataTable tbSubsign = new DataTable();

            if (files != null)
            {
                String FileExt = Path.GetExtension(files.FileName).ToUpper();
                if (FileExt == ".PDF" || FileExt == ".XLSX" || FileExt == ".XLS")
                {
                    string _fileName = appEmp.APPNO + Path.GetFileName(files.FileName);

                    String filePath = "/UploadFiles/" + _fileName;
                    string _path    = Path.Combine(Server.MapPath("~/UploadFiles"), _fileName);
                    //Stream str = files.InputStream;
                    //BinaryReader Br = new BinaryReader(str);
                    //Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
                    //files.SaveAs(MapPath(filePath));
                    files.SaveAs(_path);
                    //files.SaveAs(MapPath)
                    appEmp.FileName = files.FileName;
                    appEmp.Username = filePath;
                    //var path1 = _path.Split('/UploadFiles/');
                    //appEmp.FileContent = FileDet;
                    //appEmp.TIMECREATE = DateTime.Now;
                    //CreateApplication(appEmp);
                }
                else
                {
                    //ViewBag.FileStatus = "Invalid file format!";
                    SetAlert("Invalid file format!", "danger");
                    return(View());
                }
            }
            var session  = (UserLogin)Session[CommonConstants.USER_SESSION];
            var signList = newCode.getListManager(session.UserID.Trim());

            string[] signemp    = signList.Split(';');
            string   signemp1   = signemp[0];
            string   signemp2   = signemp[1];
            var      signname11 = newCode.getNameEmp(signemp1);
            var      signname22 = newCode.getNameEmp(signemp2);

            appEmp.APPSTATES     = "";
            appEmp.Signer1No     = signemp1;
            appEmp.Signer1Name   = signname11;
            appEmp.Checkwait     = appEmp.Signer1No;
            appEmp.CHECKWAITNAME = appEmp.Signer1Name;
            appEmp.APPSTATUS     = "Waiting...";
            appEmp.ApplicantNo   = session.UserID.Trim();
            appEmp.ApplicantName = session.UserName;
            appEmp.ApplicantCode = session.CostCode;
            appEmp.ApplicantMail = session.Mail;
            appEmp.ApplicantDep  = session.Department;


            appEmp.Signer2No   = signemp2;
            appEmp.Signer2Name = signname22;

            //appEmp.OrderNo = DateTime.Now.ToString("yyyymm")
            newCode.newCreateAppFormIT02(appEmp);
            return(RedirectToAction("Index", "APP_ESIGN", new { area = "Employee" }));
        }
        // [OutputCache(Location = System.Web.UI.OutputCacheLocation.Server, Duration = 3600 * 24, VaryByParam = "None")]
        public ActionResult FORM_IT_01()
        {
            FORM_IT_01Model formIT01 = new FORM_IT_01Model();
            var             formID   = "FORM_IT_01";
            var             newCode  = new NewCode();

            if (formID == null)
            {
                return(RedirectToAction(""));
            }


            formIT01.FormID = newCode.getFormID(formID);
            string    sqlQuery  = @"select * from TitleForm where FormID = '" + formIT01.FormID + "'";
            DataTable dataTitle = new DataTable();

            dataTitle = dbHelpers.DoSQLSelect(sqlQuery);
            string titleBu = "";
            string titleEx = "";

            if (dataTitle.Rows.Count > 0)
            {
                for (int i = 0; i < dataTitle.Rows.Count; i++)
                {
                    titleBu += dataTitle.Rows[i]["FormContent"].ToString() + ";";
                    titleEx += dataTitle.Rows[i]["Example"].ToString() + ";";
                }
            }

            // gan gia tri cho list signer
            string    sqlQuery1     = @"select * from SubmitSign where FormID = '" + formIT01.FormID + "' order by SignNo asc";
            DataTable tbSignProcess = new DataTable();

            tbSignProcess = dbHelpers.DoSQLSelect(sqlQuery1);
            string signEm   = "";
            string SignNa   = "";
            string statusNa = "";
            int    step1    = 0;
            //string agent = "";
            List <ApprovalAppModel> listAppro = new List <ApprovalAppModel>();


            if (tbSignProcess.Rows.Count > 0)
            {
                for (int i = 0; i < tbSignProcess.Rows.Count; i++)
                {
                    step1    = i;
                    statusNa = tbSignProcess.Rows[i]["SignName"].ToString();

                    listAppro.Add(new ApprovalAppModel
                    {
                        step       = step1,
                        statusName = statusNa,
                        signEmpNo  = "",
                        SignName   = ""
                    });
                }
            }

            formIT01.approvalApps = listAppro;
            // gan gia tri  cho title
            string[] titleList = titleBu.Split(';');

            formIT01.Title0 = titleList[0];
            formIT01.Title1 = titleList[1];
            formIT01.Title2 = titleList[2];
            formIT01.Title3 = titleList[3];
            formIT01.Title4 = titleList[4];

            formIT01.Title5 = titleList[5];
            formIT01.Title6 = titleList[6];
            formIT01.Title7 = titleList[7];
            formIT01.Title8 = titleList[8];
            formIT01.Title9 = titleList[9];

            formIT01.Title10 = titleList[10];
            formIT01.Title11 = titleList[11];
            formIT01.Title12 = titleList[12];
            formIT01.Title13 = titleList[13];
            formIT01.Title14 = titleList[14];

            formIT01.Title15 = titleList[15];
            formIT01.Title16 = titleList[16];
            formIT01.Title17 = titleList[17];
            formIT01.Title18 = titleList[18];
            formIT01.Title19 = titleList[19];

            formIT01.Title20 = titleList[20];
            formIT01.Title21 = titleList[21];
            formIT01.Title22 = titleList[22];
            formIT01.Title23 = titleList[23];
            formIT01.Title24 = titleList[24];

            formIT01.Title25 = titleList[25];

            formIT01.Title26 = titleList[26];

            string[] exampleList = titleEx.Split(';');
            formIT01.Title0Example = exampleList[0];
            formIT01.Title1Example = exampleList[1];
            formIT01.Title5Example = exampleList[5];
            formIT01.Title7Example = exampleList[7];
            formIT01.Title8Example = exampleList[8];

            formIT01.Title10Example = exampleList[10];
            formIT01.Title11Example = exampleList[11];
            formIT01.Title12Example = exampleList[12];
            formIT01.Title13Example = exampleList[13];
            formIT01.Title14Example = exampleList[14];
            formIT01.Title15Example = exampleList[15];
            formIT01.Title16Example = exampleList[16];
            formIT01.Title17Example = exampleList[17];

            formIT01.Title26Example = exampleList[26];



            var session = (UserLogin)Session[CommonConstants.USER_SESSION];

            formIT01.Title3Content = session.UserName.ToString();
            formIT01.Title4Content = session.UserID.ToString();

            PostmanService.PostmanServiceSoapClient postman = new PostmanService.PostmanServiceSoapClient();
            DataTable tbPost = new DataTable();

            tbPost = postman.GetEmpInfomation(formIT01.Title4Content.Trim());

            formIT01.Title17Content = tbPost.Rows[0]["NOTES_ID"].ToString();
            formIT01.Title1Content  = tbPost.Rows[0]["CURRENT_OU_NAME"].ToString();
            if (formIT01.Title17Content == null || formIT01.Title17Content == "")
            {
                formIT01.Title17Content = "";
            }
            //formIT01.titleName = titleList;
            setViewFac();
            var a = titleList.Count();

            return(View(formIT01));
        }
        public void setViewFac(long?selectedID = null)
        {
            var dao = new NewCode();

            ViewBag.Title0Content = new SelectList(dao.listFac(), "Factory_name", "Factory_name", selectedID);
        }