/// <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 AssociateAccountExists(string Email) { string _Email = Email.ToLower(); WcrCryptography crypto = new WcrCryptography(); AssociateAccountExistsParameters sqlParams = new AssociateAccountExistsParameters(); sqlParams.EmailId = crypto.WcrSimpleEncrypt(_Email); 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; UserAccountStatus returnModel = JsonConvert.DeserializeObject <UserAccountStatus>(resp.Content.ReadAsStringAsync().Result); if (returnModel == null) { return("-1"); } else { DataSet ds = new DataSet("dataSet"); DataTable table = ds.Tables.Add("associateExists"); table.Columns.Add("AccountId", typeof(int)); table.Columns.Add("Status", typeof(int)); table.Columns.Add("IsEmailVerified", typeof(int)); DataRow dr = table.NewRow(); dr["AccountId"] = returnModel.AssociateID; dr["Status"] = returnModel.Status; dr["IsEmailVerified"] = returnModel.IsEmailVerified; table.Rows.Add(dr); return(ds.GetXml()); } } }
/// <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 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"); } }
//public string VerifiedAccount(string username) //{ // try // { // WcrCryptography cardEncrypt = new WcrCryptography(); // SqlCommand cmd = new SqlCommand("proc_GetVerificationCode", objCon.Con); // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@username", username); // cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase); // cmd.Parameters.AddWithValue("@action", "verified"); // if (objCon.Con.State == ConnectionState.Open) // { } // else // { // objCon.Con.Open(); // } // int a = cmd.ExecuteNonQuery(); // if (a >= 1) // { // return "1"; // } // else // { // return "0"; // } // } // catch { return null; } //} #endregion public string VerifiedAccount(string username) { try { WcrCryptography cardEncrypt = new WcrCryptography(); SqlCommand cmd = new SqlCommand("proc_GetVerificationCode", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@username", username); cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase); cmd.Parameters.AddWithValue("@action", "verified"); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } int a = cmd.ExecuteNonQuery(); if (a >= 1) { WcrCryptography crypt = new WcrCryptography(); AssociateLogInParameters dataContent = new AssociateLogInParameters(); dataContent.Mob = crypt.WcrSimpleEncrypt(username); HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest); using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword)) { resp = client.PostAsJsonAsync("api/AccountCreation/AssociateActivation", dataContent).Result; int rc = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result); if (rc < 0) { // do we handle the error? } } return("1"); } else { return("0"); } } catch { return(null); } }
/// <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 ResendActivationCode(string _Email) { WcrCryptography crypto = new WcrCryptography(); HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest); WcrClassLibrary.DataObjects.EmailAddress sqlParams = new WcrClassLibrary.DataObjects.EmailAddress(); sqlParams.Email = crypto.WcrSimpleEncrypt(_Email); using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword)) { resp = client.PutAsJsonAsync("api/AccountCreation/ResendActivationCode", sqlParams).Result; int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result); if (Id > 0) { return(Id.ToString()); } else { return(ClsCommon.InactiveValue.ToString()); } } }
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 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 }