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