public void saveRequestInfo(String eId, DateTime dc, string rs, string rc, DateTime du)
        {
            Request r = new Request();

            r.EmployeeID    = eId;
            r.DateCreated   = dc;
            r.RequestStatus = rs;
            r.Comments      = rc;
            r.DateUpdated   = du;
            r.DeletedFlag   = false;

            context.AddToRequests(r);
            context.SaveChanges();
        }
        /** create new stationery request for outstanding quantity **/
        public void createRequest(String departmentName)
        {
            var q = (from d in context.Departments
                     where d.DeptName.Equals(departmentName)
                     select d).FirstOrDefault();

            Request addRequest = new Request();

            addRequest.EmployeeID    = q.DeptRep;
            addRequest.DateCreated   = DateTime.Now;
            addRequest.DateUpdated   = DateTime.Now;
            addRequest.RequestStatus = "Outstanding";
            addRequest.DeletedFlag   = false;
            context.AddToRequests(addRequest);
            context.SaveChanges();
        }