public ActionResult CreateConfirm([Bind(Include = "id,U_Id_Approval,U_Id_Dept_MNG,U_Id_LCA_Leader,U_Id_LCA_MNG,U_Id_Comtor,U_Id_FM,U_Id_GD,customer_Id,quantity,dealLine,title,increaseProductivity,newModel,increaseProduction,improve,C_5s,checkJig,reducePeple,errorContent,currentError,afterError,cost_Savings,other,pay,model,pcb,contentDetail,cost,date_Create,date_Update,date_Received,date_Finish,file_upload,file_upload_update,costDetail_upload")] tbl_Request tbl_Request)
{
sess = Session["user"] as tbl_User;
string groupName = db.tbl_User.Find(sess.id).tbl_Group.group_Name;
// Tìm người phiên dịch
//var comtor = db.tbl_User.Where(r => r.tbl_Group.group_Name.Contains(groupName) && r.tbl_Permission.permission_Id.Equals(3)).FirstOrDefault();
tbl_Request.U_Id_LCA_MNG = db.tbl_User.Where(r => r.tbl_Group.group_Name.Contains("MNG-LCA") && r.tbl_Permission.permission_Id.Equals(2)).FirstOrDefault().id;
//if (comtor != null)
//{
// tbl_Request.U_Id_Comtor = comtor.id;
//}
tbl_Request.U_Id_FM = db.tbl_User.Where(r => r.tbl_Group.group_Name.Contains("FM") && r.tbl_Permission.permission_Id.Equals(2)).FirstOrDefault().id;
tbl_Request.U_Id_GD = db.tbl_User.Where(r => r.tbl_Group.group_Name.Contains("GD") && r.tbl_Permission.permission_Id.Equals(2)).FirstOrDefault().id;
var deptMngId = db.tbl_User.Where(r => r.tbl_Group.group_Name.Equals(groupName) && r.tbl_Permission.permission_Id.Equals(2)).FirstOrDefault().id;
if (ModelState.IsValid)
{
db.Entry(tbl_Request).State = EntityState.Modified;
tbl_Request.U_Id_Dept_MNG = tbl_Request.U_Id_Approval = deptMngId;
tbl_Request.U_Id_Create = tbl_Request.U_Id_Send = sess.id;
tbl_Request.date_Create = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.group_Id = new SelectList(db.tbl_Group.Where(r => !r.group_Name.Equals("Support")), "group_Id", "group_Name");
ViewBag.customer_Id = new SelectList(db.tbl_Customer, "customer_Id", "customer_Name", tbl_Request.customer_Id);
ViewBag.U_Id_Create = new SelectList(db.tbl_User, "U_Id", "U_username", tbl_Request.U_Id_Create);
return(View(tbl_Request));
}
public ActionResult Edit([Bind(Include = "id,group_Id,permission_Id,username,password,fullname,phone,email,stamp,createAt")] tbl_User tbl_User)
{
var newPass = Common.EncryptionMD5(tbl_User.password);
tbl_User.password = newPass;
userSession = Session["user"] as tbl_User;
if (!userSession.tbl_Permission.permission_Id.Equals(1))
{
return(HttpNotFound());
}
if (ModelState.IsValid)
{
db.Entry(tbl_User).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.group_Id = new SelectList(db.tbl_Group, "group_Id", "group_Name", tbl_User.group_Id);
ViewBag.permission_Id = new SelectList(db.tbl_Permission, "permission_Id", "allow", tbl_User.permission_Id);
return(View(tbl_User));
}
public ActionResult ChangePassword(tbl_User user)
{
//var userSession = Session["user"] as tbl_User;
//int id = userSession.id;
//tbl_User tbl_User = db.tbl_User.Find(id);
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
var newPass = Common.EncryptionMD5(user.password);
user.password = newPass;
//user.id = tbl_User.id;
//user.createAt = tbl_User.createAt;
//user.email = tbl_User.email;
//user.fullname = tbl_User.fullname;
//user.group_Id = tbl_User.group_Id;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "id,U_Id_Create,U_Id_Approval,U_Id_Dept_MNG,U_Id_LCA_Leader,U_Id_LCA_MNG,U_Id_Comtor,U_Id_FM,U_Id_GD,date_Dept_MNG_Approval,date_LCA_Leader_Approval,date_LCA_MNG_Approval,date_Requestor_Approval,date_Comtor_Approval,date_Dept_Confirm,date_FM_Approval,date_GD_Approval,customer_Id,quantity,dealLine,title,increaseProductivity,newModel,increaseProduction,improve,C_5s,checkJig,reducePeple,errorContent,currentError,afterError,cost_Savings,other,pay,model,pcb,contentDetail,cost,date_Create,date_Update,date_Received,date_Finish,file_upload,file_update_1,file_update_2,file_update_3,file_update_4,file_update_5,costDetail_upload, comment")] tbl_Request tbl_Request)
{
//var temp = db.tbl_Request.Find(tbl_Request.id) as tbl_Request;
sess = Session["user"] as tbl_User;
if (sess.id != tbl_Request.U_Id_Approval)
{
return(HttpNotFound());
}
//if (sess.tbl_Permission.allow.Equals("approval") && sess.tbl_Group.group_Name.Contains("LCA") && !sess.tbl_Group.group_Name.Contains("MNG"))
//{
// if (tbl_Request.date_Finish == null)
// {
// ModelState.AddModelError("dateFinishNull", "Ngày nhận không để trống");
// ViewBag.customer_Id = new SelectList(db.tbl_Customer, "customer_Id", "customer_Name", tbl_Request.customer_Id);
// ViewBag.group_Id = new SelectList(db.tbl_Group.Where(r => !r.group_Name.Contains("Support") && r.group_Name.Contains("LCA")), "group_Id", "group_Name");
// return View(tbl_Request);
// }
// if (tbl_Request.cost == null)
// {
// ModelState.AddModelError("costNull", "Báo giá không để trống");
// ViewBag.customer_Id = new SelectList(db.tbl_Customer, "customer_Id", "customer_Name", tbl_Request.customer_Id);
// ViewBag.group_Id = new SelectList(db.tbl_Group.Where(r => !r.group_Name.Contains("Support") && r.group_Name.Contains("LCA")), "group_Id", "group_Name");
// return View(tbl_Request);
// }
//}
if (Request.Form["submit"] != null)
{
if (ModelState.IsValid)
{
db.Entry(tbl_Request).State = EntityState.Modified;
sess = Session["user"] as tbl_User;
//var userApproval = db.tbl_User.Find(tbl_Request.U_Id_Approval) as tbl_User;
//var permission = db.tbl_User.Find(tbl_Request.U_Id_Approval).tbl_Permission.permission_Id;
var group = sess.tbl_Group.group_Name;
if (sess.tbl_Permission.permission_Id.Equals(2)) // Quyền approval
{
//var group = userApproval.tbl_Group.group_Name;
if (group.Contains("GD")) // GD approval
{
tbl_Request.date_GD_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = 1;
}
else if (group.Contains("FM")) // FM Approval
{
tbl_Request.date_FM_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_GD;
}
else if (group.Contains("MNG")) //LCA Mgr xác nhận
{
tbl_Request.date_LCA_MNG_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_Create;
}
else if (group.Contains("LCA") && !group.Equals("LCA")) // Leader LCA xác nhận
{
if (tbl_Request.date_Finish == null || tbl_Request.cost == null)
{
//ViewBag.required = "(*) Bắt buộc phải nhập";
ViewBag.customer_Id = new SelectList(db.tbl_Customer, "customer_Id", "customer_Name", tbl_Request.customer_Id);
ViewBag.U_Id_Create = new SelectList(db.tbl_User, "U_Id", "U_username", tbl_Request.U_Id_Create);
ViewBag.group_Id = new SelectList(db.tbl_Group.Where(r => !r.group_Name.Contains("Support")), "group_Id", "group_Name");
return(RedirectToAction("Edit"));
}
tbl_Request.date_LCA_Leader_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_LCA_MNG;
}
else if (tbl_Request.date_LCA_MNG_Approval == null) // Trưởng bộ phận xác nhận lần 1
{
tbl_Request.date_Dept_MNG_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_LCA_Leader;
}
else if (group.Equals("Comtor")) //Comtor Approval
{
tbl_Request.date_Comtor_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_FM;
}
else // Trưởng bộ phận xác nhận lần 2
{
tbl_Request.date_Dept_Confirm = DateTime.Now;
if (tbl_Request.cost < 200) //Dưới 200 USD thì đơn được phê duyệt
{
tbl_Request.U_Id_Approval = 1;
}
else // >200 USD chuyển cho Comtor
{
if (tbl_Request.U_Id_Comtor == null) // Nếu không có Comtor
{
tbl_Request.U_Id_Approval = tbl_Request.U_Id_FM;
tbl_Request.U_Id_Comtor = -1;
}
else // Có Comtor
{
tbl_Request.U_Id_Approval = (int)tbl_Request.U_Id_Comtor;
}
}
}
}
else if (sess.tbl_Permission.permission_Id.Equals(3) && tbl_Request.date_LCA_MNG_Approval != null) //member xác nhận trước khi yêu cầu đến trưởng phòng
{
tbl_Request.date_Requestor_Approval = DateTime.Now;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_Dept_MNG;
}
if (tbl_Request.U_Id_Approval == 1) // Finish
{
ViewBag.approved = true;
}
tbl_Request.U_Id_Send = sess.id;
tbl_Request.date_Received = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("getRequestByUserApproval", "Business"));
}
}
else if (Request.Form["reject"] != null)
{
db.Entry(tbl_Request).State = EntityState.Modified;
tbl_Request.U_Id_Approval = tbl_Request.U_Id_Create;
tbl_Request.date_Comtor_Approval = null;
tbl_Request.date_Dept_Confirm = null;
tbl_Request.date_Dept_MNG_Approval = null;
tbl_Request.date_Finish = null;
tbl_Request.date_FM_Approval = null;
tbl_Request.date_GD_Approval = null;
tbl_Request.date_LCA_Leader_Approval = null;
tbl_Request.date_LCA_MNG_Approval = null;
tbl_Request.date_Received = null;
tbl_Request.date_Requestor_Approval = null;
tbl_Request.date_Update = null;
tbl_Request.U_Id_Send = sess.id;
db.SaveChanges();
return(RedirectToAction("getRequestByUserApproval", "Business"));
}
ViewBag.customer_Id = new SelectList(db.tbl_Customer, "customer_Id", "customer_Name", tbl_Request.customer_Id);
ViewBag.U_Id_Create = new SelectList(db.tbl_User, "U_Id", "U_username", tbl_Request.U_Id_Create);
ViewBag.group_Id = new SelectList(db.tbl_Group.Where(r => !r.group_Name.Contains("Support")), "group_Id", "group_Name");
return(View(tbl_Request));
}
