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