public static void Update(Operation operation)
 {
     Operation inDbOperation;
     using (var context = new WorkLoadDatabaseEntity())
     {
         inDbOperation = (from s in context.Operations
                          where s.OpId == operation.OpId
                          select s).FirstOrDefault();
         if (operation.OpDesc != null)
         {
             inDbOperation.OpDesc = operation.OpDesc;
         }
         if (operation.OpStatus != null)
         {
             inDbOperation.OpStatus = operation.OpStatus;
         }
         if (operation.OpCompletionDate != null)
         {
             inDbOperation.OpCompletionDate = operation.OpCompletionDate;
         }
         if (operation.WONumber != null)
         {
             inDbOperation.WONumber = operation.WONumber;
         }
         context.SaveChanges();
     }
 }
 public static void Add(Operation operation)
 {
     using (var context = new WorkLoadDatabaseEntity())
     {
         try
         {
             context.Operations.Add(operation);
             context.SaveChanges();
         }
         catch (Exception ex)
         {
             throw;
         }
     }
 }