private void UpdateRequest(object parameter)
        {
            if (ValidateRequestId(RequestId))
            {
                using (KongBuBankEntities db = new KongBuBankEntities())
                {
                    SalaryRaiseRequest request = db.SalaryRaiseRequests.Find(RequestId);
                    if (Selected)
                    {
                        //Approve raise
                        Employee employee = db.Employees.Find(request.EmployeeId);
                        employee.Salary += request.Amount;

                        request.IsApproved = "Accepted";

                        MessageBox.Show("Salary Raise Request Accepted!", "Success");
                    }
                    else
                    {
                        request.IsApproved = "Rejected";
                        MessageBox.Show("Salary Raise Request Rejected!", "Rejected");
                    }
                    RequestId = null;
                    db.SaveChanges();
                    LoadDataGrid();
                }
            }
        }
        private void Submit(object parameter)
        {
            if (IsEmployeeValid(EmployeeId))
            {
                if (RaiseAmount > 0)
                {
                    using (KongBuBankEntities db = new KongBuBankEntities())
                    {
                        SalaryRaiseRequest request = new SalaryRaiseRequest();
                        request.RequestId   = "SR" + IdFormat(Count("SalaryRaiseRequest") + 1);
                        request.EmployeeId  = EmployeeId;
                        request.Amount      = RaiseAmount;
                        request.IsApproved  = "Pending";
                        request.RequestDate = DateTime.Now;

                        db.SalaryRaiseRequests.Add(request);
                        db.SaveChanges();

                        MessageBox.Show("Salary Raise Request Sent!", "Success");
                        EmployeeId  = null;
                        RaiseAmount = 0;
                    }
                }
            }
        }
 private bool ValidateRequestId(string _requestId)
 {
     using (KongBuBankEntities db = new KongBuBankEntities())
     {
         SalaryRaiseRequest request = db.SalaryRaiseRequests.Find(_requestId);
         if (request == null)
         {
             MessageBox.Show("Salary Request not found!", "Error");
             return(false);
         }
         else
         {
             if (request.IsApproved != "Pending")
             {
                 MessageBox.Show("Salary Request already processed!", "Error");
                 return(false);
             }
         }
         return(true);
     }
 }