protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { if (Request["id"] != null) { ErmTsPersonalInfoPara p = new ErmTsPersonalInfoPara(); RegisterENG eng = new RegisterENG(); p = eng.GetRegisterInfo(Convert.ToInt64(Request["id"])); eng=null; if (p.ID>0){ if (p.MIDDLE_NAME.Trim() != "") lblName.Text = p.FIRST_NAME + " " + p.MIDDLE_NAME + " " + p.LAST_NAME; else lblName.Text = p.FIRST_NAME + " " + p.LAST_NAME; lblID.Text = "*" + p.ID.ToString().PadLeft(4, '0') + "*"; lblName2.Text = p.FIRST_NAME + " " + p.LAST_NAME; lblPosition.Text =p.POSITION_NAME; lblDivision.Text =p.DIVISION; lblCompany.Text =p.COMPANY_NAME; lblProvince.Text = p.CITY; lblMobileNumber.Text = p.MOBILE_NO; } p = null; } } }
public long SavePersonalInfo(ErmTsPersonalInfoPara p,string LoginName, TransactionDB trans) { long ret = 0; try { ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq(); if (p.ID > 0) lnq.GetDataByPK(p.ID, trans.Trans); lnq.MEMBER_NO = p.MEMBER_NO; lnq.MEMBER_TYPE = p.MEMBER_TYPE; lnq.IDCARD_NO = p.IDCARD_NO; lnq.TITLE_NAME = p.TITLE_NAME; lnq.FIRST_NAME = p.FIRST_NAME; lnq.MIDDLE_NAME = p.MIDDLE_NAME; lnq.LAST_NAME = p.LAST_NAME; lnq.POSITION_NAME = p.POSITION_NAME; lnq.DIVISION = p.DIVISION; lnq.COMPANY_NAME = p.COMPANY_NAME; lnq.ADDRESS = p.ADDRESS; lnq.CITY = p.CITY; lnq.STATE = p.STATE; lnq.COUNTRY = p.COUNTRY; lnq.ZIPCODE = p.ZIPCODE; lnq.TELNO = p.TELNO; lnq.MOBILE_NO = p.MOBILE_NO; lnq.FAXNO = p.FAXNO; lnq.EMAIL = p.EMAIL; lnq.WEBSITE = p.WEBSITE; lnq.REGISTERED_CAPITAL = p.REGISTERED_CAPITAL; lnq.ANNUAL_SALE_VALUE_YEAR = p.ANNUAL_SALE_VALUE_YEAR; lnq.ANNUAL_SALE_VALUE_VOLUMNS = p.ANNUAL_SALE_VALUE_VOLUMNS; lnq.REGISPERIOD = p.REGISPERIOD; lnq.VALID_DATE = p.VALID_DATE; lnq.EXPIRE_DATE = p.EXPIRE_DATE; bool re = false; if (lnq.ID > 0) re = lnq.UpdateByPK(LoginName, trans.Trans); else re = lnq.InsertData(LoginName, trans.Trans); if (re == true) ret = lnq.ID; }catch(Exception ex){ _err = "Engine.Questionnaire.RegisteENG.SavePersonalInfo Exception :" + ex.Message; ret=0; } return ret; }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { if (Request["id"] != null) { ErmTsPersonalInfoPara p = new ErmTsPersonalInfoPara(); RegisterENG eng = new RegisterENG(); p = eng.GetRegisterInfo(Convert.ToInt64(Request["id"])); eng=null; if (p.ID>0){ if (p.MIDDLE_NAME.Trim() != "") lblName.Text = p.FIRST_NAME + " " + p.MIDDLE_NAME + " " + p.LAST_NAME; else lblName.Text = p.FIRST_NAME + " " + p.LAST_NAME; lblID.Text = p.ID.ToString().PadLeft(6, '0'); } p = null; } } }
public ErmTsPersonalInfoPara GetRegisterInfo(long vID) { ErmTsPersonalInfoPara ret = new ErmTsPersonalInfoPara(); try { ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq(); ret = lnq.GetParameter(vID, null); lnq = null; } catch (Exception ex) { } return ret; }
protected void btnSave_Click(object sender, EventArgs e) { if (validate() == false) return; String strServerName = ConfigurationManager.AppSettings["ServerName"]; String strDbName = ConfigurationManager.AppSettings["DbName"]; String strDbUserID = ConfigurationManager.AppSettings["DbUserID"]; String strDbPwd = ConfigurationManager.AppSettings["DbPwd"]; SqlConnection objConn = new SqlConnection("Data Source=" + strServerName +";Initial Catalog=" + strDbName +";User ID=" +strDbUserID + ";password="******"0") { String strSql = ""; strSql = "Select Count(*) From ERM_TS_Personal_info Where first_name='" + txtFirstName.Text + "' And last_name='" + txtLastName.Text + "'"; SqlCommand objCmd = new SqlCommand(strSql, objConn); String Result = Convert.ToString(objCmd.ExecuteScalar()); if (Result != "0") { Config.SetAlert("ชื่อนี้ได้ทำการลงทะเบียนแล้ว", this); return; } strSql = "Select Count(*) From ERM_TS_Personal_info Where Email='" + txtEmail.Text + "' "; objCmd = new SqlCommand(strSql, objConn); Result = Convert.ToString(objCmd.ExecuteScalar()); if (Result != "0") { Config.SetAlert("อีเมลล์นี้ได้ทำการลงทะเบียนแล้ว", this); return; } strSql = "Select Count(*) From ERM_TS_Personal_info Where Mobile_No='" + txtMobileNo.Text + "' "; objCmd = new SqlCommand(strSql, objConn); Result = Convert.ToString(objCmd.ExecuteScalar()); if (Result != "0") { Config.SetAlert("เบอร์โทรนี้ได้ทำการลงทะเบียนแล้ว", this); return; } } int intChkA = 0; int intChkB = 0; int intChkC = 0; int intChkD = 0; int intChkE = 0; if ((rdPeriod.Items[0].Selected == false) && (rdPeriod.Items[1].Selected == false)) { Config.SetAlert("กรุณาเลือกช่วงเวลาเข้าร่วมงาน", this); return; } if (ChkA01.Checked == true) { intChkA += 1; } if (ChkA02.Checked == true) { intChkA += 1; } if (ChkA03.Checked == true) { intChkA += 1; } if (ChkA04.Checked == true) { intChkA += 1; } if (ChkA05.Checked == true) { intChkA += 1; } if (ChkA06.Checked == true) { intChkA += 1; } if (ChkA07.Checked == true) { intChkA += 1; } if (ChkA08.Checked == true) { intChkA += 1; } if (ChkA09.Checked == true) { intChkA += 1; } if (ChkA10.Checked == true) { intChkA += 1; } if (ChkA11.Checked == true) { intChkA += 1; } if (ChkA12.Checked == true) { intChkA += 1; } if (ChkA13.Checked == true) { intChkA += 1; } if (ChkA14.Checked == true) { intChkA += 1; } if (ChkA15.Checked == true) { intChkA += 1; } if (ChkA16.Checked == true) { intChkA += 1; } if (ChkA17.Checked == true) { intChkA += 1; } if (ChkB01.Checked == true) { intChkB += 1; } if (ChkB02.Checked == true) { intChkB += 1; } if (ChkB03.Checked == true) { intChkB += 1; } if (ChkB04.Checked == true) { intChkB += 1; } if (ChkB05.Checked == true) { intChkB += 1; } if (ChkB06.Checked == true) { intChkB += 1; } if (ChkB07.Checked == true) { intChkB += 1; } if (ChkB08.Checked == true) { intChkB += 1; } if (ChkB09.Checked == true) { intChkB += 1; } if (ChkB10.Checked == true) { intChkB += 1; } if (ChkB11.Checked == true) { intChkB += 1; } if (ChkB12.Checked == true) { intChkB += 1; } if (ChkB13.Checked == true) { intChkB += 1; } if (ChkB14.Checked == true) { intChkB += 1; } if (ChkC01.Checked == true) { intChkC += 1; } if (ChkC02.Checked == true) { intChkC += 1; } if (ChkC03.Checked == true) { intChkC += 1; } if (ChkC04.Checked == true) { intChkC += 1; } if (ChkC05.Checked == true) { intChkC += 1; } if (ChkC06.Checked == true) { intChkC += 1; } if (ChkC07.Checked == true) { intChkC += 1; } if (ChkD01.Checked == true) { intChkD += 1; } if (ChkD02.Checked == true) { intChkD += 1; } if (ChkE01.Checked == true) { intChkE += 1; } if (ChkE02.Checked == true) { intChkE += 1; } if (ChkE03.Checked == true) { intChkE += 1; } if (ChkE04.Checked == true) { intChkE += 1; } if (ChkE05.Checked == true) { intChkE += 1; } if (ChkE06.Checked == true) { intChkE += 1; } if (ChkE07.Checked == true) { intChkE += 1; } if (ChkE08.Checked == true) { intChkE += 1; } if (ChkE09.Checked == true) { intChkE += 1; } if (ChkE10.Checked == true) { intChkE += 1; } if (ChkE11.Checked == true) { intChkE += 1; } if (ChkE12.Checked == true) { intChkE += 1; } if (ChkE13.Checked == true) { intChkE += 1; } if (ChkE14.Checked == true) { intChkE += 1; } if (ChkE15.Checked == true) { intChkE += 1; } if (ChkE16.Checked == true) { intChkE += 1; } if (ChkE17.Checked == true) { intChkE += 1; } if (ChkE18.Checked == true) { intChkE += 1; } if (ChkE19.Checked == true) { intChkE += 1; } if (intChkA == 0) { Config.SetAlert("กรุณาระบุประเภทธุรกิจของท่าน", this); return; } if (intChkB == 0) { Config.SetAlert("กรุณาระบุช่องทางการได้รับข่าวสาร", this); return; } if (intChkC == 0) { Config.SetAlert("กรุณาระบุวัตถุประสงค์ของการเข้าชมงาน", this); return; } if (intChkD == 0) { Config.SetAlert("กรุณาระบุความต้องการการเข้าชม", this); return; } if (intChkE == 0) { Config.SetAlert("กรุณาระบุประเภทสินค้าหรือบริการที่ท่านสนใจ", this); return; } //Page.Form.DefaultFocus = txtFirstName.ClientID; ErmTsPersonalInfoPara Erm = new ErmTsPersonalInfoPara(); if (lblid.Text != "0") { Erm.ID = Convert.ToInt64(lblid.Text); } Erm.IDCARD_NO = "0"; //txtIDCardNo.Text; Erm.TITLE_NAME = rdiTitle.SelectedValue; if (rdiTitle.SelectedValue == "OTHERS") { Erm.TITLE_NAME = txtTitleOthers.Text; } Erm.FIRST_NAME = txtFirstName.Text; Erm.MIDDLE_NAME = "";// txtMiddleName.Text; Erm.LAST_NAME = txtLastName.Text; Erm.POSITION_NAME = txtPosition.Text; Erm.COMPANY_NAME = txtCompany.Text; Erm.ADDRESS = txtAddress.Text; Erm.CITY = txtCity.Text; Erm.STATE = "";//txtState.Text; Erm.COUNTRY = txtCountry.Text; Erm.ZIPCODE = txtZipCode.Text; Erm.TELNO = txtTelNumber.Text; Erm.FAXNO = txtFaxNumber.Text; Erm.EMAIL = txtEmail.Text; Erm.WEBSITE = txtWebSite.Text; Erm.DIVISION = txtDivition.Text; Erm.MOBILE_NO = txtMobileNo.Text; if ((rdPeriod.Items[0].Selected == true) && (rdPeriod.Items[1].Selected == true)) { Erm.REGISPERIOD = "3"; } else { Erm.REGISPERIOD = rdPeriod.SelectedValue; } // if (txtRegisteredCapital.Text != "") Erm.REGISTERED_CAPITAL = 0;//Convert.ToDouble(txtRegisteredCapital.Text); Erm.ANNUAL_SALE_VALUE_YEAR = DateTime.Today.Year; Erm.ANNUAL_SALE_VALUE_VOLUMNS = rdAnnualSale.SelectedValue; TransactionDB Trans = new TransactionDB(); Engine.Questionnaire.RegisterENG eng = new Engine.Questionnaire.RegisterENG(); long id; id = eng.SavePersonalInfo(Erm, "Register", Trans); if (id > 0) { bool IsDel = true; IsDel = eng.DeleteInterest(id, Trans); if (IsDel == false) { Trans.RollbackTransaction(); ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('ไม่สามารถบันทึกข้อมูลได้');", true); return; } SaveDetail(ChkA01, id, Trans,"","A"); SaveDetail(ChkA02, id, Trans, "", "A"); SaveDetail(ChkA03, id, Trans, "", "A"); SaveDetail(ChkA04, id, Trans, "", "A"); SaveDetail(ChkA05, id, Trans, "", "A"); SaveDetail(ChkA06, id, Trans, "", "A"); SaveDetail(ChkA07, id, Trans, "", "A"); SaveDetail(ChkA08, id, Trans, "", "A"); SaveDetail(ChkA09, id, Trans, "", "A"); SaveDetail(ChkA10, id, Trans, txtA10.Text, "A"); SaveDetail(ChkA11, id, Trans, "", "A"); SaveDetail(ChkA12, id, Trans, "", "A"); SaveDetail(ChkA13, id, Trans, "", "A"); SaveDetail(ChkA14, id, Trans, "", "A"); SaveDetail(ChkA15, id, Trans, "", "A"); SaveDetail(ChkA16, id, Trans, "", "A"); SaveDetail(ChkA17, id, Trans, txtA17.Text, "A"); SaveDetail(ChkB01, id, Trans, "", "B"); SaveDetail(ChkB02, id, Trans, "", "B"); SaveDetail(ChkB03, id, Trans, "", "B"); SaveDetail(ChkB04, id, Trans, txtB04.Text, "B"); SaveDetail(ChkB05, id, Trans, txtB05.Text, "B"); SaveDetail(ChkB06, id, Trans, txtB06.Text, "B"); SaveDetail(ChkB07, id, Trans, "", "B"); SaveDetail(ChkB08, id, Trans, "", "B"); SaveDetail(ChkB09, id, Trans, "", "B"); SaveDetail(ChkB10, id, Trans, "", "B"); SaveDetail(ChkB11, id, Trans, "", "B"); SaveDetail(ChkB12, id, Trans, "", "B"); SaveDetail(ChkB13, id, Trans, "", "B"); SaveDetail(ChkB14, id, Trans, txtB14.Text, "B"); SaveDetail(ChkC01, id, Trans, "", "C"); SaveDetail(ChkC02, id, Trans, "", "C"); SaveDetail(ChkC03, id, Trans, "", "C"); SaveDetail(ChkC04, id, Trans, "", "C"); SaveDetail(ChkC05, id, Trans, "", "C"); SaveDetail(ChkC06, id, Trans, "", "C"); SaveDetail(ChkC07, id, Trans, txtC07.Text, "C"); SaveDetail(ChkD01, id, Trans, "", "D"); SaveDetail(ChkD02, id, Trans, txtD02.Text, "D"); SaveDetail(ChkE01, id, Trans, "", "E"); SaveDetail(ChkE02, id, Trans, "", "E"); SaveDetail(ChkE03, id, Trans, "", "E"); SaveDetail(ChkE04, id, Trans, "", "E"); SaveDetail(ChkE05, id, Trans, "", "E"); SaveDetail(ChkE06, id, Trans, "", "E"); SaveDetail(ChkE07, id, Trans, "", "E"); SaveDetail(ChkE08, id, Trans, "", "E"); SaveDetail(ChkE09, id, Trans, "", "E"); SaveDetail(ChkE10, id, Trans, "", "E"); SaveDetail(ChkE11, id, Trans, "", "E"); SaveDetail(ChkE12, id, Trans, "", "E"); SaveDetail(ChkE13, id, Trans, "", "E"); SaveDetail(ChkE14, id, Trans, "", "E"); SaveDetail(ChkE15, id, Trans, "", "E"); SaveDetail(ChkE16, id, Trans, "", "E"); SaveDetail(ChkE17, id, Trans, "", "E"); SaveDetail(ChkE18, id, Trans, "", "E"); SaveDetail(ChkE19, id, Trans, "", "E"); Trans.CommitTransaction(); bool ret = false; ret = clsSendMail.SendEmailMessage(txtEmail.Text, "*****@*****.**", "mail.scoresolutions.co.th", "1qaz@WSX", txtFirstName.Text + " " + txtLastName.Text, id.ToString(), Server.MapPath("~/image/PrintAdsTheretrunofRFIDHERO_Resize.jpg"), 25, false, Server.MapPath("~/image/logo.png")); if (ret == false) { ret = clsSendMail.SendEmailMessage(txtEmail.Text, "*****@*****.**", "smtp.live.com", "1qaz@WSX", txtFirstName.Text + " " + txtLastName.Text, id.ToString(), Server.MapPath("~/image/PrintAdsTheretrunofRFIDHERO_Resize.jpg"), 587, true, Server.MapPath("~/image/logo.png")); } if (ret == true) { Trans = new TransactionDB(); if (eng.UpdateIsSendMail(id, "Register", Trans) == true) { Trans.CommitTransaction(); } else { Trans.RollbackTransaction(); } } eng = null; //Response.Redirect("../WebApp/frmRegisterComplete.aspx?id=" + Convert.ToString(id)); //Config.ShowModalDialog("../WebApp/frmRegisterEmailComplete.aspx?id=" +id, this); Config.RedirecPage("../WebApp/frmRegisterEmailComplete.aspx?id=" + id, this); Clear(); } else { Trans.RollbackTransaction(); Config.SetAlert("ไม่สามารถบันทึกข้อมูลได้",this); } }
public static ErmTsPersonalInfoPara GetPersonalInfoByMemberNo(string MemberNo) { ErmTsPersonalInfoPara ret = new ErmTsPersonalInfoPara(); try { DataTable dt = new DataTable(); ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq(); dt = lnq.GetDataList("member_no='" + MemberNo + "'", "", null); if (dt.Rows.Count > 0) { ret = lnq.GetParameter(Convert.ToInt64(dt.Rows[0]["id"]),null); } dt.Dispose(); } catch (Exception ex) { ret = new ErmTsPersonalInfoPara(); } return ret; }