/// <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());
}
}
/// <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(); }
}
public string ConsumerLogin(string EmailID, string Password)
{
string str = string.Empty;
BllAssociateLogin Objassociate = new BllAssociateLogin();
PropConsumerRegistration Proconsumer = new PropConsumerRegistration();
Proconsumer.MobileNo = EmailID;
Proconsumer.Password = Password;
str = Objassociate.Selectconsumer(Proconsumer);
return(str);
}
public string DeleteConsumer()
{
string str = string.Empty;
PropConsumerRegistration objProperty = new PropConsumerRegistration();
objProperty.ID = Convert.ToInt16(Session["consumer"]);
BllConsumerRegistration Objconsumer = new BllConsumerRegistration();
str = Objconsumer.DeleteConsumer(objProperty);
Session.Abandon();
return(str);
}
/// <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 DeleteConsumer(PropConsumerRegistration objProperty)
{
DllConsumerRegistration objDal = new DllConsumerRegistration();
try
{
return(objDal.DeleteConsumer(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string UpdatePhote(PropConsumerRegistration objProperty)
{
DllConsumerRegistration objDal = new DllConsumerRegistration();
try
{
return(objDal.UpdateConsumerPhoto(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
/// <summary>
/// This Method will be used to insert Consumer Data into Database
/// </summary>
/// <param name="objProperty"></param>
/// <returns></returns>
public string RecordInsert(PropConsumerRegistration objProperty)
{
DllConsumerRegistration objDal = new DllConsumerRegistration();
try
{
return(objDal.InsertData(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string ResetConsumerPass(PropConsumerRegistration objConsumer)
{
DllAssociateLogin objDal = new DllAssociateLogin();
try
{
return(objDal.ResetConsumerPass(objConsumer));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (context.Request.Files.Count > 0)
{
string str = string.Empty;
string assId = string.Empty;
string _mainImg = string.Empty;
HttpFileCollection files = context.Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFile file = files[i];
string fname;
string m = string.Empty;
if (HttpContext.Current.Request.Browser.Browser.ToUpper() == "IE" || HttpContext.Current.Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
assId = fname;
}
if (i == 0)
{
fname = Path.Combine(context.Server.MapPath("../ConsumerPhoto/"), Convert.ToInt16(context.Session["consumer"]).ToString() + ".png");
file.SaveAs(fname);
_mainImg = Convert.ToInt16(context.Session["consumer"]).ToString() + ".png";
BllConsumerRegistration objUpdatePic = new BllConsumerRegistration();
PropConsumerRegistration objConsumerRegistration = new PropConsumerRegistration();
objConsumerRegistration.Photo = _mainImg;
objConsumerRegistration.ID = Convert.ToInt16(context.Session["consumer"]);
str = objUpdatePic.UpdatePhote(objConsumerRegistration);
context.Response.Write(str);
}
}
}
}
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(); }
}
/// <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 SendConsumerPassonEmail(PropConsumerRegistration objConsumer)
{
WcrCryptography crypto = new WcrCryptography();
ChangeConsumerPasswordParameters sqlParams = new ChangeConsumerPasswordParameters();
sqlParams.Email = crypto.EncryptUserName(objConsumer.EmailID);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(objConsumer.EmailID))
{
resp = client.PostAsJsonAsync("api/ConsumerTransactions/SendPasswordResetEmail", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id >= 0)
{
return(Id.ToString());
}
else
{
return("-1");
}
}
}
public string UpdateConsumer(string FirstName, string Address, string userName, string MobileNo, string password, string emailID, string ZipCode, string lastName, string Unit_Apt, string city, string stateID)
{
string str = string.Empty;
PropConsumerRegistration proConsumerRegistration = new PropConsumerRegistration();
proConsumerRegistration.Name = FirstName;
proConsumerRegistration.Address = Address;
proConsumerRegistration.UserName = userName;
proConsumerRegistration.MobileNo = MobileNo;
proConsumerRegistration.Password = password;
proConsumerRegistration.EmailID = emailID;
proConsumerRegistration.ZipCode = ZipCode;
proConsumerRegistration.LastName = lastName;
proConsumerRegistration.Unit_Apt = Unit_Apt;
proConsumerRegistration.City = city;
proConsumerRegistration.StateID = stateID;
proConsumerRegistration.ID = Convert.ToInt16(Session["consumer"].ToString());
BllConsumerRegistration objConsumer = new BllConsumerRegistration();
str = objConsumer.RecordUpdate(proConsumerRegistration);
return(str);
}
