/// <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(); } }