/// <summary>
/// This Method is used to check authentication of associate
/// </summary>
/// <param name="objadmin">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string SendAssociatePassonEmail(PropAssociateRegistration objassociate)
{
WcrCryptography crypto = new WcrCryptography();
ChangeAssociatePasswordParameters sqlParams = new ChangeAssociatePasswordParameters();
sqlParams.Email = crypto.EncryptUserName(objassociate.EmailID);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objassociate.EmailID))
{
resp = client.PostAsJsonAsync("api/AssociateTransactions/SendPasswordResetEmail", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id >= 0)
{
return(Id.ToString());
}
else
{
return("-1");
}
}
}
public string UpdateCompulsoryData(string Name, int ID, string uname)
{
WcrCryptography crypto = new WcrCryptography();
ConsumersParameters sqlParams = new ConsumersParameters();
sqlParams.Name = Name;
sqlParams.Id = ID;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(uname))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/ConsumersUConsumerRcd", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id > 0)
{
return(Id.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
//SqlCommand cmd = new SqlCommand("proc_Consumers", objCon.Con);
//cmd.CommandType = CommandType.StoredProcedure;
//objCon.Con.Open();
//cmd.Parameters.AddWithValue("@name", Name);
//cmd.Parameters.AddWithValue("@id", ID);
//cmd.Parameters.AddWithValue("@action", "uconsumerRcd");
//int a = cmd.ExecuteNonQuery();
//objCon.Con.Close();
//if (a > 0)
//{
// return a.ToString();
//}
//else
//{ return ClsCommon.InactiveValue.ToString(); }
}
public string UpdateAssociate(string FullName, string LastName, string Password, string EmailID, string MobileNo, string LicenceID, string LicenceState, string ZipCode)
{
WcrCryptography crypt = new WcrCryptography();
if (Session["associate"].ToString() != "" || Session["associate"].ToString() != null)
{
string str = string.Empty;
PropAssociateRegistration proAssociateRegistration = new PropAssociateRegistration();
proAssociateRegistration.FullName = FullName;
proAssociateRegistration.LastName = LastName;
// proAssociateRegistration.UserName = UserName;
//proAssociateRegistration.EmailID = crypt.WcrSimpleEncrypt(EmailID);
//proAssociateRegistration.Password = crypt.WcrSimpleEncrypt(Password);
proAssociateRegistration.EmailID = EmailID;
proAssociateRegistration.Password = Password;
proAssociateRegistration.MobileNo = MobileNo;
proAssociateRegistration.ZipCode = ZipCode;
proAssociateRegistration.LicenseID = LicenceID;
proAssociateRegistration.LicenseState = LicenceState;
//HttpFileCollection files = Request.Files;
//for (int i = 0; i < files.Count; i++)
//{
// HttpPostedFile file = files[i];
// string fname;
//}
//proAssociateRegistration.Photo = Photo;
BllAssociateRegistration objAssociate = new BllAssociateRegistration();
str = objAssociate.UpdateAssociateProfile(proAssociateRegistration, Session["associate"].ToString());
return(str);
}
else
{
return("Error in Authentication");
}
}
public string RecordExistsOrNotForAssociate(PropAssociateRegistration objAssociateRegistration)
{
WcrCryptography crypto = new WcrCryptography();
AssociateAccountExistsParameters sqlParams = new AssociateAccountExistsParameters();
//sqlParams.EmailId = crypto.EncryptUserName(objAssociateRegistration.EmailID);
sqlParams.EmailId = crypto.WcrSimpleEncrypt(objAssociateRegistration.EmailID);
sqlParams.Action = "associate";
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword))
{
resp = client.PostAsJsonAsync("api/AccountCreation/AssociateAccountExists", sqlParams).Result;
if (resp.IsSuccessStatusCode != true)
{
return(ClsCommon.InactiveValue.ToString());
}
WcrClassLibrary.DataObjects.UserAccountStatus returnModel = JsonConvert.DeserializeObject <WcrClassLibrary.DataObjects.UserAccountStatus>(resp.Content.ReadAsStringAsync().Result);
if (returnModel == null)
{
return(ClsCommon.InactiveValue.ToString());
}
else
{
if (returnModel.AssociateID < 1)
{
return(ClsCommon.InactiveValue.ToString());
}
else
{
return(returnModel.AssociateID.ToString());
}
}
}
}
public string DeleteConsumer(PropConsumerRegistration objConsumerRegistration)
{
WcrCryptography crypto = new WcrCryptography();
ConsumersParameters sqlParams = new ConsumersParameters();
sqlParams.Id = objConsumerRegistration.ID;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objConsumerRegistration.EmailID))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/ConsumersDeleteAccount", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id > 0)
{
return(Id.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
//SqlCommand cmd = new SqlCommand("proc_Consumers", objCon.Con);
//cmd.CommandType = CommandType.StoredProcedure;
//objCon.Con.Open();
//cmd.Parameters.AddWithValue("@id", objConsumerRegistration.ID);
//cmd.Parameters.AddWithValue("@Action", "DeleteAccount");
//int a = cmd.ExecuteNonQuery();
//objCon.Con.Close();
//if (a > 0)
//{
// return a.ToString();
//}
//else
//{ return ClsCommon.InactiveValue.ToString(); }
}
public string SelectConsumerDetail(int ID, string uname)
{
WcrCryptography crypto = new WcrCryptography();
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(uname))
{
resp = client.GetAsync(string.Format("api/ConsumerTransactions/consumerDetail?inConsumerId={0}", ID)).Result;
ConsumerDetail_ReturnDataModel returnModel = JsonConvert.DeserializeObject <ConsumerDetail_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
if (returnModel == null)
{
return(null);
}
else
{
returnModel.Name = crypto.DecryptUserName(returnModel.Name);
returnModel.Address = crypto.WcrSimpleDecrypt(returnModel.Address);
returnModel.Mob = crypto.WcrSimpleDecrypt(returnModel.Mob);
returnModel.UserName = crypto.WcrSimpleDecrypt(returnModel.UserName);
returnModel.EmailId = crypto.DecryptUserName(returnModel.EmailId);
returnModel.Password = crypto.DecryptPassword(returnModel.Password);
returnModel.ZipCode = crypto.WcrSimpleDecrypt(returnModel.ZipCode);
returnModel.ConsumerPhoto = returnModel.ConsumerPhoto;
returnModel.LastName = crypto.WcrSimpleDecrypt(returnModel.LastName);
returnModel.Unit_Apt = crypto.WcrSimpleDecrypt(returnModel.Unit_Apt);
returnModel.City = crypto.WcrSimpleDecrypt(returnModel.City);
returnModel.StateId = crypto.WcrSimpleDecrypt(returnModel.StateId);
DataSet ds = new DataSet("dataSet");
DataTable table = ds.Tables.Add("ConsumerDetail");
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Address", typeof(string));
table.Columns.Add("Mob", typeof(string));
table.Columns.Add("UserName", typeof(string));
table.Columns.Add("EmailId", typeof(string));
table.Columns.Add("Password", typeof(string));
table.Columns.Add("ZipCode", typeof(string));
table.Columns.Add("ConsumerPhoto", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("Unit_Apt", typeof(string));
table.Columns.Add("City", typeof(string));
table.Columns.Add("StateId", typeof(string));
DataRow dr = table.NewRow();
dr["Id"] = ID;
dr["Name"] = returnModel.Name;
dr["Address"] = returnModel.Address;
dr["Mob"] = returnModel.Mob;
dr["UserName"] = returnModel.UserName;
dr["EmailId"] = returnModel.EmailId;
dr["Password"] = returnModel.Password;
dr["ZipCode"] = returnModel.ZipCode;
dr["ConsumerPhoto"] = returnModel.ConsumerPhoto;
dr["LastName"] = returnModel.LastName;
dr["Unit_Apt"] = returnModel.Unit_Apt;
dr["City"] = returnModel.City;
dr["StateId"] = returnModel.StateId;
table.Rows.Add(dr);
return(ds.GetXml());
}
////SqlCommand cmd = new SqlCommand("proc_ConsumerDetail", objCon.Con);
////cmd.CommandType = CommandType.StoredProcedure;
////cmd.Parameters.AddWithValue("@ID", ID);
////cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
////SqlDataAdapter adpt = new SqlDataAdapter();
////DataSet ds = new DataSet();
////if (objCon.Con.State == ConnectionState.Open)
////{ }
////else
////{
//// objCon.Con.Open();
////}
////cmd.Connection = objCon.Con;
////adpt.SelectCommand = cmd;
////adpt.Fill(ds, "ConsumerDetail");
////objCon.Con.Close();
////return ds.GetXml();
}
}
/// <summary>
/// This Method is used to check authentication of associate
/// </summary>
/// <param name="objadmin">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string SelectAssociate(PropAssociateLogin objassociate)
{
WcrCryptography crypto = new WcrCryptography();
AssociateLogInParameters sqlParams = new AssociateLogInParameters();
sqlParams.Mob = crypto.EncryptUserName(objassociate.Mob.ToLower());
sqlParams.Password = crypto.EncryptPassword(objassociate.Password);
string ddd = WcrCryptography.SqlPassphrase;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objassociate.Mob))
{
resp = client.PostAsJsonAsync("api/AssociateTransactions/AssociateLogin", sqlParams).Result;
AssociateLogin_ReturnDataModel returnModel = JsonConvert.DeserializeObject <AssociateLogin_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
if (returnModel == null)
{
return("0");
}
else
{
DataSet ds = new DataSet("dataSet");
DataTable table = ds.Tables.Add("associateLogin");
table.Columns.Add("AssociateId", typeof(int));
table.Columns.Add("Status", typeof(int));
table.Columns.Add("Mobile", typeof(string));
DataRow dr = table.NewRow();
dr["AssociateId"] = returnModel.AssociateId;
dr["Status"] = returnModel.Status;
dr["Mobile"] = returnModel.MobileNo;
table.Rows.Add(dr);
return(ds.GetXml());
//if (Id > 0)
//{
// return Id.ToString();
//}
//else
//{ return "-1"; }
}
}
//try
//{
// WcrCryptography cardEncrypt = new WcrCryptography();
// SqlCommand cmd = new SqlCommand("proc_AssociateLogin", objCon.Con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Mob", objassociate.Mob);
// cmd.Parameters.AddWithValue("@Password", objassociate.Password);
// cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
// if (objCon.Con.State == ConnectionState.Open)
// { }
// else
// {
// objCon.Con.Open();
// }
// SqlDataReader dr = cmd.ExecuteReader();
// DataTable dt = new DataTable();
// dt.Load(dr);
// objCon.Con.Close();
// if (dt.Rows.Count > 0)
// {
// return dt.Rows[0]["AssociateID"].ToString();
// }
// else
// {
// return "-1";
// }
//}
//catch { return null; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
WcrCryptography cardEncrypt = new WcrCryptography();
BllAssociateRegistration d = new BllAssociateRegistration();
DataTable dt = new DataTable();
dt = d.retcardData(Convert.ToInt32(Session["associate"].ToString()), Session["userName"].ToString());
if (dt != null && dt.Rows.Count > 0)
{
string _crdID = dt.Rows[0]["CardDataId"].ToString();
string _crd = cardEncrypt.WcrDecryptCardNumber(dt.Rows[0]["CardNumber"].ToString());
string _fstName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_FirstName"].ToString());
string _sndName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_LastName"].ToString());
string _Address = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Address"].ToString());
string _city = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_City"].ToString());
string _state = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_State"].ToString());
string _zip = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Zip"].ToString());
string _country = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Country"].ToString());
string _cvv = cardEncrypt.WcrDecrypt(dt.Rows[0]["CVV"].ToString());
string _months = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpMonth"].ToString());
string _year = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpYear"].ToString());
string _crdType = cardEncrypt.WcrDecrypt(dt.Rows[0]["CardType"].ToString());
txtCreditCard.Text = _crd.TrimStart('0');
txtCvv.Text = _cvv;
cardFname.Text = _fstName;
cardLastname.Text = _sndName;
Cardaddress.Text = _Address;
cardCity.Text = _city;
BindState();
cardState.Text = _state;
cardCountry.Text = _country;
BindStateWiseZipCode();
cardzipcode.Text = _zip;
ddlMonth.Text = _months;
ddlYear.Text = _year;
CardID.Value = _crdID;
//hidCardID.Text = _crdID;
//string a = _crd.Substring(0, 1);
string a = _crd.TrimStart('0').Substring(0, 1);
if (a == "3")
{
CheckBox1.Checked = false;
CheckBox2.Checked = false;
CheckBox3.Checked = true;
CheckBox4.Checked = false;
}
else if (a == "6")
{
CheckBox1.Checked = false;
CheckBox2.Checked = false;
CheckBox3.Checked = false;
CheckBox4.Checked = true;
}
else if (a == "5")
{
CheckBox1.Checked = false;
CheckBox2.Checked = true;
CheckBox3.Checked = false;
CheckBox4.Checked = false;
}
else if (a == "4")
{
CheckBox1.Checked = true;
CheckBox2.Checked = false;
CheckBox3.Checked = false;
CheckBox4.Checked = false;
}
else
{
CheckBox1.Checked = false;
CheckBox2.Checked = false;
CheckBox3.Checked = true;
CheckBox4.Checked = false;
}
}
else
{
}
}
catch
{ }
}
}
public string InsertData(PropAssociateRegistration objAssociateRegistration)
{
WcrCryptography crypto = new WcrCryptography();
AssociateRegistrationParameters sqlParams = new AssociateRegistrationParameters();
sqlParams.FullName = crypto.WcrSimpleEncrypt(objAssociateRegistration.FullName);
sqlParams.LastName = crypto.WcrSimpleEncrypt(objAssociateRegistration.LastName);
sqlParams.EmailId = crypto.EncryptUserName(objAssociateRegistration.EmailID.ToLower());
//string ssss = crypto.WcrSimpleEncrypt(objAssociateRegistration.EmailID);
sqlParams.Password = crypto.EncryptPassword(objAssociateRegistration.Password);
sqlParams.MobileNo = crypto.WcrSimpleEncrypt(objAssociateRegistration.MobileNo);
sqlParams.ZipCode = crypto.WcrSimpleEncrypt(objAssociateRegistration.ZipCode);
sqlParams.Photo = "0.png";
sqlParams.LicenseState = crypto.WcrSimpleEncrypt(objAssociateRegistration.LicenseState);
sqlParams.LicenseId = crypto.WcrSimpleEncrypt(objAssociateRegistration.LicenseID);
sqlParams.ForMonths = "1";
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword)) //using (WcrHttpClient client = new WcrHttpClient(objAssociateRegistration.EmailID, objAssociateRegistration.Password))
{
resp = client.PostAsJsonAsync("api/AccountCreation/AssociateRegistrationAdd", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id > 0)
{
return(Id.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
#region
////WcrCryptography cardEncrypt = new WcrCryptography();
////SqlCommand cmd = new SqlCommand("proc_AssociateRegistration", objCon.Con);
////cmd.CommandType = CommandType.StoredProcedure;
////objCon.Con.Open();
////try
////{
//// cmd.Parameters.AddWithValue("@FullName", objAssociateRegistration.FullName);
//// cmd.Parameters.AddWithValue("@LastName", objAssociateRegistration.LastName);
//// cmd.Parameters.AddWithValue("@EmailId", objAssociateRegistration.EmailID);
//// cmd.Parameters.AddWithValue("@Password", objAssociateRegistration.Password);
//// cmd.Parameters.AddWithValue("@MobileNo", objAssociateRegistration.MobileNo);
//// cmd.Parameters.AddWithValue("@ZipCode", objAssociateRegistration.ZipCode);
//// cmd.Parameters.AddWithValue("@Photo", "0.png");
//// cmd.Parameters.AddWithValue("@LicenseState", objAssociateRegistration.LicenseState);
//// cmd.Parameters.AddWithValue("@LicenseId", objAssociateRegistration.LicenseID);
//// //cmd.Parameters.AddWithValue("@ReferralID", objAssociateRegistration.ReferralID);
//// //cmd.Parameters.AddWithValue("@CouponCode", objAssociateRegistration.CouponCode);
//// //string ActivationCode = System.Guid.NewGuid().ToString().Substring(0, 7);
//// //cmd.Parameters.AddWithValue("@ActivateCode", ActivationCode);
//// // cmd.Parameters.AddWithValue("@Discount", objAssociateRegistration.Discount);
//// cmd.Parameters.AddWithValue("@ForMonths", 1);
//// cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
//// cmd.Parameters.AddWithValue("@Action", "Add");
//// int a = Convert.ToInt16(cmd.ExecuteScalar());
//// objCon.Con.Close();
//// if (a > 0)
//// {
//// return a.ToString();
//// }
//// else
//// { return ClsCommon.InactiveValue.ToString(); }
//}
//catch (Exception showError)
//{
// throw showError;
//}
//finally
//{
// cmd.Dispose();
// objCon.Con.Close();
// objCon.Con.Dispose();
//}
#endregion
}
/// <summary>
/// This Method will get associate detail on the basis of associateID
/// </summary>
/// <param name="AdvertismentID"></param>
/// <returns></returns>
public string GetAssociateBasicDetail(int associateID, string userName)
{
WcrCryptography crypto = new WcrCryptography();
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(userName))
{
//resp = client.GetAsync($"api/AssociateTransactions/AssociateRegistrationView?inAssociateId={associateID}").Result;
resp = client.GetAsync(string.Format("api/AssociateTransactions/AssociateRegistrationView?inAssociateId={0}", associateID)).Result;
AssociateRegistrationView_ReturnDataModel returnModel = JsonConvert.DeserializeObject <AssociateRegistrationView_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
returnModel.Email = crypto.DecryptUserName(returnModel.Email);
returnModel.FullName = crypto.WcrSimpleDecrypt(returnModel.FullName);
returnModel.LastName = crypto.WcrSimpleDecrypt(returnModel.LastName);
returnModel.LicenseId = crypto.WcrSimpleDecrypt(returnModel.LicenseId);
returnModel.LicenseState = crypto.WcrSimpleDecrypt(returnModel.LicenseState);
returnModel.MobileNo = crypto.WcrSimpleDecrypt(returnModel.MobileNo);
returnModel.Password = crypto.DecryptPassword(returnModel.Password);
returnModel.Photo = returnModel.Photo;
returnModel.UserName = crypto.WcrSimpleDecrypt(returnModel.UserName);
returnModel.ZipCode = crypto.WcrSimpleDecrypt(returnModel.ZipCode);
DataSet ds = new DataSet("dataSet");
DataTable table = ds.Tables.Add("ViewAssociateBasicDetail");
table.Columns.Add("AssociateId", typeof(int));
table.Columns.Add("Email", typeof(string));
table.Columns.Add("FullName", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("LicenseId", typeof(string));
table.Columns.Add("LicenseState", typeof(string));
table.Columns.Add("MobileNo", typeof(string));
table.Columns.Add("Password", typeof(string));
table.Columns.Add("Photo", typeof(string));
table.Columns.Add("UserName", typeof(string));
table.Columns.Add("ZipCode", typeof(string));
DataRow dr = table.NewRow();
dr["AssociateId"] = associateID;
dr["Email"] = returnModel.Email;
dr["FullName"] = returnModel.FullName;
dr["LastName"] = returnModel.LastName;
dr["LicenseId"] = returnModel.LicenseId;
dr["LicenseState"] = returnModel.LicenseState;
dr["MobileNo"] = returnModel.MobileNo;
dr["Password"] = returnModel.Password;
dr["Photo"] = returnModel.Photo;
dr["UserName"] = returnModel.UserName;
dr["ZipCode"] = returnModel.ZipCode;
table.Rows.Add(dr);
return(ds.GetXml());
//ds.Tables.Add(dt);
//adpt.Fill(ds, "ViewAssociateBasicDetail");
//return ds.GetXml();
//DataSet ds = new DataSet();
//SqlDataAdapter adpt = new SqlDataAdapter();
//ds = JsonConvert.DeserializeObject<DataSet>(resp.Content.ReadAsStringAsync().Result);
//adpt.Fill(ds, "ViewAssociateBasicDetail");
//return ds.GetXml();
}
//SqlCommand cmd = new SqlCommand("proc_AssociateRegistration", objCon.Con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@associateID", associateID);
//cmd.Parameters.AddWithValue("@action", "View");
//cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
//SqlDataAdapter adpt = new SqlDataAdapter();
//DataSet ds = new DataSet();
//if (objCon.Con.State == ConnectionState.Open)
//{ }
//else
//{
// objCon.Con.Open();
//}
//cmd.Connection = objCon.Con;
//adpt.SelectCommand = cmd;
//adpt.Fill(ds, "ViewAssociateBasicDetail");
//objCon.Con.Close();
//return ds.GetXml();
}
private void BindRecords()
{
try
{
BindState();
BllPurchaseCategory objp = new BllPurchaseCategory();
int s = objp.CardExistsOrNot1(Session["associate"].ToString());
if (s >= 1)
{
WcrCryptography cardEncrypt = new WcrCryptography();
BllAssociateRegistration d = new BllAssociateRegistration();
DataTable dt = new DataTable();
dt = d.retcardData(Convert.ToInt32(Session["associate"].ToString()), Session["userName"].ToString());
if (dt.Rows.Count > 0)
{
pnlupdate.Visible = true;
pnlAdd.Visible = false;
divCardEntry.Visible = true;
divViewCardInfo.Visible = false;
string _state = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_State"].ToString());
cardState.Text = _state;
cardState.SelectedValue = _state;
string _crdID = dt.Rows[0]["CardDataId"].ToString();
string _crd = cardEncrypt.WcrDecryptCardNumber(dt.Rows[0]["CardNumber"].ToString());
string _fstName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_FirstName"].ToString());
string _sndName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_LastName"].ToString());
string _Address = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Address"].ToString());
string _city = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_City"].ToString());
string _zip = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Zip"].ToString());
string _country = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Country"].ToString());
string _cvv = cardEncrypt.WcrDecrypt(dt.Rows[0]["CVV"].ToString());
string _months = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpMonth"].ToString());
string _year = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpYear"].ToString());
string _crdType = cardEncrypt.WcrDecrypt(dt.Rows[0]["CardType"].ToString());
txtCreditCard.Text = _crd.TrimStart('0');
txtCvv.Text = _cvv;
cardFname.Text = _fstName;
cardLastname.Text = _sndName;
Cardaddress.Text = _Address;
txtcity.Text = _city;
BindStateWiseZipCode();
ddlMonth.Text = _months;
ddlYear.Text = _year;
//hidCardID.Text = _crdID;
CardID.Value = _crdID;
// string a = _crd.Substring(0, 1);
string a = _crd.TrimStart('0').Substring(0, 1);
if (a == "3")
{
CheckBox3.Checked = true;
}
else if (a == "6")
{
CheckBox4.Checked = true;
}
else if (a == "5")
{
CheckBox2.Checked = true;
}
else if (a == "4")
{
CheckBox1.Checked = true;
}
else
{
CheckBox3.Checked = true;
}
cardzipcode.Text = _zip;
cardzipcode.SelectedValue = _zip;
}
else
{
pnlupdate.Visible = false;
pnlAdd.Visible = true;
divCardEntry.Visible = true;
divViewCardInfo.Visible = false;
}
}
else
{
pnlupdate.Visible = false;
pnlAdd.Visible = true;
divCardEntry.Visible = true;
divViewCardInfo.Visible = false;
txtCreditCard.Text = "";
cardFname.Text = "";
cardLastname.Text = "";
Cardaddress.Text = "";
txtCvv.Text = "";
cardzipcode.Text = "";
txtcity.Text = "";
cardState.Text = "0";
}
}
catch
{ }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
BllPurchaseCategory objp = new BllPurchaseCategory();
int s = objp.CardExistsOrNot1(Session["associate"].ToString());
if (s >= 1)
{
WcrCryptography cardEncrypt = new WcrCryptography();
BllAssociateRegistration d = new BllAssociateRegistration();
DataTable dt = new DataTable();
dt = d.retcardData(Convert.ToInt32(Session["associate"].ToString()), Session["userName"].ToString());
if (dt != null && dt.Rows.Count > 0)
{
Button1.Visible = false;
divCardEntry.Visible = false;
divViewCardInfo.Visible = true;
string _crdID = dt.Rows[0]["CardDataId"].ToString();
string _crd = cardEncrypt.WcrDecryptCardNumber(dt.Rows[0]["CardNumber"].ToString());
string _fstName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_FirstName"].ToString());
string _sndName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_LastName"].ToString());
string _Address = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Address"].ToString());
string _city = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_City"].ToString());
string _state = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_State"].ToString());
string _zip = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Zip"].ToString());
string _country = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Country"].ToString());
string _cvv = cardEncrypt.WcrDecrypt(dt.Rows[0]["CVV"].ToString());
string _months = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpMonth"].ToString());
string _year = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpYear"].ToString());
string _crdType = cardEncrypt.WcrDecrypt(dt.Rows[0]["CardType"].ToString());
txtCreditCard.Text = _crd.TrimStart('0');
txtCvv.Text = _cvv;
cardFname.Text = _fstName;
cardLastname.Text = _sndName;
Cardaddress.Text = _Address;
txtcity.Text = _city;
cardState.Text = _state;
cardCountry.Text = _country;
cardzipcode.Text = _zip;
ddlMonth.Text = _months;
ddlYear.Text = _year;
CardID.Value = _crdID;
//hidCardID.Text = _crdID;
//string a = _crd.Substring(0, 1);
string a = _crd.TrimStart('0').Substring(0, 1);
if (a == "3")
{
chkAmex.Checked = true;
chkAmex.Enabled = false;
chkDiscoverry.Enabled = false;
chkMasterCard.Enabled = false;
crdVisa.Enabled = false;
}
else if (a == "6")
{
chkAmex.Enabled = false;
chkDiscoverry.Checked = true;
chkDiscoverry.Enabled = false;
chkMasterCard.Enabled = false;
crdVisa.Enabled = false;
}
else if (a == "5")
{
chkAmex.Enabled = false;
chkDiscoverry.Enabled = false;
chkMasterCard.Checked = true;
chkMasterCard.Enabled = false;
crdVisa.Enabled = false;
}
else if (a == "4")
{
chkAmex.Enabled = false;
chkDiscoverry.Enabled = false;
chkMasterCard.Enabled = false;
crdVisa.Checked = true;
crdVisa.Enabled = false;
}
else
{
chkAmex.Checked = true;
chkAmex.Enabled = false;
chkDiscoverry.Enabled = false;
chkMasterCard.Enabled = false;
crdVisa.Enabled = false;
}
lblCardNumber.Text = _crd.TrimStart('0');;
lblExpMonth.Text = _months;
lblExpYear.Text = _year;
lblCvvCode.Text = _cvv;
lblFstName.Text = _fstName;
lblLastName.Text = _sndName;
lblStreetAddress.Text = _Address;
lblCity.Text = _city;
lblState.Text = _state;
lblCountry.Text = _country;
lblZipCode.Text = _zip;
}
else
{
pnlAdd.Visible = true;
Button1.Visible = false;
divCardEntry.Visible = true;
divViewCardInfo.Visible = false;
}
}
else
{
BindState();
Button1.Visible = false;
pnlAdd.Visible = true;
divCardEntry.Visible = true;
divViewCardInfo.Visible = false;
}
}
catch { }
}
}
protected void btnreset_Click(object sender, EventArgs e)
{
BllPurchaseCategory objp = new BllPurchaseCategory();
int s = objp.CardExistsOrNot1(Session["associate"].ToString());
if (s >= 1)
{
WcrCryptography cardEncrypt = new WcrCryptography();
BllAssociateRegistration d = new BllAssociateRegistration();
DataTable dt = new DataTable();
dt = d.retcardData(Convert.ToInt32(Session["associate"].ToString()), Session["userName"].ToString());
if (dt.Rows.Count > 0)
{
string _crdID = dt.Rows[0]["CardDataId"].ToString();
string _crd = cardEncrypt.WcrDecryptCardNumber(dt.Rows[0]["CardNumber"].ToString());
string _fstName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_FirstName"].ToString());
string _sndName = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_LastName"].ToString());
string _Address = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Address"].ToString());
string _city = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_City"].ToString());
string _state = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_State"].ToString());
string _zip = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Zip"].ToString());
string _country = cardEncrypt.WcrDecrypt(dt.Rows[0]["Cardholder_Country"].ToString());
string _cvv = cardEncrypt.WcrDecrypt(dt.Rows[0]["CVV"].ToString());
string _months = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpMonth"].ToString());
string _year = cardEncrypt.WcrDecrypt(dt.Rows[0]["ExpYear"].ToString());
string _crdType = cardEncrypt.WcrDecrypt(dt.Rows[0]["CardType"].ToString());
txtCreditCard.Text = _crd;
txtCvv.Text = _cvv;
cardFname.Text = _fstName;
cardLastname.Text = _sndName;
Cardaddress.Text = _Address;
txtcity.Text = _city;
cardState.Text = _state;
cardzipcode.Text = _zip;
ddlMonth.Text = _months;
ddlYear.Text = _year;
hidCardID.Value = _crdID;
}
else
{
}
}
else
{
txtCreditCard.Text = "";
cardFname.Text = "";
cardLastname.Text = "";
Cardaddress.Text = "";
txtCvv.Text = "";
cardzipcode.Text = "";
txtcity.Text = "";
cardState.Text = "0";
//ddlMonth.Text = _months;
//ddlYear.Text = _year;
// ContentPlaceHolder1_txtCreditCard.value = "";
//ContentPlaceHolder1_cardFname.value = "";
//ContentPlaceHolder1_cardLastname.value = "";
//ContentPlaceHolder1_Cardaddress.value = "";
//ContentPlaceHolder1_txtCvv.value = "";
//ContentPlaceHolder1_cardzipcode.value = "";
//ContentPlaceHolder1_txtcity.value = "";
//$('#ContentPlaceHolder1_cardState').val('Select State');
//$('#ContentPlaceHolder1_ddlMonth').val('Month');
//$('#ContentPlaceHolder1_ddlYear').val('Year');
}
}
