public bool Save(string emailid, string password)
{
SqlDataReader dr = null;
var ms = new MethodStore();
dr = ms.sp_ExcecuteReader("RegisterDealer", "@Email", emailid, "@Password", password, "@Name", Name, "@NameOfCompany", NameOfCompany, "@Address", Address, "@City", City, "@State", State, "@Pincode", Pincode, "@PhoneNo", Phone);
if (!CheckResult(ms, dr))
{
return(false);
}
if (dr.Read())
{
DealersId = dr["DealerId"].ToString();
ms.ConnectionClose(dr);
if (DealersId == "0")
{
Error = "Account already exists with " + emailid; return(false);
}
}
ms.ConnectionClose(dr);
return(true);
}
public bool Select()
{
SqlDataReader dr = null;
var ms = new MethodStore();
dr = ms.sp_ExcecuteReader("SelectDealerDetails", "@DealerId", DealersId);
if (!CheckResult(ms, dr))
{
return(false);
}
if (dr.Read())
{
Email = dr["DealersEmail"].ToString();
OldPass = dr["DealersPassword"].ToString();
Name = dr["Name"].ToString();
NameOfCompany = dr["NameOfCompany"].ToString();
Address = dr["Address"].ToString();
City = dr["City"].ToString();
State = dr["State"].ToString();
Pincode = dr["Pincode"].ToString();
Phone = dr["PhoneNo"].ToString();
}
ms.ConnectionClose(dr);
return(true);
}
public bool EmailVerification(string Id)
{
var ms = new MethodStore();
var result = ms.sp_ExecuteQuery("VerifyEmail", "@DealerId", Id);
return(CheckResult(ms, result));
}
public bool ChangePassword(string Oldpass, string NewPass)
{
var ms = new MethodStore();
var result = ms.sp_ExecuteQuery("ChangePassword", "@DealerId", DealersId, "@OldPassword", Oldpass, "@NewPassword ", NewPass);
return(CheckResult(ms, result));
}
public bool UpdateDealerDetails()
{
var ms = new MethodStore();
var result = ms.sp_ExecuteQuery("UpdateDealerDetails", "@DealerId", DealersId,
"@Name", Name, "@NameOfCompany", NameOfCompany, "@Address", Address, "@City", City, "@State", State, "@Pincode", Pincode, "@PhoneNo", Phone);
return(CheckResult(ms, result));
}
private static bool CheckResult(MethodStore ms, SqlDataReader dr)
{
if (dr != null)
{
return(true);
}
Error = ms.Error;
ms.ConnectionClose(null);
return(false);
}
private static bool CheckResult(MethodStore ms, bool result)
{
if (!result)
{
Error = ms.Error;
ms.ConnectionClose();
return(false);
}
ms.ConnectionClose();
return(true);
}
public string Login(string emailid, string password)
{
SqlDataReader dr = null;
var ms = new MethodStore();
dr = ms.sp_ExcecuteReader("SelectDealer", "@Email", emailid, "@Password", password);
if (!CheckResult(ms, dr))
{
return(Error = ms.Error);
}
if (dr.Read())
{
DealersId = dr["DealersId"].ToString();
ms.ConnectionClose(dr);
return(DealersId);
}
ms.ConnectionClose(dr);
return(Error = "Your Email or Password is not correct");
}
public string ForgotPassword(string emailid)
{
var ms = new MethodStore();
SqlDataReader dr = null;
dr = ms.sp_ExcecuteReader("ForgotPassword", "@EmailId", emailid);
if (!CheckResult(ms, dr))
{
return(Error = ms.Error);
}
if (dr.Read())
{
PassWord = dr["DealersPassword"].ToString();
Name = dr["Name"].ToString();
return("true");
}
ms.ConnectionClose(dr);
return(Error = "Email-id is not registered with us Register now." + emailid);
}
