public JsonResult Edit(MediaInquiries mediaInquiries) { string message = ""; var valid = true; //test bool result; try { result = MediaInquiries.UpdateMediaInquiries(mediaInquiries); if (result == false) { message = "Media Inquiries not saved "; valid = false; } else { message = "Media Inquiries details updated successfully."; } } catch (Exception ex) { valid = false; message = "Error occurred while updating Media Inquiries." + ex.Message; } return(Json(new { Valid = valid, Message = message, Errors = GetErrorsFromModelState() }, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { //MediaInquiries mediaInquiries = db.MediaInquiries.Find(id); //db.MediaInquiries.Remove(mediaInquiries); //db.SaveChanges(); bool res = MediaInquiries.DeleteMediaInquiries(id); return(RedirectToAction("MediaInquiriesList")); }
//MediaInquiries //public ActionResult MediaInquiriesList() public ActionResult MediaInquiriesList(string todaysdate) { //string todaysdate= ; DataTable dt = new System.Data.DataTable(); DateTime enteredDate = System.DateTime.Now.Date; if (todaysdate != "" && todaysdate != null) { enteredDate = DateTime.Parse(todaysdate); } dt = MediaInquiries.GetMediaInquiriesByDate(enteredDate); return(View("MediaInquiriesList", dt)); }
// GET: MeetingAttendances/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DataTable dt = new System.Data.DataTable(); dt = MediaInquiries.GetMediaInquiriesById(id); MediaInquiries mediaInquiries = ConvertDT2MediaInq(dt); return(View(mediaInquiries)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var Reporters = db.Reporters.ToList(); //var objReporter = new SelectList(Reporters, "ReportID", "ReporterName"); ViewBag.Reporters = Reporters; var InquirySources = db.InquirySources.ToList(); // var objInquirySources = new SelectList(InquirySources, "InquirySourceId", "InquirySourceName"); ViewBag.InquirySources = InquirySources; ViewBag.InquiryType = db.TypeRequests.ToList(); ViewBag.Bureaus = db.BureausDS.ToList(); ViewBag.Category = db.Categories.ToList(); //MediaInquiries obj = new MediaInquiries(); //obj.Date = System.DateTime.Now; //obj.IsEmail = 0; //return View(obj); DataTable dt = new System.Data.DataTable(); dt = MediaInquiries.GetMediaInquiriesById(id); //Get rest of the Inquiry details-selected inquiries source, GetReporter DataTable DT_mediaInquiryDetails = new System.Data.DataTable(); if (id != null) { DT_mediaInquiryDetails = MediaInquiries.GetMediaInquiriesByInqId(id); } List <MediaInquiryDetail> mediaInquiryDetails = ConvertDT2InqDetails(DT_mediaInquiryDetails); MediaInquiries mediaInquiries = ConvertDT2MediaInq(dt); ViewBag.mediaInquiryDetails = mediaInquiryDetails; return(View(mediaInquiries)); }
// GET: MediaInquiries/Create public ActionResult Create() { var Reporters = db.Reporters.ToList(); //var objReporter = new SelectList(Reporters, "ReportID", "ReporterName"); ViewBag.Reporters = Reporters; var InquirySources = db.InquirySources.ToList(); // var objInquirySources = new SelectList(InquirySources, "InquirySourceId", "InquirySourceName"); ViewBag.InquirySources = InquirySources; ViewBag.InquiryType = db.TypeRequests.ToList(); ViewBag.Bureaus = db.BureausDS.ToList(); ViewBag.Category = db.Categories.ToList(); MediaInquiries obj = new MediaInquiries(); obj.Date = System.DateTime.Now; obj.IsEmail = 0; return(View(obj)); }
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)); } }