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;
                SearchCorporateER ERsearchcriteria = Session["ERsearchcriteria"] as SearchCorporateER;

                var rfiService = new JCR.Reports.Areas.Corporate.Services.RFIReportService();

                fileContents = rfiService.RFIReportRDLC(ERsearchcriteria, (int)WebConstants.ReportFormat.PDF, SortBy, SortOrder);

                email.AttachmentLocation[0] = emailService.SavePDF(ExcelGridName, fileContents);
                email.FileContents          = fileContents;
                email.ReportName            = ERReportName;
                //int actionTypeId = 48;
                emailSuccess = emailService.SendExcelEmailAttachemnt(email, true, "FromCorporateEmailAddress");
                if (emailSuccess)
                {
                    emailMessage = WebConstants.Excel_Email_Success;
                }
                else
                {
                    emailMessage = WebConstants.Email_Failed;
                }
            }
            catch (Exception ex)
            {
                emailMessage = WebConstants.Excel_Email_Failed;

                ExceptionLog exceptionLog = new ExceptionLog
                {
                    ExceptionText = "Reports: " + ex.Message,
                    PageName      = "PriorityRFIFinding",
                    MethodName    = "PriorityTjcRFISendERPDFEmail",
                    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 createErPdf(string ExcelGridName, string ERReportName, string SortBy = "", string SortOrder = "")
        {
            var emailService = new CommonService();

            var    createErPdf = "failed";
            string fileGuid    = "";

            try
            {
                byte[]            fileContents     = null;
                SearchCorporateER ERsearchcriteria = Session["ERsearchcriteria"] as SearchCorporateER;
                Session.Remove("ERsearchcriteria");
                var RFIService = new JCR.Reports.Areas.Corporate.Services.RFIReportService();
                fileContents = RFIService.RFIReportRDLC(ERsearchcriteria, (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      = "PriorityRFIFinding",
                    MethodName    = "PriorityTjcRFIcreateErPdf",
                    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 }));
        }