Example #1
0
        public tbl_Leaves GetLeavsOBFromLeaveModel(LeaveModel leaveModel)
        {
            var configuration = new MapperConfiguration(cfg => {
                cfg.CreateMap <LeaveModel, tbl_Leaves>();
            });
            IMapper mapper = configuration.CreateMapper();

            Leaves = mapper.Map <LeaveModel, tbl_Leaves>(leaveModel);
            return(Leaves);
        }
Example #2
0
        public LeaveModel GetLeaveModelFromLeavesOB(tbl_Leaves LeavesOB)
        {
            var configuration = new MapperConfiguration(cfg => {
                cfg.CreateMap <tbl_Leaves, LeaveModel>();
            });
            IMapper mapper = configuration.CreateMapper();

            LeaveModel = mapper.Map <tbl_Leaves, LeaveModel>(LeavesOB);
            return(LeaveModel);
        }
Example #3
0
        public LeaveModel GetLeaveByID(int leaveID)
        {
            LeaveModel leaveModel = null;
            tbl_Leaves LeavesOB   = (from lv in _dbContext.tbl_Leaves
                                     where lv.ID == leaveID
                                     select lv
                                     ).FirstOrDefault();

            leaveModel = _leavesMapper.GetLeaveModelFromLeavesOB(LeavesOB);
            return(leaveModel);
        }
Example #4
0
        public bool ApplyLeave(LeaveModel leave)
        {
            try
            {
                tbl_Leaves leavesOB = _leavesMapper.GetLeavsOBFromLeaveModel(leave);
                var        usr      = _userDetailRepository.GetUserDetailByBadgeNumber(leavesOB.BadgeNumber);
                leavesOB.DeptId             = usr.DeptId;
                leavesOB.ManagerBadgeNumber = (int)usr.ManagerBadgeNumber;
                var lv      = _dbContext.tbl_Leaves;
                var dptList = lv == null ? new List <tbl_Leaves>():lv.ToList();
                _dbContext.tbl_Leaves.Add(leavesOB);

                var user = _dbContext.tbl_EmpDetails.Where(e => e.BadgeNumber == leave.BadgeNumber).FirstOrDefault();

                tbl_LeaveMaster leaveMaster    = _dbContext.tbl_LeaveMasters.Where(lm => lm.UserName == user.UserName && lm.LeaveTypeId == leave.LeaveTypeId && lm.Year == DateTime.Now.Year).FirstOrDefault();
                var             usedLeaved     = leaveMaster.UsedLeaves;
                var             balanceLeave   = leaveMaster.BalanceLeave;
                var             allotedLeaves  = leaveMaster.AllotedLeaves;
                var             numberOfLeaves = leave.NumberOfLeaves;

                leaveMaster.UsedLeaves   = (usedLeaved + numberOfLeaves);
                leaveMaster.BalanceLeave = allotedLeaves - (usedLeaved + numberOfLeaves);

                var local = _dbContext.Set <tbl_LeaveMaster>()
                            .Local
                            .FirstOrDefault(entry => entry.LeaveMasterId.Equals(leaveMaster.LeaveMasterId));
                if (local != null)
                {
                    _dbContext.Entry(local).State = EntityState.Detached;
                }
                _dbContext.Entry(leaveMaster).State = EntityState.Modified;
                Save();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }