public SalesPersonQuotaHistoryCollection GetAllSalesPersonQuotaHistorysDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
SalesPersonQuotaHistoryCollection cols = new SalesPersonQuotaHistoryCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesPersonQuotaHistorysDynamic");
while (reader.Read())
{
SalesPersonQuotaHistory SPQH = new SalesPersonQuotaHistory();
SPQH.SalesPersonID = Int32.Parse(reader["SalesPersonID"].ToString());
SPQH.QuotaDate = DateTime.Parse(reader["QuotaDate"].ToString());
SPQH.SalesQuota = Decimal.Parse(reader["SalesQuota"].ToString());
SPQH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());;
cols.Add(SPQH);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSalesPersonQuotaHistorysDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public SalesPersonQuotaHistoryCollection GetAllSalesPersonQuotaHistorysCollection()
{
IDBManager dbm = new DBManager();
SalesPersonQuotaHistoryCollection cols = new SalesPersonQuotaHistoryCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesPersonQuotaHistoryAll");
while (reader.Read())
{
SalesPersonQuotaHistory SPQH = new SalesPersonQuotaHistory();
SPQH.SalesPersonID = Int32.Parse(reader["SalesPersonID"].ToString());
SPQH.QuotaDate = DateTime.Parse(reader["QuotaDate"].ToString());
SPQH.SalesQuota = decimal.Parse(reader["SalesQuota"].ToString());
SPQH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SPQH);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSalesPersonQuotaHistorysCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}