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();
}
