public Order Create(string userId,
string purpose,
string deliveryAddress,
string receiverName,
string carrierName,
string driverName,
string vehicleNumber)
{
var town = deliveryAddress.Split(", ", StringSplitOptions.RemoveEmptyEntries)[0];
var street = deliveryAddress.Split(", ", StringSplitOptions.RemoveEmptyEntries)[1];
OrderPurpose deliveryPurpose = Enum.Parse <OrderPurpose>(purpose);
DeliveryAddress address = _context.DeliveryAddresses.FirstOrDefault(x => x.Town == town && x.Street == street);
Receiver receiver = _context.Receivers.FirstOrDefault(x => x.Name == receiverName);
Carrier carrier = _context.Carriers.FirstOrDefault(x => x.Name == carrierName);
Driver driver = _context.Drivers.FirstOrDefault(x => x.FullName == driverName && x.CarrierId == carrier.Id);
Vehicle vehicle = _context.Vehicles.FirstOrDefault(x => x.RegNumber == vehicleNumber && x.CarrierId == carrier.Id);
var order = new Order()
{
CreatedOn = DateTime.UtcNow,
Purpose = deliveryPurpose,
Status = OrderStatus.Uncompleted,
OilsUserId = userId,
DeliveryAddress = address,
Receiver = receiver,
Carrier = carrier,
Driver = driver,
Vehicle = vehicle
};
_context.Orders.Add(order);
_context.SaveChanges();
return(order);
}
public Carrier Edit(Carrier carrier)
{
_context.Update(carrier);
_context.SaveChanges();
return(carrier);
}
public Delivery Create(string deliveryDate, string supplierName, string serialNumber)
{
var supplier = _context.Suppliers.SingleOrDefault(x => x.Name == supplierName);
var lot = _context.Lots.SingleOrDefault(x => x.SerialNumber == serialNumber);
var delivery = new Delivery
{
DeliveryDate = DateTime.Parse(deliveryDate),
Supplier = supplier,
Lot = lot,
};
_context.Deliveries.Add(delivery);
_context.SaveChanges();
return(delivery);
}
public OrderedProducts Include(string orderId, string productCode, string productName, string packegesCount, string packegesWeight, string lot)
{
var product = _context.Products.First(x => x.ProductCode == productCode && x.Name == productName);
var lotId = _context.Lots.First(x => x.SerialNumber == lot).Id;
var orderedProduct = new OrderedProducts()
{
OrderedPackagesCount = int.Parse(packegesCount),
OrderedPackagesWeight = decimal.Parse(packegesWeight),
ProductId = product.Id,
OrderId = orderId,
LotId = lotId,
};
_context.OrderedProducts.Add(orderedProduct);
_context.SaveChanges();
return(orderedProduct);
}
public Supplier Create(string name)
{
var supplier = new Supplier
{
Name = name
};
_context.Suppliers.Add(supplier);
_context.SaveChanges();
return(supplier);
}
public Receiver IncludeNewAddress(string receiverId, string town, string street)
{
var receiver = _context.Receivers
.Include(x => x.DeliveryAddresses)
.First(x => x.Id == receiverId);
receiver.DeliveryAddresses.Add(new DeliveryAddress
{
Town = town,
Street = street
});
_context.SaveChanges();
return(receiver);
}
public void Seed()
{
for (int i = 1; i < 10; i++)
{
this._context.Products.Add(new Product()
{
Name = $"Oil{i}",
ProductCode = $"0101010{i}",
PackageCapacity = 205,
Viscosity = $"{i * 5}/40",
Lots = new List <Lot>
{
new Lot()
{
SerialNumber = $"12{i*10}/12",
PackagesCount = 20 + i,
PackagesWeight = 3700,
Density = 0.905m,
},
new Lot()
{
SerialNumber = $"55{i*20}/55",
PackagesCount = 20 + i,
PackagesWeight = 3700,
Density = 0.8875m,
},
new Lot()
{
SerialNumber = $"88{i*30}/88",
PackagesCount = 20 + i,
PackagesWeight = 3700,
Density = 0.814m,
},
},
});
}
for (int i = 1; i < 10; i++)
{
this._context.Receivers.Add(new Receiver()
{
Name = $"Receiver{i}",
DeliveryAddresses = new List <DeliveryAddress>()
{
new DeliveryAddress
{
Town = $"Town-1 Receiver{i}",
Street = $"Street-1 Receiver{i}"
},
new DeliveryAddress
{
Town = $"Town-2 Receiver{i}",
Street = $"Street-2 Receiver{i}",
},
new DeliveryAddress
{
Town = $"Town-3 Receiver{i}",
Street = $"Street-3 Receiver{i}",
},
},
Orders = new List <Order>()
});
}
for (int i = 1; i < 10; i++)
{
this._context.Carriers.Add(new Carrier()
{
Name = $"Carrier{i}",
Drivers = new List <Driver>()
{
new Driver
{
FullName = $"Driver-1 Carrier{i}",
},
new Driver
{
FullName = $"Driver-2 Carrier{i}",
},
new Driver
{
FullName = $"Driver-3 Carrier{i}"
}
},
Vehicles = new List <Vehicle>()
{
new Vehicle
{
RegNumber = $"PB{i}{i}{i}{i}AH Carrier{i}"
},
new Vehicle
{
RegNumber = $"PB{i+1}{i+1}{i+1}{i+1}AH Carrier{i}"
},
new Vehicle
{
RegNumber = $"PB{i+2}{i+2}{i+2}{i+2}AH Carrier{i}"
},
},
});
}
for (int i = 1; i < 10; i++)
{
this._context.Suppliers.Add(new Supplier
{
Name = $"Supplier{i}",
});
}
_context.SaveChanges();
}