protected void btnDisSave_Click(object sender, EventArgs e) { try { AccountBiz biz = new AccountBiz(); DTO.AccountDetail user = new DTO.AccountDetail(); user.ID = lblDisUserID.Text; user.ACTIVE = radIsActive.SelectedValue; user.ID_CARD_NO = lblDisIdCard.Text; if (user.ACTIVE == "D") { user.DELETE_USER = ddlDisRemark.SelectedValue; user.OTH_DELETE_USER = txtDisRemarkText.Text; if (String.IsNullOrEmpty(user.DELETE_USER)) { MessageBoxError("กรุณาเลือก เหตุผลการยกเลิก"); return; } } var res = biz.DisableUser(user, UserProfile); if (!res.IsError) { PopUpDisableUser.Hide(); MessageBoxSuccess("บันทึกข้อมูลเรียบร้อยแล้ว"); BindGrid(); UpdatePanelGv.Update(); } else { MessageBoxError(res.ErrorMsg); } } catch (Exception ex) { MessageBoxError(ex.Message); } }
public DTO.ResponseMessage <bool> DisableUser(DTO.AccountDetail user, DTO.UserProfile userProfile) { return(svc.DisableUser(user, userProfile)); }
public DTO.ResponseMessage <Boolean> EditMemberTypeAndActive(DTO.AccountDetail ent, DTO.UserProfile userProfile) { return(svc.EditMemberTypeAndActive(ent, userProfile)); }
protected void btnUpdate_Click(object sender, EventArgs e) { AccountBiz biz = new AccountBiz(); try { DTO.AccountDetail ent = new DTO.AccountDetail(); ent.ID = lblUserId.Text; ent.MEMBER_TYPE = ddlMemberTypeEdit.SelectedValue; if (ent.MEMBER_TYPE == "2" && trCompany.Visible == true) { ent.COMP_CODE = txtCompanyId.Text.Trim(); } else if (ent.MEMBER_TYPE == "3" && trAssoc.Visible == true) { ent.COMP_CODE = txtAssocId.Text.Trim(); } else if (ent.MEMBER_TYPE == "7" && trExamPlaceGroup.Visible == true) { ent.COMP_CODE = ddlExamPlaceGroup.SelectedValue; } else { ent.COMP_CODE = UserCompCode; } ent.OTH_USER_TYPE = txtRemark.Text; var res = biz.EditMemberTypeAndActive(ent, UserProfile); if (!res.IsError) { PopUpEditTypeAccount.Hide(); this.MasterSite.ModelSuccess.ShowMessageSuccess = SysMessage.SaveSucess; this.MasterSite.ModelSuccess.ShowModalSuccess(); btnSearch_Click(sender, e); UpdatePanelGv.Update(); UplPopUp.Update(); } else { PopUpEditTypeAccount.Show(); this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg; this.MasterSite.ModelError.ShowModalError(); if (ent.MEMBER_TYPE == "2" && trCompany.Visible == true) { SetCompanyIdName(); } else if (ent.MEMBER_TYPE == "3" && trAssoc.Visible == true) { SetAssocIdName(); } else if (ent.MEMBER_TYPE == "7" && trExamPlaceGroup.Visible == true) { SetExamPlaceGroup(); } UplPopUp.Update(); } } catch (Exception ex) { PopUpEditTypeAccount.Show(); this.MasterSite.ModelError.ShowMessageError = ex.Message; this.MasterSite.ModelError.ShowModalError(); UplPopUp.Update(); } }
public DTO.ResponseMessage <bool> DisableUser(DTO.AccountDetail user, DTO.UserProfile userProfile) { DTO.ResponseMessage <bool> res = new DTO.ResponseMessage <bool>(); try { var ent = base.ctx.AG_IAS_USERS.FirstOrDefault(s => s.USER_ID == user.ID); if (ent == null) { res.ErrorMsg = "ไม่พบข้อมูลผู้ใช้"; LoggerFactory.CreateLog().LogError(String.Format("ไม่พบข้อมูลผู้ใช้งาน AG_IAS_USERS->USER_ID :{0}", user.ID)); return(res); } if (ent.IS_ACTIVE == user.ACTIVE) { res.ErrorMsg = "ไม่มีการเปลี่ยนแปลงข้อมูล"; return(res); } ent.IS_ACTIVE = user.ACTIVE; ent.UPDATED_BY = userProfile.Id; ent.UPDATED_DATE = DateTime.Now; ent.DELETE_USER = user.DELETE_USER; ent.OTH_DELETE_USER = user.OTH_DELETE_USER; // ยกเลิกบัญชีผู้ใช้ [IS_ACTIVE=D] ให้ส่ง E-mail แจ้ง User if (ent.IS_ACTIVE == "D") { var person = base.ctx.AG_IAS_PERSONAL_T.FirstOrDefault(s => s.ID == user.ID); if (person != null) { person.STATUS = "7"; #region sent mail if (!String.IsNullOrEmpty(person.EMAIL)) { string fromMail = ConfigurationManager.AppSettings["EmailOut"].ToString(); string toMail = person.EMAIL; string Subject = "แจ้งยกเลิกการใช้งาน"; StringBuilder Body = new StringBuilder(); Body.Append("เนื่องด้วยบัญชีใช้งานของคุณ " + person.NAMES + " " + person.LASTNAME + " ได้ถูกยกเลิกการใช้งานใน "); Body.Append(" ระบบช่องทางการบริการตัวแทน/นายหน้าประกันภัยแบบเบ็ดเสร็จ <br/>"); Body.Append(" เหตุผลการยกเลิกการใช้งาน : เนื่องจาก " + user.DELETE_USER + (!string.IsNullOrEmpty(user.OTH_DELETE_USER) ? " - " + user.OTH_DELETE_USER : "")); Body.Append(" <br/><br/>"); EmailSender.Sending(Body, toMail, Subject).Sent(); } #endregion sent mail } var regis = base.ctx.AG_IAS_REGISTRATION_T.FirstOrDefault(s => s.ID == user.ID); if (regis != null) { regis.STATUS = "7"; } } base.ctx.SaveChanges(); } catch (Exception ex) { res.ErrorMsg = "พบข้อผิดพลาดในการยกเลิกบัญชีผู้ใช้งาน"; LoggerFactory.CreateLog().Fatal(string.Format("AccountService_DisableUser USER_ID:{0}", user.ID), ex); } return(res); }
public DTO.ResponseMessage <bool> EditMemberTypeAndActive(DTO.AccountDetail ent, DTO.UserProfile userProfile) { DTO.ResponseMessage <Boolean> res = new DTO.ResponseMessage <bool>(); try { string loginfo = string.Empty; var Person = base.ctx.AG_IAS_PERSONAL_T.FirstOrDefault(x => x.ID == ent.ID); var User = base.ctx.AG_IAS_USERS.FirstOrDefault(s => s.USER_ID == ent.ID); if (Person == null || User == null) { res.ErrorMsg = "ไม่พบข้อมูลผู้ใช้งาน"; LoggerFactory.CreateLog().LogError(String.Format("ไม่พบข้อมูลผู้ใช้งาน USER_ID :{0} ในตาราง AG_IAS_PERSONAL_T หรือ AG_IAS_USERS", ent.ID)); return(res); } #region Check from TYPE to TYPE string err = "ไม่สามารถย้ายประเภทผู้ใช้งาน"; switch (Person.MEMBER_TYPE) { case "1": if (ent.MEMBER_TYPE != "1") { res.ErrorMsg = err; return(res); } break; case "2": case "3": case "7": if (ent.MEMBER_TYPE != "2" && ent.MEMBER_TYPE != "3" && ent.MEMBER_TYPE != "7") { res.ErrorMsg = err; return(res); } break; case "4": case "5": case "6": if (ent.MEMBER_TYPE != "5" && ent.MEMBER_TYPE != "6" && ent.MEMBER_TYPE != "4") { res.ErrorMsg = err; return(res); } break; } #endregion Check from TYPE to TYPE /** * ย้าย MEMBER_TYPE จาก (02-บริษัท, 03-สมาคม) ไปเป็น (07-เจ้าหน้าที่สนามสอบ) * ให้ตรวจสอบ (02-บริษัท, 03-สมาคม) ว่ามีการสมัครสอบหรือไม่? * หากมีการสมัครสอบจะไม่สามารถย้ายไปเป็น (07-เจ้าหน้าที่สนามสอบ) */ if ((Person.MEMBER_TYPE == "2" || Person.MEMBER_TYPE == "3") && ent.MEMBER_TYPE == "7") { OracleDB ora = new OracleDB(); string sql = "select count(*) haveCount from AG_APPLICANT_T where ID_CARD_NO = '" + Person.ID_CARD_NO + "' and " + " EXAM_PLACE_CODE in (select EXAM_PLACE_CODE from AG_EXAM_PLACE_R) "; DataTable dt = ora.GetDataTable(sql); if (dt.Rows[0]["haveCount"].ToInt() > 0) { res.ErrorMsg = "ไม่สามารถย้ายประเภทผู้ใช้งาน"; return(res); } } /* * 2-บริษัท, 3-สมาคม, 5-คปภ.การเงิน, 6-คปภ.ตัวแทน, 7-เจ้าหน้าที่สนามสอบ */ if (ent.MEMBER_TYPE == "2" || ent.MEMBER_TYPE == "3" || ent.MEMBER_TYPE == "7") { if (ent.COMP_CODE == Person.COMP_CODE && Person.MEMBER_TYPE == ent.MEMBER_TYPE) { res.ErrorMsg = "ไม่มีการเปลี่ยนแปลงข้อมูล"; return(res); } var Regis = base.ctx.AG_IAS_REGISTRATION_T.FirstOrDefault(s => s.ID == ent.ID); if (Regis == null) { res.ErrorMsg = "ไม่พบข้อมูลผู้ใช้งาน"; return(res); } // ย้ายได้เฉพาะ status = 2-อนุมัติ(สมัคร), 5-อนุมัติ(แก้ไข) if (Person.STATUS != "2" && Person.STATUS != "5" && Person.STATUS != null) { var Status = base.ctx.AG_IAS_STATUS.FirstOrDefault(s => s.STATUS_CODE == Person.STATUS); res.ErrorMsg = "ไม่สามารถย้ายประเภทผู้ใช้งาน เนื่องจากสถานะ " + Status.STATUS_NAME; return(res); } string ID = OracleDB.GetGenAutoId(); #region AG_IAS_PERSONAL_T AG_IAS_PERSONAL_T newPerson = new AG_IAS_PERSONAL_T { ID = ID, //new Data MEMBER_TYPE = ent.MEMBER_TYPE, //new Data ID_CARD_NO = Person.ID_CARD_NO, EMPLOYEE_NO = Person.EMPLOYEE_NO, PRE_NAME_CODE = Person.PRE_NAME_CODE, NAMES = Person.NAMES, LASTNAME = Person.LASTNAME, NATIONALITY = Person.NATIONALITY, BIRTH_DATE = Person.BIRTH_DATE, SEX = Person.SEX, EDUCATION_CODE = Person.EDUCATION_CODE, ADDRESS_1 = Person.ADDRESS_1, ADDRESS_2 = Person.ADDRESS_2, AREA_CODE = Person.AREA_CODE, PROVINCE_CODE = Person.PROVINCE_CODE, ZIP_CODE = Person.ZIP_CODE, TELEPHONE = Person.TELEPHONE, LOCAL_ADDRESS1 = Person.LOCAL_ADDRESS1, LOCAL_ADDRESS2 = Person.LOCAL_ADDRESS2, LOCAL_AREA_CODE = Person.LOCAL_AREA_CODE, LOCAL_PROVINCE_CODE = Person.LOCAL_PROVINCE_CODE, LOCAL_ZIPCODE = Person.LOCAL_ZIPCODE, LOCAL_TELEPHONE = Person.LOCAL_TELEPHONE, EMAIL = Person.EMAIL, STATUS = Person.STATUS, TUMBON_CODE = Person.TUMBON_CODE, LOCAL_TUMBON_CODE = Person.LOCAL_TUMBON_CODE, COMP_CODE = ent.COMP_CODE, //new Data CREATED_BY = userProfile.Id, //new Data CREATED_DATE = DateTime.Now, //new Data UPDATED_BY = userProfile.Id, //new Data UPDATED_DATE = DateTime.Now, //new Data APPROVE_RESULT = Person.APPROVE_RESULT, APPROVED_BY = Person.APPROVED_BY, AGENT_TYPE = Person.AGENT_TYPE, SIGNATUER_IMG = Person.SIGNATUER_IMG, IMG_SIGN = Person.IMG_SIGN }; #endregion #region AG_IAS_USERS AG_IAS_USERS newUser = new AG_IAS_USERS { USER_ID = ID, //new Data USER_NAME = User.USER_NAME, USER_PASS = User.USER_PASS, USER_TYPE = ent.MEMBER_TYPE, //new Data IS_ACTIVE = User.IS_ACTIVE, USER_RIGHT = ent.MEMBER_TYPE, //new Data USER_TERM_ACCEPTED = User.USER_TERM_ACCEPTED, CREATED_BY = userProfile.Id, //new Data CREATED_DATE = DateTime.Now, //new Data UPDATED_BY = userProfile.Id, //new Data UPDATED_DATE = DateTime.Now, //new Data RESET_TIMES = User.RESET_TIMES, OIC_TYPE = User.OIC_TYPE, MEMBER_TYPE = ent.MEMBER_TYPE, //new Data OIC_EMP_NO = User.OIC_EMP_NO, IS_APPROVE = User.IS_APPROVE, APPROVED_BY = User.APPROVED_BY, STATUS = User.STATUS, APP_CLOSED = User.APP_CLOSED, LASTPASSWORD_CHANGDATE = User.LASTPASSWORD_CHANGDATE, OTH_USER_TYPE = ent.OTH_USER_TYPE //new Data }; #endregion #region AG_IAS_REGISTRATION_T AG_IAS_REGISTRATION_T newRegis = new AG_IAS_REGISTRATION_T { ID = ID, MEMBER_TYPE = ent.MEMBER_TYPE, ID_CARD_NO = Regis.ID_CARD_NO, EMPLOYEE_NO = Regis.EMPLOYEE_NO, PRE_NAME_CODE = Regis.PRE_NAME_CODE, NAMES = Regis.NAMES, LASTNAME = Regis.LASTNAME, NATIONALITY = Regis.NATIONALITY, BIRTH_DATE = Regis.BIRTH_DATE, SEX = Regis.SEX, EDUCATION_CODE = Regis.EDUCATION_CODE, ADDRESS_1 = Regis.ADDRESS_1, ADDRESS_2 = Regis.ADDRESS_2, AREA_CODE = Regis.AREA_CODE, PROVINCE_CODE = Regis.PROVINCE_CODE, ZIP_CODE = Regis.ZIP_CODE, TELEPHONE = Regis.TELEPHONE, LOCAL_ADDRESS1 = Regis.LOCAL_ADDRESS1, LOCAL_ADDRESS2 = Regis.LOCAL_ADDRESS2, LOCAL_AREA_CODE = Regis.LOCAL_AREA_CODE, LOCAL_PROVINCE_CODE = Regis.LOCAL_PROVINCE_CODE, LOCAL_ZIPCODE = Regis.LOCAL_ZIPCODE, LOCAL_TELEPHONE = Regis.LOCAL_TELEPHONE, EMAIL = Regis.EMAIL, STATUS = Regis.STATUS, TUMBON_CODE = Regis.TUMBON_CODE, LOCAL_TUMBON_CODE = Regis.LOCAL_TUMBON_CODE, COMP_CODE = ent.COMP_CODE, CREATED_BY = userProfile.Id, CREATED_DATE = DateTime.Now, UPDATED_BY = userProfile.Id, UPDATED_DATE = DateTime.Now, NOT_APPROVE_DATE = Regis.NOT_APPROVE_DATE, LINK_REDIRECT = Regis.LINK_REDIRECT, REG_PASS = Regis.REG_PASS, APPROVE_RESULT = Regis.APPROVE_RESULT, APPROVED_BY = Regis.APPROVED_BY, AGENT_TYPE = Regis.AGENT_TYPE, IMPORT_STATUS = Regis.IMPORT_STATUS }; #endregion base.ctx.AG_IAS_PERSONAL_T.AddObject(newPerson); base.ctx.AG_IAS_USERS.AddObject(newUser); base.ctx.AG_IAS_REGISTRATION_T.AddObject(newRegis); Person.STATUS = "7"; Regis.STATUS = "7"; User.IS_ACTIVE = "C"; User.UPDATED_BY = userProfile.Id; User.UPDATED_DATE = DateTime.Now; User.OTH_USER_TYPE = ent.OTH_USER_TYPE; loginfo = string.Format("{0} {1} เปลี่ยนประเภทผู้ใช้งานจาก USER_ID:{2} เป็น USER_ID:{3}", Person.NAMES, Person.LASTNAME, ent.ID, ID); } else if (ent.MEMBER_TYPE == "5" || ent.MEMBER_TYPE == "6" || ent.MEMBER_TYPE == "4") { if (ent.MEMBER_TYPE == Person.MEMBER_TYPE) { res.ErrorMsg = "ไม่มีการเปลี่ยนแปลงข้อมูล"; return(res); } loginfo = string.Format("[OIC] USER_ID:{0} {1} {2} เปลี่ยนประเภทผู้ใช้งานจาก MEMBER_TYPE:{3} เป็น MEMBER_TYPE:{4}", ent.ID, Person.NAMES, Person.LASTNAME, Person.MEMBER_TYPE, ent.MEMBER_TYPE); Person.MEMBER_TYPE = ent.MEMBER_TYPE; Person.UPDATED_BY = userProfile.Id; Person.UPDATED_DATE = DateTime.Now; User.USER_TYPE = ent.MEMBER_TYPE; User.MEMBER_TYPE = ent.MEMBER_TYPE; User.UPDATED_BY = userProfile.Id; User.UPDATED_DATE = DateTime.Now; User.OTH_USER_TYPE = ent.OTH_USER_TYPE; } else { res.ErrorMsg = "ไม่มีการเปลี่ยนแปลงข้อมูล"; return(res); } base.ctx.SaveChanges(); LoggerFactory.CreateLog().LogInfo(loginfo); } catch (Exception ex) { res.ErrorMsg = "พบข้อผิดพลาดในการเปลี่ยนประเภทผู้ใช้งาน"; LoggerFactory.CreateLog().Fatal(string.Format("AccountService_EditMemberTypeAndActive USER_ID: {0}", ent.ID), ex); } return(res); }