/// <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;
}
}
