protected virtual void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
_context.Dispose();
}
}
this.disposed = true;
}
protected virtual void Dispose(bool disposing)
{
if (_disposed)
{
return;
}
if (disposing)
{
// Free any other managed objects here.
//
}
Db.Dispose();
_disposed = true;
}
public void Dispose()
{
context.Database.EnsureDeleted();
context.Dispose();
}
static void Main(string[] args)
{
var context = new OnlineStoreDbContext();
//Customer
var emp = new CustomerRepository(context);
var customer1 = new Customer
{
CustomerID = Guid.NewGuid(),
CustomerName = "Vandolph",
CreditLimit = 1000,
IsActive = true
};
emp.Create(customer1);
var customer2 = new Customer
{
CustomerID = Guid.NewGuid(),
CustomerName = "Vandolph",
CreditLimit = 1000,
IsActive = true
};
var emp2 = new CustomerRepository(context);
emp.Delete(customer2);
var customers = from c in context.Departments
select c;
var page2 = customers.Skip(40)
.Take(40)
.ToList();
context.Dispose();
//Add Department
var tmg = new Department
{
DepartmentID = Guid.NewGuid(),
DepartmentName = "Technology Management",
IsActive = true
};
var bdg = new Department
{
DepartmentID = Guid.NewGuid(),
DepartmentName = "Business Development",
IsActive = true
};
context.Departments.Add(tmg);
context.Departments.Add(bdg);
context.SaveChanges();
#region Add Employee
var simon = new Employee
{
EmployeeID = Guid.NewGuid(),
FirstName = "Simon",
MiddleName = "D.",
LastName = "Bradecina",
Department = tmg
};
var bjae = new Employee
{
EmployeeID = Guid.NewGuid(),
FirstName = "Bjae",
MiddleName = "A.",
LastName = "Bradecina",
Department = tmg
};
//product
var prod = new Product
{
ProductID = Guid.NewGuid(),
ProductName = "Candy",
IsActive = true
};
context.Product.Add(prod);
context.SaveChanges();
#endregion
#region Create Record
context.Employees.Add(simon);
context.Employees.Add(bjae);
context.SaveChanges();
#endregion
#region Delete Record
var s = new Employee
{
EmployeeID = Guid.NewGuid(),
FirstName = "Vicente",
MiddleName = "B.",
LastName = "Bradecina",
Department = tmg
};
context.Employees.Add(s);
context.SaveChanges();
var b = new Employee
{
EmployeeID = Guid.NewGuid(),
FirstName = "Roselyn",
MiddleName = "D.",
LastName = "Bradecina",
Department = tmg
};
s = context.Employees.Find(s.EmployeeID);
context.Employees.Remove(s);
context.SaveChanges();
#endregion
#region Update Record
var n = new Employee
{
EmployeeID = Guid.NewGuid(),
FirstName = "Annabeth",
MiddleName = "G..",
LastName = "Susvilla",
Department = tmg
};
var e = new Employee
{
EmployeeID = Guid.NewGuid(),
FirstName = "Ezekiel",
MiddleName = "D.",
LastName = "Bradecina",
Department = tmg
};
context.Employees.Add(e);
context.SaveChanges();
s = context.Employees.Find(e.EmployeeID);
context.Employees.Update(e);
context.SaveChanges();
#endregion
#region Retrieve Records
var departments = from d in context.Departments
select d;
var page3 = departments.Skip(40)
.Take(40)
.ToList();
var tmgEmployees = from empl in context.Employees
join d in context.Departments
on empl.DepartmentID equals d.DepartmentID
where d.DepartmentName.Equals("Technollogy Management")
orderby e.LastName
select new
{
FullName = empl.FirstName + "" +
empl.MiddleName.Substring(0, 1),
empl.LastName,
Department = d.DepartmentName
};
var result = tmgEmployees.ToList();
context.Dispose();
}
