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