public void  UpdateApproveStatus(Requisition requisition, string comments, int?approvedbyId)
        {
            requisition.RequisitionStatus = "Approved";
            requisition.Comment           = comments;
            requisition.ApprovedDate      = DateTime.Today.Date;
            requisition.ApprovedBy        = approvedbyId;

            db.Entry(requisition).State = EntityState.Modified;
            db.SaveChanges();

            string reqListId = requisition.RequisitionId.ToString();

            notify.NewRequisitonMade(reqListId);
            try
            {
                string emailBody = requisition.Employee.EmployeeName + ", your requisition dated " + requisition.OrderedDate.Value.Date.ToString("dd/MM/yyyy") + " has been approved. Please go to http://" + uSvc.GetBaseUrl() + "/Stationery/Requisition/" + requisition.RequisitionId + " for more information.";
                uSvc.SendEmail(new List <string>(new string[] { requisition.Employee.Email }), "Approved Requisition", emailBody);
            }
            catch (Exception e)
            {
                System.Diagnostics.Debug.WriteLine(e.ToString());
            }
        }