private static void SetEntities()
{
if (entities == null)
{
entities = new DesignPatternDBEntities();
}
}
void setCurrentState()
{
using (DesignPatternDBEntities dBEntities = new DesignPatternDBEntities())
{
workitemRepository = new WorkItemRepository(dBEntities);
var DAworkItem = workitemRepository.FindById(7);
workItem.Id = DAworkItem.Id;
workItem.State = DAworkItem.State;
workItem.Title = DAworkItem.Title;
workItem.Description = DAworkItem.Description;
}
}
static void executeRepository()
{
using (DesignPatternDBEntities entities = new DesignPatternDBEntities())
{
CustomerRepository customerRepository = new CustomerRepository(entities);
var x = customerRepository.FindById(1);
Console.WriteLine("Customer First Name: " + x.FirstName);
Console.WriteLine("Customer Middle Name: " + x.MiddleName);
Console.ReadKey();
}
}
static void executeUnitOfWork()
{
using (DesignPatternDBEntities entities = new DesignPatternDBEntities())
{
UnitOfWork.UnitOfWork UoW = new UnitOfWork.UnitOfWork(entities);
Customer customer = new Customer();
Address address = new Address();
Random rnd = new Random();
int rngNum = rnd.Next(1, 500);
customer.FirstName = "FirstName " + rngNum;
customer.MiddleName = "MiddleName " + rngNum;
customer.LastName = "LastName " + rngNum;
rngNum = rnd.Next(1, 500);
address.City = "City Number " + rngNum;
address.StreetAddress = rngNum + " Street";
rngNum = rnd.Next(1000, 9999);
address.ZipCode = rngNum.ToString();
address.State = "QW " + rngNum;
address.CustomerId = customer.CustomerId;
UoW.CustomerRepo.Add(customer);
UoW.AddressRepo.Add(address);
UoW.Commit();
var displayCustomer = UoW.CustomerRepo.FindById(customer.CustomerId);
var displayAddress = UoW.AddressRepo.FindById(address.Id);
Console.WriteLine("Newly Created Customer: " + "ID: " + displayCustomer.CustomerId + ", Name: " + displayCustomer.FirstName
+ " " + displayCustomer.MiddleName + ", " + displayCustomer.LastName);
Console.WriteLine("Newly Created Address: " + "ID: " + displayAddress.Id);
Console.WriteLine("City: " + displayAddress.City);
Console.WriteLine("Street Address: " + displayAddress.StreetAddress);
Console.WriteLine("ZipCode: " + displayAddress.ZipCode);
Console.WriteLine("State: " + displayAddress.State);
Console.ReadKey();
}
}
public UnitOfWork(DesignPatternDBEntities DBEntities)
{
this.DBEntities = DBEntities;
CustomerRepo = new CustomerRepository(DBEntities);
AddressRepo = new AddressRepository(DBEntities);
}
public CustomerRepository(DesignPatternDBEntities dBEntities)
{
this.dBEntities = dBEntities;
}
public WorkItemRepository(DesignPatternDBEntities dBEntities)
{
DBEntities = dBEntities;
}
public AddressRepository(DesignPatternDBEntities dBEntities)
{
DBEntities = dBEntities;
}
