public static DataSet GetFederationAndQuestionnaireDetails(string strFederationIds) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@FederationIds", strFederationIds); return(db.FillDataSet("usp_GetFederationAndQuestionnaireDetails")); }
public static DataSet GetFJCAllocationData(int CampYearID) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "GetFJCAllocation"); db.AddParameter("@CampYearID", CampYearID); return(db.FillDataSet("usprsCamperApplications_Select")); }
public static string GetGradeEligibilityRange(int FederationID) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@FederationIds", FederationID.ToString()); DataSet ds = db.FillDataSet("usp_GetFederationAndQuestionnaireDetails"); return(ds.Tables[0].Rows[0][0].ToString()); }
public static DataSet GetAllByFedID(int CampYearID, int FedID) { var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "ByFedIdAndYearId"); db.AddParameter("@CampYearID", CampYearID); db.AddParameter("@FedID", FedID); return(db.FillDataSet("usp_FedCampGrant")); }
public static DataSet GetSchoolTypeReport(int CampYearID, int FedID) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "SchoolTypeReport"); db.AddParameter("@CampYearID", CampYearID); db.AddParameter("@FedID", FedID); return(db.FillDataSet("usprsCamperAnswer_Select")); }
public static DataSet GetCamperTimesInCampCountByState(int CampYearID, string FedID_List, string StatusName_List, int TimesReceivedGrant) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "CamperTimesInCampCountByState"); db.AddParameter("@CampYearID", CampYearID); db.AddParameter("@FedID_List", FedID_List); db.AddParameter("@StatusName_List", StatusName_List); db.AddParameter("@TimesReceivedGrant", TimesReceivedGrant); return(db.FillDataSet("usprsCamperApplications_Select")); }
public static DataSet GetSummparyByProgramReports(string campYearIDs, DateTime cutoffDate, string fedIDs, string statusNames, bool hasManualData) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "GetFJCCamperReportPerCamp"); db.AddParameter("@CampYearID_List", campYearIDs); db.AddParameter("@CutoffDate", cutoffDate.ToString("MM/dd/yyyy")); db.AddParameter("@FedID_List", fedIDs); db.AddParameter("@StatusName_List", statusNames); db.AddParameter("@hasManualStatus", hasManualData); return(db.FillDataSet("usprsApplicationChangeHistory_Select")); }
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")); }
// 2016-04-09 This action block should be deleted because next block is a rewrite using table parameter public static DataSet GetCamperSummaryReportByCamp(int CampYearID, string FedID_List, string CampID_List, string StatusID_List, int TimesReceivedGrant) { var db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "GetCamperSummaryReportByCamp"); db.AddParameter("@CampYearID", CampYearID); db.AddParameter("@FedID_List", FedID_List); db.AddParameter("@CampID_List", CampID_List); db.AddParameter("@StatusID_List", StatusID_List); db.AddParameter("@TimesReceivedGrant", TimesReceivedGrant); return(db.FillDataSet("usprsCamperApplications_Select")); }
public static bool AuthenticateAndGetUserProfile(string EmailID, string Password, out DataSet dsRetLogin) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@EmailID", EmailID); db.AddParameter("@Password", Password); DataSet dsLogin = db.FillDataSet("usp_ValidateLogin"); dsRetLogin = dsLogin; return(dsLogin.Tables[0].Rows.Count > 0 ? true : false); }
public static DataSet GetParentCountryOfOrigin(int CampYearID, string FedID_List, string CampID_List, string StatusID_List, string CountryID_List, int TimesReceivedGrant) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "GetParentCountry"); db.AddParameter("@CampYearID", CampYearID); db.AddParameter("@FedID_List", FedID_List); db.AddParameter("@CampID_List", CampID_List); db.AddParameter("@StatusID_List", StatusID_List); db.AddParameter("@CountryID_List", CountryID_List); db.AddParameter("@TimesReceivedGrant", TimesReceivedGrant); return(db.FillDataSet("usprsCamperAnswer_Select")); }
public static DataSet getAllFederations() { SQLDBAccess db = new SQLDBAccess("CIPMS"); return(db.FillDataSet("usp_GetAllFederations")); }