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(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(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 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 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(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(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 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(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(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(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(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 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 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(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(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 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 BindableCollection <OrderDTO> GetAllBindableCollection()
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var result = new BindableCollection <OrderDTO>(GetAll());
return(result);
}
}
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(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(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(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 List <EventHistoryDTO> GetAll()
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var result = db.EventHistory.Where(x => x.IsDisabled == false).Select(
x => new EventHistoryDTO
{
Id = x.Id,
EventId = x.EventId,
StartDate = x.StartDate,
}).ToList();
return(result);
}
}
public static List <ReturnDTO> GetAll()
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var result = db.Returns.Where(x => x.IsDisabled == false).Select(
x => new ReturnDTO
{
Id = x.Id,
Client = x.Client,
Date = x.Date,
Description = x.Description,
}).ToList();
return(result);
}
}
public static EventHistoryDTO GetById(int id)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var result = db.EventHistory.Where(x => x.Id == id).Select(
x => new EventHistoryDTO
{
Id = x.Id,
EventId = x.EventId,
StartDate = x.StartDate,
}).FirstOrDefault();
return(result);
}
}
public static ReturnDTO GetById(int id)
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var result = db.Returns.Where(x => x.Id == id).Select(
x => new ReturnDTO
{
Id = x.Id,
Client = x.Client,
Date = x.Date,
Description = x.Description,
}).FirstOrDefault();
return(result);
}
}
public static List <EquipmentDTO> GetAll()
{
using (WarehouseSystemContext db = new WarehouseSystemContext())
{
var result = db.Equipments.Where(x => x.IsDisabled == false).Select(
x => new EquipmentDTO
{
Id = x.Id,
Type = x.Type,
Model = x.Model,
Mark = x.Mark,
AddDate = x.AddDate,
Status = x.Status,
}).ToList();
return(result);
}
}
