public ActionResult Details(string id)
{
try
{
if (string.IsNullOrEmpty(id))
{
return(RedirectToAction("TimeSheet", "AllTimeSheet"));
}
MainTimeSheetView objMT = new MainTimeSheetView();
objMT.ListTimeSheetDetails = _ITimeSheet.TimesheetDetailsbyTimeSheetMasterID(Convert.ToInt32(Session["UserID"]), Convert.ToInt32(id));
objMT.ListofProjectNames = _ITimeSheet.GetProjectNamesbyTimeSheetMasterID(Convert.ToInt32(id));
objMT.ListofPeriods = _ITimeSheet.GetPeriodsbyTimeSheetMasterID(Convert.ToInt32(id));
objMT.ListoDayofWeek = DayofWeek();
objMT.TimeSheetMasterID = Convert.ToInt32(id);
return(View(objMT));
}
catch (Exception)
{
throw;
}
}
public ActionResult Report(TimeSheetExportUserModel objtimesheet)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
dt.Columns.Add("ProjectName", typeof(string));
dt.Columns.Add("Sunday", typeof(string));
dt.Columns.Add("Monday", typeof(string));
dt.Columns.Add("Tuesday", typeof(string));
dt.Columns.Add("Wednesday", typeof(string));
dt.Columns.Add("Thursday", typeof(string));
dt.Columns.Add("Friday", typeof(string));
dt.Columns.Add("Saturday", typeof(string));
dt.Columns.Add("Total", typeof(string));
dt.Columns.Add("Description", typeof(string));
var filename = "TimesheetMaster";
var timesheetdata = _ITimeSheetExport.GetTimeSheetMasterIDTimeSheet(objtimesheet.FromDate, objtimesheet.ToDate);
if (timesheetdata != null)
{
if (timesheetdata.Tables.Count > 0)
{
if (timesheetdata.Tables[0].Rows.Count == 0)
{
TempData["NoExportMessage"] = "No Data to Export";
return(View("TimeSheetReport", new TimeSheetExportUserModel()));
}
else
{
for (int k = 0; k < timesheetdata.Tables[0].Rows.Count; k++)
{
var timesheetID = Convert.ToInt32(timesheetdata.Tables[0].Rows[k]["TimeSheetMasterID"]);
var data = _ITimeSheet.GetPeriodsbyTimeSheetMasterID(Convert.ToInt32(timesheetID));
DataRow row2 = dt.NewRow();
row2["ProjectName"] = "";
row2["Sunday"] = "";
row2["Monday"] = "";
row2["Tuesday"] = "";
row2["Wednesday"] = "";
row2["Thursday"] = "";
row2["Friday"] = "";
row2["Saturday"] = "";
row2["Total"] = "";
row2["Description"] = "";
dt.Rows.Add(row2);
DataRow row = dt.NewRow();
row["ProjectName"] = "";
row["Sunday"] = data[0].Period;
row["Monday"] = data[1].Period;
row["Tuesday"] = data[2].Period;
row["Wednesday"] = data[3].Period;
row["Thursday"] = data[4].Period;
row["Friday"] = data[5].Period;
row["Saturday"] = data[6].Period;
row["Total"] = "";
row["Description"] = "";
dt.Rows.Add(row);
var ListofProjectNames = _ITimeSheet.GetProjectNamesbyTimeSheetMasterID(Convert.ToInt32(timesheetID));
for (int i = 0; i < ListofProjectNames.Count(); i++)
{
var ListofHours = MethodonViews.GetHoursbyTimeSheetMasterID(timesheetID, ListofProjectNames[i].ProjectID);
var ListofDescription = WebTimeSheetManagement.Helpers.MethodonViews.GetDescriptionbyTimeSheetMasterID(timesheetID, ListofProjectNames[i].ProjectID);
DataRow row1 = dt.NewRow();
row1["ProjectName"] = ListofProjectNames[i].ProjectName;
row1["Sunday"] = ListofHours[0].Hours;
row1["Monday"] = ListofHours[1].Hours;
row1["Tuesday"] = ListofHours[2].Hours;
row1["Wednesday"] = ListofHours[3].Hours;
row1["Thursday"] = ListofHours[4].Hours;
row1["Friday"] = ListofHours[5].Hours;
row1["Saturday"] = ListofHours[6].Hours;
row1["Total"] = ListofHours[7].Hours;
row1["Description"] = Convert.ToString(ListofDescription);
dt.Rows.Add(row1);
}
}
ds.Tables.Add(dt);
var gv = new GridView();
gv.DataSource = ds;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=" + filename.Trim() + ".xls" + "");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
}
}
}
return(View("Report", new TimeSheetExportUserModel()));
}
catch (Exception)
{
throw;
}
finally
{
ds.Dispose();
}
}