public ManageCustomersForm()
{
InitializeComponent();
_db = new AppContext();
_customerRepository = new CustomerRepository(_db);
_searchCustomer = new Repository.Models.Customer();
}
public ManageCustomerFarmsForm()
{
InitializeComponent();
_db = new AppContext();
_customerRepository = new CustomerRepository(_db);
_farmRepository = new CustomerFarmRepository(_db);
}
public ManageCustomerInterpolationForm(bool btnAddToVisible)
{
InitializeComponent();
_db = new AppContext();
_customerRepository = new CustomerRepository(_db);
_farmRepository = new CustomerFarmRepository(_db);
_interpolationRepository = new CustomerInterpolationRepository(_db);
_fieldRepository = new InterpolatedFieldRepository(_db);
btnAddTo.Visible = btnAddToVisible;
}
public SaveKrigingForm()
{
InitializeChart();
_db = new AppContext();
_customerRepository = new CustomerRepository(_db);
_farmRepository = new CustomerFarmRepository(_db);
_interpolationRepository = new CustomerInterpolationRepository(_db);
_addedFiles = new List<string>();
InitializeComponent();
}
static void Main(string[] args)
{
var connectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\GitHub\Repository\Repository\TestDB.mdf;Integrated Security=True";
var connection = new SqlConnection(connectionString);
var uow = new UnitOfWork(connection);
var mapper = new CustomerSQLMapper(connection);
var customerTest1 = Customer.Create("Zaid", "Barrera");
try
{
connection.Open();
var customerRepository = new CustomerRepository(uow, mapper);
customerRepository.Add(customerTest1);
Console.WriteLine("Customer ADDED - UnitOfWork");
Wait();
uow.Commit();
Console.WriteLine("Customer COMMITTED - Database");
Wait();
var customers = customerRepository.FindAll();
customerTest1.FirstName = "Kaike";
customerRepository.Update(customerTest1);
Console.WriteLine("Customer MODIFIED - UnitOfWork");
Wait();
uow.Commit();
Console.WriteLine("Customer COMMITTED - Database");
Wait();
customerRepository.Remove(customerTest1);
Console.WriteLine("Customer DELETED - UnitOfWork");
Wait();
uow.Commit();
Console.WriteLine("Customer COMMITTED - Database");
Console.WriteLine("DONE!");
Wait();
}
catch (Exception ex)
{ }
finally { connection.Close(); }
//var categoryTest1 = CreateCategory("FirstCategory");
//var categoryTest2 = CreateCategory("SecondCategory");
//var categoryTest3 = CreateCategory("ThirdCategory");
//Console.WriteLine("Press SPACE to contine");
//Console.WriteLine("Categories CREATED:");
//LogCategory(categoryTest1);
//LogCategory(categoryTest2);
//LogCategory(categoryTest3);
//Wait();
//var connectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\GitHub\Repository\Repository\TestDB.mdf;Integrated Security=True";
//var connection = new SqlConnection(connectionString);
//var uow = new UnitOfWork(connection);
//var mapper = new CategorySQLMapper(connection);
//try
//{
// connection.Open();
// var categoryRepository = new CategoryRepository(uow, mapper);
// categoryRepository.Add(categoryTest1);
// categoryRepository.Add(categoryTest2);
// categoryRepository.Add(categoryTest3);
// Console.WriteLine("Categories ADDED - UnitOfWork");
// ShowCategoriesInDB(categoryRepository);
// Wait();
// uow.Commit();
// ShowCategoriesInDB(categoryRepository);
// Wait();
// categoryTest3.Name = "ModifiedCategory";
// categoryRepository.Update(categoryTest3);
// categoryRepository.Remove(categoryTest2);
// Console.WriteLine("Categories MODIFIED - UnitOfWork");
// ShowCategoriesInDB(categoryRepository);
// Wait();
// uow.Commit();
// ShowCategoriesInDB(categoryRepository);
// Wait();
//}
//catch (Exception ex)
//{ }
//finally { connection.Close(); }
}
private void PreparePlayers()
{
_uow = new UnitOfWork();
_mapper = new LockingMapper(new CustomerSQLMapper());
_repository = new CustomerRepository(_uow, _mapper);
_customer = _repository.FindBy(new Guid("da365eb6-74c2-4d60-aa33-ac1af3637b1a"));
}
private void CleanupPlayers()
{
_uow = null;
_mapper = null;
_repository = null;
_customer = null;
}
public CustomerExtension()
{
_db = new AppContext();
_customerRepository = new CustomerRepository(_db);
_farmRepository = new CustomerFarmRepository(_db);
}