public static int DeleteCustomer(Customer customer)
{
int result;
TMSDataLibrary.Customer _objcustomer = new TMSDataLibrary.Customer();
result = _objcustomer.DeleteCustomer(customer.UserId);
return result;
}
/// <summary>
/// Add Customer Information To Database In customer
/// </summary>
/// <param name="customer">Customer</param>
/// <returns>status</returns>
public static int AddCustomer(Customer customer)
{
int result;
string customerNo = "";
TMSDataLibrary.Customer _objcustomer = new TMSDataLibrary.Customer();
int usertype = (int)CONSTANT.ApplicationUserType.Customer;
result = _objcustomer.AddCustomer(customer.Password, customer.FirstName, customer.LastName,
customer.Mobile, customer.Email, customer.AddressLine, customer.Pincode, customer.CityId, usertype, customer.ProfilePhoto, out customerNo);
customer.CustomerNo = customerNo;
return result;
}
/// <summary>
/// Get Information About customer According Userid
/// </summary>
/// <param name="userid">User Id</param>
/// <returns>Customer</returns>
public static Customer GetCustomerInfo(int userid)
{
DataTable dt = new DataTable();
Customer _customer = new Customer();
TMSDataLibrary.Customer _customerdata = new TMSDataLibrary.Customer();
dt = _customerdata.GetCustomerInfo(userid);
if (dt.Rows.Count > 0)
{
_customer.CustomerId = (int)dt.Rows[0][CONSTS.CustomerColumnIndex.CustomerId];
_customer.UserId = (int)dt.Rows[0][CONSTS.CustomerColumnIndex.UserId];
_customer.FirstName = dt.Rows[0][CONSTS.CustomerColumnIndex.FirstName].ToString();
_customer.LastName = dt.Rows[0][CONSTS.CustomerColumnIndex.LastName].ToString();
_customer.Mobile = dt.Rows[0][CONSTS.CustomerColumnIndex.Mobile].ToString();
_customer.Email = dt.Rows[0][CONSTS.CustomerColumnIndex.Email].ToString();
_customer.AddressLine = dt.Rows[0][CONSTS.CustomerColumnIndex.AddressLine].ToString();
_customer.CityId = Convert.ToInt16(dt.Rows[0][CONSTS.CustomerColumnIndex.CityId]);
_customer.CityName = dt.Rows[0][CONSTS.CustomerColumnIndex.CityName].ToString();
_customer.Pincode = dt.Rows[0][CONSTS.CustomerColumnIndex.Pincode].ToString();
//var abc = dt.Rows[0][CONSTS.CustomerColumnIndex.ProfilePhoto].ToString();
if (dt.Rows[0][CONSTS.CustomerColumnIndex.ProfilePhoto].ToString() != "")
{
_customer.ProfilePhoto = dt.Rows[0][CONSTS.CustomerColumnIndex.ProfilePhoto].ToString();
}
if (dt.Rows[0][CONSTS.CustomerColumnIndex.CompanyName].ToString() != "")
{
_customer.CompanyName = dt.Rows[0][CONSTS.CustomerColumnIndex.CompanyName].ToString();
}
if (dt.Rows[0][CONSTS.CustomerColumnIndex.ServieTaxNo].ToString() != "")
{
_customer.ServieTaxNo = dt.Rows[0][CONSTS.CustomerColumnIndex.ServieTaxNo].ToString();
}
if (dt.Rows[0][CONSTS.CustomerColumnIndex.PanNumber].ToString() != "")
{
_customer.PanNumber = dt.Rows[0][CONSTS.CustomerColumnIndex.PanNumber].ToString();
}
if (dt.Rows[0][CONSTS.CustomerColumnIndex.Website].ToString() != "")
{
_customer.Website = dt.Rows[0][CONSTS.CustomerColumnIndex.Website].ToString();
}
if (dt.Rows[0][CONSTS.CustomerColumnIndex.EstablishYear].ToString() != "")
{
_customer.EstablishYear = dt.Rows[0][CONSTS.CustomerColumnIndex.EstablishYear].ToString();
}
if (dt.Rows[0][CONSTS.CustomerColumnIndex.UpdatedAt].ToString() != "")
{
_customer.UpdatedAt = Convert.ToDateTime(dt.Rows[0][CONSTS.CustomerColumnIndex.UpdatedAt].ToString());
}
_customer.CustomerNo = dt.Rows[0][CONSTS.CustomerColumnIndex.CustomerNo].ToString();
}
return _customer;
}
/// <summary>
/// Update customer Information To Database In Customer table
/// </summary>
/// <param name="customer">object of class customer</param>
/// <returns>Number of updated row in result</returns>
public static int UpdateCustomer(Customer customer)
{
int result;
TMSDataLibrary.Customer _objcutomer = new TMSDataLibrary.Customer();
result = _objcutomer.UpdateCustomer(customer.UserId, customer.AddressLine,
customer.Website, customer.ProfilePhoto, customer.PanNumber, customer.Pincode,
customer.EstablishYear, customer.ServieTaxNo, customer.CompanyName, customer.CityId);
return result;
}
public static DataTable GetCustomerInfo(string firstname, string moblie, string customerNo)
{
TMSDataLibrary.Customer customer = new TMSDataLibrary.Customer();
return customer.GetCustomerInfo(firstname, moblie, customerNo);
}
/// <summary>
/// Getv All Customer
/// </summary>
/// <returns>datatable of Customer</returns>
public static DataTable GetCustomerInfo()
{
TMSDataLibrary.Customer customer = new TMSDataLibrary.Customer();
return customer.GetCustomerInfo();
}
