public Category UpdateCategory(Category _s)
        {
            try
            {
                var numberOfUpdated = 0;
                using (var context = new ProjectManagementEntities())
                {
                    var Category = context.Category.FirstOrDefault(x => x.Id == _s.Id);

                    if (Category != null)
                    {
                        Category.Name      = _s.Name;
                        Category.ProjectId = _s.ProjectId;
                        Category.Status    = _s.Status;
                        numberOfUpdated    = context.SaveChanges();
                        return(numberOfUpdated > 0 ? _s : null);
                    }
                    return(null);
                }
            }
            catch (System.Exception exc)
            {
                throw exc;
            }
        }
 public Category SaveCategory(Category _Category)
 {
     try
     {
         using (var context = new ProjectManagementEntities())
         {
             context.Category.Add(_Category);
             int numberOfInserted = context.SaveChanges();
             return(numberOfInserted > 0 ? _Category : null);
         }
     }
     catch (System.Exception exc)
     {
         throw exc;
     }
 }