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