public void ExportScreeningFollowupReport(ScreeningFollowupReport followupReport, int reportFormatType) { try { followupReport.RequestedPage = 0; followupReport.PageSize = 0; followupReport.SkipRows = followupReport.GetSkipRows(); followupReport.SortColumn = "Classroom"; followupReport.SortOrder = "ASC"; followupReport = screeningData.GetScreeningFollowupReport(staff, followupReport); #region Itextsharp PDF generation Region string imagePath = Server.MapPath("~/Images/"); var reportTypeEnum = FingerprintsModel.EnumHelper.GetEnumByStringValue <FingerprintsModel.Enums.ReportFormatType>(reportFormatType.ToString()); MemoryStream workStream = Fingerprints.Common.FactoryInstance.Instance.CreateInstance <Export>().ExportScreeningFollowupReport(followupReport, reportTypeEnum, imagePath); string reportName = "Screening Follow-up Report"; DownloadReport(workStream, reportTypeEnum, reportName); #endregion } catch (Exception ex) { clsError.WriteException(ex); } }
public ScreeningFollowupReport GetScreeningFollowup(ScreeningFollowupReport report) { report.SkipRows = report.GetSkipRows(); report = screeningData.GetScreeningFollowupReport(staff, report); return(report); }
public ActionResult ScreeningFollowupReport() { ScreeningFollowupReport report = FactoryInstance.Instance.CreateInstance <ScreeningFollowupReport>(); report.ScreeningList = screeningData.GetScreeningsByUserAccess(staff); return(View(report)); }
public ScreeningFollowupReport GetScreeningFollowupReport(StaffDetails staff, ScreeningFollowupReport modal) { try { modal.ScreeningFollowupList = new List<ScreeningFollowup>(); var centerIDs = string.Join(",", modal.CenterIDs.Select(x => EncryptDecrypt.Decrypt64(x))); var screeningIDs = string.Join(",", modal.ScreeningIDs.Select(x => EncryptDecrypt.Decrypt64(x))); var classroomIDs = modal.ClassroomIDs!=null && modal.ClassroomIDs.Length > 0 ? string.Join(",", modal.ClassroomIDs.Select(x => x!="0"? EncryptDecrypt.Decrypt64(x):x)) : "0"; var parameters = new IDbDataParameter[] { dbManager.CreateParameter("@AgencyID",staff.AgencyId,DbType.Guid), dbManager.CreateParameter("@RoleID",staff.RoleId,DbType.Guid), dbManager.CreateParameter("@UserID",staff.UserId,DbType.Guid), dbManager.CreateParameter("@CenterIDs",centerIDs,DbType.AnsiString), dbManager.CreateParameter("@ClassroomIDs",classroomIDs,DbType.AnsiString), dbManager.CreateParameter("@ScreeningIDs", screeningIDs, DbType.AnsiString), dbManager.CreateParameter("@Take",modal.PageSize,DbType.Int32), dbManager.CreateParameter("@Skip",modal.SkipRows,DbType.Int32), dbManager.CreateParameter("@SortOrder",modal.SortOrder,DbType.String), dbManager.CreateParameter("@SortColumn",modal.SortColumn,DbType.String), dbManager.CreateParameter("@SearchTerm",modal.SearchTerm,DbType.String), dbManager.CreateParameter("@TotalRecord",int.MaxValue,0,DbType.Int32,ParameterDirection.Output) }; reader = dbManager.GetDataReader("USP_GetScreeningFollowupReport", CommandType.StoredProcedure, parameters, out dbConnection); while (reader.Read()) { modal.ScreeningFollowupList.Add(new ScreeningFollowup { CenterID = reader["CenterID"] == DBNull.Value ? "0" : Convert.ToString(reader["CenterID"]), CenterName = reader["CenterName"] == DBNull.Value ? "0" : Convert.ToString(reader["CenterName"]), ClassroomID = reader["ClassroomID"] == DBNull.Value ? "0" : Convert.ToString(reader["ClassroomID"]), ClassroomName = reader["ClassroomName"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ClassroomName"]), ClientId = reader["ClientID"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ClientID"]), ClientName = string.Concat(reader["FirstName"].ToString(), " ", reader["MiddleName"], " ", reader["LastName"]), Dob = Convert.ToString(reader["DOB"]), AgeInWords = Convert.ToString(reader["AgeInWords"]).Replace(" Years","Y").Replace(" Months","M").Replace(" Days","D"), ProgramType = Convert.ToString(reader["ProgramType"]), DateOfFirstService = Convert.ToString(reader["DateOfFirstService"]), ScreeningQuestion = new ScreeningQ { ScreeningId = reader["ScreeningID"] == DBNull.Value ? "0" : Convert.ToString(reader["ScreeningID"]), ScreeningName = reader["ScreeningName"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ScreeningName"]), Questionlist = new List<Questions>().ToList(), }, ScreeningPeriods=new ScreeningPeriods { Description= reader["Description"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Description"]), ScreeningPeriodIndex= reader["ScreeningPeriodID"] == DBNull.Value ? 0 : Convert.ToInt64(reader["ScreeningPeriodID"]), }, StepUpToQualityStars = reader["StepUpToQualityStars"] == DBNull.Value ? "0" : Convert.ToString(reader["StepUpToQualityStars"]), ScreeningDate=reader["ScreeningDate"]==DBNull.Value?string.Empty:Convert.ToString(reader["ScreeningDate"]) }); modal.ScreeningFollowupList.Last().ScreeningQuestion.Questionlist.Add(new Questions { Question = reader["Question"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Question"]), }); } reader.Close(); dbManager.CloseConnection(dbConnection); modal.TotalRecord = (int)parameters.Where(x => x.ParameterName == "@TotalRecord" && x.Direction == ParameterDirection.Output).Select(x => x.Value).First(); } catch (Exception ex) { clsError.WriteException(ex); if(reader!=null && !reader.IsClosed) { reader.Close(); dbManager.CloseConnection(dbConnection); } } finally { } return modal; }
public PartialViewResult GetScreeningFollowupReport(ScreeningFollowupReport report) { report = this.GetScreeningFollowup(report); return(PartialView("~/Views/Screening/_ScreeningFollowup.cshtml", report)); }