public static string Edit(EventDTO eventDTO)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Events.Where(x => x.Id == eventDTO.Id).FirstOrDefault();
toModify.Id = eventDTO.Id;
toModify.Name = eventDTO.Name;
toModify.Description = eventDTO.Description;
toModify.Executed = eventDTO.Executed;
toModify.UserId = eventDTO.UserId;
toModify.OrderId = eventDTO.OrderId;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Edit(EmployeeDTO employee)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Employees.Where(x => x.Id == employee.Id).FirstOrDefault();
toModify.Id = employee.Id;
toModify.FirstName = employee.FirstName;
toModify.LastName = employee.LastName;
toModify.Email = employee.Email;
toModify.PhoneNumber = employee.PhoneNumber;
toModify.EmploymentDate = employee.EmploymentDate;
toModify.Workplace = employee.Workplace;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Add(ClientDTO client)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Client newClient = new Client();
newClient.Id = client.Id;
newClient.CompanyName = client.CompanyName;
newClient.PostalCode = client.PostalCode;
newClient.Email = client.Email;
newClient.PhoneNumber = client.PhoneNumber;
newClient.Address = client.Address;
var context = new ValidationContext(newClient, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newClient, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Clients.Add(newClient);
db.SaveChanges();
}
return(error);
}
}
public static string Add(EventHistoryDTO eventHistory)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
EventHistory newEventHistory = new EventHistory();
newEventHistory.Id = eventHistory.Id;
newEventHistory.EventId = eventHistory.EventId;
newEventHistory.StartDate = eventHistory.StartDate;
var context = new ValidationContext(newEventHistory, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newEventHistory, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.EventHistory.Add(newEventHistory);
db.SaveChanges();
}
return(error);
}
}
public static string Edit(EventHistoryDTO eventHistory)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.EventHistory.Where(x => x.Id == eventHistory.Id).FirstOrDefault();
toModify.Id = eventHistory.Id;
toModify.EventId = eventHistory.EventId;
toModify.StartDate = eventHistory.StartDate;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Add(DeliveryDTO delivery)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Delivery newDelivery = new Delivery();
newDelivery.Id = delivery.Id;
newDelivery.DeliveredItem = delivery.DeliveredItem;
newDelivery.ItemQuantity = delivery.ItemQuantity;
newDelivery.RecipientCompany = delivery.RecipientCompany;
newDelivery.PostalCode = delivery.PostalCode;
newDelivery.CityTown = delivery.CityTown;
newDelivery.StreetAddress = delivery.StreetAddress;
newDelivery.Weight = delivery.Weight;
newDelivery.Description = delivery.Description;
var context = new ValidationContext(newDelivery, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newDelivery, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Deliveries.Add(newDelivery);
db.SaveChanges();
}
return(error);
}
}
public static string Edit(ClientDTO client)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Clients.Where(x => x.Id == client.Id).FirstOrDefault();
toModify.Id = client.Id;
toModify.CompanyName = client.CompanyName;
toModify.PostalCode = client.PostalCode;
toModify.Email = client.Email;
toModify.PhoneNumber = client.PhoneNumber;
toModify.Address = client.Address;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Add(OrderDTO order)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Order newOrder = new Order();
newOrder.Id = order.Id;
newOrder.OrderItem = order.OrderItem;
newOrder.ItemQuantity = order.ItemQuantity;
newOrder.RecipientCompany = order.RecipientCompany;
newOrder.PostalCode = order.PostalCode;
newOrder.CityTown = order.CityTown;
newOrder.StreetAddress = order.StreetAddress;
newOrder.Description = order.Description;
var context = new ValidationContext(newOrder, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newOrder, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Orders.Add(newOrder);
db.SaveChanges();
}
return(error);
}
}
public static string Add(UserDTO user)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
User newUser = new User();
newUser.Id = user.Id;
newUser.FirstName = user.FirstName;
newUser.LastName = user.LastName;
newUser.Email = user.Email;
newUser.PhoneNumber = user.PhoneNumber;
newUser.BirthDate = user.BirthDate;
newUser.UserName = user.UserName;
newUser.Password = user.Password;
var context = new ValidationContext(newUser, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newUser, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Users.Add(newUser);
db.SaveChanges();
}
return(error);
}
}
public static string Edit(InventoryDTO inventory)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Inventory.Where(x => x.Id == inventory.Id).FirstOrDefault();
toModify.Id = inventory.Id;
toModify.ItemFrom = inventory.ItemFrom;
toModify.ItemTo = inventory.ItemTo;
toModify.DateOfArrival = inventory.DateOfArrival;
toModify.DateToSend = inventory.DateToSend;
toModify.Weight = inventory.Weight;
toModify.Status = inventory.Status;
toModify.Description = inventory.Description;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Edit(UserDTO user)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Users.Where(x => x.Id == user.Id).FirstOrDefault();
toModify.Id = user.Id;
toModify.FirstName = user.FirstName;
toModify.LastName = user.LastName;
toModify.Email = user.Email;
toModify.PhoneNumber = user.PhoneNumber;
toModify.BirthDate = user.BirthDate;
toModify.UserName = user.UserName;
toModify.Password = user.Password;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Add(ReturnDTO returnVar)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Return newReturn = new Return();
newReturn.Id = returnVar.Id;
newReturn.Client = returnVar.Client;
newReturn.Date = returnVar.Date;
newReturn.Description = returnVar.Description;
var context = new ValidationContext(newReturn, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newReturn, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Returns.Add(newReturn);
db.SaveChanges();
}
return(error);
}
}
public static string Add(InventoryDTO inventory)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Inventory newInventory = new Inventory();
newInventory.Id = inventory.Id;
newInventory.ItemFrom = inventory.ItemFrom;
newInventory.ItemTo = inventory.ItemTo;
newInventory.DateOfArrival = inventory.DateOfArrival;
newInventory.DateToSend = inventory.DateToSend;
newInventory.Weight = inventory.Weight;
newInventory.Status = inventory.Status;
newInventory.Description = inventory.Description;
var context = new ValidationContext(newInventory, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newInventory, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Inventory.Add(newInventory);
db.SaveChanges();
}
return(error);
}
}
public static string Edit(ReturnDTO returnVar)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Returns.Where(x => x.Id == returnVar.Id).FirstOrDefault();
toModify.Id = returnVar.Id;
toModify.Client = returnVar.Client;
toModify.Date = returnVar.Date;
toModify.Description = returnVar.Description;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Edit(OrderDTO order)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Orders.Where(x => x.Id == order.Id).FirstOrDefault();
toModify.Id = order.Id;
toModify.OrderItem = order.OrderItem;
toModify.RecipientCompany = order.RecipientCompany;
toModify.ItemQuantity = order.ItemQuantity;
toModify.PostalCode = order.PostalCode;
toModify.CityTown = order.CityTown;
toModify.StreetAddress = order.StreetAddress;
toModify.Description = order.Description;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Add(ShipmentDTO shipment)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Shipment newShipment = new Shipment();
newShipment.Id = shipment.Id;
newShipment.ShippedItem = shipment.ShippedItem;
newShipment.ItemQuantity = shipment.ItemQuantity;
newShipment.RecipientCompany = shipment.RecipientCompany;
newShipment.PostalCode = shipment.PostalCode;
newShipment.CityTown = shipment.CityTown;
newShipment.StreetAddress = shipment.StreetAddress;
newShipment.Weight = shipment.Weight;
newShipment.Description = shipment.Description;
var context = new ValidationContext(newShipment, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newShipment, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Shipments.Add(newShipment);
db.SaveChanges();
}
return(error);
}
}
public static string Add(EmployeeDTO employee)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Employee newEmployee = new Employee();
newEmployee.Id = employee.Id;
newEmployee.FirstName = employee.FirstName;
newEmployee.LastName = employee.LastName;
newEmployee.Email = employee.Email;
newEmployee.PhoneNumber = employee.PhoneNumber;
newEmployee.EmploymentDate = employee.EmploymentDate;
newEmployee.Workplace = employee.Workplace;
var context = new ValidationContext(newEmployee, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newEmployee, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Employees.Add(newEmployee);
db.SaveChanges();
}
return(error);
}
}
public static string Edit(EquipmentDTO equipment)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
var toModify = db.Equipments.Where(x => x.Id == equipment.Id).FirstOrDefault();
toModify.Id = equipment.Id;
toModify.Type = equipment.Type;
toModify.Model = equipment.Model;
toModify.Mark = equipment.Mark;
toModify.AddDate = equipment.AddDate;
toModify.Status = equipment.Status;
var context = new ValidationContext(toModify, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(toModify, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.SaveChanges();
}
return(error);
}
}
public static string Add(EquipmentDTO equipment)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Equipment newEquipment = new Equipment();
newEquipment.Id = equipment.Id;
newEquipment.Type = equipment.Type;
newEquipment.Model = equipment.Model;
newEquipment.Mark = equipment.Mark;
newEquipment.AddDate = equipment.AddDate;
newEquipment.Status = equipment.Status;
var context = new ValidationContext(newEquipment, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newEquipment, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Equipments.Add(newEquipment);
db.SaveChanges();
}
return(error);
}
}
public static void Delete(ReturnDTO returnVar)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var toDelete = db.Returns.Where(x => x.Id == returnVar.Id).FirstOrDefault();
toDelete.IsDisabled = true;
db.SaveChanges();
}
}
public static void Delete(OrderDTO order)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var toDelete = db.Orders.Where(x => x.Id == order.Id).FirstOrDefault();
toDelete.IsDisabled = true;
db.SaveChanges();
}
}
public static void Delete(InventoryDTO inventory)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var toDelete = db.Inventory.Where(x => x.Id == inventory.Id).FirstOrDefault();
toDelete.IsDisabled = true;
db.SaveChanges();
}
}
public static void Delete(EmployeeDTO employee)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var toDelete = db.Employees.Where(x => x.Id == employee.Id).FirstOrDefault();
toDelete.IsDisabled = true;
db.SaveChanges();
}
}
public static void Delete(EquipmentDTO equipment)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var toDelete = db.Equipments.Where(x => x.Id == equipment.Id).FirstOrDefault();
toDelete.IsDisabled = true;
db.SaveChanges();
}
}
public static string Add(EventDTO eventDTO)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
string error = null;
Event newEvent = new Event();
newEvent.Id = eventDTO.Id;
newEvent.Name = eventDTO.Name;
newEvent.Description = eventDTO.Description;
newEvent.Executed = eventDTO.Executed;
newEvent.UserId = eventDTO.UserId;
newEvent.OrderId = eventDTO.OrderId;
var context = new ValidationContext(newEvent, null, null);
var result = new List <ValidationResult>();
Validator.TryValidateObject(newEvent, context, result, true);
foreach (var x in result)
{
error = error + x.ErrorMessage + "\n";
}
if (error == null)
{
db.Events.Add(newEvent);
db.SaveChanges();
}
return(error);
}
}
public static void Seed(WarehouseSystemContext db)
{
IList <Client> Clients = new List <Client>();
Clients.Add(new Client()
{
Id = 1, CompanyName = "Tomex", PostalCode = "16-010", Address = "Warszawska 54", Email = "*****@*****.**", PhoneNumber = "123456789"
});
Clients.Add(new Client()
{
Id = 2, CompanyName = "Adamex", PostalCode = "16-011", Address = "Krucza 32", Email = "*****@*****.**", PhoneNumber = "67895432"
});
Clients.Add(new Client()
{
Id = 3, CompanyName = "RazDwaTrzy", PostalCode = "16-012", Address = "Wąska 1", Email = "*****@*****.**", PhoneNumber = "12345632"
});
Clients.Add(new Client()
{
Id = 4, CompanyName = "Delta", PostalCode = "16-013", Address = "Waszyngtonaa 2", Email = "*****@*****.**", PhoneNumber = "123458932"
});
foreach (var item in Clients)
{
db.Clients.Add(item);
}
IList <Delivery> Deliveries = new List <Delivery>();
Deliveries.Add(new Delivery()
{
Id = 1, RecipientCompany = "Alfa", PostalCode = "16-010", CityTown = "Warszawa", DeliveredItem = "Czajnik", ItemQuantity = 1, Description = "brak", StreetAddress = "Długa 21", Weight = 15
});
Deliveries.Add(new Delivery()
{
Id = 2, RecipientCompany = "Beteta", PostalCode = "16-210", CityTown = "Gdańsk", DeliveredItem = "Kubek", ItemQuantity = 3, Description = "brak", StreetAddress = "Wiejska 42", Weight = 15
});
Deliveries.Add(new Delivery()
{
Id = 3, RecipientCompany = "Karolex", PostalCode = "13-010", CityTown = "Legionowo", DeliveredItem = "Szklanka", ItemQuantity = 3, Description = "brak", StreetAddress = "Warszawska 2", Weight = 15
});
Deliveries.Add(new Delivery()
{
Id = 4, RecipientCompany = "OneAndTwo", PostalCode = "11-010", CityTown = "Olsztyn", DeliveredItem = "Maskotka", ItemQuantity = 6, Description = "brak", StreetAddress = "Mickiewicza 21", Weight = 15
});
foreach (var item in Deliveries)
{
db.Deliveries.Add(item);
}
IList <Employee> Employees = new List <Employee>();
Employees.Add(new Employee()
{
Id = 1, FirstName = "Andrzej", LastName = "Grabara", Email = "*****@*****.**", PhoneNumber = "871313123", EmploymentDate = new DateTime(2017, 2, 14), Workplace = "Magazyn"
});
Employees.Add(new Employee()
{
Id = 2, FirstName = "Beata", LastName = "Kościelniak", Email = "*****@*****.**", PhoneNumber = "691323123", EmploymentDate = new DateTime(2017, 2, 11), Workplace = "Rampa"
});
Employees.Add(new Employee()
{
Id = 3, FirstName = "Tomasz", LastName = "Lis", Email = "*****@*****.**", PhoneNumber = "696133123", EmploymentDate = new DateTime(2017, 2, 13), Workplace = "Sortownia"
});
Employees.Add(new Employee()
{
Id = 4, FirstName = "Przemysław", LastName = "Bak", Email = "*****@*****.**", PhoneNumber = "696513223", EmploymentDate = new DateTime(2017, 2, 12), Workplace = "Sortownia"
});
foreach (var item in Employees)
{
db.Employees.Add(item);
}
IList <Equipment> Equipments = new List <Equipment>();
Equipments.Add(new Equipment()
{
Id = 1, Type = "Wózek widłowy", Mark = "Workp", Model = "TR34", AddDate = new DateTime(2017, 3, 3), Status = "Aktywny"
});
Equipments.Add(new Equipment()
{
Id = 2, Type = "Wózek widłowy", Mark = "WorkP", Model = "TR35", AddDate = new DateTime(2017, 4, 9), Status = "Niedostępny"
});
Equipments.Add(new Equipment()
{
Id = 3, Type = "Rękawice", Mark = "Teslo", Model = "AN321", AddDate = new DateTime(2017, 1, 11), Status = "Aktywny"
});
Equipments.Add(new Equipment()
{
Id = 4, Type = "Kask", Mark = "Dark", Model = "Db47", AddDate = new DateTime(2017, 7, 12), Status = "Aktywny"
});
foreach (var item in Equipments)
{
db.Equipments.Add(item);
}
IList <Event> Events = new List <Event>();
Events.Add(new Event()
{
Id = 1, Name = "Test", Description = "Test", Executed = false, UserId = 1, OrderId = 1
});
Events.Add(new Event()
{
Id = 2, Name = "Test2", Description = "Test2", Executed = false, UserId = 2, OrderId = 2
});
Events.Add(new Event()
{
Id = 3, Name = "Test3", Description = "Test3", Executed = false, UserId = 3, OrderId = 3
});
Events.Add(new Event()
{
Id = 4, Name = "Test4", Description = "Test4", Executed = false, UserId = 4, OrderId = 4
});
foreach (var item in Events)
{
db.Events.Add(item);
}
IList <EventHistory> EventHistory = new List <EventHistory>();
EventHistory.Add(new EventHistory()
{
Id = 1, EventId = 1, StartDate = new DateTime(2017, 2, 14)
});
EventHistory.Add(new EventHistory()
{
Id = 2, EventId = 2, StartDate = new DateTime(2017, 6, 14)
});
EventHistory.Add(new EventHistory()
{
Id = 3, EventId = 3, StartDate = new DateTime(2017, 3, 14)
});
EventHistory.Add(new EventHistory()
{
Id = 4, EventId = 4, StartDate = new DateTime(2017, 2, 16)
});
foreach (var item in EventHistory)
{
db.EventHistory.Add(item);
}
IList <Inventory> Inventory = new List <Inventory>();
Inventory.Add(new Inventory()
{
Id = 1, ItemFrom = "Adam Korol", ItemTo = "Słowik", DateOfArrival = new DateTime(2017, 1, 3), DateToSend = new DateTime(2017, 2, 3), Weight = 3, Status = "Dostarczono", Description = "Brak"
});
Inventory.Add(new Inventory()
{
Id = 2, ItemFrom = "Tomex", ItemTo = "OneAndTwo", DateOfArrival = new DateTime(2017, 1, 4), DateToSend = new DateTime(2017, 2, 4), Weight = 1, Status = "W magazynie", Description = "Nie rzucać!"
});
Inventory.Add(new Inventory()
{
Id = 3, ItemFrom = "Kamil Olczyk", ItemTo = "Grzegorz Tarasiewicz", DateOfArrival = new DateTime(2017, 1, 5), DateToSend = new DateTime(2017, 2, 5), Weight = 7, Status = "W magazynie", Description = "Nie rzucać!"
});
Inventory.Add(new Inventory()
{
Id = 4, ItemFrom = "RazDwaTrzy", ItemTo = "Michał Adamek", DateOfArrival = new DateTime(2017, 1, 6), DateToSend = new DateTime(2017, 2, 6), Weight = 5, Status = "Dostarczono", Description = "Brak"
});
foreach (var item in Inventory)
{
db.Inventory.Add(item);
}
IList <Order> Orders = new List <Order>();
Orders.Add(new Order()
{
Id = 1, OrderItem = "Telefon Iphone 6s", ItemQuantity = 1, RecipientCompany = "Tomex", CityTown = "Kraków", PostalCode = "13-011", StreetAddress = "Warszawska 6", Description = "Nie rzucać!"
});
Orders.Add(new Order()
{
Id = 2, OrderItem = "Czajnik elektryczny", ItemQuantity = 23, RecipientCompany = "RazDwaTrzy", CityTown = "Białystok", PostalCode = "13-101", StreetAddress = "Krótka 4", Description = "Brak"
});
Orders.Add(new Order()
{
Id = 3, OrderItem = "Flet", ItemQuantity = 2, RecipientCompany = "Słowik", CityTown = "Warszawa", PostalCode = "13-031", StreetAddress = "Mickiewicza 3", Description = "Brak"
});
Orders.Add(new Order()
{
Id = 4, OrderItem = "Bateria", ItemQuantity = 15, RecipientCompany = "Telekom", CityTown = "Olsztyn", PostalCode = "13-001", StreetAddress = "Okopowa 54", Description = "Brak"
});
foreach (var item in Orders)
{
db.Orders.Add(item);
}
IList <Return> Returns = new List <Return>();
Returns.Add(new Return()
{
Id = 1, Client = "Adam Wakulak", Date = new DateTime(2017, 4, 6), Description = "Brak"
});
Returns.Add(new Return()
{
Id = 2, Client = "Kamil Stoch", Date = new DateTime(2017, 4, 7), Description = "Brak"
});
Returns.Add(new Return()
{
Id = 3, Client = "Andrzej Duda", Date = new DateTime(2017, 4, 8), Description = "Uszkodzenie szybki"
});
Returns.Add(new Return()
{
Id = 4, Client = "Andreas Kooler", Date = new DateTime(2017, 4, 9), Description = "Zgniecenie"
});
foreach (var item in Returns)
{
db.Returns.Add(item);
}
IList <Shipment> Shipments = new List <Shipment>();
Shipments.Add(new Shipment()
{
Id = 1, ShippedItem = "Szafa", ItemQuantity = 1, RecipientCompany = "Januszex", CityTown = "Warszawa", PostalCode = "13-097", StreetAddress = "Waszyngtona 5", Weight = 4, Description = "Brak"
});
Shipments.Add(new Shipment()
{
Id = 2, ShippedItem = "Ubudowa telefonu mi6", ItemQuantity = 12, RecipientCompany = "OneAndTwo", CityTown = "Ełk", PostalCode = "12-197", StreetAddress = "Krucza 2", Weight = 44, Description = "Brak"
});
Shipments.Add(new Shipment()
{
Id = 3, ShippedItem = "Kubek z imieniem", ItemQuantity = 6, RecipientCompany = "Testrix", CityTown = "Białystok", PostalCode = "15-297", StreetAddress = "Towarowa 21", Weight = 2, Description = "Uwaga produkt delikatny!"
});
Shipments.Add(new Shipment()
{
Id = 4, ShippedItem = "Szklanki Zestaw", ItemQuantity = 8, RecipientCompany = "Phil", CityTown = "Białystok", PostalCode = "13-297", StreetAddress = "Długa 121", Weight = 12, Description = "Nie rzucać!"
});
foreach (var item in Shipments)
{
db.Shipments.Add(item);
}
IList <User> Users = new List <User>();
Users.Add(new User()
{
Id = 1, FirstName = "Administrator", LastName = "Adminsitrator", BirthDate = new DateTime(1999, 1, 13), Email = "*****@*****.**", PhoneNumber = "654321123", UserName = "******", Password = "******"
});
Users.Add(new User()
{
Id = 2, FirstName = "Adam", LastName = "Lewandowski", BirthDate = new DateTime(1999, 2, 13), Email = "*****@*****.**", PhoneNumber = "654311123", UserName = "******", Password = "******"
});
Users.Add(new User()
{
Id = 3, FirstName = "Jan", LastName = "Nowak", BirthDate = new DateTime(1999, 6, 13), Email = "*****@*****.**", PhoneNumber = "654331123", UserName = "******", Password = "******"
});
Users.Add(new User()
{
Id = 4, FirstName = "Andrzej", LastName = "Kowalski", BirthDate = new DateTime(1999, 5, 13), Email = "*****@*****.**", PhoneNumber = "654341123", UserName = "******", Password = "******"
});
Users.Add(new User()
{
Id = 5, FirstName = "Karol", LastName = "Koc", BirthDate = new DateTime(1999, 1, 13), Email = "*****@*****.**", PhoneNumber = "654321123", UserName = "******", Password = "******"
});
foreach (var item in Users)
{
db.Users.Add(item);
}
db.SaveChanges();
}