public DataSet GetTransactionHistoryByCustomer(CustomerSearch custSearch) { DataSet ds; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Customers_Report_TransactionsAll); db.AddInParameter(cmd, "@iCustomerID", DbType.Int32, custSearch.CustId); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return(ds); }
public DataSet SearchCustomers(CustomerSearch customerSearch) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Customers_Search); db.AddInParameter(cmd, "@sCustomerCode", DbType.String, customerSearch.CustomerCode); db.AddInParameter(cmd, "@sCus_Name", DbType.String, customerSearch.Cus_Name); db.AddInParameter(cmd, "@iIsActiveOption", DbType.Int32, customerSearch.IsActiveOption); db.AddInParameter(cmd, "@iIsCreditCustomerOption", DbType.Int32, customerSearch.IsCreditCustomerOption); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return(ds); }
public DataSet SearchCustomers(CustomerSearch customerSearch) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Customers_Search); db.AddInParameter(cmd, "@sCustomerCode", DbType.String, customerSearch.CustomerCode); db.AddInParameter(cmd, "@sCus_Name", DbType.String, customerSearch.Cus_Name); db.AddInParameter(cmd, "@iIsActiveOption", DbType.Int32, customerSearch.IsActiveOption); db.AddInParameter(cmd, "@iIsCreditCustomerOption", DbType.Int32, customerSearch.IsCreditCustomerOption); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }
public DataSet GetTransactionHistoryByCustomer(CustomerSearch custSearch) { DataSet ds; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Customers_Report_TransactionsAll); db.AddInParameter(cmd, "@iCustomerID", DbType.Int32, custSearch.CustId); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }