/// <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(); } }
public string RecordExistsOrNot(PropAssociateRegistration objAssociateRegistration) { WcrCryptography crypto = new WcrCryptography(); AssociateRegistrationParameters sqlParams = new AssociateRegistrationParameters(); sqlParams.EmailId = crypto.EncryptUserName(objAssociateRegistration.EmailID); HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest); //using (WcrHttpClient client = new WcrHttpClient(objAssociateRegistration.EmailID)) //using (WcrHttpClient client = new WcrHttpClient(objAssociateRegistration.EmailID)) using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword)) { resp = client.PostAsJsonAsync("api/AssociateTransactions/AssociateRegistrationRecordExists", 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_AssociateRegistration", objCon.Con); //cmd.CommandType = CommandType.StoredProcedure; //objCon.Con.Open(); //try //{ // cmd.Parameters.AddWithValue("@EmailID", objAssociateRegistration.EmailID); // cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase); // cmd.Parameters.AddWithValue("@Action", "RecordExists"); // 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(); //} }
/// <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 AssociateResetPassword(PropAssociateRegistration objassociate) { WcrCryptography crypto = new WcrCryptography(); ChangeAssociatePasswordParameters sqlParams = new ChangeAssociatePasswordParameters(); sqlParams.Email = crypto.EncryptUserName(objassociate.EmailID); HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest); using (WcrHttpClient client = new WcrHttpClient(objassociate.EmailID)) { resp = client.PostAsJsonAsync("api/AssociateTransactions/SendPasswordResetEmail", 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 }