/// <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
}
public string UpdateConsumerPhoto(PropConsumerRegistration objConsumerRegistration)
{
WcrCryptography crypto = new WcrCryptography();
ConsumersParameters sqlParams = new ConsumersParameters();
sqlParams.ConPhoto = objConsumerRegistration.Photo;
sqlParams.Id = objConsumerRegistration.ID;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objConsumerRegistration.EmailID))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/ConsumersUpdatePhoto", 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("@ConPhoto", objConsumerRegistration.Photo);
//cmd.Parameters.AddWithValue("@id", objConsumerRegistration.ID);
//cmd.Parameters.AddWithValue("@Action", "UpdatePhoto");
//int a = cmd.ExecuteNonQuery();
//objCon.Con.Close();
//if (a > 0)
//{
// return a.ToString();
//}
//else
//{ return ClsCommon.InactiveValue.ToString(); }
}
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(); }
}
