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);
}
private void RenderList(long caseID)
{
WaiveCollection waives = Waive.Utils.GetTopWaivesByCaseID(caseID, 5);
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter writer = new HtmlTextWriter(sw))
{
writer.RenderBeginTag(HtmlTextWriterTag.Ul);
foreach (Waive waive in waives)
{
if (waive.EstOrderDate < DateTime.Now)
{
writer.AddAttribute("class", "red");
}
else if (waive.EstOrderDate >= DateTime.Now && waive.EstOrderDate < DateTime.Now.AddDays(5))
{
writer.AddAttribute("class", "yellow");
}
else
{
writer.AddAttribute("class", "green");
}
writer.RenderBeginTag(HtmlTextWriterTag.Li);
writer.AddAttribute("class", "fa fa-circle");
writer.RenderBeginTag(HtmlTextWriterTag.I);
writer.RenderEndTag();
writer.AddAttribute("class", "date");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(waive.EstOrderDate.ToShortDateString());
writer.RenderEndTag(); // Span
writer.AddAttribute("href", Urls.WaiveUrl + "?caseid=" + caseID + "&waiveid=" + waive.ID + "&pagetype=waive");
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.Write(waive.Title);
writer.RenderEndTag(); // A
writer.RenderEndTag(); // Li
}
writer.RenderEndTag(); // UL
}
litWaives.Text = sw.ToString();
}
}
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);
}