public List <Dictionary <string, object> > GetSiteMonthlySummary(string start, string end)
{
string procName = "wfmpcp_GetSiteMonthlyHiringPlan_sp";
string[] parameters = { "Start", "End" };
object[] inputParams = { start, end };
return(_context.Read(procName, parameters, inputParams));
}
public List <Dictionary <string, object> > Read(long?lobID, string start = "", string end = "", int includeDatapoint = 0,
string tablename = "WeeklyAHDatapoint", string segmentCategoryID = "", string segmentID = "",
string siteID = "", string campaignID = "")
{
string lobid = "";
if (lobID > 0)
{
lobid = lobID.ToString();
}
if (tablename == "WeeklyStaffDatapoint")
{
string procName = "wfmpcp_GetStaffPlanner_sp";
string[] parameters = { "lobid", "start", "end", "includeDatapoint", "segmentid", "siteID", "campaignID" };
object[] inputParams = { lobid, start, end, includeDatapoint, segmentID, siteID, campaignID };
return(_context.Read(procName, parameters, inputParams));
}
else if (tablename == "WeeklyHiringDatapoint")
{
string procName = "wfmpcp_GetHiringRequirements_sp";
string[] parameters = { "campaignID", "start", "end", "includeDatapoint", "siteID" };
object[] inputParams = { campaignID, start, end, includeDatapoint, siteID };
return(_context.Read(procName, parameters, inputParams));
}
else if (tablename == "WeeklyHiringDatapointTotal")
{
string procName = "wfmpcp_GetHiringRequirementsTotal_sp";
string[] parameters = { "campaignID", "start", "end", "includeDatapoint", "siteID" };
object[] inputParams = { campaignID, start, end, includeDatapoint, siteID };
return(_context.Read(procName, parameters, inputParams));
}
else if (tablename == "WeeklySummaryDatapoint")
{
string procName = "wfmpcp_GetSummary1_sp";
string[] parameters = { "campaignID", "start", "end", "includeDatapoint", "siteID", "lobid" };
object[] inputParams = { campaignID, start, end, includeDatapoint, siteID, lobid };
return(_context.Read(procName, parameters, inputParams));
}
else
{
string procName = "wfmpcp_GetAssumptionsHeadcount_sp";
string[] parameters = { "lobid", "start", "end", "includeDatapoint", "tablename", "segmentcategoryid", "segmentid", "siteID", "campaignID" };
object[] inputParams = { lobid, start, end, includeDatapoint, tablename, segmentCategoryID, segmentID, siteID, campaignID };
return(_context.Read(procName, parameters, inputParams));
}
}