public void ExportScreeningReviewReport(NDayScreeningReviewReport nDayScreeningReviewReport, int reportFormatType)
{
try
{
nDayScreeningReviewReport.RequestedPage = 0;
nDayScreeningReviewReport.PageSize = 0;
nDayScreeningReviewReport.SkipRows = nDayScreeningReviewReport.GetSkipRows();
nDayScreeningReviewReport.SortColumn = "Classroom";
nDayScreeningReviewReport.SortOrder = "ASC";
nDayScreeningReviewReport = screeningData.GetScreeningReviewReport(staff, nDayScreeningReviewReport);
#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>().ExportScreeningReviewReport(nDayScreeningReviewReport, reportTypeEnum, imagePath);
string reportName = "45-Day_Screening_Review_Report";
DownloadReport(workStream, reportTypeEnum, reportName);
#endregion
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
}
public ActionResult ScreeningReview()
{
NDayScreeningReviewReport modal = new NDayScreeningReviewReport();
modal.ScreeningReportPeriodsList = FactoryInstance.Instance.CreateInstance <ScreeningData>().GetScreeningReportPeriods(staff);
return(View(modal));
}
public PartialViewResult GetScreeningReviewReport(NDayScreeningReviewReport nDayScreeningReviewReport)
{
nDayScreeningReviewReport.SkipRows = nDayScreeningReviewReport.GetSkipRows();
nDayScreeningReviewReport = screeningData.GetScreeningReviewReport(staff, nDayScreeningReviewReport);
return(PartialView("~/Views/Screening/_ScreeningReview.cshtml", nDayScreeningReviewReport));
}
public NDayScreeningReviewReport GetScreeningReviewReport(StaffDetails staff, NDayScreeningReviewReport modal)
{
try
{
modal.NDayScreeningReviewList = new List<NDaysScreeningReview>();
modal.CenterID = string.Join(",", modal.CenterID.Split(',').Select(x => EncryptDecrypt.Decrypt64(x)));
modal.ScreeningID = string.Join(",", modal.ScreeningID.Split(',').Select(x => EncryptDecrypt.Decrypt64(x)));
modal.ClassroomID = modal.ClassroomID != "" && modal.ClassroomID != "0" ? string.Join(",", modal.ClassroomID.Split(',').Select(x => EncryptDecrypt.Decrypt64(x))):modal.ClassroomID;
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("@ScreeningReportPeriodID",modal.ScreeningReportPeriodID,DbType.Int32),
dbManager.CreateParameter("@CenterIDs",modal.CenterID,DbType.AnsiString),
dbManager.CreateParameter("@ClassroomIDs",modal.ClassroomID,DbType.AnsiString),
dbManager.CreateParameter("@ScreeningIDs", modal.ScreeningID, 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_GetScreeningReviewReport", CommandType.StoredProcedure, parameters, out dbConnection);
while(reader.Read())
{
modal.NDayScreeningReviewList.Add(new NDaysScreeningReview
{
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"]),
ScreeningID=reader["ScreeningID"]==DBNull.Value?0:Convert.ToInt32(reader["ScreeningID"]),
ScreeningName =reader["ScreeningName"]==DBNull.Value?string.Empty:Convert.ToString(reader["ScreeningName"]),
Completed=reader["Completed"]==DBNull.Value?0:Convert.ToInt64(reader["Completed"]),
CompletedButLate=reader["CompletedButLate"]==DBNull.Value?0:Convert.ToInt64(reader["CompletedButLate"]),
NotExpired=reader["NotExpired"]==DBNull.Value?0:Convert.ToInt64(reader["NotExpired"]),
NotCompletedandLate=reader["NotCompletedandLate"]==DBNull.Value?0:Convert.ToInt64(reader["NotCompletedandLate"]),
StepUpToQualityStars=reader["StepUpToQualityStars"]==DBNull.Value?"0":Convert.ToString(reader["StepUpToQualityStars"])
});
}
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);
}
finally
{
}
return modal;
}
