/// <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 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());
}
}
}
public string UpdateAssociatePic(PropAssociateRegistration objAssociateRegistration, string associateID, string userName)
{
if (userName != null && userName != "")
{
WcrCryptography crypto = new WcrCryptography();
AssociateRegistrationParameters sqlParams = new AssociateRegistrationParameters();
sqlParams.Photo = objAssociateRegistration.Photo;
sqlParams.AssociateId = Convert.ToInt32(associateID);
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(userName))
{
resp = client.PostAsJsonAsync("api/AssociateTransactions/AssociateRegistrationEditPic", 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 SendConsumerDetail(int associateID, int advertisementID, int consumerID, int jobtype, int zipcode, string username)
{
WcrCryptography crypto = new WcrCryptography();
InterestNotificationObject sqlParams = new InterestNotificationObject();
sqlParams.AssociateId = associateID;
sqlParams.AdvertisementId = advertisementID;
sqlParams.ConsumerId = consumerID;
sqlParams.JobType = jobtype;
sqlParams.ZipCode = zipcode;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(username))
{
resp = client.PostAsJsonAsync("api/AssociateTransactions/SendInterestNotifications", sqlParams).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id >= 0)
{
return(Id.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
#region
#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");
}
}
/// <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 GetEmailIdByAssociateId(int inAssociateId)
{
string oStr = string.Empty;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(WcrVault.Gateway.getwcrusername, WcrVault.Gateway.getwcrpassword))
{
string endpoint = "api/AccountCreation/GetAssociateEmailById?inAssociateId=" + inAssociateId.ToString();
resp = client.GetAsync(endpoint).Result;
oStr = JsonConvert.DeserializeObject <string>(resp.Content.ReadAsStringAsync().Result);
}
WcrCryptography crypt = new WcrCryptography();
oStr = crypt.WcrSimpleDecrypt(oStr);
return(oStr);
}
//public string LoadPaymentHistoryItem(CardPaymentObj objAssociateRegistration, int AssociateID, string description, int CardDataId)
//{
// SqlCommand cmd = new SqlCommand("proc_LoadPaymentHistoryItem", objCon.Con);
// cmd.CommandType = CommandType.StoredProcedure;
// objCon.Con.Open();
// try
// {
// cmd.Parameters.AddWithValue("@PaymentID", objAssociateRegistration.PaymentID);
// cmd.Parameters.AddWithValue("@PaymentAmt", objAssociateRegistration.Total);
// cmd.Parameters.AddWithValue("@PaymentDate", System.DateTime.Now.ToString());
// cmd.Parameters.AddWithValue("@PaymentDesc", description);
// cmd.Parameters.AddWithValue("@CardDataId", CardDataId);
// cmd.Parameters.AddWithValue("@AssociateID", AssociateID);
// cmd.Parameters.AddWithValue("@CardNumber", objAssociateRegistration.CardNumber);
// 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 will get associate detail on the basis of AdvertismentID
/// </summary>
/// <param name="AdvertismentID"></param>
/// <returns></returns>
public string GetAssociateDetail(int AdvertismentID, string userName)
{
WcrCryptography crypto = new WcrCryptography();
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(userName))
{
resp = client.PostAsJsonAsync("api/AssociateTransactions/GetAssociateDetail", AdvertismentID).Result;
// DataSet ds = new DataSet();
GetAssociateDetail_ReturnDataModel returnModel = JsonConvert.DeserializeObject <GetAssociateDetail_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
returnModel.Email = crypto.DecryptUserName(returnModel.Email);
returnModel.FullName = crypto.WcrSimpleDecrypt(returnModel.FullName);
returnModel.MobileNo = crypto.WcrSimpleDecrypt(returnModel.MobileNo);
SqlDataAdapter adpt = new SqlDataAdapter();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr = dt.NewRow();
dr["Email"] = returnModel.Email;
dr["FullName"] = returnModel.FullName;
dr["MobileNo"] = returnModel.MobileNo;
dr["AssociateId"] = returnModel.AssociateId;
ds.Tables.Add(dt);
adpt.Fill(ds, "ViewAssociateDetail");
return(ds.GetXml());
}
//SqlCommand cmd = new SqlCommand("Usp_GetassociateDetail", objCon.Con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@advertismentID", AdvertismentID);
//SqlDataAdapter adpt = new SqlDataAdapter();
//DataSet ds = new DataSet();
//if (objCon.Con.State == ConnectionState.Open)
//{ }
//else
//{
// objCon.Con.Open();
//}
//cmd.Connection = objCon.Con;
//adpt.SelectCommand = cmd;
//adpt.Fill(ds, "ViewAssociateDetail");
//objCon.Con.Close();
//return ds.GetXml();
}
//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); }
}
public string AssociateSupport(int associateID, string message, string uname)
{
int associateId = associateID;
string sMsg = message;
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(uname))
{
resp = client.PutAsJsonAsync(string.Format("api/EmailServices/WcrAssociateSupport?inAssociateId={0}&inMessage={1}", associateId, sMsg), string.Empty).Result;
int Id = JsonConvert.DeserializeObject <int>(resp.Content.ReadAsStringAsync().Result);
if (Id == 0)
{
return(Id.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 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 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");
}
}
}
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(); }
}
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());
}
}
}
}
/// <summary>
/// This Method will get associate detail on the basis of associateID
/// </summary>
/// <param name="AdvertismentID"></param>
/// <returns></returns>
public string GetAssociateBasicDetail(int associateID, string userName)
{
WcrCryptography crypto = new WcrCryptography();
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(userName))
{
//resp = client.GetAsync($"api/AssociateTransactions/AssociateRegistrationView?inAssociateId={associateID}").Result;
resp = client.GetAsync(string.Format("api/AssociateTransactions/AssociateRegistrationView?inAssociateId={0}", associateID)).Result;
AssociateRegistrationView_ReturnDataModel returnModel = JsonConvert.DeserializeObject <AssociateRegistrationView_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
returnModel.Email = crypto.DecryptUserName(returnModel.Email);
returnModel.FullName = crypto.WcrSimpleDecrypt(returnModel.FullName);
returnModel.LastName = crypto.WcrSimpleDecrypt(returnModel.LastName);
returnModel.LicenseId = crypto.WcrSimpleDecrypt(returnModel.LicenseId);
returnModel.LicenseState = crypto.WcrSimpleDecrypt(returnModel.LicenseState);
returnModel.MobileNo = crypto.WcrSimpleDecrypt(returnModel.MobileNo);
returnModel.Password = crypto.DecryptPassword(returnModel.Password);
returnModel.Photo = returnModel.Photo;
returnModel.UserName = crypto.WcrSimpleDecrypt(returnModel.UserName);
returnModel.ZipCode = crypto.WcrSimpleDecrypt(returnModel.ZipCode);
DataSet ds = new DataSet("dataSet");
DataTable table = ds.Tables.Add("ViewAssociateBasicDetail");
table.Columns.Add("AssociateId", typeof(int));
table.Columns.Add("Email", typeof(string));
table.Columns.Add("FullName", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("LicenseId", typeof(string));
table.Columns.Add("LicenseState", typeof(string));
table.Columns.Add("MobileNo", typeof(string));
table.Columns.Add("Password", typeof(string));
table.Columns.Add("Photo", typeof(string));
table.Columns.Add("UserName", typeof(string));
table.Columns.Add("ZipCode", typeof(string));
DataRow dr = table.NewRow();
dr["AssociateId"] = associateID;
dr["Email"] = returnModel.Email;
dr["FullName"] = returnModel.FullName;
dr["LastName"] = returnModel.LastName;
dr["LicenseId"] = returnModel.LicenseId;
dr["LicenseState"] = returnModel.LicenseState;
dr["MobileNo"] = returnModel.MobileNo;
dr["Password"] = returnModel.Password;
dr["Photo"] = returnModel.Photo;
dr["UserName"] = returnModel.UserName;
dr["ZipCode"] = returnModel.ZipCode;
table.Rows.Add(dr);
return(ds.GetXml());
//ds.Tables.Add(dt);
//adpt.Fill(ds, "ViewAssociateBasicDetail");
//return ds.GetXml();
//DataSet ds = new DataSet();
//SqlDataAdapter adpt = new SqlDataAdapter();
//ds = JsonConvert.DeserializeObject<DataSet>(resp.Content.ReadAsStringAsync().Result);
//adpt.Fill(ds, "ViewAssociateBasicDetail");
//return ds.GetXml();
}
//SqlCommand cmd = new SqlCommand("proc_AssociateRegistration", objCon.Con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@associateID", associateID);
//cmd.Parameters.AddWithValue("@action", "View");
//cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
//SqlDataAdapter adpt = new SqlDataAdapter();
//DataSet ds = new DataSet();
//if (objCon.Con.State == ConnectionState.Open)
//{ }
//else
//{
// objCon.Con.Open();
//}
//cmd.Connection = objCon.Con;
//adpt.SelectCommand = cmd;
//adpt.Fill(ds, "ViewAssociateBasicDetail");
//objCon.Con.Close();
//return ds.GetXml();
}
public string SelectConsumerDetail(int ID, string uname)
{
WcrCryptography crypto = new WcrCryptography();
HttpResponseMessage resp = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest);
using (WcrHttpClient client = new WcrHttpClient(uname))
{
resp = client.GetAsync(string.Format("api/ConsumerTransactions/consumerDetail?inConsumerId={0}", ID)).Result;
ConsumerDetail_ReturnDataModel returnModel = JsonConvert.DeserializeObject <ConsumerDetail_ReturnDataModel>(resp.Content.ReadAsStringAsync().Result);
if (returnModel == null)
{
return(null);
}
else
{
returnModel.Name = crypto.DecryptUserName(returnModel.Name);
returnModel.Address = crypto.WcrSimpleDecrypt(returnModel.Address);
returnModel.Mob = crypto.WcrSimpleDecrypt(returnModel.Mob);
returnModel.UserName = crypto.WcrSimpleDecrypt(returnModel.UserName);
returnModel.EmailId = crypto.DecryptUserName(returnModel.EmailId);
returnModel.Password = crypto.DecryptPassword(returnModel.Password);
returnModel.ZipCode = crypto.WcrSimpleDecrypt(returnModel.ZipCode);
returnModel.ConsumerPhoto = returnModel.ConsumerPhoto;
returnModel.LastName = crypto.WcrSimpleDecrypt(returnModel.LastName);
returnModel.Unit_Apt = crypto.WcrSimpleDecrypt(returnModel.Unit_Apt);
returnModel.City = crypto.WcrSimpleDecrypt(returnModel.City);
returnModel.StateId = crypto.WcrSimpleDecrypt(returnModel.StateId);
DataSet ds = new DataSet("dataSet");
DataTable table = ds.Tables.Add("ConsumerDetail");
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Address", typeof(string));
table.Columns.Add("Mob", typeof(string));
table.Columns.Add("UserName", typeof(string));
table.Columns.Add("EmailId", typeof(string));
table.Columns.Add("Password", typeof(string));
table.Columns.Add("ZipCode", typeof(string));
table.Columns.Add("ConsumerPhoto", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("Unit_Apt", typeof(string));
table.Columns.Add("City", typeof(string));
table.Columns.Add("StateId", typeof(string));
DataRow dr = table.NewRow();
dr["Id"] = ID;
dr["Name"] = returnModel.Name;
dr["Address"] = returnModel.Address;
dr["Mob"] = returnModel.Mob;
dr["UserName"] = returnModel.UserName;
dr["EmailId"] = returnModel.EmailId;
dr["Password"] = returnModel.Password;
dr["ZipCode"] = returnModel.ZipCode;
dr["ConsumerPhoto"] = returnModel.ConsumerPhoto;
dr["LastName"] = returnModel.LastName;
dr["Unit_Apt"] = returnModel.Unit_Apt;
dr["City"] = returnModel.City;
dr["StateId"] = returnModel.StateId;
table.Rows.Add(dr);
return(ds.GetXml());
}
////SqlCommand cmd = new SqlCommand("proc_ConsumerDetail", objCon.Con);
////cmd.CommandType = CommandType.StoredProcedure;
////cmd.Parameters.AddWithValue("@ID", ID);
////cmd.Parameters.AddWithValue("@Passphrase", WcrCryptography.SqlPassphrase);
////SqlDataAdapter adpt = new SqlDataAdapter();
////DataSet ds = new DataSet();
////if (objCon.Con.State == ConnectionState.Open)
////{ }
////else
////{
//// objCon.Con.Open();
////}
////cmd.Connection = objCon.Con;
////adpt.SelectCommand = cmd;
////adpt.Fill(ds, "ConsumerDetail");
////objCon.Con.Close();
////return ds.GetXml();
}
}
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
}
/// <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; }
}
