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