/// <summary>
/// This Method is used to check authentication of Consumer
/// </summary>
/// <param name="objadmin">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string SelectConsumer(PropConsumerRegistration objConsumer)
{
WcrCryptography crypto = new WcrCryptography();
ConsumerLoginParameters sqlParams = new ConsumerLoginParameters();
string _Email = objConsumer.MobileNo.ToLower();
// sqlParams.Mob = crypto.EncryptUserName(objConsumer.MobileNo);
sqlParams.Mob = crypto.EncryptUserName(_Email);
sqlParams.Password = crypto.EncryptPassword(objConsumer.Password);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objConsumer.MobileNo))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/ConsumerLogin", sqlParams).Result;
ConsumerLogin_ReturnDataModel returnModel = JsonConvert.DeserializeObject <ConsumerLogin_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
DataSet ds = new DataSet("dataSet");
DataTable table = ds.Tables.Add("consumerLogin");
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Flag", typeof(int));
DataRow dr = table.NewRow();
dr["Id"] = returnModel.Id;
dr["Flag"] = returnModel.Flag;
table.Rows.Add(dr);
return(ds.GetXml());
}
}
public string UpdateAssociateProfile(PropAssociateRegistration objAssociateRegistration, string userName)
{
if (userName != null && userName != "")
{
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);
sqlParams.Password = crypto.EncryptPassword(objAssociateRegistration.Password);
sqlParams.MobileNo = crypto.WcrSimpleEncrypt(objAssociateRegistration.MobileNo);
sqlParams.ZipCode = crypto.WcrSimpleEncrypt(objAssociateRegistration.ZipCode);
sqlParams.LicenseState = crypto.WcrSimpleEncrypt(objAssociateRegistration.LicenseState);
sqlParams.LicenseId = crypto.WcrSimpleEncrypt(objAssociateRegistration.LicenseID);
sqlParams.AssociateId = Convert.ToInt32(userName);
string currentEmailID = GetEmailIdByAssociateId(Convert.ToInt32(userName));
if (!currentEmailID.Equals(objAssociateRegistration.EmailID))
{
string strReturn = this.RecordExistsOrNotForAssociate(new PropAssociateRegistration()
{
EmailID = objAssociateRegistration.EmailID
});
if (!ClsCommon.InactiveValue.ToString().Equals(strReturn))
{
return("InValid Email ID");
}
strReturn = this.RecordExistsOrNotForConsumer(new PropAssociateRegistration()
{
EmailID = objAssociateRegistration.EmailID
});
if (!ClsCommon.InactiveValue.ToString().Equals(strReturn))
{
return("InValid Email ID");
}
}
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(currentEmailID))
{
resp = client.PostAsJsonAsync("api/AssociateTransactions/AssociateRegistrationEditRcd", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id > 0)
{
return(Id.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
}
else
{
return("Not Valid");
}
}
/// <summary>
/// This Methos will be used to update consumer detail
/// </summary>
/// <param name="objConsumerRegistration"></param>
/// <returns></returns>
public string UpdateData(PropConsumerRegistration objConsumerRegistration)
{
WcrCryptography crypto = new WcrCryptography();
ConsumersParameters sqlParams = new ConsumersParameters();
sqlParams.Name = crypto.WcrSimpleEncrypt(objConsumerRegistration.Name);
sqlParams.Address = crypto.WcrSimpleEncrypt(objConsumerRegistration.Address);
sqlParams.Mob = crypto.WcrSimpleEncrypt(objConsumerRegistration.MobileNo);
sqlParams.UserName = crypto.WcrSimpleEncrypt(objConsumerRegistration.UserName);
sqlParams.EmailId = crypto.EncryptUserName(objConsumerRegistration.EmailID);
sqlParams.Password = crypto.EncryptPassword(objConsumerRegistration.Password);
sqlParams.ZipCode = crypto.WcrSimpleEncrypt(objConsumerRegistration.ZipCode);
sqlParams.LastName = crypto.WcrSimpleEncrypt(objConsumerRegistration.LastName);
sqlParams.Unit_Apt = crypto.WcrSimpleEncrypt(objConsumerRegistration.Unit_Apt);
sqlParams.City = crypto.WcrSimpleEncrypt(objConsumerRegistration.City);
sqlParams.StateId = crypto.WcrSimpleEncrypt(objConsumerRegistration.StateID);
sqlParams.Id = Convert.ToInt32(objConsumerRegistration.ID);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objConsumerRegistration.EmailID))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/ConsumersEditConsumer", 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", objConsumerRegistration.Name);
//cmd.Parameters.AddWithValue("@address", objConsumerRegistration.Address);
//cmd.Parameters.AddWithValue("@mob", objConsumerRegistration.MobileNo);
//cmd.Parameters.AddWithValue("@userName", objConsumerRegistration.UserName);
//cmd.Parameters.AddWithValue("@password", objConsumerRegistration.Password);
//cmd.Parameters.AddWithValue("@emailID", objConsumerRegistration.EmailID);
//cmd.Parameters.AddWithValue("@ZipCode", objConsumerRegistration.ZipCode);
//cmd.Parameters.AddWithValue("@lastName", objConsumerRegistration.LastName);
//cmd.Parameters.AddWithValue("@Unit_Apt", objConsumerRegistration.Unit_Apt);
//cmd.Parameters.AddWithValue("@city", objConsumerRegistration.City);
//cmd.Parameters.AddWithValue("@stateID", objConsumerRegistration.StateID);
//cmd.Parameters.AddWithValue("@id", objConsumerRegistration.ID);
//cmd.Parameters.AddWithValue("@Action", "EditConsumer");
//cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
//int a = cmd.ExecuteNonQuery();
//objCon.Con.Close();
//if (a > 0)
//{
// return a.ToString();
//}
//else
//{ return ClsCommon.InactiveValue.ToString(); }
}
/// <summary>
/// This Method is used to Post data into tbl_sale table
/// </summary>
/// <param name="objAssociateRegistration"></param>
/// <returns>1 for success and -1 for fail</returns>
public string InsertData(PropConsumerRegistration objConsumerRegistration)
{
WcrCryptography crypto = new WcrCryptography();
ConsumersParameters sqlParams = new ConsumersParameters();
sqlParams.Name = crypto.WcrSimpleEncrypt(objConsumerRegistration.Name);
sqlParams.EmailId = crypto.EncryptUserName(objConsumerRegistration.EmailID.ToLower());
sqlParams.Password = crypto.EncryptPassword(objConsumerRegistration.Password);
sqlParams.Address = crypto.WcrSimpleEncrypt(objConsumerRegistration.Address);
sqlParams.ZipCode = crypto.WcrSimpleEncrypt(objConsumerRegistration.ZipCode);
sqlParams.Mob = crypto.WcrSimpleEncrypt(objConsumerRegistration.MobileNo);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword))
{
resp = client.PostAsJsonAsync("api/AccountCreation/ConsumersAdd", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id > 0)
{
return(Id.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
#region
//SqlCommand cmd = new SqlCommand("proc_Consumers", objCon.Con);
//cmd.CommandType = CommandType.StoredProcedure;
//objCon.Con.Open();
//cmd.Parameters.AddWithValue("@Name", objConsumerRegistration.Name);
//cmd.Parameters.AddWithValue("@EmailID", objConsumerRegistration.EmailID);
//cmd.Parameters.AddWithValue("@Password", objConsumerRegistration.Password);
//cmd.Parameters.AddWithValue("@address", objConsumerRegistration.Address);
//cmd.Parameters.AddWithValue("@ZipCode", objConsumerRegistration.ZipCode);
//cmd.Parameters.AddWithValue("@Action", "Add");
//cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
//int a = Convert.ToInt16(cmd.ExecuteScalar());
//objCon.Con.Close();
//if (a > 0)
//{
// return a.ToString();
//}
//else
//{ return ClsCommon.InactiveValue.ToString(); }
#endregion
}
/// <summary>
/// </summary>
/// <param name="objadmin">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string ResetConsumerPass(PropConsumerRegistration objassociate)
{
WcrCryptography crypto = new WcrCryptography();
ChangeConsumerPasswordParameters sqlParams = new ChangeConsumerPasswordParameters();
sqlParams.Email = crypto.EncryptUserName(objassociate.EmailID);
sqlParams.Password = crypto.EncryptPassword(objassociate.Password);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objassociate.EmailID))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/ChangeAssociatePassword", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id >= 1)
{
return(Id.ToString());
}
else
{
return("-1");
}
}
}
/// <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; }
}
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
}