protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
EntityServiceReference.EntityServiceClient ServiceRefClient = new EntityServiceReference.EntityServiceClient();
ServiceRefClient.Open();
if (Session["RegId"] != null && Session["RegId"] != "")
{
int cnfrm = ServiceRefClient.ChangePassword(LblMembershipId.Text.ToString(), txtOldPassword.Text.ToString(), txtNewPassword.Text.ToString());
if (cnfrm == 1)
{
LblMsg.Text = "Password Changed";
EntityServiceReference.EntityServiceClient ServiceRefClient2 = new EntityServiceReference.EntityServiceClient();
ServiceRefClient2.Open();
var arr=ServiceRefClient2.GetUserDetails(Session["RegId"].ToString());
if(arr.Length>0)
{
HTMLMailer(arr[0].Email.ToString(),txtNewPassword.Text.ToString(), Session["RegId"].ToString());
}
ServiceRefClient2.Close();
}
else
{
LblMsg.Text = "Entered Password Is Wrong";
}
}
ServiceRefClient.Close();
}
catch (Exception ex)
{
LblMsg.Text= ex.Message;
}
}
void InsertTransDetails()
{
if (Request.QueryString["Type"] != null && Request.QueryString["Type"] != "")
{
if (Request.QueryString["Type"].ToString().Equals("signup"))
{
//Pay Details , membership payment details update
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
int Confirm = ServiceClient.UpdatePaymentDetails(LblMemberId.Text.ToString(), 0, 0, Convert.ToDecimal(LblAmount.Text.ToString()), LblMemberId.Text.ToString());
ServiceClient.Close();
//PG
if (rbl_CardType.SelectedValue == "IDBI")
{
Response.Redirect("../Payment/Idbi/Default.aspx?type=idbi&transid=" + LblMemberId.Text.ToString() + "_" + LblType.Text.ToString() +"&amt=" + LblAmount.Text.ToString() + "&show=" + LblType.Text.ToString());
}
else if (rbl_CardType.SelectedValue == "AMEX")
{
Response.Redirect("../Payment/Amex/Default.aspx?type=amex&transid=" + LblMemberId.Text.ToString() + "&amt=" + LblAmount.Text.ToString() + "&show=" + LblType.Text.ToString());
}
// end PG
}
else if (Request.QueryString["Type"].ToString().Equals("topup"))
{
// top up insert
//Pay Details , membership payment details update
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
// trans type 0=recharge, 1=payment
var Confirm = ServiceClient.InsertTopUpDetails(LblMemberId.Text.ToString(),Convert.ToDecimal(LblAmount.Text.ToString()),DateTime.Now.Date,LblMemberId.Text.ToString(),0);
if (Confirm[0].Transaction_Id != "")
{
LblTransId.Text = Confirm[0].Transaction_Id.ToString();
}
ServiceClient.Close();
//PG
if (rbl_CardType.SelectedValue == "IDBI")
{
Response.Redirect("../Payment/Idbi/Default.aspx?type=idbi&transid=" + LblTransId.Text.ToString() + "_" + LblType.Text.ToString() + "&amt=" + LblAmount.Text.ToString() + "&show=" + LblType.Text.ToString());
}
else if (rbl_CardType.SelectedValue == "AMEX")
{
Response.Redirect("../Payment/Amex/Default.aspx?type=amex&transid=" + LblTransId.Text.ToString() + "&amt=" + LblAmount.Text.ToString() + "&show=" + LblType.Text.ToString());
}
else if (rbl_CardType.SelectedValue == "HDFC")
{
Response.Redirect("../Payment/HDFC/Default.aspx?type=hdfc&transid=" + LblTransId.Text.ToString() + "&amt=" + LblAmount.Text.ToString() + "&show=" + LblType.Text.ToString());
}
// end PG
}
}
}
void BindData()
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
if (Session["RegId"] != null && Session["RegId"] != "")
{
var arr = ServiceClient.GetPointStatusByMemberId(Session["RegId"].ToString());
if (arr.Length > 0)
{
GridPointList.DataSource = arr;
GridPointList.DataBind();
}
}
ServiceClient.Close();
}
protected void BindData()
{
EntityServiceReference.EntityServiceClient ServiceClient=new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
if (Session["RegId"] != null && Session["RegId"] != "")
{
var arr = ServiceClient.GetAllCardsDetails();
for (int i = 0; i <= arr.Length-1; i++)
{
DivTxt += "<li><a href='CardListing.aspx?type=" + arr[i].Code.ToString() + "'>" + arr[i].Description.ToString() + "</a></li>";
}
Response.Write(DivTxt.ToString());
}
}
void BindData()
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
if (Session["RegId"] != null && Session["RegId"] != "")
{
var arr = ServiceClient.GetUserDetails(Session["RegId"].ToString());
if (arr.Length > 0)
{
txtFirstName.Text = arr[0].FirstName.ToString();
txtLastName.Text = arr[0].LastName.ToString();
txtCity.Text = arr[0].City.ToString();
txtAddress.Text = arr[0].Address.ToString();
txtMobileNo.Text = arr[0].Mobile.ToString();
if (!arr[0].DOB.ToString().Equals(""))
{
String[] arrDob = new String[arr[0].DOB.Length];
arrDob = arr[0].DOB.ToString().Split('/');
ddlday.SelectedValue = arrDob[0].ToString();
ddlmonth.SelectedValue = arrDob[1].ToString();
ddlyear.SelectedValue = arrDob[2].ToString();
}
if (!arr[0].AnniversaryDate.ToString().Equals(""))
{
String[] arrAnn = new String[arr[0].AnniversaryDate.Length];
arrAnn = arr[0].AnniversaryDate.ToString().Split('/');
DdlDayAnniversary.SelectedValue = arrAnn[0].ToString();
DdlMonthAnniversary.SelectedValue = arrAnn[1].ToString();
DdlYearAnniversary.SelectedValue = arrAnn[2].ToString();
}
txtDesignation.Text = arr[0].Designation.ToString();
TxtEmail.Text= arr[0].Email.ToString();
DdlCountry.SelectedItem.Text = arr[0].County.ToString();
RdMartialStatus.SelectedValue = arr[0].MaritalStatus.ToString();
RdGender.SelectedValue = arr[0].Salutation.ToString();
if (RdMartialStatus.SelectedValue.ToString().Equals("Married"))
{
trAnn.Visible = true;
}
else
{
trAnn.Visible = false;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IsLogged"] != null && Session["IsLogged"] != "")
{
EntityServiceReference.EntityServiceClient ServiceRefClient = new EntityServiceReference.EntityServiceClient();
ServiceRefClient.Open();
var arr = ServiceRefClient.GetUserDetails(Session["RegId"].ToString());
LblUserName.Text = "Welcome " + arr[0].FirstName.ToString() + " " + arr[0].LastName.ToString() + " [<a href='Logout.aspx'>Sign Out</a> ]";
ServiceRefClient.Close();
}
else
{
LblUserName.Text = "";
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
EntityServiceReference.EntityServiceClient ServiceRefClient = new EntityServiceReference.EntityServiceClient();
ServiceRefClient.Open();
var arr = ServiceRefClient.ForgotPassword(txtmembershipId.Text.ToString(), txtEmailId.Text.ToString());
if (arr.Length > 0)
{
//LblMsg.Text = arr[0].Password.ToString();
emailid = txtEmailId.Text.ToString();
if (arr[0].Value.ToString().Equals("1"))// pwd exist already
{
if (arr[0].Password.ToString().Trim().Equals("") || arr[0].Password.ToString().Trim().Equals(null))// pwd exist already
{
////generate pwd
//var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
//var random = new Random();
//var pwd = new string(
// Enumerable.Repeat(chars, 8)
// .Select(s => s[random.Next(s.Length)])
// .ToArray());
////update pwd in db
//EntityServiceReference.EntityServiceClient ServiceRefClient1 = new EntityServiceReference.EntityServiceClient();
//ServiceRefClient1.Open();
//int cnfrm = ServiceRefClient1.ChangePassword(txtmembershipId.Text.ToString(), arr[0].Password.ToString(), pwd.ToString());
//ServiceRefClient1.Close();
//HTMLMailer(emailid.ToString(), pwd.ToString(), txtmembershipId.Text.ToString());
//LblMsg.Text = "Your password is mailed at " + emailid.ToString();
LblMsg.Text = "Password not found! Please register and verify your membership.";
}
else
{
pwd = arr[0].Password.ToString();
LblMsg.Text = "Your password is mailed at " + emailid.ToString();
// send mail sms
HTMLMailer(emailid.ToString(), pwd.ToString(), txtmembershipId.Text.ToString());
}
}
else
{
LblMsg.Text = "<center>Dear Guest,The Email ID or MembershipID provided by you does not match with our records.<br/>Request you to call at Loyalty Desk for assistance.</center><center>Tel:0124-4847435.</center><center>Email:<a href='mailto:[email protected]'>[email protected]</center></a>";
}
}
ServiceRefClient.Close();
}
void BindData()
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
if (Session["RegId"] != null && Session["RegId"] != "")
{
LblMemberId.Text = Session["RegId"].ToString();
var arr = ServiceClient.GetCardsBalanceByMemberId(Session["RegId"].ToString());
if (arr.Length>0)
{
LblRemainingPoints.Text = arr[0].RemainingPoints.ToString();
LblRemainingAmount.Text = arr[0].RemainingAmount.ToString();
LblAfter24Points.Text = arr[0].After24HourPoints.ToString();
}
}
ServiceClient.Close();
}
void BindData()
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
if (Session["RegId"] != null && Session["RegId"] != "")
{
var arr = ServiceClient.GetUserDetails(Session["RegId"].ToString());
if (arr.Length > 0)
{
LblMemberId.Text = arr[0].MemberID.ToString();
LblName.Text = arr[0].FirstName.ToString() + " " + arr[0].LastName.ToString();
LblAddress.Text = arr[0].Address.ToString();
LblMobileNo.Text = arr[0].Mobile.ToString();
LblDob.Text = arr[0].DOB.ToString();
LblAnniversary.Text = arr[0].AnniversaryDate.ToString();
LblDesignation.Text = arr[0].Designation.ToString();
LblEmailId.Text = arr[0].Email.ToString();
LblStatus.Text = arr[0].MaritalStatus.ToString();
}
}
}
protected void BtnSubmit_Click(object sender, ImageClickEventArgs e)
{
EntityServiceReference.EntityServiceClient ServiceRefClient = new EntityServiceReference.EntityServiceClient();
ServiceRefClient.Open();
var arr = ServiceRefClient.GetUserLogin(txtMemberId.Text.ToString(), txtPassword.Text.ToString());
if (arr.Length > 0)
{
if (arr[0].Value.ToString().Equals("2"))
{
Session["IsLogged"] = "1";
Session["RegId"] = arr[0].ERPMemberId.ToString();
Response.Redirect("UserCard.aspx");
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Invalid Member Id or Password";
}
}
ServiceRefClient.Close();
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
bool istrue = Regex.IsMatch(txtmobile.Text.ToString(), "^[0-9]{10}$");
bool isEmailcorrect = Regex.IsMatch(txtEmail.Text.ToString(), "^([0-9a-zA-Z]+([_.-]?[0-9a-zA-Z]+)*@[0-9a-zA-Z]+[0-9,a-z,A-Z,.,-][.]{1}[a-zA-Z]{2,4})+$");
if (txtFirstName.Text == "" || txtFirstName.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Name');", true);
txtFirstName.Focus();
}
else if (txtEmail.Text == "" || txtEmail.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Email ID');", true);
txtEmail.Focus();
}
else if (isEmailcorrect == false)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter valid Email ID');", true);
txtEmail.Focus();
}
else if (txtmobile.Text == "" || txtmobile.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Mobile No.');", true);
txtmobile.Focus();
}
else if (istrue==false)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter valid Mobile No.');", true);
txtmobile.Focus();
}
else if (rdYes.Checked&&(txtMembership.Text==""||txtMembership.Text.ToString()==null))
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter valid Membership ID');", true);
txtMembership.Focus();
txtMembership.Enabled = true;
}
else if (txtComments.Text == "" || txtComments.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Comments');", true);
txtComments.Focus();
}
else
{
Inquiryfrm.Visible = false;
if (Session["RegId"] != null && Session["RegId"].ToString() != "")
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
var arr = ServiceClient.GetUserDetails(Session["RegId"].ToString());
if (arr.Length > 0)
{
String username = arr[0].FirstName.ToString() + " " + arr[0].LastName.ToString();
MailToAdmin(arr[0].Email.ToString());
MailToUser(arr[0].Email.ToString(), username.ToString());
Lblmsg.Visible = true;
Lblmsg.Text = "Thanks for your kind Feedback";
txtComments.Text = "";
BtnSubmit.Enabled = false;
ServiceClient.Close();
}
}
else
{
Session["RegId"] = "";
MailToAdmin(txtEmail.Text.ToString());
MailToUser(txtEmail.Text.ToString(), txtFirstName.Text.ToString());
Lblmsg.Visible = true;
Lblmsg.Text = "Thanks for your kind Feedback";
}
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
// EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
//ServiceClient.Open();
String WebMemberId = "";
// get max id
try
{
//var MaxIdValue = ServiceClient.GetMaxMemberId();
//if (MaxIdValue.Length > 0)
//{
// //String[] arr = new String[3];
// //arr = MaxIdValue[0].Member_Id.ToString().Split('-');
// //int NewMaxId = Convert.ToInt32(arr[1].ToString()) + 1;
// //WebMemberId = "TMP-" + NewMaxId.ToString();
// int NewMaxId = Convert.ToInt32(MaxIdValue[0].No_) + 1;
// WebMemberId = NewMaxId.ToString();
//}
//else
//{ // first user
// WebMemberId = "1";
//}
//ServiceClient.Close();
EntityServiceReference.EntityServiceClient ServiceClientInsert2 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert2.Open();
var MobileNo = ServiceClientInsert2.MobilenoExist(txtMobileNo.Text.ToString());
EntityServiceReference.EntityServiceClient ServiceClientInsert1 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert1.Open();
var emailconfirm = ServiceClientInsert1.EmailExists(txtEmailId.Text.ToString());
if (emailconfirm > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Email Already Exist..!!');", true);
}
else if (MobileNo > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('MobileNo. Already Exist..!!');", true);
}
else
{
DateTime dtdoa;
String Dob = ddlmonth.SelectedValue.ToString() + "/" + ddlday.SelectedValue.ToString() + "/" + ddlyear.SelectedValue.ToString();
String Doa = DdlMonthAnniversary.SelectedValue.ToString() + "/" + DdlDayAnniversary.SelectedValue.ToString() + "/" + DdlYearAnniversary.SelectedValue.ToString();
DateTime dtdob = Convert.ToDateTime(Dob);
dtdoa = Convert.ToDateTime(Doa);
txtDesignation.Text = "";
txtPassword.Text = "";
Decimal paidamount = Convert.ToDecimal(0.00);
if (RdGender.SelectedValue.ToString().Equals("Mr."))
{
Gender = "Male";
}
else
{
Gender = "Female";
}
if (RdMartialStatus.SelectedValue.ToString().Equals("Married"))
{
dtdoa = Convert.ToDateTime(Doa);
}
else
{
dtdoa = DateTime.Parse("01/01/1753");
}
EntityServiceReference.EntityServiceClient ServiceClientInsert = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert.Open();
var confirm = ServiceClientInsert.registeruserwithoutpayment(WebMemberId, RdGender.SelectedValue.ToString(), txtFirstName.Text.ToString(), txtLastName.Text.ToString(), txtAddress.Text.ToString(), txtAddress.Text.ToString(), txtCity.Text.ToString(), txtCountry.Text.ToString(), txtMobileNo.Text.ToString(), txtMobileNo.Text.ToString(), txtEmailId.Text.ToString(), dtdob, dtdoa, RdMartialStatus.SelectedValue.ToString(), Gender, paidamount, DateTime.Now, "0", "-", txtEmailId.Text.ToString(), txtPassword.Text.ToString(), txtDesignation.Text.ToString(), false, false);
if (confirm.Length > 0)
{
WebMemberId = confirm[0].tempwebid.Value.ToString();
//***************this is used to trace the useer redirect from mailer********************
#region for update Royal_MailerTracker
if (Session["mailerid"].ToString() != "" && Session["mailerid"] != null)
{
string str = "update [dbo].[Royal_MailerTracker] set Name='" + txtFirstName.Text + "',EMail='" + txtEmailId.Text + "',WebID=" + WebMemberId + ",MobileNo='" + txtMobileNo.Text + "' where ID=" + Convert.ToInt64(Session["mailerid"].ToString());
SqlCommand scmd = new SqlCommand(str, con);
try
{
con.Open();
scmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
}
#endregion for update Royal_MailerTracker
//**********************************************************************************************
HTMLSignUpMailer(WebMemberId);
Response.Redirect("UserRegisterationSuccess.aspx");
}
ServiceClientInsert.Close();
ServiceClientInsert1.Close();
ServiceClientInsert2.Close();
}
}
catch (Exception ex)
{
LblMsg.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
String WebMemberId = "";
// get max id
try
{
EntityServiceReference.EntityServiceClient ServiceClientInsert2 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert2.Open();
var MobileNo = ServiceClientInsert2.MobilenoExist(txtMobileNo.Text.ToString());
EntityServiceReference.EntityServiceClient ServiceClientInsert1 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert1.Open();
var emailconfirm = ServiceClientInsert1.EmailExists(txtEmailId.Text.ToString());
if (emailconfirm > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Email Already Exist..!!');", true);
}
else if (MobileNo > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('MobileNo. Already Exist..!!');", true);
}
else
{
DateTime dtdoa;
String Dob = ddlmonth.SelectedValue.ToString() + "/" + ddlday.SelectedValue.ToString() + "/" + ddlyear.SelectedValue.ToString();
String Doa = DdlMonthAnniversary.SelectedValue.ToString() + "/" + DdlDayAnniversary.SelectedValue.ToString() + "/" + DdlYearAnniversary.SelectedValue.ToString();
DateTime dtdob = Convert.ToDateTime(Dob);
dtdoa = Convert.ToDateTime(Doa);
txtDesignation.Text = "";
txtPassword.Text = "";
Decimal paidamount = Convert.ToDecimal(0.00);
if (RdGender.SelectedValue.ToString().Equals("Mr."))
{
Gender = "Male";
}
else
{
Gender = "Female";
}
if (RdMartialStatus.SelectedValue.ToString().Equals("Married"))
{
dtdoa = Convert.ToDateTime(Doa);
}
else
{
dtdoa = DateTime.Parse("01/01/1753");
}
EntityServiceReference.EntityServiceClient ServiceClientInsert = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert.Open();
var confirm = ServiceClientInsert.registeruserwithoutpayment(WebMemberId, RdGender.SelectedValue.ToString(), txtFirstName.Text.ToString(), txtLastName.Text.ToString(), txtAddress.Text.ToString(), txtAddress.Text.ToString(), txtCity.Text.ToString(), txtCountry.Text.ToString(), txtMobileNo.Text.ToString(), txtMobileNo.Text.ToString(), txtEmailId.Text.ToString(), dtdob, dtdoa, RdMartialStatus.SelectedValue.ToString(), Gender, paidamount, DateTime.Now, "0", "-", txtEmailId.Text.ToString(), txtPassword.Text.ToString(), txtDesignation.Text.ToString(), false, false);
if (confirm.Length > 0)
{
WebMemberId = confirm[0].tempwebid.Value.ToString();
//****************this is used to trace the useer redirect from mailer*********************
#region for update Royal_MailerTracker
string str = "update [dbo].[Royal_MailerTracker] set Name='" + txtFirstName.Text + "',EMail='" + txtEmailId.Text + "',WebID=" + WebMemberId + ",MobileNo='" + txtMobileNo.Text + "' where ID=" + Convert.ToInt64(Session["mailerid"].ToString());
SqlCommand scmd = new SqlCommand(str, con);
try
{
con.Open();
scmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
#endregion for update Royal_MailerTracker
//**********************************************************************************************
HTMLSignUpMailer(WebMemberId);
if (Convert.ToInt32(WebMemberId) > 0)
{
grayBG.Visible = true;
showcontainer.Visible = true;
Container.Visible = true;
lb_digitalmsg.Visible = true;
lb_digitalmsg.Text = "Enrollment No: " + WebMemberId + "" + "<br/> Thank you for Registering with us. Please collect your card from loyalty helpdesk.";
ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: digital_kaos(); ", true);
}
}
ServiceClientInsert.Close();
ServiceClientInsert1.Close();
ServiceClientInsert2.Close();
}
}
catch (Exception ex)
{
LblMsg.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
String WebMemberId = "";
// get max id
try
{
EntityServiceReference.EntityServiceClient ServiceClientInsert2 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert2.Open();
var MobileNo = ServiceClientInsert2.MobilenoExist(txtMobileNo.Text.ToString());
EntityServiceReference.EntityServiceClient ServiceClientInsert1 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert1.Open();
var emailconfirm = ServiceClientInsert1.EmailExists(txtEmailId.Text.ToString());
if (emailconfirm > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Email Already Exist..!!');", true);
}
else if (MobileNo > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('MobileNo. Already Exist..!!');", true);
}
else
{
DateTime dtdoa;
String Dob = ddlmonth.SelectedValue.ToString() + "/" + ddlday.SelectedValue.ToString() + "/" + ddlyear.SelectedValue.ToString();
String Doa = DdlMonthAnniversary.SelectedValue.ToString() + "/" + DdlDayAnniversary.SelectedValue.ToString() + "/" + DdlYearAnniversary.SelectedValue.ToString();
DateTime dtdob = Convert.ToDateTime(Dob);
dtdoa = Convert.ToDateTime(Doa);
txtDesignation.Text = "";
txtPassword.Text = "";
Decimal paidamount = Convert.ToDecimal(0.00);
if (RdGender.SelectedValue.ToString().Equals("Mr."))
{
Gender = "Male";
}
else
{
Gender = "Female";
}
if (RdMartialStatus.SelectedValue.ToString().Equals("Married"))
{
dtdoa = Convert.ToDateTime(Doa);
}
else
{
dtdoa = DateTime.Parse("01/01/1753");
}
EntityServiceReference.EntityServiceClient ServiceClientInsert = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert.Open();
var confirm = ServiceClientInsert.registeruserwithoutpayment(WebMemberId, RdGender.SelectedValue.ToString(), txtFirstName.Text.ToString(), txtLastName.Text.ToString(), txtAddress.Text.ToString(), txtAddress.Text.ToString(), txtCity.Text.ToString(), txtCountry.Text.ToString(), txtMobileNo.Text.ToString(), txtMobileNo.Text.ToString(), txtEmailId.Text.ToString(), dtdob, dtdoa, RdMartialStatus.SelectedValue.ToString(), Gender, paidamount, DateTime.Now, "0", "-", txtEmailId.Text.ToString(), txtPassword.Text.ToString(), txtDesignation.Text.ToString(), false, false);
if (confirm.Length > 0)
{
WebMemberId = confirm[0].tempwebid.Value.ToString();
//****************this is used to trace the useer redirect from mailer*********************
#region for update Royal_MailerTracker
string str = "update [dbo].[Royal_MailerTracker] set Name='" + txtFirstName.Text + "',EMail='" + txtEmailId.Text + "',WebID=" + WebMemberId + ",MobileNo='" + txtMobileNo.Text + "' where ID=" + Convert.ToInt64(Session["mailerid"].ToString());
SqlCommand scmd = new SqlCommand(str, con);
try
{
con.Open();
scmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
#endregion for update Royal_MailerTracker
//**********************************************************************************************
HTMLSignUpMailer(WebMemberId);
if (Convert.ToInt32(WebMemberId) > 0)
{
grayBG.Visible = true;
showcontainer.Visible = true;
Container.Visible = true;
lb_digitalmsg.Visible = true;
lb_digitalmsg.Text = "Enrollment No: " + WebMemberId + "" + "<br/> Thank you for Registering with us. Please collect your card from loyalty helpdesk.";
ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: digital_kaos(); ", true);
}
}
ServiceClientInsert.Close();
ServiceClientInsert1.Close();
ServiceClientInsert2.Close();
}
}
catch (Exception ex)
{
LblMsg.Text = ex.Message;
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
if (Session["RegId"] != null && Session["RegId"] != "")
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
DateTime dtdoa;
String Dob = ddlmonth.SelectedValue.ToString() + "/" + ddlday.SelectedValue.ToString() + "/" + ddlyear.SelectedValue.ToString();
String Doa = DdlDayAnniversary.SelectedValue.ToString() + "/" + DdlMonthAnniversary.SelectedValue.ToString() + "/" + DdlYearAnniversary.SelectedValue.ToString();
DateTime dtdob = Convert.ToDateTime(Dob);
if (RdMartialStatus.SelectedValue.ToString().Equals("Married"))
{
dtdoa = Convert.ToDateTime(Doa);
}
else
{
dtdoa =System.DateTime.Now;
}
int Confirm = ServiceClient.UpdateUserDetails(Session["RegId"].ToString(), RdGender.SelectedItem.Text.ToString(), txtFirstName.Text.ToString(), txtLastName.Text.ToString(), txtAddress.Text.ToString(), "", txtCity.Text.ToString(), DdlCountry.SelectedItem.Text.ToString(), txtMobileNo.Text.ToString(), TxtEmail.Text.ToString(), dtdob, dtdoa, RdMartialStatus.SelectedValue.ToString(), txtDesignation.Text.ToString(), txtMobileNo.Text.ToString());
if (Confirm == 1)
{
LblMsg.Text = "Record Updated";
HTMLSignUpMailer(Session["RegId"].ToString());
}
ServiceClient.Close();
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
bool istrue = Regex.IsMatch(txtmobile.Text.ToString(), "^[0-9]{10}$");
bool isEmailcorrect = Regex.IsMatch(txtEmail.Text.ToString(), "^([0-9a-zA-Z]+([_.-]?[0-9a-zA-Z]+)*@[0-9a-zA-Z]+[0-9,a-z,A-Z,.,-][.]{1}[a-zA-Z]{2,4})+$");
if (txtFirstName.Text == "" || txtFirstName.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Name');", true);
txtFirstName.Focus();
}
else if (txtEmail.Text == "" || txtEmail.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Email ID');", true);
txtEmail.Focus();
}
else if (isEmailcorrect == false)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter valid Email ID');", true);
txtEmail.Focus();
}
else if (txtmobile.Text == "" || txtmobile.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Mobile No.');", true);
txtmobile.Focus();
}
else if (istrue == false)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter valid Mobile No.');", true);
txtmobile.Focus();
}
else if (rdYes.Checked && (txtMembership.Text == "" || txtMembership.Text.ToString() == null))
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter valid Membership ID');", true);
txtMembership.Focus();
txtMembership.Enabled = true;
}
else if (txtComments.Text == "" || txtComments.Text.ToString() == null)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Please Enter Your Comments');", true);
txtComments.Focus();
}
else
{
Inquiryfrm.Visible = false;
if (Session["RegId"] != null && Session["RegId"].ToString() != "")
{
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
var arr = ServiceClient.GetUserDetails(Session["RegId"].ToString());
if (arr.Length > 0)
{
String username = arr[0].FirstName.ToString() + " " + arr[0].LastName.ToString();
MailToAdmin(arr[0].Email.ToString());
MailToUser(arr[0].Email.ToString(), username.ToString());
Lblmsg.Visible = true;
Lblmsg.Text = "Thanks for your kind Feedback";
txtComments.Text = "";
BtnSubmit.Enabled = false;
ServiceClient.Close();
}
}
else
{
Session["RegId"] = "";
MailToAdmin(txtEmail.Text.ToString());
MailToUser(txtEmail.Text.ToString(), txtFirstName.Text.ToString());
Lblmsg.Visible = true;
Lblmsg.Text = "Thanks for your kind Feedback";
}
}
}
void BindData()
{
if (Session["RegId"] != null && Session["RegId"] != "")
{
EntityServiceReference.EntityServiceClient ServiceClient1 = new EntityServiceReference.EntityServiceClient();
ServiceClient1.Open();
// get card details by m id
var dbreturns = ServiceClient1.GetUserDetails(Session["RegId"].ToString());
String Name = dbreturns[0].FirstName.ToString();
lblName.Text = Name;
lblMemberID.Text = dbreturns[0].MemberID.ToString();
lblDate.Text = dbreturns[0].DateonCard.ToString();
if (dbreturns.Length > 0)
{
String CardType = dbreturns[0].CardCode.ToString();
// get card details by card type
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
var arr = ServiceClient.GetCardsDetailsbyType(CardType);
GridCardList.DataSource = arr;
GridCardList.DataBind();
ServiceClient.Close();
if (CardType.ToString().ToUpper().Equals("BLUE"))
{
ImgCard.ImageUrl = "../Skins/images/blueCard.png";
}
else if (CardType.ToString().ToUpper().Equals("GOLD"))
{
ImgCard.ImageUrl = "../Skins/images/goldCard.png";
}
else if (CardType.ToString().ToUpper().Equals("PLATINUM"))
{
ImgCard.ImageUrl = "../Skins/images/platinumCard.png";
}
else if (CardType.ToString().ToUpper().Equals("PURPLE"))
{
ImgCard.ImageUrl = "../Skins/images/purpleCard.png";
}
else if (CardType.ToString().ToUpper().Equals("TITANIUM"))
{
ImgCard.ImageUrl = "../Skins/images/titaniumCard.png";
}
else if (CardType.ToString().ToUpper().Equals("PRINCE"))
{
ImgCard.ImageUrl = "../Skins/images/princeCard.png";
}
else if (CardType.ToString().ToUpper().Equals("KING"))
{
ImgCard.ImageUrl = "../Skins/images/kingCard.png";
}
}
EntityServiceReference.EntityServiceClient ServiceClient2 = new EntityServiceReference.EntityServiceClient();
ServiceClient2.Open();
var CardDetails = ServiceClient2.GetCardsBalanceByMemberId(Session["RegId"].ToString());
String RemainingAmount = CardDetails[0].RemainingAmount.ToString();
lblavailableVal.Text = RemainingAmount;
String RemainingPoints = CardDetails[0].RemainingPoints.ToString();
lblAvailablePoints.Text = RemainingPoints;
String After24Hrs = CardDetails[0].After24HourPoints.ToString();
lblAfter24hrs.Text = After24Hrs;
String RechargeAmount = CardDetails[0].RechargeAmount.ToString();
lblTotalRedemption.Text = RechargeAmount;
ServiceClient1.Close();
ServiceClient2.Close();
}
}
void BindData()
{
if (Session["RegId"] != null && Session["RegId"] != "")
{
EntityServiceReference.EntityServiceClient ServiceClient1 = new EntityServiceReference.EntityServiceClient();
ServiceClient1.Open();
// get card details by m id
var dbreturns = ServiceClient1.GetUserDetails(Session["RegId"].ToString());
String Name = dbreturns[0].FirstName.ToString();
lblName.Text = Name;
lblMemberID.Text = dbreturns[0].MemberID.ToString();
lblDate.Text = dbreturns[0].DateonCard.ToString();
if (dbreturns.Length > 0)
{
String CardType = dbreturns[0].CardCode.ToString();
// get card details by card type
EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
ServiceClient.Open();
var arr = ServiceClient.GetCardsDetailsbyType(CardType);
GridCardList.DataSource = arr;
GridCardList.DataBind();
ServiceClient.Close();
if (CardType.ToString().ToUpper().Equals("BLUE"))
{
ImgCard.ImageUrl = "../Skins/images/blueCard.png";
}
else if (CardType.ToString().ToUpper().Equals("GOLD"))
{
ImgCard.ImageUrl = "../Skins/images/goldCard.png";
}
else if (CardType.ToString().ToUpper().Equals("PLATINUM"))
{
ImgCard.ImageUrl = "../Skins/images/platinumCard.png";
}
else if (CardType.ToString().ToUpper().Equals("PURPLE"))
{
ImgCard.ImageUrl = "../Skins/images/purpleCard.png";
}
else if (CardType.ToString().ToUpper().Equals("TITANIUM"))
{
ImgCard.ImageUrl = "../Skins/images/titaniumCard.png";
}
else if (CardType.ToString().ToUpper().Equals("PRINCE"))
{
ImgCard.ImageUrl = "../Skins/images/princeCard.png";
}
else if (CardType.ToString().ToUpper().Equals("KING"))
{
ImgCard.ImageUrl = "../Skins/images/kingCard.png";
}
}
EntityServiceReference.EntityServiceClient ServiceClient2 = new EntityServiceReference.EntityServiceClient();
ServiceClient2.Open();
var CardDetails = ServiceClient2.GetCardsBalanceByMemberId(Session["RegId"].ToString());
String RemainingAmount = CardDetails[0].RemainingAmount.ToString();
lblavailableVal.Text = RemainingAmount;
String RemainingPoints = CardDetails[0].RemainingPoints.ToString();
lblAvailablePoints.Text = RemainingPoints;
String After24Hrs = CardDetails[0].After24HourPoints.ToString();
lblAfter24hrs.Text = After24Hrs;
String RechargeAmount = CardDetails[0].RechargeAmount.ToString();
lblTotalRedemption.Text = RechargeAmount;
ServiceClient1.Close();
ServiceClient2.Close();
}
}
protected void BtnBookTickets_Click(object sender, EventArgs e)
{
EntityServiceReference.EntityServiceClient ServiceRefClient = new EntityServiceReference.EntityServiceClient();
ServiceRefClient.Open();
var arr = ServiceRefClient.GetUserDetails(Session["RegId"].ToString());
String FirstName = arr[0].FirstName.ToString();
String LastName = arr[0].LastName.ToString();
String EmailID = arr[0].Email.ToString();
String MobileNo = arr[0].Mobile.ToString();
String Address = arr[0].Address.ToString();
String Address2 = arr[0].Address2.ToString();
ServiceRefClient.Close();
//Response.Redirect(ConfigurationManager.AppSettings.Get("MsTicketURL").ToString() + "?RemainingAmount=" + Server.UrlEncode(Encrypt(lblavailableVal.Text)) + "&RemainingPoints=" + Server.UrlEncode(Encrypt(lblAvailablePoints.Text)) + "&MemberShipId=" + Server.UrlEncode(Encrypt(Session["RegId"].ToString())) + "&FirstName=" + Server.UrlEncode(Encrypt(FirstName)) + "&LastName=" + Server.UrlEncode(Encrypt(LastName))+"&Email="+Server.UrlEncode(Encrypt(EmailID))+"&Mobile="+Server.UrlEncode(Encrypt(MobileNo))+"&Address="+Server.UrlEncode(Encrypt(Address)));
string password = "******";
string ss = Common.Encrypt(lblAvailablePoints.Text, password);
string ss1 = Common.Encrypt(FirstName, password);
string ss2 = Common.Encrypt(LastName, password);
string url = ConfigurationManager.AppSettings.Get("MsTicketURL").ToString() + "?RemainingAmount=" + Server.UrlEncode(Common.Encrypt(lblavailableVal.Text, password))
+ "&RemainingPoints=" + Server.UrlEncode(Common.Encrypt(lblAvailablePoints.Text, password)) + "&MemberShipId=" +
Server.UrlEncode(Common.Encrypt(Session["RegId"].ToString(), password)) + "&FirstName=" + Server.UrlEncode(Common.Encrypt(FirstName, password))
+ "&LastName=" + Server.UrlEncode(Common.Encrypt(LastName, password)) + "&Email="
+ Server.UrlEncode(Common.Encrypt(EmailID, password)) + "&Mobile=" + Server.UrlEncode(Common.Encrypt(MobileNo, password)) +
"&Address=" + Server.UrlEncode(Common.Encrypt(Address, password));
Response.Redirect(url);
//+"&Address2="+Server.UrlEncode(Encrypt(Address2))
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
// EntityServiceReference.EntityServiceClient ServiceClient = new EntityServiceReference.EntityServiceClient();
//ServiceClient.Open();
String WebMemberId = "";
// get max id
try
{
//var MaxIdValue = ServiceClient.GetMaxMemberId();
//if (MaxIdValue.Length > 0)
//{
// //String[] arr = new String[3];
// //arr = MaxIdValue[0].Member_Id.ToString().Split('-');
// //int NewMaxId = Convert.ToInt32(arr[1].ToString()) + 1;
// //WebMemberId = "TMP-" + NewMaxId.ToString();
// int NewMaxId = Convert.ToInt32(MaxIdValue[0].No_) + 1;
// WebMemberId = NewMaxId.ToString();
//}
//else
//{ // first user
// WebMemberId = "1";
//}
//ServiceClient.Close();
EntityServiceReference.EntityServiceClient ServiceClientInsert2 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert2.Open();
var MobileNo = ServiceClientInsert2.MobilenoExist(txtMobileNo.Text.ToString());
EntityServiceReference.EntityServiceClient ServiceClientInsert1 = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert1.Open();
var emailconfirm = ServiceClientInsert1.EmailExists(txtEmailId.Text.ToString());
if (emailconfirm > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('Email Already Exist..!!');", true);
}
else if (MobileNo > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "test", "alert('MobileNo. Already Exist..!!');", true);
}
else
{
DateTime dtdoa;
String Dob = ddlmonth.SelectedValue.ToString() + "/" + ddlday.SelectedValue.ToString() + "/" + ddlyear.SelectedValue.ToString();
String Doa = DdlMonthAnniversary.SelectedValue.ToString() + "/" + DdlDayAnniversary.SelectedValue.ToString() + "/" + DdlYearAnniversary.SelectedValue.ToString();
DateTime dtdob = Convert.ToDateTime(Dob);
dtdoa = Convert.ToDateTime(Doa);
txtDesignation.Text = "";
txtPassword.Text = "";
Decimal paidamount = Convert.ToDecimal(0.00);
if (RdGender.SelectedValue.ToString().Equals("Mr."))
{
Gender = "Male";
}
else
{
Gender = "Female";
}
if (RdMartialStatus.SelectedValue.ToString().Equals("Married"))
{
dtdoa = Convert.ToDateTime(Doa);
}
else
{
dtdoa = DateTime.Parse("01/01/1753");
}
EntityServiceReference.EntityServiceClient ServiceClientInsert = new EntityServiceReference.EntityServiceClient();
ServiceClientInsert.Open();
var confirm = ServiceClientInsert.registeruserwithoutpayment(WebMemberId, RdGender.SelectedValue.ToString(), txtFirstName.Text.ToString(), txtLastName.Text.ToString(), txtAddress.Text.ToString(), txtAddress.Text.ToString(), txtCity.Text.ToString(), txtCountry.Text.ToString(), txtMobileNo.Text.ToString(), txtMobileNo.Text.ToString(), txtEmailId.Text.ToString(), dtdob, dtdoa, RdMartialStatus.SelectedValue.ToString(), Gender, paidamount, DateTime.Now, "0", "-", txtEmailId.Text.ToString(), txtPassword.Text.ToString(), txtDesignation.Text.ToString(), false, false);
if (confirm.Length > 0)
{
WebMemberId = confirm[0].tempwebid.Value.ToString();
//***************this is used to trace the useer redirect from mailer********************
#region for update Royal_MailerTracker
if (Session["mailerid"].ToString() != "" && Session["mailerid"] != null)
{
string str = "update [dbo].[Royal_MailerTracker] set Name='" + txtFirstName.Text + "',EMail='" + txtEmailId.Text + "',WebID=" + WebMemberId + ",MobileNo='" + txtMobileNo.Text + "' where ID=" + Convert.ToInt64(Session["mailerid"].ToString());
SqlCommand scmd = new SqlCommand(str, con);
try
{
con.Open();
scmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
}
#endregion for update Royal_MailerTracker
//**********************************************************************************************
HTMLSignUpMailer(WebMemberId);
Response.Redirect("UserRegisterationSuccess.aspx");
}
ServiceClientInsert.Close();
ServiceClientInsert1.Close();
ServiceClientInsert2.Close();
}
}
catch (Exception ex)
{
LblMsg.Text = ex.Message;
}
}
