public DataSet getCustomer(CustomerBiz oCustomerBiz)
{
DataSet dsCustomer = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCustomer = new DataSet();
dsCustomer = objCoreDataLayer.ExecuteDataSet("pr_getcustomer", new object[] { oCustomerBiz.Email,oCustomerBiz.Pwd});
}
catch (Exception ex)
{
throw ex;
}
return dsCustomer;
}
public bool changePwd(CustomerBiz oCustomerBiz)
{
try
{
CustomerData oCustomerData = new CustomerData();
//Todo encrypt
String pwdEncrypt = SHA256Encrypt(oCustomerBiz.Pwd);
oCustomerBiz.Pwd = pwdEncrypt;
return oCustomerData.changePwd(oCustomerBiz);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean customerSignUp(CustomerBiz oCustomerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strRetValue = string.Empty;
strRetValue = objCoreDataLayer.ExecuteScalar("pr_insertcustomer", new object[] { oCustomerBiz.Email,oCustomerBiz.Name,oCustomerBiz.Pwd }, true);
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
public DataSet getCustomer(CustomerBiz oCustomerBiz,out string custStatus)
{
try
{
//Todo encryption
String pwdEncrypt = SHA256Encrypt(oCustomerBiz.Pwd);
oCustomerBiz.Pwd = pwdEncrypt;
CustomerData oCustomerData = new CustomerData();
bool isStatus = false;
bool isUserExist = oCustomerData.isUserExist(oCustomerBiz);
DataSet dsCustomer = null;
if (isUserExist)
{
dsCustomer = new DataSet();
dsCustomer = oCustomerData.getCustomer(oCustomerBiz);
}
if (dsCustomer!=null && dsCustomer.Tables.Count > 0)
isStatus = true;
if (isStatus)
custStatus = "Inactive";
else
custStatus = "";
return dsCustomer;
}
catch (Exception ex)
{
throw ex;
}
}
public int insertShippingAddress(CustomerBiz oCustomerBiz)
{
try
{
CustomerData oCustomerData = new CustomerData();
return oCustomerData.insertShippingAddress(oCustomerBiz);
}
catch (Exception ex)
{
throw ex;
}
}
public int insertCustomer(CustomerBiz oCustomerBiz)
{
try
{
CustomerData oCustomerData = new CustomerData();
// Todo encryption
String pwdEncrypt = SHA256Encrypt(oCustomerBiz.Pwd);
oCustomerBiz.Pwd = pwdEncrypt;
int iCheck=0;
bool isUserExist = oCustomerData.isEmailExist(oCustomerBiz);
if (isUserExist)
{
iCheck=1;
}
else
{
bool isSucc = oCustomerData.customerSignUp(oCustomerBiz);
if (isSucc)
iCheck=2;
}
return iCheck;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet getCustomerSavedAddress(CustomerBiz oCustomerBiz)
{
try
{
CustomerData oCustomerData = new CustomerData();
DataSet dsCustomerAdd = new DataSet();
dsCustomerAdd = oCustomerData.getCustomerSavedAddress(oCustomerBiz);
return dsCustomerAdd;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet getCustomerSavedAddress(CustomerBiz oCustomerBiz)
{
DataSet dsCustomerAdd = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCustomerAdd = new DataSet();
dsCustomerAdd = objCoreDataLayer.ExecuteDataSet("pr_getcustomerSavedAdd", new object[] { oCustomerBiz.CustomerId });
}
catch (Exception ex)
{
throw ex;
}
return dsCustomerAdd;
}
public Boolean isUserExist(CustomerBiz oCustomerBiz)
{
int cnt = 0;
bool flg = false;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
cnt = Convert.ToInt32(objCoreDataLayer.ExecuteScalar("pr_checkcustomer", new object[] { oCustomerBiz.Email,oCustomerBiz.Pwd}, false));
if (cnt > 0)
flg = true;
}
catch (Exception ex)
{
throw ex;
}
return flg;
}
public int insertShippingAddress(CustomerBiz oCustomerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
int iCustomerAddID = 0;
try
{
iCustomerAddID = objCoreDataLayer.ExecuteIdentity("pr_InsShippingAdd", new object[] { oCustomerBiz.CustomerId,oCustomerBiz.ShippingName,oCustomerBiz.ShippingAddress,oCustomerBiz.ShippingPincode,oCustomerBiz.ShippingCity,oCustomerBiz.ShippingState,oCustomerBiz.ShippingMobile,oCustomerBiz.ShippingSaveName});
}
catch (Exception ex)
{
throw ex;
}
return iCustomerAddID;
}
