public JsonResult UpdateAdvanceCreditAndAvailed(LeavePolicy leavePolicy) { MTSHRDataLayer.EmployeeLeave data = new MTSHRDataLayer.EmployeeLeave(); var result = JsonConvert.SerializeObject(data.UpdateAdvanceCreditAndAvailed(leavePolicy.Id, leavePolicy.MaxAllowBal, leavePolicy.ConsecutiveLeave)); return(Json(new { success = result })); }
public JsonResult GetAllEmployeeLeaveList(Leave le) { try { MTSHRDataLayer.EmployeeLeave data_leaves = new MTSHRDataLayer.EmployeeLeave(); DataTable dt = new DataTable(); dt = data_leaves.GetAllEmployeeLeaveList(le.FromDate, le.ToDate, le.EmployeeName); for (int i = 0; i < dt.Rows.Count; i++) { DateTime startdate = Convert.ToDateTime(dt.Rows[i]["FromDate"]); DateTime enddate = Convert.ToDateTime(dt.Rows[i]["ToDate"]); List <DateTime> alldate = returnalldates(startdate, enddate); } return(Json(JsonConvert.SerializeObject(data_leaves.GetAllEmployeeLeaveList(le.FromDate, le.ToDate, le.EmployeeName)))); } catch (Exception ex) { BaseExceptionHandler.HandleException(ref ex); } return(Json(new { success = true })); }
public ActionResult ReadLeavePolicy(string deptID) { MTSHRDataLayer.EmployeeLeave data = new MTSHRDataLayer.EmployeeLeave(); var result = JsonConvert.SerializeObject(data.ReadLeaveType(deptID == "" ?(Int64?)null : Convert.ToInt64(deptID))); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllLeaveType(Int64 empid) { // string empid = Session["UserID"].ToString(); //string department = Session["DepartmentId"].ToString(); //Int64 id = Convert.ToInt64(empid); //Int64 departmentid = Convert.ToInt64(department); MTSHRDataLayer.EmployeeLeave LeaveTypedata = new MTSHRDataLayer.EmployeeLeave(); var LeaveTypes = LeaveTypedata.GetAllLeaveType(empid); List <SelectListItem> LeaveTypelist = new List <SelectListItem>(); try { LeaveTypelist.Add(new SelectListItem() { Value = "0", Text = "----Select LeaveType----" }); for (int i = 0; i < LeaveTypes.Tables[0].Rows.Count; i++) { LeaveTypelist.Add(new SelectListItem() { Value = LeaveTypes.Tables[0].Rows[i]["id"].ToString(), Text = LeaveTypes.Tables[0].Rows[i]["LeaveType"].ToString() }); } } catch (Exception exec) { BaseExceptionHandler.HandleException(ref exec); } ViewBag.LeaveTypes = LeaveTypelist; // return LeaveTypelist; return(Json(new { success = true, LeaveList = JsonConvert.SerializeObject(LeaveTypelist) }, JsonRequestBehavior.AllowGet)); }
public JsonResult AddAdvanceCreditLeave(string EmpId, string Availableleave, string AdvanceCredit, string AdvanceAvailed, string leavetype) { MTSHRDataLayer.EmployeeLeave data = new MTSHRDataLayer.EmployeeLeave(); var result = JsonConvert.SerializeObject(data.AddAdvanceCreditLeave(Convert.ToInt64(EmpId), Availableleave == ""? (Int64)0 : Convert.ToInt64(Availableleave), AdvanceCredit == ""?(Int64)0 : Convert.ToInt64(AdvanceCredit), AdvanceAvailed == "" ? (Int64)0 : Convert.ToInt64(AdvanceAvailed), Convert.ToInt64(leavetype))); return(Json(new { success = result })); }
public List <SelectListItem> GetAllEmployeeNames() { List <SelectListItem> EmployeeNameList = new List <SelectListItem>(); try { string empid = Session["UserID"].ToString(); //string empName = String.Format("{0} {1}", Session["FirstName"].ToString(), Session["LastName"].ToString()); MTSHRDataLayer.EmployeeLeave EmployeeNamedata = new MTSHRDataLayer.EmployeeLeave(); var EmployeeNames = EmployeeNamedata.GetAllEmployeeNames(); EmployeeNameList.Add(new SelectListItem() { Value = "", Text = "----Select Employee----" }); for (int i = 0; i < EmployeeNames.Tables[0].Rows.Count; i++) { string ID = EmployeeNames.Tables[0].Rows[i]["id"].ToString(); EmployeeNameList.Add(new SelectListItem() { Text = EmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), Value = ID }); } //EmployeeNameList.RemoveAt(EmployeeNameList.IndexOf(new SelectListItem() { Value = empid, Text = empName })); } catch (Exception exec) { BaseExceptionHandler.HandleException(ref exec); } return(EmployeeNameList); }
public ActionResult Export(Leave leave) { MTSHRDataLayer.EmployeeLeave data_leaves = new MTSHRDataLayer.EmployeeLeave(); int month = DateTime.ParseExact(leave.Month, "MMMM", System.Globalization.CultureInfo.InvariantCulture).Month; DataTable dt = new DataTable(); return(Json(JsonConvert.SerializeObject(data_leaves.GetApprovedLeaveList(month, leave.Year)))); }
public ActionResult ReadEmployeeLeaveBalance(int?employeeid) { int year = DateTime.Now.Year; MTSHRDataLayer.EmployeeLeave data = new MTSHRDataLayer.EmployeeLeave(); var result = JsonConvert.SerializeObject(data.ReadEmployeeLeaveList(employeeid, false, year)); return(Json(result, JsonRequestBehavior.AllowGet)); }
public int LossOfPayDays(Leave le) { MTSHRDataLayer.EmployeeLeave data_leaves = new MTSHRDataLayer.EmployeeLeave(); int month = DateTime.ParseExact(le.Month, "MMMM", System.Globalization.CultureInfo.InvariantCulture).Month; int result = data_leaves.UpdateLopDays(le.EmployeeName, le.LeaveType, month, le.Year, le.lopDays); return(result); }
public JsonResult GetEmployeeLeaveCount() { MTSHRDataLayer.EmployeeLeave data_contact = new MTSHRDataLayer.EmployeeLeave(); string Employee_Id = Session["UserID"].ToString(); Int64 id = Convert.ToInt64(Employee_Id); DateTime dateTime = DateTime.Now; int year = dateTime.Year; DataSet ds = data_contact.GetEmployeeLeaveDetails(id, false, year); return(Json(new{ result = JsonConvert.SerializeObject(ds.Tables[0]) }, JsonRequestBehavior.AllowGet)); }
public FileResult GetAllEmployeeLeaveList(Leave le) { MTSHRDataLayer.EmployeeLeave data_leaves = new MTSHRDataLayer.EmployeeLeave(); DataTable dt = new DataTable("Grid"); dt = data_leaves.GetAllEmployeeApprovedLeaveList(le.FromDate, le.ToDate, le.EmployeeName); using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt); using (MemoryStream stream = new MemoryStream()) { wb.SaveAs(stream); return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Grid.xlsx")); } } }
public List <SelectListItem> GetAllEmployeeNames() { MTSHRDataLayer.EmployeeLeave EmployeeNamedata = new MTSHRDataLayer.EmployeeLeave(); var EmployeeNames = EmployeeNamedata.GetAllEmployeeNames(); List <SelectListItem> EmployeeNameList = new List <SelectListItem>(); //EmployeeNameList.Insert(0, new SelectListItem() { Value = "0", Text = "----Select Employee NameA----" }); for (int i = 0; i < EmployeeNames.Tables[0].Rows.Count; i++) { EmployeeNameList.Add(new SelectListItem() { Text = EmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), Value = EmployeeNames.Tables[0].Rows[i]["id"].ToString() }); } return(EmployeeNameList.OrderBy(o => o.Text).ToList()); // EmployeeNameList.Insert(0, new SelectListItem() { Value = "0", Text = "----Select ALL----" }); // return EmployeeNameList; }
public ActionResult ShowAllEmployeeDocuments() { string empid = Session["UserID"].ToString(); string roleId = Session["RoleId"].ToString(); MTSHRDataLayer.EmployeeLeave EmployeeNamedata = new MTSHRDataLayer.EmployeeLeave(); var EmployeeNames = EmployeeNamedata.GetActiveEmployeeNames(); List <SelectListItem> EmployeeNameList = new List <SelectListItem>(); EmployeeNameList.Add(new SelectListItem() { Value = "", Text = "----Select Employee----" }); for (int i = 0; i < EmployeeNames.Tables[0].Rows.Count; i++) { string ID = EmployeeNames.Tables[0].Rows[i]["id"].ToString(); if (roleId != "4" && !ID.Equals(empid)) { EmployeeNameList.Add(new SelectListItem() { Text = EmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), Value = ID }); } if (roleId == "4") { EmployeeNameList.Add(new SelectListItem() { Text = EmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), Value = ID }); } } TempData["EmployeeNames"] = EmployeeNameList; var docu = getdocumentname(); ViewBag.EmployeeNameList = EmployeeNameList; ViewBag.Documents = docu; TempData["Documents"] = docu; TempData.Keep("Documents"); return(View()); }