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