public static DataSet GetSessionLengthByCamp(int CampYearID, DataTable dtFedId, DataTable dtCampId, DataTable dtStatusId, int TimesReceivedGrant)
{
var db = new SQLDBAccess("CIPMS");
db.AddParameter("@Action", "SessionLengthByCamp");
db.AddParameter("@CampYearID", CampYearID);
db.AddParameterWithValue("@FedIdTable", dtFedId);
db.AddParameterWithValue("@CampIdTable", dtCampId);
db.AddParameterWithValue("@StatusIdTable", dtStatusId);
db.AddParameter("@TimesReceivedGrant", TimesReceivedGrant);
return(db.FillDataSet("usprsCamperApplications_Select"));
}
public static DataTable GetReport(int campYearId, int fedId, IList <int> campIdList, bool isFinal)
{
var db = new SQLDBAccess("CIPMS");
var spName = "usp_PaymentProcessingSelfFuncingPreliminary";
if (isFinal)
{
spName = "usp_PaymentProcessingSelfFuncingFinalMode";
db.AddParameter("@UserID", HttpContext.Current.Session["UserID"]);
}
db.AddParameter("@CampYearID", campYearId);
db.AddParameter("@FedID", fedId);
var dt = new DataTable();
dt.Columns.Add("CampID");
foreach (var id in campIdList)
{
var row = dt.NewRow();
row["CampID"] = id;
dt.Rows.Add(row);
}
db.AddParameterWithValue("@CampIDList", dt);
return(db.FillDataTable(spName));
}
