public IHttpActionResult GetAllTemplates()
{
ReviewTemplate student = null;
List <ReviewTemplate> studentInfo = new List <ReviewTemplate>();
try
{
//Querying with LINQ to Entities
using (var context = new qmEntities())
{
var query = context.GetAllTemplates().ToList();
foreach (var item in query)
{
student = new ReviewTemplate();
student.TemplateId = item.templateid;
student.Templatedesc = item.templatedesc;
studentInfo.Add(student);
}
return(Ok(studentInfo));
}
}
catch (Exception ex)
{
return(Ok(ex.InnerException.ToString()));
throw ex;
}
}
public IHttpActionResult GetCSVList()
{
ReportGeneratedBO student = null;
List <ReportGeneratedBO> ReportGeneratedBOList = new List <ReportGeneratedBO>();
try
{
//Querying with LINQ to Entities
using (var context = new qmEntities())
{
var query = context.GetReportcsvList();
foreach (var item in query)
{
student = new ReportGeneratedBO
{
CreatedBy = item.CreatedBy,
CreatedOn = item.CreatedOn,
MethodofCreation = item.MethodofCreation,
ReportGeneratedFileName = item.ReportGeneratedFileName,
ReportGeneratedFullPath = item.ReportGeneratedFullPath,
ReportLocation = item.ReportLocation
};
ReportGeneratedBOList.Add(student);
}
}
}
catch (Exception ex)
{
return(Ok(ex.InnerException.ToString()));
throw ex;
}
return(Ok(ReportGeneratedBOList));
}
public IHttpActionResult GetAllWorkGroups()
{
WorkGroup student = null;
List <WorkGroup> studentInfo = new List <WorkGroup>();
try
{
//Querying with LINQ to Entities
using (var context = new qmEntities())
{
var query = context.GetAllWorkGroups().ToList();
foreach (var item in query)
{
student = new WorkGroup();
student.WorkGroupId = item.workgroupid;
student.WorkGroupName = item.workgroupname;
studentInfo.Add(student);
}
return(Ok(studentInfo));
}
}
catch (Exception ex)
{
return(Ok(ex.InnerException.ToString()));
throw ex;
}
}
public IHttpActionResult GetCustomerServiceDetails(ReportModel reportModel)
{
WorkGroupReportBO student = null;
List <WorkGroupReportBO> WorkGroupReportBOList = new List <WorkGroupReportBO>();
try
{
using (var context = new qmEntities())
{
context.Configuration.AutoDetectChangesEnabled = false;
context.SetCommandTimeOut(10000);
var query = context.GetReport(reportModel.StartDate, reportModel.EndDate, reportModel.WorkGroupID, reportModel.TemplateID).ToList();
foreach (var item in query)
{
student = new WorkGroupReportBO
{
mediaid = item.mediaid,
starttime = item.starttime,
endtime = item.endtime,
dnis = item.dnis,
ani = item.ani,
updateuserid = item.updateuserid,
percentscore = item.percentscore,
reviewdate = item.reviewdate,
username = item.username,
userroleid = item.userroleid,
usertypeid = item.usertypeid,
workgroupname = item.workgroupname,
description = item.description,
name = item.name,
sequencenumber = item.sequencenumber,
questiondescription = item.questiondescription,
questionnumber = item.questionnumber,
questiontext = item.questiontext,
responserequired = item.responserequired,
questionadditionalpoint = item.questionadditionalpoint,
questionadditionalconditionpoint = item.questionadditionalconditionpoint,
weightedscore = item.weightedscore,
sectionWeight = item.sectionWeight,
responsetext = item.responsetext,
questionWeight = item.questionWeight,
questiontypedesc = item.questiontypedesc,
questionScored = item.questionScored,
reviewTemplate = item.reviewTemplate,
ScorecardStatus = item.ScorecardStatus
};
WorkGroupReportBOList.Add(student);
}
if (WorkGroupReportBOList.Count > 0)
{
CreateCSV(WorkGroupReportBOList);
ReportGeneratedBO rgBO = new ReportGeneratedBO()
{
CreatedBy = "User",
//CreatedOn = DateTime.Today,
MethodofCreation = "Manually",
ReportGeneratedFileName = filename,
ReportGeneratedFullPath = locationAndFile,
ReportLocation = location
};
var insertQuery = context.InsertReport(rgBO.ReportGeneratedFileName, DateTime.Now, rgBO.CreatedBy, rgBO.MethodofCreation, rgBO.ReportGeneratedFullPath, rgBO.ReportLocation);
return(Ok(WorkGroupReportBOList));
}
}
}
catch (Exception ex)
{
return(Ok(ex.ToString()));
throw ex;
}
return(Ok(WorkGroupReportBOList));
}
