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