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