public List <IdeasAndInnovationsData> GetIdeasAndInnovationsDetails()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <IdeasAndInnovationsData>("[dbo].[getIdeasAndInnovationsDetails]").ToList();
return(QueryResult);
}
public List <RisksIssuesForProject> GetRisksAndIssuesDetails()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <RisksIssuesForProject>("[dbo].[getRisksAndIssuesDetails]").ToList();
return(QueryResult);
}
public List <PROCESS_MODEL_OBJECTIVES> GetProcessModelObjectives()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <PROCESS_MODEL_OBJECTIVES>("[dbo].[getProcessModelObjective]").ToList <PROCESS_MODEL_OBJECTIVES>();
return(QueryResult);
}
public List <ActionItemsViewDetails> GetActionItemsStatus()
{
var dbContext = new CSPDbContext();
var TemplateDetails = dbContext.Database.SqlQuery <ActionItemsViewDetails>("[dbo].[getActionItemsViewDetails]").ToList();
return(TemplateDetails);
}
public List <PROCESS_MODEL> GetScopeOfAudit()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <PROCESS_MODEL>("[dbo].[getAuditScope]").ToList <PROCESS_MODEL>();
return(QueryResult);
}
public IEnumerable <CRISP_CATEGORY_RAG_SUMMARY> getCrispCategoryRagSummary()
{
var dbContext = new CSPDbContext();
var TemplateDetails = dbContext.Database.SqlQuery <CRISP_CATEGORY_RAG_SUMMARY>("[dbo].[get_CRISP_category_RAG_summary]").ToList();
return(TemplateDetails);
}
public List <CustomerProjectData> GetCustomerProjectDetails()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <CustomerProjectData>("[dbo].[getCustomerProjectDetails]").ToList <CustomerProjectData>();
return(QueryResult);
}
public IEnumerable <ChartDataMonthly> GetChartDetails(string DateField, string xAxis, string yAxis, string Level1, string Level2, string xAxisType, string frequency, int reportId, DateTime startDate, DateTime endDate, string filtersXml)
{
if (Level1 == null)
{
Level1 = string.Empty;
}
if (Level2 == null)
{
Level2 = string.Empty;
}
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@DATE_FIELD_NAME", DateField);
SqlParameter param2 = new SqlParameter("@XAXIS_FIELD_NAME", xAxis);
SqlParameter param3 = new SqlParameter("@YAXIS_FIELD_NAME", yAxis);
SqlParameter param4 = new SqlParameter("@LEVEL1_FIELD_NAME", Level1);
SqlParameter param5 = new SqlParameter("@LEVEL2_FIELD_NAME", Level2);
SqlParameter param6 = new SqlParameter("@XAXIS_FIELD_TYPE", xAxisType);
SqlParameter param7 = new SqlParameter("@FREQUENCY", frequency);
SqlParameter param8 = new SqlParameter("@REPORTID", reportId);
SqlParameter param9 = new SqlParameter("@STARTDATE", startDate.ToString("dd-MMM-yyy") + " 00:00");
SqlParameter param10 = new SqlParameter("@ENDDATE", endDate.ToString("dd-MMM-yyy") + " 23:59");
SqlParameter param11 = new SqlParameter("@FILTERSXML", filtersXml);
dbContext.Database.CommandTimeout = 360;
var QueryResult = dbContext.Database.SqlQuery <ChartDataMonthly>("[dbo].[usp_get_sqa_chartdetails] @DATE_FIELD_NAME, @XAXIS_FIELD_NAME, @YAXIS_FIELD_NAME, @LEVEL1_FIELD_NAME, @LEVEL2_FIELD_NAME, @XAXIS_FIELD_TYPE, @FREQUENCY, @REPORTID, @STARTDATE, @ENDDATE, @FILTERSXML ", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11).ToList();
return(QueryResult);
}
public List <PROCESS_MODEL> GetProcessModel()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <PROCESS_MODEL>("[dbo].[getProcessModel]").ToList <PROCESS_MODEL>();
return(QueryResult);
}
public IEnumerable <CSAT_INITIATED_SUMMARY> getCSSInitiatedSummary()
{
var dbContext = new CSPDbContext();
var TemplateDetails = dbContext.Database.SqlQuery <CSAT_INITIATED_SUMMARY>("[dbo].[getCSS_initiated_summary]").ToList();
return(TemplateDetails);
}
public List <OverAllData> GetOverAllRisksData()
{
var dbContext = new CSPDbContext();
var TemplateDetails = dbContext.Database.SqlQuery <OverAllData>("[dbo].[getOverAllRisksData]").ToList();
return(TemplateDetails);
}
public List <PERSPECTIVE_LIST> GetGlobalCategory()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <PERSPECTIVE_LIST>("[dbo].[getGlobalCategory]").ToList();
return(QueryResult);
}
public IEnumerable <CustomerProjects> CustomerProjects()
{
var dbContext = new CSPDbContext();
var TemplateDetails = dbContext.Database.SqlQuery <CustomerProjects>("[dbo].[usp_get_CustomerProjects]").ToList();
return(TemplateDetails);
}
public void DeleteAccessControls(string Ids, string Delimiter)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@Ids", Ids);
SqlParameter param2 = new SqlParameter("@Delimiter", Delimiter);
var QueryResult = dbContext.Database.SqlQuery <string>("[dbo].[usp_delete_AccessControls] @Ids, @Delimiter ", param1, param2).ToList();
}
public IEnumerable <CSAT_RECEIVED_SUMMARY> getCSSReceivedSummary()
{
var dbContext = new CSPDbContext();
var TemplateDetails = dbContext.Database.SqlQuery <CSAT_RECEIVED_SUMMARY>("[dbo].[getCSS_received_summary]").ToList();
return(TemplateDetails);
}
public List <ProjectStatusViewDetails> GetProjectStartAndEndDateForViewDetails()
{
var dbContext = new CSPDbContext();
var projectstatus = dbContext.Database.SqlQuery <ProjectStatusViewDetails>("[dbo].[getProjectStartAndEndDateForViewDetails]").ToList();
return(projectstatus);
}
public List <PARAMETER_TABLE> GetStatusOfAudit()
{
var dbContext = new CSPDbContext();
var QueryResult = dbContext.Database.SqlQuery <PARAMETER_TABLE>("[dbo].[getAuditStatus]").ToList <PARAMETER_TABLE>();
return(QueryResult);
}
public List <KPI> GetTotalKPIMonthCount(DateTime month)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@MONTH", month);
var QueryResult = dbContext.Database.SqlQuery <KPI>("[dbo].[sp_gettotalKPICountMonth] @MONTH", param1).ToList();
return(QueryResult);
}
public List <AUDIT_PROCESS_TESTS> GetAuditProcessTests(int ProcessModelId)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@PROCESS_MODEL_ID", ProcessModelId);
var QueryResult = dbContext.Database.SqlQuery <AUDIT_PROCESS_TESTS>("[dbo].[sp_getTestsForProcessModel] @PROCESS_MODEL_ID", param1).ToList();
return(QueryResult);
}
public List <ProcessDetails> GetProcessByServiceArea(int ServiceAreaId)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@SERVICE_AREA_ID", ServiceAreaId);
var QueryResult = dbContext.Database.SqlQuery <ProcessDetails>("[dbo].[getProcessByServiceArea] @SERVICE_AREA_ID ", param1).ToList <ProcessDetails>();
return(QueryResult);
}
public List <PROCESS_SERVICE_AREA> GetServiceAreaForModel(string processModelId)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@PROCESS_MODEL_ID", processModelId);
var QueryResult = dbContext.Database.SqlQuery <PROCESS_SERVICE_AREA>("[dbo].[getServiceAreaForModel] @PROCESS_MODEL_ID", param1).ToList <PROCESS_SERVICE_AREA>();
return(QueryResult);
}
public List <PROCESS_MODEL_OBJECTIVES_NEW> GetObjectivesFromServiceAreaId(int ServiceAreaId)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@id", ServiceAreaId);
var QueryResult = dbContext.Database.SqlQuery <PROCESS_MODEL_OBJECTIVES_NEW>("[dbo].[getObjectivesFromServiceAreaId] @id", param1).ToList <PROCESS_MODEL_OBJECTIVES_NEW>();
return(QueryResult);
}
public List <INSIGHTS_FILTER> GetReportCondition(string ReportType)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@ReportType", ReportType);
var QueryResult = dbContext.Database.SqlQuery <INSIGHTS_FILTER>("[dbo].[getreportconditions] @ReportType", param1).ToList <INSIGHTS_FILTER>();
return(QueryResult);
}
public IEnumerable <CUSTOMER_PROJECT_PORTFOLIO> GetCustomerProjectDetailsByCustomerEmailId(string EmailId)
{
var context = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@EMAILID", EmailId);
var staffSummaryDetails = context.Database.SqlQuery <CUSTOMER_PROJECT_PORTFOLIO>("[dbo].[getCustomerProjectDetailsByCustomerEmailId] @EMAILID", param1).ToList();
return(staffSummaryDetails);
}
public IEnumerable <CSAT_SURVEY_DATA> getCSSResponseSummary(int Year)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@YEAR", Year);
var TemplateDetails = dbContext.Database.SqlQuery <CSAT_SURVEY_DATA>("[dbo].[getCSSResponseSummary] @YEAR ", param1).ToList();
return(TemplateDetails);
}
public IEnumerable <PROJECT_CSAT_DATA> GetCSSTable(string YearQuarter)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@YEAR_QUARTER", YearQuarter);
var TemplateDetails = dbContext.Database.SqlQuery <PROJECT_CSAT_DATA>("[dbo].[getCSSTable] @YEAR_QUARTER ", param1).ToList();
return(TemplateDetails);
}
public IEnumerable <CUSTOMER_PROJECT_PORTFOLIO> getCustomerProjectPorfolioList()
{
var dbContext = new CSPDbContext();
// SqlParameter param1 = new SqlParameter("@custid", CustomerId);
var TemplateDetails = dbContext.Database.SqlQuery <CUSTOMER_PROJECT_PORTFOLIO>("[dbo].[getCustomerProjectPortfolioList]").ToList();
return(TemplateDetails);
}
public List <AUDIT_CHECKLIST_PROJECT_EXECUTION_EXTENDED> GetChecklistAudit(int CustomerId, string ProjectId)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@CUSTOMER_ID", CustomerId);
SqlParameter param2 = new SqlParameter("@PROJECT_ID", ProjectId);
var QueryResult = dbContext.Database.SqlQuery <AUDIT_CHECKLIST_PROJECT_EXECUTION_EXTENDED>("[dbo].[getCheckPointsforProject] @CUSTOMER_ID ,@PROJECT_ID ", param1, param2).ToList();
return(QueryResult);
}
public List <AUDIT_CONTROL_TEST_COUNT> GetAuditControlandTestCountReport(string ProjectId, DateTime month)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@PROJECT_ID", ProjectId);
SqlParameter param2 = new SqlParameter("@AUDIT_START_DATE", month);
var QueryResult = dbContext.Database.SqlQuery <AUDIT_CONTROL_TEST_COUNT>("[dbo].[getAuditControlandTestCountReport] @PROJECT_ID ,@AUDIT_START_DATE", param1, param2).ToList();
return(QueryResult);
}
public List <AUDIT_EXECUTION_REPORT> GetAuditExecutionReport(string ProjectId, DateTime month)
{
var dbContext = new CSPDbContext();
SqlParameter param1 = new SqlParameter("@PROJECT_ID", ProjectId);
SqlParameter param2 = new SqlParameter("@START_DATE", month);
var QueryResult = dbContext.Database.SqlQuery <AUDIT_EXECUTION_REPORT>("[dbo].[getAuditReportExecution] @PROJECT_ID ,@START_DATE", param1, param2).ToList();
return(QueryResult);
}