//hien thi trang ky don public ActionResult EditApp(string appNo) { var session = (UserLogin)Session[CommonConstants.USER_SESSION]; ApprovalApp approval = getApprovalApp(appNo); return(View(approval)); }
// GET: Employee/APP_ESIGN/Edit/5 public ActionResult Edit(string appNo) { //if (id == null) //{ // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); //} //DATA_APP_ESIGN dATA_APP_ESIGN = db.DATA_APP_ESIGN.Find(id); //if (dATA_APP_ESIGN == null) //{ // return HttpNotFound(); //} //var session = (UserLogin)Session[CommonConstants.USER_SESSION]; //if(session.UserID.Trim() != dATA_APP_ESIGN.Checkwait.Trim()) //{ // return RedirectToAction("Index"); //} //string appNo = dATA_APP_ESIGN.APPNO.Trim().ToString(); ApprovalApp approval = getApprovalApp(appNo); return(View(approval)); }
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")); } }
//lay du lieu trang ky don private ApprovalApp getApprovalApp(string appNo) { ApprovalApp aprApp = new ApprovalApp(); string sqlQuery = @"select * from APPROVE_SIGN where APPNO = '" + appNo + "'"; SQLServerDBHelper dBHelper = new SQLServerDBHelper("EsignDB"); DataTable tb = dBHelper.DoSQLSelect(sqlQuery); string sqlQuery1 = @"select * from DATA_APP_ESIGN where APPNO = '" + appNo + "'"; DataTable tb1 = dBHelper.DoSQLSelect(sqlQuery1); //aprApp.EmpModels = new EmpModel(); // don nguoi dung lam EmpModel empM = new EmpModel(); if (tb1.Rows.Count > 0) { DataRow dr1 = tb1.Rows[0]; empM.APPSTATES = dr1["APPSTATES"].ToString(); empM.APPNO = dr1["APPNO"].ToString(); empM.Checkwait = dr1["Checkwait"].ToString(); empM.ApplicantNo = dr1["ApplicantNo"].ToString(); empM.ApplicantName = dr1["ApplicantName"].ToString(); empM.ApplicantCode = dr1["ApplicantCode"].ToString(); empM.ApplicantMail = dr1["ApplicantMail"].ToString(); empM.ApplicantPhone = dr1["ApplicantPhone"].ToString(); empM.ApplicantDep = dr1["ApplicantDep"].ToString(); empM.Recipientunit = dr1["Recipientunit"].ToString(); empM.Organizer = dr1["Organizer"].ToString(); empM.Copysubmission = dr1["Copysubmission"].ToString(); empM.Page = dr1["Page"].ToString(); empM.Issuer = dr1["Issuer"].ToString(); empM.Documentnumber = dr1["Documentnumber"].ToString(); empM.Daycreate = dr1["Daycreate"].ToString(); empM.Title = dr1["Title"].ToString(); empM.AppContent = dr1["AppContent"].ToString(); empM.FileName = dr1["FileName"].ToString(); empM.Signer3No = dr1["Signer3No"].ToString(); empM.Signer3Name = dr1["Signer3Name"].ToString(); empM.Signer4No = dr1["Signer4No"].ToString(); empM.Signer4Name = dr1["Signer4Name"].ToString(); empM.Signer5No = dr1["Signer5No"].ToString(); empM.Signer5Name = dr1["Signer5Name"].ToString(); empM.Signer6No = dr1["Signer6No"].ToString(); empM.Signer6Name = dr1["Signer6Name"].ToString(); empM.Username = dr1["USERNAME"].ToString(); //empM.FileContent = dr1["FileContent"].ToString(); //empM.FileContent = Convert.ToByte(dr1["FileContent"].); } List <APPROVE_SIGN> list_A = new List <APPROVE_SIGN>(); long approveID = 0; string appID = ""; string approverName = ""; string approverNo = ""; string processName = ""; DateTime time = DateTime.Now; string note = ""; string status = ""; string agentIP = ""; string agent = ""; if (tb.Rows.Count > 0) { //DataRow dr = tb.Rows[0]; for (int i = 0; i < tb.Rows.Count; i++) { //approveID = Convert.ToInt32(tb.Rows[i]["APPROVEID"].ToString()); appID = tb.Rows[i]["APPNO"].ToString(); approverName = tb.Rows[i]["APPROVERNAME"].ToString(); approverNo = tb.Rows[i]["APPROVEREMP"].ToString(); processName = tb.Rows[i]["PROCESSNAME"].ToString(); note = tb.Rows[i]["NOTES"].ToString(); status = tb.Rows[i]["STATUS"].ToString(); time = Convert.ToDateTime(tb.Rows[i]["TIMEAPPROVE"].ToString()); //agentIP = tb.Rows[i]["AGENTEMP"].ToString(); //agent = tb.Rows[i]["AGENTNAME"].ToString(); list_A.Add(new APPROVE_SIGN { APPROVEID = approveID, APPNO = appID, APPROVERNAME = approverName, APPROVEREMP = approverNo, PROCESSNAME = processName, NOTES = note, STATUS = status, TIMEAPPROVE = time //AGENTEMP = agentIP, //AGENTNAME = agent }); } } aprApp.APPROVEs = list_A; aprApp.EmpModels = empM; return(aprApp); }