public Employee GetEmployee(int employeeID)
{
using (var db = new AalborgZooContainer())
{
return(db.EmployeeSet.FirstOrDefault(x => x.Id == employeeID));
}
}
public Unit GetUnitById(int id)
{
using (var db = new AalborgZooContainer())
{
Unit unit = db.UnitSet.FirstOrDefault(x => x.Id == id);
return(unit);
}
}
/// <summary>
/// Adding an employee to the database
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
public Employee AddEmployee(Employee employee)
{
using (var db = new AalborgZooContainer())
{
Employee employeeWithID = db.EmployeeSet.Add(employee);
db.SaveChanges();
return(employeeWithID);
}
}
public DBAalborgZoo()
{
using (AalborgZooContainer context = new AalborgZooContainer())
{
context.EmployeeSet.Add(new Employee()
{
FirstName = "Tobias", LastName = "Pallumate"
});
context.SaveChanges();
}
}
static public void DeleteDatabase()
{
using (db = new AalborgZooContainer())
{
db.Database.ExecuteSqlCommand("DELETE FROM [UnitProductVersion]");
db.Database.ExecuteSqlCommand("DELETE FROM [OrderLineSet] DBCC CHECKIDENT ([OrderLineSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [ProductVersionSet] DBCC CHECKIDENT ([ProductVersionSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [DepartmentSpecificProductSet] DBCC CHECKIDENT ([DepartmentSpecificProductSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [DepartmentChangeSet] DBCC CHECKIDENT ([DepartmentChangeSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [PasswordChangedSet] DBCC CHECKIDENT ([PasswordChangedSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [OrderSet] DBCC CHECKIDENT ([OrderSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [ShoppingListSet] DBCC CHECKIDENT ([ShoppingListSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [EmployeeSet] DBCC CHECKIDENT ([EmployeeSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [DepartmentSet] DBCC CHECKIDENT ([DepartmentSet], RESEED, 0)");
//db..RemoveRange(db.DepartmentChangeSet.Where(x => true));
//db.DepartmentChangeSet.RemoveRange(db.DepartmentChangeSet.Where(x => true));
db.Database.ExecuteSqlCommand("DELETE FROM [UnitSet] DBCC CHECKIDENT ([UnitSet], RESEED, 0)");
db.Database.ExecuteSqlCommand("DELETE FROM [ProductSet] DBCC CHECKIDENT ([ProductSet], RESEED, 0)");
}
}
/// <summary>
/// Gets all the Zookeepers in the database.
/// </summary>
/// <returns></returns>
public List <Zookeeper> GetAllZookeepers()
{
List <Zookeeper> AllZookeepers = new List <Zookeeper>();
using (var db = new AalborgZooContainer())
{
var temp = new List <Employee>(db.EmployeeSet);
foreach (Employee e in temp)
{
Zookeeper tempZookeeper = e as Zookeeper;
if (tempZookeeper != null)
{
AllZookeepers.Add(tempZookeeper);
}
}
return(AllZookeepers);
}
}
static public void PopulateDatabase()
{
using (db = new AalborgZooContainer())
{
/* Shopper */
Shopper shp = new Shopper()
{
DateHired = DateTime.Today.AddMonths(-1),
Name = "Tobias Palludan",
Password = "******",
Username = "******"
};
db.EmployeeSet.Add(shp);
shp = new Shopper()
{
DateHired = DateTime.Today.AddMonths(-1),
Name = "Mikkel Jessen",
Password = "******",
Username = "******",
};
db.EmployeeSet.Add(shp);
db.SaveChanges();
/* Departments */
Department depSydAmerika = new Department()
{
DateCreated = DateTime.Today.AddMonths(-1),
Name = "Sydamerika",
};
db.DepartmentSet.Add(depSydAmerika);
Department depAfrika = new Department()
{
DateCreated = DateTime.Today.AddMonths(-1),
Name = "Afrika",
};
db.DepartmentSet.Add(depAfrika);
db.SaveChanges();
/* Zookeepers */
Zookeeper zkp = new Zookeeper()
{
DateHired = DateTime.Today.AddMonths(-1),
Department = depSydAmerika,
Name = "Anh Tuan Truong"
};
db.EmployeeSet.Add(zkp);
zkp = new Zookeeper()
{
DateHired = DateTime.Today.AddMonths(-1),
Department = depSydAmerika,
Name = "Casper Corfitz Christensen"
};
db.EmployeeSet.Add(zkp);
zkp = new Zookeeper()
{
DateHired = DateTime.Today.AddMonths(-1),
Department = depSydAmerika,
Name = "Kristoffer Jensen"
};
db.EmployeeSet.Add(zkp);
zkp = new Zookeeper()
{
DateHired = DateTime.Today.AddMonths(-1),
Department = depSydAmerika,
Name = "Jacob Gosch"
};
db.EmployeeSet.Add(zkp);
Zookeeper zkpAfrika = new Zookeeper()
{
DateHired = DateTime.Today.AddMonths(-1),
Department = depAfrika,
Name = "Afrika Medarbejder, burde ikke vises"
};
db.EmployeeSet.Add(zkpAfrika);
db.SaveChanges();
/* Product */
Product prodBanan = new Product()
{
CreatedByID = zkp.Id,
DateCreated = DateTime.Today.AddMonths(-1),
Name = "Banan",
};
db.ProductSet.Add(prodBanan);
Product prodPære = new Product()
{
CreatedByID = zkp.Id,
DateCreated = DateTime.Today.AddMonths(-1),
Name = "Pære",
};
db.ProductSet.Add(prodPære);
Product prodÆble = new Product()
{
CreatedByID = zkp.Id,
DateCreated = DateTime.Today.AddMonths(-1),
Name = "Æble",
};
db.ProductSet.Add(prodÆble);
Product prodAbrikos = new Product()
{
CreatedByID = zkp.Id,
DateCreated = DateTime.Today.AddMonths(-1),
Name = "Abrikos",
};
db.ProductSet.Add(prodAbrikos);
Product prodTuttiFruttiMix = new Product()
{
CreatedByID = zkp.Id,
DateCreated = DateTime.Today.AddMonths(-1),
Name = "TuttiFruttiMix, burde ikke vises",
};
db.ProductSet.Add(prodTuttiFruttiMix);
db.SaveChanges();
/* Product versions */
ProductVersion prodvBanan = new ProductVersion()
{
Name = "Banan",
Product = prodBanan,
IsActive = true,
Supplier = "FrugtKarl",
Units = db.UnitSet.ToList(),
DateCreated = DateTime.Today,
CreatedByID = shp.Id
};
db.ProductVersionSet.Add(prodvBanan);
ProductVersion prodvÆble = new ProductVersion()
{
Name = "Æble",
Product = prodÆble,
IsActive = true,
Supplier = "FrugtKarl",
Units = db.UnitSet.ToList(),
DateCreated = DateTime.Today,
CreatedByID = shp.Id
};
db.ProductVersionSet.Add(prodvÆble);
ProductVersion prodvPære = new ProductVersion()
{
Name = "Pære",
Product = prodPære,
IsActive = true,
Supplier = "FrugtKarl",
DateCreated = DateTime.Today,
Units = db.UnitSet.ToList(),
CreatedByID = shp.Id
};
db.ProductVersionSet.Add(prodvPære);
ProductVersion prodvAbrikos = new ProductVersion()
{
Name = "Abrikos",
Product = prodAbrikos,
IsActive = true,
Supplier = "FrugtKarl",
DateCreated = DateTime.Today,
Units = db.UnitSet.ToList(),
CreatedByID = shp.Id
};
db.ProductVersionSet.Add(prodvAbrikos);
ProductVersion prodvTuttiFrutti = new ProductVersion()
{
Name = "Tutti Frutti Mix, burde ikke vises",
Product = prodTuttiFruttiMix,
IsActive = true,
Supplier = "Tivoli",
DateCreated = DateTime.Today,
Units = db.UnitSet.ToList(),
CreatedByID = shp.Id
};
db.ProductVersionSet.Add(prodvTuttiFrutti);
db.SaveChanges();
/* Department Specific Products */
DepartmentSpecificProduct departmentSpecificProduct = new DepartmentSpecificProduct()
{
Department = depSydAmerika,
Product = prodBanan
};
db.DepartmentSpecificProductSet.Add(departmentSpecificProduct);
departmentSpecificProduct = new DepartmentSpecificProduct()
{
Department = depSydAmerika,
Product = prodÆble
};
db.DepartmentSpecificProductSet.Add(departmentSpecificProduct);
departmentSpecificProduct = new DepartmentSpecificProduct()
{
Department = depSydAmerika,
Product = prodPære
};
db.DepartmentSpecificProductSet.Add(departmentSpecificProduct);
departmentSpecificProduct = new DepartmentSpecificProduct()
{
Department = depSydAmerika,
Product = prodAbrikos
};
db.DepartmentSpecificProductSet.Add(departmentSpecificProduct);
departmentSpecificProduct = new DepartmentSpecificProduct()
{
Department = depAfrika,
Product = prodTuttiFruttiMix
};
db.DepartmentSpecificProductSet.Add(departmentSpecificProduct);
db.SaveChanges();
/* Shopping list */
ShoppingList shoppingList = new ShoppingList()
{
CreatedByID = shp.Id,
DateCreated = DateTime.Today,
Shopper = shp,
Status = 2,
};
db.ShoppingListSet.Add(shoppingList);
db.SaveChanges();
/* Orders */
Order order = new Order()
{
DateCreated = DateTime.Today,
Status = 2,
DepartmentID = depSydAmerika.Id,
OrderedByID = zkp.Id,
ShoppingList = shoppingList,
DateOrdered = DateTime.Today,
};
db.OrderSet.Add(order);
db.SaveChanges();
/* OrderLine */
OrderLine orderLineBanan = new OrderLine()
{
Order = order,
ProductVersion = prodvBanan,
Quantity = 15,
Unit = db.UnitSet.First()
};
db.OrderLineSet.Add(orderLineBanan);
db.SaveChanges();
OrderLine orderLineÆble = new OrderLine()
{
Order = order,
ProductVersion = prodvÆble,
Quantity = 15,
Unit = db.UnitSet.First()
};
db.OrderLineSet.Add(orderLineÆble);
db.SaveChanges();
OrderLine orderLinePære = new OrderLine()
{
Order = order,
ProductVersion = prodvPære,
Quantity = 15,
Unit = db.UnitSet.First()
};
db.OrderLineSet.Add(orderLinePære);
db.SaveChanges();
OrderLine orderLineAbrikos = new OrderLine()
{
Order = order,
ProductVersion = prodvAbrikos,
Quantity = 15,
Unit = db.UnitSet.First()
};
db.OrderLineSet.Add(orderLineAbrikos);
db.SaveChanges();
OrderLine orderLineTuttiFruttiMix = new OrderLine()
{
Order = order,
ProductVersion = prodvTuttiFrutti,
Quantity = 15,
Unit = db.UnitSet.First()
};
db.OrderLineSet.Add(orderLineTuttiFruttiMix);
db.SaveChanges();
}
}
