public ActionResult CreateERSessionCriteria(SearchAssignmentStatusByUser ERsearch)
{
try
{
ValidateSearchCriteria(ERsearch);
Session["ERsearchcriteria"] = ERsearch;
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "AssignmentStatusByUser",
MethodName = "CreateERSessionCriteria",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
return(RedirectToAction("Error", "Transfer"));
}
}
public ActionResult GetReportDetailData(SearchAssignmentStatusByUser search, int LevelIdentifier)
{
try
{
JsonResult jr = new JsonResult();
ValidateSearchCriteria(search);
List <AssignmentStatusByUser_EPData> DetailData = new List <AssignmentStatusByUser_EPData>();
DetailData = AssignmentService.GetAssignmentStatusByUser_EPData(search);
jr = Json(DetailData, JsonRequestBehavior.AllowGet);
jr.MaxJsonLength = Int32.MaxValue;
jr.RecursionLimit = 100;
return(jr);
}
catch (Exception ex)
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "AssignmentStatusByUser",
MethodName = "GetReportData",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
return(RedirectToAction("Error", "Transfer"));
}
}
public ActionResult GetAssignmentAssignedTo(SearchAssignmentStatusByUser search)
{
ValidateSearchCriteria(search);
var result = AssignmentService.GetAssignmentAssignedTo(search);
result.Insert(0, new AssignedToUser
{
UserID = Convert.ToInt32(-1),
FullName = "All"
});
return(PartialView("Search/_AssignmentAssignedTo", result));
}
public ActionResult createErPdf(string ExcelGridName, string ERReportName, string SortBy = "", string SortOrder = "")
{
var emailService = new CommonService();
var createErPdf = "failed";
string fileGuid = "";
try
{
byte[] fileContents = null;
SearchAssignmentStatusByUser search = Session["ERsearchcriteria"] as SearchAssignmentStatusByUser;
Session.Remove("ERsearchcriteria");
var assignmentService = new JCR.Reports.Areas.Corporate.Services.AssignmentStatusByUserReportService();
fileContents = assignmentService.AssignmentStatusByUserReportRDLC(search, (int)WebConstants.ReportFormat.PDF, SortBy, SortOrder);
if (fileContents != null)
{
createErPdf = "success";
}
else
{
createErPdf = "failed";
}
fileGuid = emailService.SavePDF(ExcelGridName, fileContents);
}
catch (Exception ex)
{
createErPdf = "failed";
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "AssignmentStatusByUser",
MethodName = "createErPdf",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
}
finally
{
Session.Remove("ERsearchcriteria");
}
return(Json(new { exportCreated = createErPdf, fileGuid = fileGuid }));
}
private static void ValidateSearchCriteria(SearchAssignmentStatusByUser search)
{
if (search.ProgramIDs == "-1")
{
search.ProgramIDs = null; search.ProgramNames = "All";
}
if (search.SelectedChapterIDs == "-1")
{
search.SelectedChapterIDs = null; search.SelectedChapterNames = "All";
}
if (search.SelectedStandardIDs == "-1")
{
search.SelectedStandardIDs = null; search.SelectedStandardNames = "All";
}
if (search.SelectedAssignedToIDs == "-1")
{
search.SelectedAssignedToIDs = null; search.SelectedAssignedToNames = "All";
}
}
public static List<AssignedToUser> GetAssignmentAssignedTo(SearchAssignmentStatusByUser search)
{
var result = new List<AssignedToUser>();
using (var DBMEdition01_Entities = new DBMEdition01_Entities())
{
try
{
result = DBMEdition01_Entities.GetUserAssignedToSiteIDAndAssignment(search.SelectedSiteIDs, search.ProgramIDs,
search.SelectedChapterIDs, search.SelectedStandardIDs, search.SelectedScoreType, search.IncludeFSAEPs,
search.IncludeDocumentationRequired, search.IncludeNewChangedEPs, search.StartDate, search.EndDate, search.StandardEffBeginDate).ToList();
}
catch (Exception ex)
{
throw ex;
}
return result;
}
}
public static List<AssignmentStatusByUser_EPData> GetAssignmentStatusByUser_EPData(SearchAssignmentStatusByUser search)
{
var result = new List<AssignmentStatusByUser_EPData>();
using (var DBMEdition01_Entities = new DBMEdition01_Entities())
{
try
{
int ProgramID = Convert.ToInt32(search.ProgramIDs);
result = DBMEdition01_Entities.GetAssignmentStatusByUser_EPWise(search.SelectedSiteIDs, ProgramID,
search.SelectedChapterIDs, search.SelectedStandardIDs, search.SelectedScoreType, search.SelectedAssignedToIDs, search.IncludeFSAEPs,
search.IncludeDocumentationRequired, search.IncludeNewChangedEPs, search.StartDate, search.EndDate, search.StandardEffBeginDate, search.ScoreValueList,
search.LevelIdentifier).ToList();
}
catch (Exception ex)
{
throw ex;
}
return result;
}
}
public static List<AssignmentStatusByUser_ChapterData> GetAssignmentStatusByUser_ChapterData(SearchAssignmentStatusByUser search)
{
var result = new List<AssignmentStatusByUser_ChapterData>();
using (var DBMEdition01_Entities = new DBMEdition01_Entities())
{
try
{
int SiteID = Convert.ToInt32(search.SelectedSiteIDs);
int ProgramID = Convert.ToInt32(search.ProgramIDs);
int SelectedAssignedToID = Convert.ToInt32(search.SelectedAssignedToIDs);
result = DBMEdition01_Entities.GetAssignmentStatusByUser_ChapterWise(SiteID, ProgramID,
search.SelectedChapterIDs, search.SelectedStandardIDs, search.SelectedScoreType, SelectedAssignedToID, search.IncludeFSAEPs,
search.IncludeDocumentationRequired, search.IncludeNewChangedEPs, search.StartDate, search.EndDate, search.StandardEffBeginDate, search.ScoreValueList).ToList();
result
.Where(a => (decimal)(a.ScoreCompletePercentage.Value + a.ScoreNotCompletePercentage.Value + a.ScorePastDueDatePercentage.Value) > (decimal)100.00).ToList()
.ForEach(delegate (AssignmentStatusByUser_ChapterData userData)
{
decimal difference = (userData.ScoreCompletePercentage.Value + userData.ScoreNotCompletePercentage.Value + userData.ScorePastDueDatePercentage.Value) - 100;
if (userData.ScoreCompletePercentage.Value > difference * 2)
userData.ScoreCompletePercentage = userData.ScoreCompletePercentage.Value - difference;
else if (userData.ScoreNotCompletePercentage.Value > difference * 2)
userData.ScoreNotCompletePercentage = userData.ScoreNotCompletePercentage.Value - difference;
else if (userData.ScorePastDueDatePercentage.Value > difference * 2)
userData.ScorePastDueDatePercentage = userData.ScorePastDueDatePercentage.Value - difference;
});
}
catch (Exception ex)
{
throw ex;
}
return result;
}
}
public byte[] AssignmentStatusByUserReportRDLC(SearchAssignmentStatusByUser search, int reportType, string SortBy = "", string SortOrder = "")
{
byte[] fileContents = null;
string reportDateTitle = "";
string rdlcName = String.Empty;
string dsName = String.Empty;
string reportSubTitle = String.Empty;
string stdDetail = string.Empty;
string findingDetails = string.Empty;
DataView dv = null;
ReportParameterCollection reportParameterCollection = new ReportParameterCollection();
try
{
if (AppSession.ReportScheduleID > 0 && search.ReportTitle != null)
{
search.ReportTitle = String.Concat(search.ReportTitle, " - Report ID: ", AppSession.ReportScheduleID);
}
else
{
search.ReportTitle = "Assignment Status by User Report";
}
//reportDateTitle = CommonService.InitializeReportDateTitle("Due", search.StartDate, search.EndDate);
if (search.StartDate != null && search.EndDate != null)
{
reportDateTitle = "Due Date for " + search.StartDate.Value.ToShortDateString() + " - " + search.EndDate.Value.ToShortDateString();
}
else if (search.StartDate != null && search.EndDate == null)
{
reportDateTitle = "Due Date since " + search.StartDate.Value.ToShortDateString();
}
else if (search.StartDate == null && search.EndDate != null)
{
reportDateTitle = "Due Date through " + search.EndDate.Value.ToShortDateString();
}
else
{
reportDateTitle = "Due Date: All";
}
search.EndDate = (search.EndDate != null && search.EndDate.ToString() != "") ? search.EndDate.Value.Date.AddHours(23).AddMinutes(29).AddSeconds(59) : search.EndDate;
// Setup ReportViewer
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.LocalReport.DisplayName = search.ReportTitle;
switch ((AssignmentStatusByUserSummaryLevels)search.LevelIdentifier)
{
case AssignmentStatusByUserSummaryLevels.Level1_ByUser:
rdlcName = "rptReportAssignmentStatusByUser_UserLevel.rdlc";
dsName = "dsReport_AssignmentStatusByUser_UserLevel";
dv = new DataView(AssignmentService.GetAssignmentStatusByUser_UserData(search).ToDataTable());
reportSubTitle = "Status by User";
break;
case AssignmentStatusByUserSummaryLevels.Level2_ByChapter:
rdlcName = "rptReportAssignmentStatusByUser_ChapterLevel.rdlc";
dsName = "dsReport_AssignmentStatusByUser_ChapterLevel";
dv = new DataView(AssignmentService.GetAssignmentStatusByUser_ChapterData(search).ToDataTable());
reportSubTitle = "Status by Chapter";
break;
case AssignmentStatusByUserSummaryLevels.Level3_ByStandard:
rdlcName = "rptReportAssignmentStatusByUser_StandardLevel.rdlc";
dsName = "dsReport_AssignmentStatusByUser_StandardLevel";
dv = new DataView(AssignmentService.GetAssignmentStatusByUser_StandardData(search).ToDataTable());
reportSubTitle = "Status by Standard";
break;
}
// Setup Report Parmaeters common to all reports
reportParameterCollection.Add(new ReportParameter("ReportTitle", search.ReportTitle.ToString()));
reportParameterCollection.Add(new ReportParameter("Programs", search.ProgramNames.ToString()));
reportParameterCollection.Add(new ReportParameter("Chapters", search.SelectedChapterNames.ToString()));
reportParameterCollection.Add(new ReportParameter("Standards", search.SelectedStandardNames.ToString()));
reportParameterCollection.Add(new ReportParameter("ReportDateTitle", reportDateTitle.ToString()));
reportParameterCollection.Add(new ReportParameter("HCOID", search.SelectedSiteHCOIDs.ToString()));
reportParameterCollection.Add(new ReportParameter("Copyright", "© " + DateTime.Now.Year.ToString() + WebConstants.Copyright.ToString()));
reportParameterCollection.Add(new ReportParameter("ReportSubTitle", reportSubTitle.ToString()));
reportParameterCollection.Add(new ReportParameter("ScoreType", search.SelectedScoreTypeName));
reportParameterCollection.Add(new ReportParameter("AssignedTo", search.SelectedAssignedToNames));
reportParameterCollection.Add(new ReportParameter("ScoreValue", search.ScoreValueNameList));
if (SortBy != "")
{
dv.Sort = SortBy + " " + SortOrder;
}
// Setup Data sources for report
reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.ReportPath = HttpContext.Current.Request.MapPath(HttpContext.Current.Request.ApplicationPath) + @"Areas\Corporate\Reports\" + rdlcName.ToString();
reportViewer.LocalReport.DataSources.Add(new ReportDataSource(dsName, dv));
reportViewer.LocalReport.SetParameters(reportParameterCollection);
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string format = WebConstants.REPORT_FORMAT_PDF; // PDF is default
if (reportType == (int)WebConstants.ReportFormat.EXCEL)
{
format = WebConstants.REPORT_FORMAT_EXCEL; // If Excel option chosen
}
fileContents = reportViewer.LocalReport.Render(format, null, out mimeType, out encoding, out extension, out streamIds, out warnings);
}
catch (Exception ex)
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "AssignmentStatusByUserReport",
MethodName = "AssignmentStatusByUserReportRDLC",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
_exceptionService.LogException(exceptionLog);
}
return(fileContents);
}
public ActionResult SendERPDFEmail(string ExcelGridName, Email email, string ERReportName, string SortBy = "", string SortOrder = "")
{
var emailService = new CommonService();
bool emailSuccess = true;
var emailMessage = WebConstants.Excel_Email_Success;
try
{
byte[] fileContents = null;
SearchAssignmentStatusByUser search = Session["ERsearchcriteria"] as SearchAssignmentStatusByUser;
Session.Remove("ERsearchcriteria");
var assignmentService = new JCR.Reports.Areas.Corporate.Services.AssignmentStatusByUserReportService();
fileContents = assignmentService.AssignmentStatusByUserReportRDLC(search, (int)WebConstants.ReportFormat.PDF, SortBy, SortOrder);
email.AttachmentLocation[0] = emailService.SavePDF(ExcelGridName, fileContents);
email.FileContents = fileContents;
email.ReportName = ERReportName;
//int actionTypeId = 51;
emailSuccess = emailService.SendExcelEmailAttachemnt(email, true);
if (emailSuccess)
{
emailMessage = WebConstants.Excel_Email_Success;
}
else
{
emailMessage = WebConstants.Email_Failed;
if (emailService.ErrorException != null)
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + emailService.ErrorException.Message,
PageName = "AssignmentStatusByUser",
MethodName = "SendERPDFEmail",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
}
}
}
catch (Exception ex)
{
emailMessage = WebConstants.Excel_Email_Failed;
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "AssignmentStatusByUser",
MethodName = "SendERPDFEmail",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
}
finally
{
Session.Remove("ERsearchcriteria");
}
return(Json(emailMessage));
}
public ActionResult GetReportData(SearchAssignmentStatusByUser search, int LevelIdentifier)
{
try
{
JsonResult jr = new JsonResult();
ValidateSearchCriteria(search);
switch ((AssignmentStatusByUserSummaryLevels)LevelIdentifier)
{
case AssignmentStatusByUserSummaryLevels.Level1_ByUser:
if (search.IsDuplicateLoadCall)
{
jr = TempData["ASBU_Level1Data"] as JsonResult;
}
else
{
List <AssignmentStatusByUser_UserData> Level1Data = new List <AssignmentStatusByUser_UserData>();
Level1Data = AssignmentService.GetAssignmentStatusByUser_UserData(search);
jr = Json(Level1Data, JsonRequestBehavior.AllowGet);
TempData["ASBU_Level1Data"] = jr;
}
break;
case AssignmentStatusByUserSummaryLevels.Level2_ByChapter:
if (search.IsDuplicateLoadCall)
{
jr = TempData["ASBU_Level2Data"] as JsonResult;
}
else
{
List <AssignmentStatusByUser_ChapterData> Level2Data = new List <AssignmentStatusByUser_ChapterData>();
Level2Data = AssignmentService.GetAssignmentStatusByUser_ChapterData(search);
jr = Json(Level2Data, JsonRequestBehavior.AllowGet);
TempData["ASBU_Level2Data"] = jr;
}
break;
case AssignmentStatusByUserSummaryLevels.Level3_ByStandard:
if (search.IsDuplicateLoadCall)
{
jr = TempData["ASBU_Level3Data"] as JsonResult;
}
else
{
List <AssignmentStatusByUser_StandardData> Level3Data = new List <AssignmentStatusByUser_StandardData>();
Level3Data = AssignmentService.GetAssignmentStatusByUser_StandardData(search);
jr = Json(Level3Data, JsonRequestBehavior.AllowGet);
TempData["ASBU_Level3Data"] = jr;
}
break;
}
jr.MaxJsonLength = Int32.MaxValue;
jr.RecursionLimit = 100;
return(jr);
}
catch (Exception ex)
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "AssignmentStatusByUser",
MethodName = "GetReportData",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
return(RedirectToAction("Error", "Transfer"));
}
}
