//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);
}
