private void Btn_Create_OnClick(object sender, RoutedEventArgs e)
{
var gender = RBtnMale.IsChecked == true ? Gender.Male : Gender.Female;
var newSeller = new Seller
{
FirstName = TxtFirstName.Text,
LastName = TxtLastName.Text,
Gender = gender,
BirthDate = Convert.ToDateTime(DtpBirthDate.ToString()),
HireDate = Convert.ToDateTime(DtpHireDate.ToString())
};
try
{
newSeller.EndDate = Convert.ToDateTime(DtpEndDate.ToString());
}
catch (Exception)
{
newSeller.EndDate = null;
}
AddingService.AddSeller(newSeller);
if (MessageBox.Show("New seller created") == MessageBoxResult.OK)
{
Close();
}
}
private void Add_Click(object sender, RoutedEventArgs e)
{
if (DatePicker.DisplayDate == null)
{
MessageBox.Show("Date can`t be null.");
return;
}
Olympiad newType = new Olympiad();
GetPropForSelectedService getService = new GetPropForSelectedService();
newType.Date = DatePicker.SelectedDate.Value;
newType.Type = getService.GetOlympTypes().FirstOrDefault(x => x.Name == (OlympTypeComboBox.SelectedItem as OlympType).Name);
newType.Country = getService.GetCountry().FirstOrDefault(x => x.Name == (CountryComboBox.SelectedValue as Country).Name);
foreach (var o in getService.GetOlympiads())
{
if (o.Date == newType.Date)
{
MessageBox.Show($"Olympiads in {o.Date.ToString("0:d")} alredy exists.");
}
}
AddingService addService = new AddingService();
addService.AddOlympiad(newType);
MessageBox.Show("Olympiad adding");
}
public void Update_Single_Customer()
{
var options = new DbContextOptionsBuilder <CustomerContext>()
.UseInMemoryDatabase(databaseName: "TT50")
.Options;
var id = 0;
using (var context = new CustomerContext(options))
{
var service = new AddingService(context);
var kimHing = service.CreateCustomer(new Customer {
Firstname = "Kim Hing", Lastname = "Yong", Title = "Mr"
});
context.SaveChanges();
id = kimHing.CustomerID;
service.UpdateCustomer(new Customer
{
CustomerID = id,
Firstname = "Kim Kim",
Lastname = "Yong",
Title = "Mr"
});
}
using (var context = new CustomerContext(options))
{
var service = new AddingService(context);
var founded = service.FindById(id);
Assert.AreEqual("Kim Kim", founded.Firstname);
}
}
public void Create_Single_Customer_In_Memory()
{
SqliteConnection connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <CustomerContext>()
//.UseInMemoryDatabase(databaseName: "TT100")
.UseSqlite(connection)
.Options;
using (var context = new CustomerContext(options))
{
context.Database.EnsureCreated();
var service = new AddingService(context);
var nadal = new Customer
{
Firstname = "Dimitrij",
Lastname = "OVTCHAROV",
Title = "Mr"
};
service.CreateCustomer(nadal);
}
using (var context = new CustomerContext(options))
{
Assert.AreEqual(1, context.Customers.Count());
var added = context.Customers.Single();
Assert.AreEqual("Dimitrij", added.Firstname);
Assert.AreEqual("OVTCHAROV", added.Lastname);
Assert.AreEqual("Mr", added.Title);
}
}
private void Btn_Create_OnClick(object sender, RoutedEventArgs e)
{
var newProduct = new Product
{
Name = TxtName.Text,
Price = Convert.ToDecimal(TxtPrice.Text)
};
AddingService.AddProduct(newProduct);
if (MessageBox.Show("New product created") == MessageBoxResult.OK)
{
Close();
}
}
private void Add_Click(object sender, RoutedEventArgs e)
{
OlympResult newType = new OlympResult();
GetPropForSelectedService getService = new GetPropForSelectedService();
newType.OlympID = getService.GetOlympiads().FirstOrDefault(x => x.Date == (OlympiadComboBox.SelectedItem as Olympiad).Date).ID;
newType.SportTypeID = getService.GetSportTypes().FirstOrDefault(x => x.Name == (OlympiadComboBox.SelectedItem as SportType).Name).ID;
newType.PersonID = getService.GetPersons().FirstOrDefault(x => x.FirstName == (OlympiadComboBox.SelectedItem as Person).FirstName &&
x.SecondName == (OlympiadComboBox.SelectedItem as Person).SecondName &&
x.ThirdName == (OlympiadComboBox.SelectedItem as Person).ThirdName).ID;
newType.Place = Convert.ToInt32(PlaceTextBox.Text);
foreach (var or in getService.GetOlympsResult())
{
if (or.Olympiad.Date == newType.Olympiad.Date)
{
if (or.SportType.Name == newType.SportType.Name)
{
//if(or.City.Name == newType.City.Name)
if (or.Person.FirstName == newType.Person.FirstName)
{
if (or.Person.SecondName == newType.Person.SecondName)
{
if (or.Person.ThirdName == newType.Person.ThirdName)
{
if (or.Place == newType.Place)
{
MessageBox.Show("This node alredy exist.");
return;
}
}
}
}
}
}
}
AddingService addService = new AddingService();
addService.AddOlympiadResultNode(newType);
MessageBox.Show("New result node adding.");
}
private void Add_Click(object sender, RoutedEventArgs e)
{
if (DatePicker.DisplayDate == null)
{
MessageBox.Show("Date can`t be null.");
return;
}
if (PhotoPath == null)
{
MessageBox.Show("Photo can`t be null.");
return;
}
Person newType = new Person();
GetPropForSelectedService getService = new GetPropForSelectedService();
newType.FirstName = FirstName;
newType.SecondName = SecondName;
newType.ThirdName = ThirdName;
newType.CountryID = getService.GetCountry(false).FirstOrDefault(x => x.Name == (CountryComboBox.SelectedItem as Country).Name).ID;
newType.DateOfBirth = DatePicker.SelectedDate.Value;
newType.PhotoPath = PhotoPath;
foreach (var p in getService.GetPersons())
{
if (p.FirstName == newType.FirstName)
{
if (p.SecondName == newType.SecondName)
{
if (p.ThirdName == newType.ThirdName)
{
MessageBox.Show($"{p.FirstName} {p.SecondName} {p.ThirdName} alredy exist`s.");
return;
}
}
}
}
AddingService addService = new AddingService();
addService.AddPerson(newType);
MessageBox.Show("New person added.");
}
private void Btn_Create_OnClick(object sender, RoutedEventArgs e)
{
var gender = RBtnMale.IsChecked == true ? Gender.Male : Gender.Female;
var newClient = new Client
{
FirstName = TxtFirstName.Text,
LastName = TxtLastName.Text,
Gender = gender,
BirthDate = Convert.ToDateTime(DtpBirthDate.SelectedDate)
};
AddingService.AddClient(newClient);
if (MessageBox.Show("New client created") == MessageBoxResult.OK)
{
Close();
}
}
private void Add_Click(object sender, RoutedEventArgs e)
{
Country newType = new Country();
newType.Name = Name_;
GetPropForSelectedService GettingService = new GetPropForSelectedService();
foreach (var type in GettingService.GetCountry())
{
if (type.Name == Name_)
{
MessageBox.Show($"{Name_} alredy exists.");
return;
}
}
AddingService service = new AddingService();
service.AddCountry(newType);
MessageBox.Show("New country added.");
}
private void Btn_Create_OnClick(object sender, RoutedEventArgs e)
{
var clientId = GettingService.GetClients()
.First(c => c.FirstName + " " + c.LastName == CmbClient.SelectedItem.ToString()).Id;
var sellerId = GettingService.GetSellers()
.First(s => s.FirstName + " " + s.LastName == CmbSeller.SelectedItem.ToString()).Id;
var productId = GettingService.GetProducts().First(p => p.Name == CmbProduct.SelectedItem.ToString()).Id;
var newOrder = new Order
{
ClientId = clientId,
SellerId = sellerId,
ProductId = productId,
OrderDate = Convert.ToDateTime(DtpOrderDate.ToString())
};
AddingService.AddOrder(newOrder);
if (MessageBox.Show("New order created") == MessageBoxResult.OK)
{
Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
SportType newType = new SportType();
newType.Name = Name_;
GetPropForSelectedService GettingService = new GetPropForSelectedService();
foreach (var type in GettingService.GetSportTypes())
{
if (type.Name == Name_)
{
MessageBox.Show($"{Name_} type alredy exists.");
return;
}
}
AddingService service = new AddingService();
service.AddSportType(newType);
MessageBox.Show("New sport type added.");
}
private void Add_Click(object sender, RoutedEventArgs e)
{
City newType = new City();
newType.Name = Name_;
newType.Country = (CountryComboBox.SelectedItem as Country);
GetPropForSelectedService GettingService = new GetPropForSelectedService();
foreach (var type in GettingService.GetCities())
{
if (type.Name == Name_)
{
MessageBox.Show($"{Name_} type alredy exists.");
return;
}
}
AddingService service = new AddingService();
service.AddCity(newType);
MessageBox.Show("New city added.");
}
public void Find_Customers_By_Lastname()
{
var options = new DbContextOptionsBuilder <CustomerContext>()
.UseInMemoryDatabase(databaseName: "TT50")
.Options;
using (var context = new CustomerContext(options))
{
context.Customers.Add(new Customer {
Firstname = "Kim Hing", Lastname = "Yong", Title = "Mr"
});
context.Customers.Add(new Customer {
Firstname = "Burak Selim", Lastname = "Yong", Title = "Mr"
});
context.Customers.Add(new Customer {
Firstname = "Su Han", Lastname = "Yong", Title = "Ms"
});
context.Customers.Add(new Customer {
Firstname = "Kim Hing", Lastname = "Yang", Title = "Mr"
});
context.Customers.Add(new Customer {
Firstname = "Koki", Lastname = "Niwa", Title = "Ms"
});
context.Customers.Add(new Customer {
Firstname = "Fun Sun", Lastname = "Kim", Title = "Ms"
});
context.SaveChanges();
}
using (var context = new CustomerContext(options))
{
var service = new AddingService(context);
var result = service.FindByLastname("Yong");
Assert.AreEqual(3, result.Count());
}
}
