public string EditCustomer(CustomerSearchProperties csp)
{
try
{
// cmd.Parameters.Add(new SqlParameter{SqlValue=username ?? (object)DBNull.Value,ParameterName="usuario" } );
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@custfname", csp.CustomerFName));
param.Add(new SqlParameter("@custlname", csp.CustomerLName));
param.Add(new SqlParameter("@customerphone", csp.CustPhoneNumber));
param.Add(new SqlParameter("@billaddress", csp.Billing_Address));
param.Add(new SqlParameter("@delivaddress", csp.Delivery_Addresss));
param.Add(new SqlParameter("@landmark", csp.Land_Mark));
param.Add(new SqlParameter("@mobile1", csp.Mobile1));
// param.Add(new SqlParameter(SqlValue
param.Add(new SqlParameter("@mobile2", csp.Mobile2));
param.Add(new SqlParameter("@custtypeid", csp.CustomerTypeId));
param.Add(new SqlParameter("@delivloclati", csp.DeliveryLocationLatitude));
param.Add(new SqlParameter("@delivloclong", csp.DeliveryLocationLongitude));
return(_objdal.fnAdddata("updateCustomer", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable getCustData(CustomerSearchProperties csp)
{
DataTable dt = new DataTable();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@customerphone", csp.CustPhoneNumber));
return(_objdal.SearchData("searchCustomerByPhone", param.ToArray()));
}
//public DataTable getCustomer()
//{
// SqlCommand cmd = new SqlCommand();
// return _objdal.SearchData("searchCustomerByPhone", null);
//}
public DataTable getCustomer(CustomerSearchProperties csp)
{
DataTable dt = new DataTable();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@customerdata", csp.CustomerFName));
return(_objdal.SearchData("searchBycustPhoneAndName", param.ToArray()));
}
public string AddNewCustomer(CustomerSearchProperties csp)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@custfname", csp.CustomerFName));
param.Add(new SqlParameter("@custlname", csp.CustomerLName));
param.Add(new SqlParameter("@customerphone", csp.CustPhoneNumber));
param.Add(new SqlParameter("@billaddress", csp.Billing_Address));
param.Add(new SqlParameter("@delivaddress", csp.Delivery_Addresss));
param.Add(new SqlParameter("@landmark", csp.Land_Mark));
param.Add(new SqlParameter("@mobile1", csp.Mobile1));
param.Add(new SqlParameter("@mobile2", csp.Mobile2));
param.Add(new SqlParameter("@custtypeid", csp.CustomerTypeId));
param.Add(new SqlParameter("@delivloclati", csp.DeliveryLocationLatitude));
param.Add(new SqlParameter("@delivloclong", csp.DeliveryLocationLongitude));
return(_objdal.fnAdddata("insertNewCustomer", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}