public ActionResult BDDept() { BDEmployeeEntity _Model = new BDEmployeeEntity(); ViewData["DeptName"] = GetAllDepatementListItem(); _Model.StartDate = DateTime.Today.ToString("dd/MM/yyyy"); _Model.EndDate = DateTime.Today.Date.ToString("dd/MM/yyyy"); return View(_Model); }
public JsonResult BDDeptList(string startDate = "", string endDate = "", string DeptName = "", int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { try { try { BDEmployeeEntity _Model = new BDEmployeeEntity(); _Model.DeptName = DeptName; _Model.StartDate = startDate; _Model.EndDate = endDate; DataTable dt = (DataTable)ExecuteDB(ERPTask.AG_GetBDDeptRecord, _Model); List<BDEmployeeEntity> ItemList = null; ItemList = new List<BDEmployeeEntity>(); 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 BDEmployeeEntity() { 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["BDDept"] = 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 BDEmployeewise() { BDEmployeeEntity _Model = new BDEmployeeEntity(); ViewData["EMPID"] = GetAllBDEmployeewiseListItem(); _Model.StartDate = DateTime.Today.ToString("dd/MM/yyyy"); _Model.EndDate = DateTime.Today.Date.ToString("dd/MM/yyyy"); return View(_Model); }