public ActionResult ExcelReport(string EX1="", string EX2="") { AttendanceEntity _Model = new AttendanceEntity(); _Model.StartDate = EX1; _Model.EndDate = EX2; DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetAttenInfoRecord, _Model); StringBuilder sb = new StringBuilder(); sb.Append("<table border='" + "2px" + "'b>"); ////For Header sb.Append("<td><td><td><b><font face=Arial size=2>" + "Attendance Report" + "</font></b></td></td></td>"); //write column headings sb.Append("<tr>"); foreach (System.Data.DataColumn dc in dt.Columns) { sb.Append("<td><b><font face=Arial size=2>" + dc.ColumnName + "</font></b></td>"); } sb.Append("</tr>"); foreach (System.Data.DataRow dr in dt.Rows) { sb.Append("<tr>"); foreach (System.Data.DataColumn dc in dt.Columns) { sb.Append("<td><font face=Arial size=" + "14px" + ">" + dr[dc].ToString() + "</font></td>"); } sb.Append("</tr>"); } ////For Footer sb.Append("<tr>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("<td>"); sb.Append("<td>"); sb.Append("<td>"); sb.Append("<td><b><font face=Arial size=2>" + "Powered By: Hasib, IT Department" + "</font></b></td>"); sb.Append("</td>"); sb.Append("</td>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</tr>"); sb.Append("</table>"); this.Response.ContentType = "application/vnd.ms-excel"; byte[] buffer = System.Text.Encoding.UTF8.GetBytes(sb.ToString()); return File(buffer, "application/vnd.ms-excel", "NorthTower.xls"); }
public JsonResult AttenInfoList(string startDate="", string endDate="", int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { try { try { AttendanceEntity _Model = new AttendanceEntity(); _Model.StartDate = startDate; _Model.EndDate = endDate; DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetAttenInfoRecord, _Model); List<AttendanceEntity> ItemList = null; ItemList = new List<AttendanceEntity>(); 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 AttendanceEntity() { SL = (iCount + 1).ToString(), PDate =dr["PDate"].ToString(), EMPID = dr["EMPID"].ToString(), EName = dr["EName"].ToString(), Designation = dr["Designation"].ToString(), DeptName = dr["DeptName"].ToString(), Intime = dr["Intime"].ToString(), Outtime = dr["Outtime"].ToString(), Status = dr["Status"].ToString(), }); } iCount += 1; } var RecordCount = dt.Rows.Count; var Record = ItemList; Session["opl"] = 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 ReportViewExcel() { AttendanceEntity obj; ReportClass rptH = new ReportClass(); ArrayList al = new ArrayList(); rptH.FileName = Server.MapPath("/Reports/CrystalReport1.rpt"); rptH.Load(); List<AttendanceEntity> ItemList = (List<AttendanceEntity>)Session["opl"]; foreach (AttendanceEntity dr in ItemList) { obj = new AttendanceEntity(); obj.PDate = dr.PDate; obj.EMPID = dr.EMPID; obj.EName = dr.EName; obj.Designation = dr.Designation; obj.DeptName = dr.DeptName; obj.Intime = dr.Intime; obj.Outtime = dr.Outtime; obj.Status = dr.Status; al.Add(obj); } rptH.SetDataSource(al); MemoryStream stream = (MemoryStream)rptH.ExportToStream(ExportFormatType.Excel); return File(stream, "application/octet-stream", "NorthTower.xls"); }
public ActionResult AttenInfo() { AttendanceEntity Model = new AttendanceEntity(); Model.StartDate = DateTime.Today.Date.ToString("dd/MM/yyyy"); Model.EndDate = DateTime.Today.Date.ToString("dd/MM/yyyy"); return View("AttenInfo", Model); }
public ActionResult NorthTowerrptall(string p1 = "", string p2 = "") { AttendanceEntity _Model = new AttendanceEntity(); _Model.StartDate = p1; _Model.EndDate = p2; AttendanceEntity obj; //ReportClass rptH = new ReportClass(); ReportClass rpt = new ReportClass(); ArrayList al = new ArrayList(); rpt.FileName = Server.MapPath("/Reports/CrystalReport1.rpt"); rpt.Load(); DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetAttenInfoRecord, _Model); List<AttendanceEntity> ItemList = null; ItemList = new List<AttendanceEntity>(); // List<NorthTowerdaycal> ItemList = (List<NorthTowerdaycal>)Session["NTR"]; foreach (DataRow dr in dt.Rows) { ItemList.Add(new AttendanceEntity() { PDate = dr["PDate"].ToString(), EMPID = dr["EMPID"].ToString(), EName = dr["EName"].ToString(), Designation = dr["Designation"].ToString(), DeptName = dr["DeptName"].ToString(), Intime = dr["Intime"].ToString(), Outtime = dr["Outtime"].ToString(), Status = dr["Status"].ToString(), }); } foreach (AttendanceEntity dr in ItemList) { obj = new AttendanceEntity(); obj.PDate = dr.PDate; obj.EMPID = dr.EMPID; obj.EName = dr.EName; obj.Designation = dr.Designation; obj.DeptName = dr.DeptName; obj.Intime = dr.Intime; obj.Outtime = dr.Outtime; obj.Status = dr.Status; al.Add(obj); } rpt.SetDataSource(al); MemoryStream stream = (MemoryStream)rpt.ExportToStream(ExportFormatType.Excel); return File(stream, "application/octet-stream", "ManagerAttend.xls"); }