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