public static WaiveCollection GetTopWaivesByCaseID(Int64 CaseID, int WindowSize)
{
WaiveCollection c = new WaiveCollection();
SqlCommand cmd = new SqlCommand();
SqlParameterCollection Params = cmd.Parameters;
Params.Add(new SqlParameter("CaseID", CaseID));
Params.Add(new SqlParameter("Size", WindowSize));
DataTable dt = Execute.FillDataTable(StoredProcedures.GetTopWaivesByCaseID, Params);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Waive o = new Waive();
LoadWaiveByReader(row, o);
c.Add(o);
}
}
return(c);
}
public static WaiveCollection GetWaives(Int64 CaseID, string SearchText, Int64 ContractID, Int64 MilestoneID, Nullable <DateTime> EstOrderDateFrom, Nullable <DateTime> EstOrderDateTo)
{
WaiveCollection c = new WaiveCollection();
SqlCommand cmd = new SqlCommand();
SqlParameterCollection Params = cmd.Parameters;
Params.Add(new SqlParameter("CaseID", CaseID));
if (ContractID > 0)
{
Params.Add(new SqlParameter("ContractID", ContractID));
}
if (MilestoneID > 0)
{
Params.Add(new SqlParameter("MilestoneID", MilestoneID));
}
if (EstOrderDateFrom != null && EstOrderDateFrom > new DateTime(1755))
{
Params.Add(new SqlParameter("EstOrderDateFrom", EstOrderDateFrom));
}
if (EstOrderDateTo != null)
{
Params.Add(new SqlParameter("EstOrderDateTo", EstOrderDateTo));
}
if (SearchText != null)
{
Params.Add(new SqlParameter("SearchText", SearchText));
}
DataTable dt = Execute.FillDataTable(StoredProcedures.GetWaives, Params);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Waive o = new Waive();
LoadWaiveByReader(row, o);
c.Add(o);
}
}
return(c);
}
public static WaiveCollection GetWaivesByCaseID(Int64 CaseID, int Ammount)
{
WaiveCollection c = new WaiveCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetWaivesByCaseID, new System.Data.SqlClient.SqlParameter("CaseID", CaseID));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Waive o = new Waive();
LoadWaiveByReader(row, o);
c.Add(o);
}
}
return(c);
}