public static int UpdateCustomer(int customerMobileNumber, string customerEmail)
{
StoredProcedureParameterList.Clear();
StoredProcedureName = ConfigurationManager.AppSettings.Get("UpdateCustomerSP");
StoredProcedureParameterList.Add(new SqlParameter("@CustomerMobileNumber", customerMobileNumber));
StoredProcedureParameterList.Add(new SqlParameter("@CustomerEmailAddress", customerEmail));
return(DBInteraction.ExecuteNonSelect(StoredProcedureName, StoredProcedureParameterList));
}
public static int RecordBillPaymentForCustomer(int customerMobileNumber, string billPaymentMode, decimal billAmount)
{
StoredProcedureParameterList.Clear();
StoredProcedureName = ConfigurationManager.AppSettings.Get("RecordBillPaymentForCustomerSP");
StoredProcedureParameterList.Add(new SqlParameter("@CustomerMobileNumber", customerMobileNumber));
StoredProcedureParameterList.Add(new SqlParameter("@BillPaymentMode", billPaymentMode));
StoredProcedureParameterList.Add(new SqlParameter("@BillAmount", billAmount));
return(DBInteraction.ExecuteNonSelect(StoredProcedureName, StoredProcedureParameterList));
}
public static int AddCutomer(int customerMobileNumber, string customerName, string customerEmail, int employeeId, string customerIdentity)
{
StoredProcedureParameterList.Clear();
StoredProcedureName = ConfigurationManager.AppSettings.Get("AddCustomerSP");
StoredProcedureParameterList.Add(new SqlParameter("@CustomerMobileNumber", customerMobileNumber));
StoredProcedureParameterList.Add(new SqlParameter("@CustomerName", customerName));
StoredProcedureParameterList.Add(new SqlParameter("@CustomerEmailAddress", customerEmail));
StoredProcedureParameterList.Add(new SqlParameter("@CustomersEmployeeId", employeeId));
StoredProcedureParameterList.Add(new SqlParameter("@CustomersIdentity", customerIdentity));
return(DBInteraction.ExecuteNonSelect(StoredProcedureName, StoredProcedureParameterList));
}