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