public void MailConfirmHelper_Can_send_mail_registration_toMember() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); AG_IAS_REGISTRATION_T regis = ctx.AG_IAS_REGISTRATION_T.SingleOrDefault(a => a.EMAIL == "*****@*****.**"); MailConfirmHelper.SendMailConfirmRegistration(regis); }
public static bool SendMailApproveRegister(AG_IAS_REGISTRATION_T register, String username) { StringBuilder emailBody = new StringBuilder(); String webUrl = String.Empty; String fromMail = ConfigurationManager.AppSettings["EmailOut"].ToString(); //String webUrl = ConfigurationManager.AppSettings["WebPublicUrl"].ToString(); if (register.MEMBER_TYPE.Equals(DTO.MemberType.General.GetEnumValue().ToString()) || register.MEMBER_TYPE.Equals(DTO.MemberType.Association.GetEnumValue().ToString()) || register.MEMBER_TYPE.Equals(DTO.MemberType.Insurance.GetEnumValue().ToString())) { webUrl = ConfigurationManager.AppSettings["WebPublicUrlForUser"].ToString(); } else { webUrl = ConfigurationManager.AppSettings["WebPublicUrl"].ToString(); } string emailAddress = register.EMAIL; //string emailSubject = "ระบบลงทะเบียนระบบช่องทางการบริหารตัวแทน/นายหน้าประกันภัย"; string fullname = String.Format("{0} {1} {2}", "", register.NAMES, register.LASTNAME); emailBody.AppendLine(String.Format("เนื่องด้วย {0} ได้ทำการสมัครเข้าใช้ ระบบช่องทางการบริการตัวแทน/นายหน้าประกันภัยแบบเบ็ดเสร็จ<br/><br />", fullname)); emailBody.AppendLine(String.Format("ชื่อผู้ใช้ระบบ : {0} <br />", username)); if (register.STATUS == ((int)DTO.RegistrationStatus.Approve).ToString()) { emailBody.AppendLine(Resources.infoMailApprovePersonHelper_001 + "<br />"); } else if (register.STATUS == ((int)DTO.RegistrationStatus.NotApprove).ToString()) { emailBody.AppendLine(Resources.infoMailApprovePersonHelper_002 + "<br />"); emailBody.AppendLine(Resources.infoMailApprovePersonHelper_003 + "<br />"); } String link = String.Format("<a href='{0}home.aspx'>คลิกเพื่อเข้าใช้ระบบ</a>", webUrl); emailBody.AppendLine(link + "<br /><br />"); try { MailMessage mailMsg = EmailSender.Sending(emailBody, emailAddress); mailMsg.Sent(); } catch (Exception) { return(false); } return(true); }
public void SendMailConfirmRegistration_Can_Sent_Email() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); AG_IAS_REGISTRATION_T regis = ctx.AG_IAS_REGISTRATION_T.SingleOrDefault(a => a.ID_CARD_NO == "1544447642968"); Assert.IsNotNull(regis); Boolean result = MailConfirmHelper.SendMailConfirmRegistration(regis); Assert.IsTrue(result); }
public static bool SendMailChangePasswordRegistration(AG_IAS_REGISTRATION_T person, String username, String oldpassword, String newpassword) { StringBuilder emailBody = new StringBuilder(); String webUrl = String.Empty; if (person.MEMBER_TYPE.Equals(DTO.MemberType.General.GetEnumValue().ToString()) || person.MEMBER_TYPE.Equals(DTO.MemberType.Association.GetEnumValue().ToString()) || person.MEMBER_TYPE.Equals(DTO.MemberType.Insurance.GetEnumValue().ToString())) { webUrl = ConfigurationManager.AppSettings["WebPublicUrlForUser"].ToString(); } else { webUrl = ConfigurationManager.AppSettings["WebPublicUrl"].ToString(); } string emailAddress = person.EMAIL; string fullname = String.Format("{0} {1} {2}", "", person.NAMES, person.LASTNAME); emailBody.AppendLine(String.Format("เนื่องด้วย {0} ได้ทำการเปลี่ยนรหัสผ่าน ระบบช่องทางการบริการตัวแทน/นายหน้าประกันภัยแบบเบ็ดเสร็จ<br/><br />", fullname)); emailBody.AppendLine(String.Format("ชื่อผู้ใช้ระบบ : {0} <br />", username)); emailBody.AppendLine(String.Format("รหัสผ่านใหม่ของคุณคือ {0} <br /><br />", newpassword)); String paras = Utils.CryptoBase64.Encryption(String.Format("{0}||{1}||{2}||{3}", username, oldpassword, newpassword, person.EMAIL)); String linkrenew = String.Format("<a href='{0}ForgetPassword/ConfirmRenew.aspx?renew={1}'>คลิกเพื่อยืนยันการเปลี่ยนรหัสผ่าน</a>", webUrl, paras); String link = String.Format("<a href='{0}home.aspx'>คลิกเพื่อเข้าใช้ระบบ</a>", webUrl); emailBody.AppendLine(linkrenew + "<br /><br />"); emailBody.AppendLine(link + "<br /><br />"); try { EmailSender.Sending(emailBody, emailAddress).Sent(); } catch (Exception) { return(false); } return(true); }
public void UpdateTest() { IRegistrationService target = CreateIRegistrationService(); // TODO: Initialize to an appropriate value String id = OracleDB.GetGenAutoId(); AG_IAS_REGISTRATION_T regis1 = new AG_IAS_REGISTRATION_T() { ID = id, ID_CARD_NO = "1236277389234", NAMES = "MyName", LASTNAME = "LastName" }; ctx.AG_IAS_REGISTRATION_T.AddObject(regis1); DTO.Registration entity = new DTO.Registration() { ID = id, ID_CARD_NO = "1234567890123", NAMES = "NewName", LASTNAME = "LastName" }; // TODO: Initialize to an appropriate value ResponseService <DTO.Registration> expected = new ResponseService <DTO.Registration>(); // TODO: Initialize to an appropriate value expected.DataResponse = new DTO.Registration() { ID = id, ID_CARD_NO = "1234567890123", NAMES = "NewName", LASTNAME = "LastName" }; ResponseService <DTO.Registration> actual; actual = target.Update(entity); Assert.AreEqual(expected.DataResponse.ID, actual.DataResponse.ID); Assert.AreEqual(expected.DataResponse.ID_CARD_NO, actual.DataResponse.ID_CARD_NO); Assert.AreEqual(expected.DataResponse.NAMES, actual.DataResponse.NAMES); Assert.AreEqual(expected.DataResponse.LASTNAME, actual.DataResponse.LASTNAME); Assert.AreNotEqual(expected.DataResponse.UPDATED_DATE, actual.DataResponse.UPDATED_DATE); //Assert.Inconclusive("Verify the correctness of this test method."); }
public static bool SendMailConfirmRegistration(AG_IAS_REGISTRATION_T reg) { StringBuilder emailBody = new StringBuilder(); String webUrl = String.Empty; //String webUrl = ConfigurationManager.AppSettings["WebPublicUrl"].ToString(); if (reg.MEMBER_TYPE.Equals(DTO.MemberType.General.GetEnumValue().ToString()) || reg.MEMBER_TYPE.Equals(DTO.MemberType.Association.GetEnumValue().ToString()) || reg.MEMBER_TYPE.Equals(DTO.MemberType.Insurance.GetEnumValue().ToString())) { webUrl = ConfigurationManager.AppSettings["WebPublicUrlForUser"].ToString(); } else { webUrl = ConfigurationManager.AppSettings["WebPublicUrl"].ToString(); } string emailAddress = reg.EMAIL; string fullname = String.Format("{0} {1} {2}", "", reg.NAMES, reg.LASTNAME); string status = ""; Int32 statusNo; if (reg.STATUS == null) { reg.STATUS = DTO.RegistrationStatus.WaitForApprove.GetEnumValue().ToString(); } if (Int32.TryParse(reg.STATUS.ToString(), out statusNo)) { if (statusNo == 1 || statusNo == 2) { DTO.RegistrationStatus regstatus = (DTO.RegistrationStatus)statusNo; //switch (regstatus) //{ // case DTO.RegistrationStatus.WaitForApprove: status = "รอการอนุมัติ"; break; // case DTO.RegistrationStatus.NotApprove: status = "ได้รับการอนุมัติ"; break; // default: // break; //} if (regstatus.GetEnumValue().ToString().Equals(DTO.RegistrationStatus.WaitForApprove.GetEnumValue().ToString())) { status = "รอการอนุมัติ"; } else if (regstatus.GetEnumValue().ToString().Equals(DTO.RegistrationStatus.Approve.GetEnumValue().ToString())) { status = "ได้รับการอนุมัติ"; } } } emailBody.AppendLine(String.Format("เนื่องด้วย {0} ได้ทำการสมัครสมาชิก ระบบช่องทางการบริการตัวแทน/นายหน้าประกันภัยแบบเบ็ดเสร็จ<br/><br/>", fullname)); if (!String.IsNullOrEmpty(reg.MEMBER_TYPE) && Convert.ToInt32(reg.MEMBER_TYPE) == (int)DTO.RegistrationType.TestCenter) { //String usernamepass = Utils.CryptoBase64.Encryption(reg.EMAIL+"||"+reg.REG_PASS); emailBody.AppendLine(String.Format("ชื่อผู้ใช้ : {0} <br /><br />", reg.EMAIL)); String link = String.Format("<a href='{0}ChangePassword/ChangePass.aspx?dat={1}'>คลิกเพื่อทำการยืนยันการลงทะเบียน</a>", webUrl, reg.LINK_REDIRECT); emailBody.AppendLine(link); } else if (!String.IsNullOrEmpty(reg.MEMBER_TYPE) && Convert.ToInt32(reg.MEMBER_TYPE) == (int)DTO.RegistrationType.General) { emailBody.AppendLine(String.Format("ชื่อผู้ใช้ : {0} <br /><br />", reg.ID_CARD_NO)); String link = String.Format("<a href='{0}home.aspx'>คลิกเพื่อเข้าใช้ระบบ</a>", webUrl); emailBody.AppendLine(link); } else if (!String.IsNullOrEmpty(reg.MEMBER_TYPE) && (Convert.ToInt32(reg.MEMBER_TYPE) == (int)DTO.RegistrationType.Insurance || Convert.ToInt32(reg.MEMBER_TYPE) == (int)DTO.RegistrationType.Association)) { emailBody.AppendLine(String.Format("ชื่อผู้ใช้ : {0} <br /><br />", reg.EMAIL)); String link = String.Format("<a href='{0}home.aspx'>คลิกเพื่อเข้าใช้ระบบ</a>", webUrl); emailBody.AppendLine(link); } emailBody.AppendLine(String.Format("ขณะนี้สถานะของคุณ คือ {0} <br /> ", status)); try { EmailSender.Sending(emailBody, emailAddress).Sent(); } catch (Exception) { return(false); } return(true); }
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); }