public WorkOrder Update(WorkOrder workorder) { var context = new CammContext(); WorkOrder targetItem = context.WorkOrders.Find(workorder.WoNumber); if (targetItem != null) { targetItem.AssemblyNumber = workorder.AssemblyNumber; targetItem.Customer = workorder.Customer; targetItem.CustomerPO = workorder.CustomerPO; targetItem.DueDate = workorder.DueDate; targetItem.QuantityToBuild = workorder.QuantityToBuild; targetItem.SalesOrder = workorder.SalesOrder; targetItem.SalesOrderLineItemNo = workorder.SalesOrderLineItemNo; targetItem.WoStatus = workorder.WoStatus; targetItem.TimeStamp = DateTime.Now; } else { throw new Exception("WorkOrder with WoNumber " + workorder.WoNumber + " not found."); } context.SaveChanges(); return(targetItem); }
public WorkOrder Add(WorkOrder workOrder) { var context = new CammContext(); var keyViolation = context.WorkOrders.Find(workOrder.WoNumber); if (keyViolation != null) { throw new Exception("Duplicate WoNumber"); } var WO = context.WorkOrders.Add(workOrder); try { var result = context.SaveChanges(); if (result == 1) { return(WO); } else { throw new Exception("Save failed for an unknown reason."); }; } catch (Exception ex) { throw new Exception("Save failed. " + ex.InnerException.InnerException); } }
public int Remove(string woNumber) { var context = new CammContext(); WorkOrder unwanted = context.WorkOrders.Find(woNumber); try { context.WorkOrders.Remove(unwanted); var result = context.SaveChanges(); return(result); } catch (Exception) { return(0); } }