/// <summary> /// Excel-Export /// </summary> public ActionResult MgrdaycalExcel(string startDate = "", string endDate = "") { // DataTable dt = -- > get your data ManagerdaycalEntity _Model = new ManagerdaycalEntity(); _Model.StartDate = startDate; _Model.EndDate = endDate; DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetManagerdaycalRecord, _Model); ERP.Utility.Excelimport.ExcelFileResult actionResult = new ERP.Utility.Excelimport.ExcelFileResult(dt) { FileDownloadName = "MgrdaycalExcel.xls" }; return actionResult; }
public ActionResult Managerdaycal() { ManagerdaycalEntity Model = new ManagerdaycalEntity(); Model.StartDate = DateTime.Today.ToString("dd/MM/yyyy"); Model.EndDate = DateTime.Today.Date.ToString("dd/MM/yyyy"); return View(Model); }
public JsonResult ManagerdaycalList(string startDate = "", string endDate = "", int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { try { try { ManagerdaycalEntity _Model = new ManagerdaycalEntity(); _Model.StartDate = startDate; _Model.EndDate = endDate; DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetManagerdaycalRecord, _Model); List<ManagerdaycalEntity> ItemList = null; ItemList = new List<ManagerdaycalEntity>(); int iCount = 0; int offset = 0; offset = jtStartIndex / jtPageSize; foreach (DataRow dr in dt.Rows) { if (iCount >= jtStartIndex && iCount < (jtPageSize * (offset + 1))) { ItemList.Add(new ManagerdaycalEntity() { EMPID = dr["EMPID"].ToString(), ENAME = dr["ENAME"].ToString(), Designation = dr["Designation"].ToString(), SECTION = dr["SECTION"].ToString(), JDate = dr["JDate"].ToString(), Status = dr["Status"].ToString(), TTDay = dr["TTDay"].ToString(), Holiday = dr["Holiday"].ToString(), Present = dr["Present"].ToString(), Absent = dr["Absent"].ToString(), CL = dr["CL"].ToString(), SL = dr["SL"].ToString(), ML = dr["ML"].ToString(), EL = dr["EL"].ToString(), }); } iCount += 1; } var RecordCount = dt.Rows.Count; var Record = ItemList; Session["MGR"] = ItemList; return Json(new { Result = "OK", Records = Record, TotalRecordCount = RecordCount }); } catch (Exception ex) { return Json(new { Result = "ERROR", Message = ex.Message }); } } catch (Exception ex) { return Json(new { Result = "ERROR", Message = ex.Message }); } }
public ActionResult BDEmployeedaycalrpt() { ManagerdaycalEntity obj; ReportClass rptH = new ReportClass(); ArrayList al = new ArrayList(); rptH.FileName = Server.MapPath("/Reports/BDEmployeedaycalrpt.rpt"); rptH.Load(); List<ManagerdaycalEntity> ItemList = (List<ManagerdaycalEntity>)Session["BDSummary"]; foreach (ManagerdaycalEntity dr in ItemList) { obj = new ManagerdaycalEntity(); obj.EMPID = dr.EMPID; obj.ENAME = dr.ENAME; obj.SECTION = dr.SECTION; obj.JDate = dr.JDate; obj.Status = dr.Status; obj.TTDay = dr.TTDay; obj.Holiday = dr.Holiday; obj.Present = dr.Present; obj.Absent = dr.Absent; obj.CL = dr.CL; obj.SL = dr.SL; obj.ML = dr.ML; obj.EL = dr.EL; al.Add(obj); } rptH.SetDataSource(al); MemoryStream stream = (MemoryStream)rptH.ExportToStream(ExportFormatType.PortableDocFormat); return File(stream, "application/pdf"); }