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