public JsonResult NorthtowerDeptList(string startDate = "", string endDate = "", string DeptName = "", int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
try
{
EmployeewiseEntity _Model = new EmployeewiseEntity();
_Model.DeptName = DeptName;
_Model.StartDate = startDate;
_Model.EndDate = endDate;
DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetNTDeptRecord, _Model);
List<EmployeewiseEntity> ItemList = null;
ItemList = new List<EmployeewiseEntity>();
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 EmployeewiseEntity()
{
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["NTDept"] = 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 NorthtowerDept()
{
EmployeewiseEntity iDEPTWise = new EmployeewiseEntity();
ViewData["DeptName"] = GetAllDepatementListItem();
iDEPTWise.StartDate = DateTime.Today.Date.ToString("dd/MM/yyyy");
iDEPTWise.EndDate = DateTime.Today.Date.ToString("dd/MM/yyyy");
return View("NorthtowerDept", iDEPTWise);
}
public ActionResult EmployeeWise()
{
EmployeewiseEntity iEMPWise = new EmployeewiseEntity();
ViewData["EMPID"] = GetAllEmployeewiseListItem();
//iEMPWise.EMPID = frm["DropDown"]; *Pass value as Parameter: EmployeeWise(string Empid, FormCollection frm)
//iEMPWise.EMPID = Request["DropDown"];
//iEMPWise.EMPID = ID;
iEMPWise.StartDate = DateTime.Today.Date.ToString("dd/MM/yyyy");
iEMPWise.EndDate = DateTime.Today.Date.ToString("dd/MM/yyyy");
return View("EmployeeWise", iEMPWise);
}
//public ActionResult NTEMPExcelReport(string EX1 = "", string EX2 = "", string EX3 = "")
//{
// EmployeewiseEntity _Model = new EmployeewiseEntity();
// _Model.StartDate = EX1;
// _Model.EndDate = EX2;
// _Model.EMPID = EX3;
// DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetEmployeewiseRecord, _Model);
// StringBuilder sb = new StringBuilder();
// sb.Append("<table border='" + "2px" + "'b>");
// //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>");
// }
// sb.Append("</table>");
// //this.Response.AddHeader("Content-Disposition", "Employees.xls");
// 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 ActionResult NTEMPExcelReport(string EX1 = "", string EX2 = "", string EX3 = "")
{
EmployeewiseEntity _Model = new EmployeewiseEntity();
_Model.StartDate = EX1;
_Model.EndDate = EX2;
_Model.EMPID = EX3;
DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetEmployeewiseRecord, _Model);
ERP.Utility.Excelimport.ExcelFileResult actionResult = new ERP.Utility.Excelimport.ExcelFileResult(dt) { FileDownloadName = "NTEmployeeWise.xls" };
return actionResult;
}
public ActionResult EmployeeWiserptExcel()
{
EmployeewiseEntity obj;
ReportClass rptH = new ReportClass();
ArrayList al = new ArrayList();
rptH.FileName = Server.MapPath("/Reports/EmployeeWiserpt.rpt");
rptH.Load();
List<EmployeewiseEntity> ItemList = (List<EmployeewiseEntity>)Session["EMPWISE"];
foreach (EmployeewiseEntity dr in ItemList)
{
obj = new EmployeewiseEntity();
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); //For Excel File
return File(stream, "application/octet-stream", "NorthTower.xls"); //For Excel with File Name
}