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