public string GetPresentEmployeeList(CompanyObj companyObj)
{
this.aDaHandler = new DashboardDAHandler();
var data = this.aDaHandler.GetPresentEmployeeList(companyObj);
return(JsonConvert.SerializeObject(data));
}
public string GetCompanyWise(DashboardFilter aInfo)
{
try
{
this.userId = Session["UserId"].ToString();
if (true)
{
this.aDaHandler = new DashboardDAHandler();
var data = this.aDaHandler.GetCompanywise(this.userId, aInfo);
TempData["FilterData"] = data;
return(JsonConvert.SerializeObject(data));
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult GetExportToExcell(DashboardFilter aInfo)
{
try
{
DataTable data;
if (TempData["FilterData"] == null)
{
var userId = Session["UserId"].ToString();
aDaHandler = new DashboardDAHandler();
data = aDaHandler.GetCompanywise(userId, aInfo);
}
else
{
data = TempData["FilterData"] as DataTable;
}
var fileName = "Daily_Attendance_Data_" + DateTime.Now.ToString("yyyy_dd_M_HH_mm_ss") + ".xls";
var gv = new GridView {
DataSource = data
};
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
Response.ContentType = "application/ms-excel";
Response.Charset = "";
var sw = new StringWriter();
var htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(View("Index"));
}
catch (Exception ex)
{
throw new HttpException(404, "Not found");
}
}
