public static void Create(MaterialsSet model) { if (!model.MaterialsTypeId.HasValue) { throw new Exception("Column MaterialsTypeId could not be null"); } if (!model.OrderId.HasValue) { throw new Exception("Column OrderId could not be null"); } MaterialsSet materialsSet = db.MaterialsSets.FirstOrDefault(rec => rec.Id == model.Id); if (materialsSet != null) { Update( new MaterialsSet() { Id = materialsSet.Id, Count = materialsSet.Count + model.Count }); return; } db.MaterialsSets.Add( new MaterialsSet() { Count = model.Count, MaterialsTypeId = model.MaterialsTypeId, OrderId = model.OrderId }); db.SaveChanges(); }
private static void Update(MaterialsSet model) { MaterialsSet materialsSet = db.MaterialsSets.FirstOrDefault(rec => rec.Id == model.Id); materialsSet.Count = model.Count; db.SaveChanges(); }
private void printTimeMaterials() { Console.WriteLine("Time: " + repairDock.CountRepairTime(damageLevel)); Console.WriteLine("Materials: "); MaterialsSet materials = repairDock.CountRepairMaterials(damageLevel); materials.printMaterials(); }
public static List <MaterialsSet> Read(MaterialsSet model, int pageSize = Int32.MaxValue, int currentPage = 0) { List <MaterialsSet> answer = null; if (model.OrderId.HasValue && model.MaterialsTypeId.HasValue) { answer = answer = db.MaterialsSets .Where(rec => rec.OrderId == model.OrderId && rec.MaterialsTypeId == model.MaterialsTypeId) .Include(rec => rec.MaterialsType) .Include(rec => rec.Order) .Skip(pageSize * currentPage) .Take(pageSize) .ToList(); } else if (model.OrderId.HasValue && !model.MaterialsTypeId.HasValue) { answer = db.MaterialsSets .Where(rec => rec.OrderId == model.OrderId) .Include(rec => rec.MaterialsType) .Include(rec => rec.Order) .Skip(pageSize * currentPage) .Take(pageSize) .ToList(); } else if (!model.OrderId.HasValue && model.MaterialsTypeId.HasValue) { answer = db.MaterialsSets .Where(rec => rec.MaterialsTypeId == model.MaterialsTypeId) .Include(rec => rec.MaterialsType) .Include(rec => rec.Order) .Skip(pageSize * currentPage) .Take(pageSize) .ToList(); } else { answer = db.MaterialsSets .Include(rec => rec.MaterialsType) .Include(rec => rec.Order) .Skip(pageSize * currentPage) .Take(pageSize) .ToList(); } return(answer); }
public static void Delete(MaterialsSet model) { List <MaterialsSet> materialsSets = null; if (model.OrderId.HasValue && model.MaterialsTypeId.HasValue) { materialsSets = db.MaterialsSets .Where(rec => rec.OrderId == model.OrderId && rec.MaterialsTypeId == model.MaterialsTypeId) .ToList(); } else if (model.OrderId.HasValue && !model.MaterialsTypeId.HasValue) { materialsSets = db.MaterialsSets .Where(rec => rec.OrderId == model.OrderId) .ToList(); } else if (!model.OrderId.HasValue && model.MaterialsTypeId.HasValue) { materialsSets = db.MaterialsSets .Where(rec => rec.MaterialsTypeId == model.MaterialsTypeId) .ToList(); } else { materialsSets = db.MaterialsSets .Where(rec => rec.Id == model.Id) .ToList(); } db.MaterialsSets.RemoveRange(materialsSets); db.SaveChanges(); }