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