public ActionResult Add(CareGiverViewModel model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    model.Email = model.Email.Trim();
                    var checkAttendent = _dbContext.tbl_Attendants.Where(w => w.Email == model.Email).FirstOrDefault();
                    if (checkAttendent == null)
                    {
                        checkAttendent = _dbContext.tbl_Attendants.Where(w => w.EmployeeNo == model.EmployeeNo).FirstOrDefault();
                        if (checkAttendent == null)
                        {
                            Attendant attendant = new Attendant()
                            {
                                FirstName   = model.FirstName,
                                MiddleName  = model.MiddleName,
                                LastName    = model.LastName,
                                EmployeeNo  = model.EmployeeNo,
                                Email       = model.Email,
                                CreatedDate = DateTime.Now,
                                CreatedBy   = UserId,
                                HrGroupId   = model.HrGroupId
                            };

                            _dbContext.tbl_Attendants.Add(attendant);
                            _dbContext.SaveChanges();

                            ViewBag.SuccessMessage = "Care Giver added successfully";
                        }
                        else
                        {
                            ViewBag.ErrorMessage = "Employee no is already exists";
                        }
                    }
                    else
                    {
                        ViewBag.ErrorMessage = "Email is already exists";
                    }
                }
            }
            catch (Exception ex)
            {
            }

            model.HrGroupList = _dbContext.tbl_HrGroups.Where(w => w.IsActive == true)
                                .Select(s => new HrGroupViewModel
            {
                Id   = s.Id,
                Name = s.Name
            }).ToList();

            return(View(model));
        }
        public ActionResult Add()
        {
            CareGiverViewModel careGiver = new CareGiverViewModel();

            careGiver.HrGroupList = _dbContext.tbl_HrGroups.Where(w => w.IsActive == true)
                                    .Select(s => new HrGroupViewModel
            {
                Id   = s.Id,
                Name = s.Name
            }).ToList();
            return(View(careGiver));
        }
        public ActionResult Edit(CareGiverViewModel model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    model.Email = model.Email.Trim();
                    var checkAttendent = _dbContext.tbl_Attendants.Where(w => w.Email == model.Email && w.Id != model.Id).FirstOrDefault();
                    if (checkAttendent == null)
                    {
                        checkAttendent = _dbContext.tbl_Attendants.Where(w => w.EmployeeNo == model.EmployeeNo && w.Id != model.Id).FirstOrDefault();
                        if (checkAttendent == null)
                        {
                            checkAttendent = _dbContext.tbl_Attendants.Where(w => w.Id == model.Id).FirstOrDefault();

                            checkAttendent.FirstName  = model.FirstName;
                            checkAttendent.LastName   = model.LastName;
                            checkAttendent.MiddleName = model.MiddleName;
                            checkAttendent.Email      = model.Email;
                            checkAttendent.HrGroupId  = model.HrGroupId;
                            checkAttendent.EmployeeNo = model.EmployeeNo;

                            _dbContext.SaveChanges();

                            ViewBag.SuccessMessage = "Care Giver updated successfully";
                        }
                        else
                        {
                            ViewBag.ErrorMessage = "Employee no is already exists";
                        }
                    }
                    else
                    {
                        ViewBag.ErrorMessage = "Email is already exists";
                    }
                }
            }
            catch (Exception ex)
            {
            }

            model.HrGroupList = _dbContext.tbl_HrGroups.Where(w => w.IsActive == true)
                                .Select(s => new HrGroupViewModel
            {
                Id   = s.Id,
                Name = s.Name
            }).ToList();

            return(View(model));
        }
        public ActionResult Edit(int id)
        {
            CareGiverViewModel model = new CareGiverViewModel();
            var checkCareGiver       = _dbContext.tbl_Attendants.Where(w => w.Id == id).FirstOrDefault();

            model.HrGroupList = _dbContext.tbl_HrGroups.Where(w => w.IsActive == true)
                                .Select(s => new HrGroupViewModel
            {
                Id   = s.Id,
                Name = s.Name
            }).ToList();

            model.FirstName  = checkCareGiver.FirstName;
            model.LastName   = checkCareGiver.LastName;
            model.MiddleName = checkCareGiver.MiddleName;
            model.Email      = checkCareGiver.Email;
            model.HrGroupId  = checkCareGiver.HrGroupId ?? 0;
            model.Id         = checkCareGiver.Id;
            model.EmployeeNo = checkCareGiver.EmployeeNo;

            return(View(model));
        }