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