public FileResult exportChartData()
{
XLExport objExp = new XLExport(Convert.ToString(TempData["processor"]));
string flName = objExp.ExcelExportChartData();
return(File(flName, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", Path.GetFileName(flName)));
}
public ActionResult generateFile(WMReportInputs input)
{
try
{
Response.Cookies.Remove("fileDownload");
repository objRep = new repository();
WMRPTErrViewModel rep = objRep.GetHistory(input);
XLExport objExp = new XLExport(rep);
string flName = objExp.ExcelExport();
return(Json(new { success = true, fileName = flName }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
static void Main(string[] args)
{
try
{
//Run the report and Create the excel sheet attach it to email and send.
repository objRepository = new repository();
//Added below two dates for shashank's request for weekly frequency
DateTime?startDt, endDt;
startDt = endDt = null;
startDt = DateTime.Now.AddDays(-Freq);
endDt = DateTime.Now;
String team = Convert.ToString(args[0]);
WMReportDataViewModal objRpt = objRepository.GetRawData(startDt, endDt);
XLExport objExport = new XLExport(objRpt);
String fileName = objExport.GenerateExcel(ConfigurationManager.AppSettings["ExcelPath"], team);
//Send an email with attachment from this file.
SendEmail(fileName);
Logger.Log(Logger.LogType.Info, "Email Has been generated for the day");
}
catch (Exception ex)
{
Logger.Log(Logger.LogType.Error, ex.ToString());
}
}
