public ActionResult ManageInquiry(MediaInquiries mediaInquiries) { try { db.MediaInquiries.Add(mediaInquiries); db.SaveChanges(); if (!string.IsNullOrEmpty(mediaInquiries.SourceData)) { string[] details = mediaInquiries.SourceData.TrimEnd('|').Split('|'); foreach (string str in details) { if (!string.IsNullOrEmpty(str)) { string[] strData = str.Trim().Split(','); MediaInquiryDetail objMD = new MediaInquiryDetail() { MediaInquiryID = mediaInquiries.MediaInquiryID, InquirySourceD = strData[0], Reporter = strData[1], TimeIn = strData[2], TimeOut = strData[3] }; db.MediaInquiryDetails.Add(objMD); } } db.SaveChanges(); } if (mediaInquiries.IsEmail == 1) { bool success = DailyMediaReport(mediaInquiries.Date); if (!success) { var resultPDF = new { Valid = false, Message = "Error" }; return(Json(resultPDF)); } } var result = new { Valid = true, Message = "Media inquiries submitted successfully" }; return(Json(result)); } catch (Exception ex) { string fileName = "Error.txt"; string path = Server.MapPath("../") + "Report\\" + fileName; if (!System.IO.File.Exists(path)) { System.IO.File.Create(path); } using (var tw = new StreamWriter(path, true)) { tw.WriteLine("Error-" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "-" + ex.Message); tw.WriteLine(ex.InnerException); } var result = new { Valid = false, Message = ex.Message }; return(Json(result)); } }
// Saves User inputted Media Inquiries data to db, calls to export the data to DailyMediaReport pdf public ActionResult ManageInquiry(MediaInquiries mediaInquiries) { ////FileStream fs = null; try { db.MediaInquiries.Add(mediaInquiries); db.SaveChanges(); if (!string.IsNullOrEmpty(mediaInquiries.SourceData)) { string[] details = mediaInquiries.SourceData.TrimEnd('|').Split('|'); foreach (string str in details) { if (!string.IsNullOrEmpty(str)) { string[] strData = str.Trim().Split(','); MediaInquiryDetail objMD = new MediaInquiryDetail() { MediaInquiryID = mediaInquiries.MediaInquiryID, InquirySourceD = strData[0], Reporter = strData[1], TimeIn = strData[2], TimeOut = strData[3] }; db.MediaInquiryDetails.Add(objMD); } } db.SaveChanges(); } if (mediaInquiries.IsEmail == 1) { //bool success = DailyMediaReport(System.DateTime.Now.Date); ////bool success = DailyMediaReport(mediaInquiries.Date); //string res = DailyMediaReportSMTP(mediaInquiries.Date); string res = DailyMediaReport(mediaInquiries.Date); if (res != "true") { var resultPDF = new { Valid = false, Message = res }; return(Json(resultPDF)); } } //hp-Test var result = new { Valid = true, Message = "Media inquiries submitted successfully" }; return(Json(result)); ////return Json(new ////{ //// //Valid = valid, //// result = result; //// Message = result.Message, //// Errors = GetErrorsFromModelState() //// }, JsonRequestBehavior.AllowGet); //string tempFolder = Server.MapPath("../") + "Temp"; ; //var filePath = Directory.GetFiles(tempFolder).Single(); // stream out the contents - don't need to dispose because File() does it for you //fs = new FileStream(filePath, FileMode.Open); //return File(fs, "message/rfc822", "mymessage.eml"); //return File(fs, "application/vnd.ms-outlook", "mymessage.eml"); //Test Approach 2-hp ////string handle = Guid.NewGuid().ToString(); ////string emlFileName = Server.MapPath("../") + "Temp\\mymessage.eml"; ////return Json(new { FileGuid = handle, FileName = emlFileName }, JsonRequestBehavior.AllowGet); //Uncomment until here-hp } catch (Exception ex) { ////string fileName = "Error.txt"; //string reportServerURL = Convert.ToString(ConfigurationManager.AppSettings["SSRSServer"]); //string path = Server.MapPath("../") + "Report\\" + fileName; ////string logPath = Convert.ToString(ConfigurationManager.AppSettings["logPath"]); string path = System.Web.Hosting.HostingEnvironment.MapPath("~/Report/Error.txt");//which is static if (!System.IO.File.Exists(path)) { System.IO.File.Create(path); } using (var tw = new StreamWriter(path, true)) { tw.WriteLine("Error-" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "-" + ex.Message); tw.WriteLine(ex.InnerException); } var result = new { Valid = false, Message = ex.Message }; return(Json(result)); } }