public DataSet GetDataSet(bool IsStoredProcedure, string sql)
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
if (IsStoredProcedure)
{
ds = dbm.GetDataSet(CommandType.StoredProcedure, sql);
}
else
{
ds = dbm.GetDataSet(CommandType.Text, sql);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetDataSet()");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(ds);
}
public DataSet GetAllSpecialOffersDynamicDataSet(string whereCondition, string orderBy)
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereCondition);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectSpecialOffersDynamic");
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSpecialOffersDynamicDataSet()");
throw (ex);;
}
finally
{
dbm.Dispose();
}
return(ds);
}
public DataSet GetAllLocationDataSet()
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectLocationsAll");
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllLocationDataSet()");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(ds);
}
public DataSet GetAllSalesTerritoryHistorysViewDataSet()
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
ds = dbm.GetDataSet(CommandType.StoredProcedure, "ViewSalesTerritoryList");
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSalesTerritoryHistorysViewDataSet()");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(ds);
}
public DataSet GetAllVendorsByNameDataSet(string name)
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
dbm.CreateParameters(1);
dbm.AddParameters(0, "@Name", name);
ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectVendorByName");
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllVendorsDataSet()");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(ds);
}
public DataSet GetAllPaymentDataSet(int PaymentID)
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
dbm.CreateParameters(1);
dbm.AddParameters(0, "@PaymentID", PaymentID);
ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectPaymentByOrderID");
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllPaymentDataSet()");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(ds);
}
public DataSet GetAllProductAdjustmentHistoryDataSet(int purchaseAdjustedQuantity)
{
IDBManager dbm = new DBManager();
DataSet ds = new DataSet();
try
{
dbm.CreateParameters(1);
dbm.AddParameters(0, "@ProductID", purchaseAdjustedQuantity);
ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectProductAdjustmentHistoryByAdjustedQuantity");
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllProductAdjustmentHistoryDataSet()");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(ds);
}
