public ActionResult EmployeeActivityWiseDetailedReport(string fromDate, string toDate, string Project_ID, string Employee_ID) { ViewBag.resultcount = false; ActivityWiseModel objact = new ActivityWiseModel(); if (Employee_ID == null || Employee_ID == "") { Employee_ID = "0"; } if (Project_ID == null || Project_ID == "") { Project_ID = "0"; } objact.data = taskService.getEmployeeDetailedActivity(fromDate, toDate, Int16.Parse(Project_ID), Int16.Parse(Employee_ID)); if (objact.data.Rows.Count == 0) { ViewBag.resultcount = true; } return(PartialView("~/Views/Report/_PVEmployeeDetailedActivity.cshtml", objact)); }
public ActionResult EmployeeActivityWiseSummaryReport(string fromDate, string toDate, string Project_ID, string Location_ID) { ViewBag.resultcount = false; ActivityWiseModel objact = new ActivityWiseModel(); if (Location_ID == null || Location_ID == "") { Location_ID = "0"; } if (Project_ID == null || Project_ID == "") { Project_ID = "0"; } objact.data = taskService.getActivityData(fromDate, toDate, Convert.ToInt16(Project_ID), Convert.ToInt16(Location_ID)); if (objact.data.Rows.Count == 0) { ViewBag.resultcount = true; } return(PartialView("~/Views/Report/_PVActivityWiseReport.cshtml", objact)); }
public FileResult ExportToCSVDetailedActivity(string fromdate, string todate, string Project_ID, string Employee_ID) { ActivityWiseModel objcat = new ActivityWiseModel(); DataTable dtResult = new DataTable(); MemoryStream memoryStream = new MemoryStream(); StreamWriter streamWriter = new StreamWriter(memoryStream); if (Employee_ID == null || Employee_ID == "") { Employee_ID = "0"; } if (Project_ID == null || Project_ID == "") { Project_ID = "0"; } dtResult = taskService.getEmployeeDetailedActivity(fromdate, todate, Convert.ToInt16(Project_ID), Convert.ToInt16(Employee_ID)); 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", "EmployeeDetailedReport - " + fromdate + " - " + todate + ".csv")); }