public bool InsertEmployeeLeaveDetails(int leaveType, string fromDate, string toDate, string comments, int workingDays) { var result = false; try { using (var ctx = new LeaveManagementSystemEntities1()) { var employeeLeaveDetails = new EmployeeLeaveTransaction { EmployeeComment = comments, FromDate = Convert.ToDateTime(fromDate), ToDate = Convert.ToDateTime(toDate), CreatedDate = DateTime.Now, NumberOfWorkingDays = workingDays, RefLeaveType = leaveType, RefStatus = (int)LeaveStatus.Planned, RefEmployeeId = 1, CreatedBy = "Alekya" }; ctx.EmployeeLeaveTransactions.Add(employeeLeaveDetails); ctx.SaveChanges(); } result = true; } catch (Exception ex) { throw; } return(result); }
public List <string> GetLeaveType() { using (var ctx = new LeaveManagementSystemEntities1()) { //var leavetypeid = (from s in ctx.MasterDataTypes // where s.Type=="LeaveType" // select s).SingleOrDefault(); var leaveType = ctx.MasterDataValues.Where(x => x.RefMasterType == 3).Select(x => x.Value).ToList(); return(leaveType); } }
public List <Announcement> GetAnnouncements() { try { using (var ctx = new LeaveManagementSystemEntities1()) { var announcements = ctx.Announcements.Where(x => x.IsActive == true).ToList(); return(announcements); } } catch (Exception ex) { throw ex; } }
public EmployeeDetail GetUserProfileDetails(int employeeId) { try { using (var ctx = new LeaveManagementSystemEntities1()) { var profileDetails = ctx.EmployeeDetails.Include("EmployeeEducationDetails").Include("EmployeeExperienceDetails").Include("UserAccounts").FirstOrDefault(i => i.Id == employeeId); return(profileDetails); } } catch (Exception ex) { throw ex; } }
public List <EmployeeLeaveTransactionModel> GetEmployeeLeaveTransaction(int id) { using (var ctx = new LeaveManagementSystemEntities1()) { var EmployeeLeaveTransactions = ctx.EmployeeLeaveTransactions.Where(m => m.RefEmployeeId == id).ToList(); var retResult = ToModel(EmployeeLeaveTransactions); if (retResult != null) { return(retResult); } else { return(null); } } }
public EmployeeCommon GetUserDetails(int UserEmpId) { try { using (var ctx = new LeaveManagementSystemEntities1()) { var empDetails = (from n in ctx.EmployeeDetails where n.Id == UserEmpId select new EmployeeCommon() { Id = n.Id, Name = n.FirstName, ManagerId = n.ManagerId, Experience = n.Experience, RoleName = n.MasterDataValue.Value, DateOfJoining = n.DateOfJoining, }).FirstOrDefault(); if (null != empDetails) { var LeaveType = ctx.LeaveMasters.ToList(); empDetails.TotalLeaveCount = LeaveType.Sum(q => q.Count); empDetails.TotalCountTaken = (from c in ctx.EmployeeLeaveTransactions where c.RefEmployeeId == UserEmpId select c.NumberOfWorkingDays).ToList().Sum(); var empdata = (from n in ctx.EmployeeProjectDetails where n.RefEmployeeId == UserEmpId select n).SingleOrDefault(); empDetails.ProjectName = empdata.MasterDataValue.Value; empDetails.ManagerName = (from n in ctx.EmployeeDetails where n.Id == empDetails.ManagerId select n.FirstName).SingleOrDefault(); return(empDetails); } else { return(null); } } } catch (Exception ex) { throw ex; } }
public bool DeleteLeaveRequest(int id) { var result = false; try { using (var ctx = new LeaveManagementSystemEntities1()) { var leaveDetails = ctx.EmployeeLeaveTransactions.FirstOrDefault(x => x.Id == id); ctx.EmployeeLeaveTransactions.Remove(leaveDetails); ctx.SaveChanges(); } result = true; } catch (Exception ex) { throw; } return(result); }
public bool SubmitLeaveForApproval(int id) { var result = false; try { using (var ctx = new LeaveManagementSystemEntities1()) { var leaveDetails = ctx.EmployeeLeaveTransactions.FirstOrDefault(x => x.Id == id); leaveDetails.RefStatus = (int)LeaveStatus.Submitted; ctx.SaveChanges(); } result = true; } catch (Exception ex) { throw; } return(result); }
public UserAccount GetUser(string emailId, string password) { try { using (var ctx = new LeaveManagementSystemEntities1()) { var userData = ctx.UserAccounts.Include("EmployeeDetail").FirstOrDefault(x => x.UserName == emailId && x.Password == password); //var userData = (from c in ctx.UserAccounts // where c.UserName == emailId && c.Password == password // select c).FirstOrDefault(); if (userData != null) { return(userData); } return(null); } } catch (System.Exception ex) { throw ex; } }
public LeaveReportModel GetLeaveReportDetails(int employeeId, int year) { try { var leaveReport = new LeaveReportModel(); using (var ctx = new LeaveManagementSystemEntities1()) { var years = ctx.EmployeeLeaveTransactions.Where(i => i.RefEmployeeId == employeeId && i.FromDate.Year == year && i.ToDate.Year == year).ToList(); foreach (var item in years) { for (DateTime date = item.FromDate; date <= item.ToDate; date = date.AddDays(1)) { if (date.DayOfWeek != DayOfWeek.Saturday && date.DayOfWeek != DayOfWeek.Sunday) { switch (date.Month) { case 1: leaveReport.Jan++; break; case 2: leaveReport.Feb++; break; case 3: leaveReport.Mar++; break; case 4: leaveReport.Apr++; break; case 5: leaveReport.May++; break; case 6: leaveReport.Jun++; break; case 7: leaveReport.Jul++; break; case 8: leaveReport.Aug++; break; case 9: leaveReport.Sep++; break; case 10: leaveReport.Oct++; break; case 11: leaveReport.Nov++; break; case 12: leaveReport.Dec++; break; } } } } //var Year = new SqlParameter("@Year", 2016); //var data= ctx.Database.SqlQuery<LeaveReportModel>("dbo.GetLeaveReportProcedure @Year", Year).ToList(); return(leaveReport); } } catch (Exception ex) { throw ex; } }