public ActionResult CategoryWiseReport(string fromdate, string todate, string LocationId)
{
ViewBag.resultcount = false;
CategoryWiseModel objcat = new CategoryWiseModel();
if (LocationId == null || LocationId == "")
{
LocationId = "0";
}
objcat.data = taskService.getcategorydata(Convert.ToDateTime(fromdate), Convert.ToDateTime(todate), Int16.Parse(LocationId));
if (objcat.data.Rows.Count == 0)
{
ViewBag.resultcount = true;
}
return(PartialView("~/Views/Report/_PVcategoryreport.cshtml", objcat));
}
public FileResult ExportToCSVCategory(string fromdate, string todate, string location)
{
CategoryWiseModel objcat = new CategoryWiseModel();
DataTable dtResult = new DataTable();
MemoryStream memoryStream = new MemoryStream();
StreamWriter streamWriter = new StreamWriter(memoryStream);
if (location == null || location == "")
{
location = "0";
}
dtResult = taskService.getcategorydata(Convert.ToDateTime(fromdate), Convert.ToDateTime(todate), Convert.ToInt16(location));
//objcat.data = taskService.getcategorydata(Convert.ToDateTime(fromdate),Convert.ToDateTime(todate),Convert.ToInt16(location));
//byte[] bpdf = new ViewAsPdf("_PVcategoryreport", objcat).BuildPdf(this.ControllerContext);
//string mimeType = "application/pdf";
//string filename = "CategoryWiseReport" + System.DateTime.Now.ToShortDateString() + ".pdf";
//return File(bpdf, mimeType, filename);
string WriteValue = "";
int i = 0;
foreach (DataColumn z in dtResult.Columns)
{
//This will create your Headers
if (i == 0)
{
WriteValue += string.Format("\"{0}\"", z.ColumnName.ToString());
i = 1;
}
else
{
WriteValue += "," + string.Format("\"{0}\"", z.ColumnName.ToString());
}
}
streamWriter.WriteLine(WriteValue);
foreach (DataRow r in dtResult.Rows)
{
WriteValue = "";
i = 0;
foreach (DataColumn z in dtResult.Columns)
{
if (i == 0)
{
WriteValue += string.Format("\"{0}\"", r[z.ColumnName].ToString());
i = 1;
}
else
{
WriteValue += "," + string.Format("\"{0}\"", r[z.ColumnName].ToString());
}
}
streamWriter.WriteLine(WriteValue);
}
streamWriter.Flush();
memoryStream.Position = 0;
return(File(memoryStream, "text/csv", "CategoryWiseReport - " + fromdate + " - " + todate + ".csv"));
}
