/// <summary> /// Return supplier related expenses by date range and supplier id /// </summary> /// <param name="searchCriteria">Set FromDate, ToDate and SuppleirId</param> /// <returns></returns> public DataSet SelectSupplierRelatedExpences(SupplierSearch searchCriteria) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Suppliers_Report_SuppliersTransctionsById); db.AddInParameter(dbCommand, "@nSupplierId", DbType.String, searchCriteria.Sup_Id); db.AddInParameter(dbCommand, "@dFromDate", DbType.DateTime, searchCriteria.FromDate); db.AddInParameter(dbCommand, "@dToDate", DbType.DateTime, searchCriteria.ToDate); return(db.ExecuteDataSet(dbCommand)); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet SelectSupplierRelatedExpences(SupplierSearch searchCriteria)"); return(null); throw ex; } }
public DataSet SearchSuppliers(SupplierSearch supplierSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Supplier_Search); db.AddInParameter(dbCommand, "@sSup_Code", DbType.String, supplierSearch.Sup_Code); db.AddInParameter(dbCommand, "@sSupplierName", DbType.String, supplierSearch.SupplierName); db.AddInParameter(dbCommand, "@iOption", DbType.Int32, supplierSearch.Option); return(db.ExecuteDataSet(dbCommand)); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddItems(Item item)"); return(null); throw ex; } }
/// <summary> /// Return supplier related expenses by date range and supplier id /// </summary> /// <param name="searchCriteria">Set FromDate, ToDate and SuppleirId</param> /// <returns></returns> public DataSet SelectSupplierRelatedExpences(SupplierSearch searchCriteria) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Suppliers_Report_SuppliersTransctionsById); db.AddInParameter(dbCommand, "@nSupplierId", DbType.String, searchCriteria.Sup_Id); db.AddInParameter(dbCommand, "@dFromDate", DbType.DateTime, searchCriteria.FromDate); db.AddInParameter(dbCommand, "@dToDate", DbType.DateTime, searchCriteria.ToDate); return db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet SelectSupplierRelatedExpences(SupplierSearch searchCriteria)"); return null; throw ex; } }
public DataSet SearchSuppliers(SupplierSearch supplierSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Supplier_Search); db.AddInParameter(dbCommand, "@sSup_Code", DbType.String, supplierSearch.Sup_Code); db.AddInParameter(dbCommand, "@sSupplierName", DbType.String, supplierSearch.SupplierName); db.AddInParameter(dbCommand, "@iOption", DbType.Int32, supplierSearch.Option); return db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddItems(Item item)"); return null; throw ex; } }