public RedirectToRouteResult Update(Review_Details reviewDetail)
        {
            if (reviewDetail.Reviewername == reviewDetail.Revieweename)
            {
                TempData["Message"] = "Reviewer and Reviewee should not be same";
                return(RedirectToAction("DisplayMessages"));
            }
            int count = reviewDetailsBL.CheckLogic(reviewDetail);

            if (count == -5)
            {
                TempData["Message"] = "Already a review is scheduled on that day for reviewee";
                return(RedirectToAction("DisplayMessages"));
            }
            else if (count == -4)
            {
                TempData["Message"] = "Already a review is scheduled on that day for reviewer";
                return(RedirectToAction("DisplayMessages"));
            }
            else if (count == 0)
            {
                reviewDetailsBL.UpdateReview(reviewDetail);
            }
            return(RedirectToAction("DisplayReviewDetails"));
        }
        public ActionResult Edit(int id)
        {
            Review_Details reviewDetail = reviewDetailsBL.GetReviewDetailsById(id);
            //ViewBag.Departments = new SelectList(departmentBL.GetDepartments(), "DepartmentID", "DepartmentName");
            //ViewBag.Designation = new SelectList(designationBL.GetDesignations(), "DesignationID", "DesignationName");
            List <SelectListItem>  reviewerDepartments    = new List <SelectListItem>();
            ReviewDetailsViewModel reviewDetailsViewModel = new ReviewDetailsViewModel();

            List <Departments> states = departmentBL.GetDepartments();

            states.ForEach(x =>
            {
                reviewerDepartments.Add(new SelectListItem {
                    Text = x.DepartmentName, Value = x.DepartmentId.ToString()
                });
            });
            ViewBag.Departments = new SelectList(departmentBL.GetDepartments(), "DepartmentID", "DepartmentName");
            reviewDetailsViewModel.Departments = reviewerDepartments;
            ReviewDetailsViewModel employeeViewModel = new ReviewDetailsViewModel();

            // employeeViewModel = AutoMapper.Mapper.Map<ReviewDetail, ReviewDetailsViewModel>(reviewDetail);
            employeeViewModel.Id                    = reviewDetail.Id;
            employeeViewModel.Reviewername          = reviewDetail.Reviewername;
            employeeViewModel.ReviewerDesignationId = reviewDetail.ReviewerDesignationId;
            employeeViewModel.ReviewerDepartmentId  = reviewDetail.ReviewerDepartmentId;
            employeeViewModel.Revieweename          = reviewDetail.Revieweename;
            employeeViewModel.RevieweeDesignationId = reviewDetail.RevieweeDesignationId;
            employeeViewModel.RevieweeDepartmentId  = reviewDetail.RevieweeDepartmentId;
            employeeViewModel.Date                  = reviewDetail.Date;
            return(View(employeeViewModel));
        }
        //Method to add review details
        public int Add(Review_Details reviewDetail)
        {
            int count = 0;
            IList <Review_Details> li     = null;
            List <Review_Details>  review = null;

            using (EmployeeContext employeeContext = new EmployeeContext())
            {
                review = employeeContext.Review_Detail.ToList();

                li = review.FindAll(p => (p.Revieweename == reviewDetail.Reviewername && p.Date == reviewDetail.Date));
                if (li.Count != 0)
                {
                    count = -4;
                    return(count);
                }
                li = review.FindAll(p => (p.Revieweename == reviewDetail.Revieweename && p.Date == reviewDetail.Date));
                if (li.Count != 0)
                {
                    count = -5;
                    return(count);
                }
                li = review.FindAll(p => (p.Reviewername == reviewDetail.Revieweename && p.Date == reviewDetail.Date));
                if (li.Count != 0)
                {
                    count = -5;
                    return(count);
                }
                employeeContext.Entry(reviewDetail).State = EntityState.Added;
                count = employeeContext.SaveChanges();
                return(count);
            }
        }
        //Method to check the logix to schedule review details
        public int CheckLogic(Review_Details reviewDetail)
        {
            int count = 0;
            IList <Review_Details> li     = null;
            List <Review_Details>  review = null;

            using (EmployeeContext employeeContext = new EmployeeContext())
            {
                review = employeeContext.Review_Detail.ToList();

                li = review.FindAll(p => (p.Revieweename == reviewDetail.Reviewername && p.Date == reviewDetail.Date));
                if (li.Count != 0)
                {
                    count = -4;
                    return(count);
                }
                li = review.FindAll(p => (p.Revieweename == reviewDetail.Revieweename && p.Date == reviewDetail.Date));
                if (li.Count != 0)
                {
                    count = -5;
                    return(count);
                }
                li = review.FindAll(p => (p.Reviewername == reviewDetail.Revieweename && p.Date == reviewDetail.Date));
                if (li.Count != 0)
                {
                    count = -5;
                    return(count);
                }
                return(count);
            }
        }
 //Method to update review details
 public bool UpdateReview(Review_Details reviewDetail)
 {
     using (EmployeeContext employeeContext = new EmployeeContext())
     {
         employeeContext.Entry(reviewDetail).State = EntityState.Modified;
         employeeContext.SaveChanges();
         return(true);
     }
 }
        //Method to delete review details
        public void Delete(int employeeId)
        {
            using (EmployeeContext employeeContext = new EmployeeContext())
            {
                Review_Details reviewDetail = GetReviewDetailsById(employeeId);

                employeeContext.Entry(reviewDetail).State = EntityState.Deleted;
                employeeContext.SaveChanges();
                //SqlParameter sqlEmployee = new SqlParameter("@Id", employee.Id);
                //employeeContext.Database.ExecuteSqlCommand("Employee_Delete @Id", sqlEmployee);
                //SqlParameter sqlAccount = new SqlParameter("@AccountId", accountdetails.AccountId);
                //employeeContext.Database.ExecuteSqlCommand("AccountDetails_Delete @AccountId", sqlAccount);
            }
        }
        public ActionResult Index(FormCollection form)
        {
            if (ModelState.IsValid)
            {
                int      revieweeDesignationId = Convert.ToInt32(form["RevieweeDesignationId"]);
                int      reviewerDepartmentId  = Convert.ToInt32(form["ReviewerDepartmentId"]);
                int      revieweeDepartmentId  = Convert.ToInt32(form["RevieweeDepartmentId"]);
                string   reviewerName          = (form["ReviewerName"]).ToString();
                int      reviewerDesignationId = Convert.ToInt32(form["ReviewerDesignationId"]);
                string   revieweeName          = (form["RevieweeName"]).ToString();
                DateTime date = Convert.ToDateTime(form["Date"]);


                Review_Details reviewDetail = new Review_Details();
                reviewDetail.Reviewername          = reviewerName;
                reviewDetail.Revieweename          = revieweeName;
                reviewDetail.ReviewerDesignationId = reviewerDesignationId;
                reviewDetail.ReviewerDepartmentId  = reviewerDepartmentId;
                reviewDetail.RevieweeDesignationId = revieweeDesignationId;
                reviewDetail.RevieweeDepartmentId  = revieweeDepartmentId;
                reviewDetail.Date = date;

                if (reviewerName == revieweeName)
                {
                    TempData["Message"] = "Reviewer and Reviewee should not be same";
                    return(RedirectToAction("DisplayMessages"));
                }
                int count = reviewDetailsBL.Add(reviewDetail);
                if (count == -5)
                {
                    TempData["Message"] = "Already a review is scheduled on that day for reviewee";
                    return(RedirectToAction("DisplayMessages"));
                }
                else if (count == -4)
                {
                    TempData["Message"] = "Already a review is scheduled on that day for reviewer";
                    return(RedirectToAction("DisplayMessages"));
                }

                else if (count != 0)
                {
                    return(RedirectToAction("DisplayReviewDetails", reviewDetail));
                }
            }
            return(RedirectToAction("ScheduleReview"));
        }
Exemplo n.º 8
0
 public bool UpdateReview(Review_Details reviewDetail)
 {
     return(reviewDetailsRepositary.UpdateReview(reviewDetail));
 }
Exemplo n.º 9
0
 public int CheckLogic(Review_Details reviewDetail)
 {
     return(reviewDetailsRepositary.CheckLogic(reviewDetail));
 }
Exemplo n.º 10
0
        //public int AddReviewDetails(int reviewerDepartmentId,int reviewerDesignationId, int reviewerName,int revieweeDepartmentId,int revieweeDesignationId, int revieweeName,DateTime date)
        //{
        //    return reviewDetailsRepositary.AddReviewDetails(reviewerDepartmentId, reviewerDesignationId, reviewerName, revieweeDepartmentId, revieweeDesignationId, revieweeName,date);
        //}

        public int Add(Review_Details reviewDetail)
        {
            return(reviewDetailsRepositary.Add(reviewDetail));
        }