private void sellingInsertButton_Click(object sender, EventArgs e)
{
try
{
using (var db = new IceCreamContext())
{
string storeAddress = iceCreamStoreTextBox.Text;
string flavor = iceCreamTextBox.Text;
var store = (from iceCreamStore in db.IceCreamStores
where iceCreamStore.Address == storeAddress
select iceCreamStore).First();
var iceCreamFlavor = (from iceCream in db.IceCreamFlavors
where iceCream.Flavor == flavor
select iceCream).First();
Selling selling = new Selling
{
SellingId = Guid.NewGuid(),
Store = store,
IceCreamFlavour = iceCreamFlavor
};
db.IceCreamSelling.Add(selling);
db.SaveChanges();
sellingListBox.Items.Add(selling.ToString());
}
}
catch (Exception ex)
{
sellingErrorLabel.Text = ex.Message;
}
}
private void insertIceCreamButton_Click(object sender, EventArgs e)
{
try
{
using (var db = new IceCreamContext())
{
string flavor = flavorTextBox.Text;
double price = Convert.ToDouble(pricePerKiloTextBox.Text);
string makerId = MakerTextBox.Text;
var maker = (from iceCreamMaker in db.IceCreamMakers
where iceCreamMaker.MakersPersonalId == makerId
select iceCreamMaker).First();
IceCream iceCream = new IceCream {
Flavor = flavor, PricePerKilo = price, Maker = maker
};
db.IceCreamFlavors.Add(iceCream);
db.SaveChanges();
IceCreamListBox.Items.Add(iceCream.ToString());
}
}
catch (Exception ex)
{
iceCreamErrorLabel.Text = ex.Message;
}
}
private void sellerInsertButton_Click(object sender, EventArgs e)
{
try
{
using (var db = new IceCreamContext())
{
string id = sellerPersonalIdTextBox.Text;
string firstName = sellerFirstNameTextBox.Text;
string lastName = sellerLastNameTextBox.Text;
float salary = (float)Convert.ToDouble(sellerSalaryTextBox.Text);
string work = sellerWorkPlaceTextBox.Text;
var store = (from iceCreamStore in db.IceCreamStores
where iceCreamStore.Address == work
select iceCreamStore).First();
Seller seller = new Seller
{
PersonalId = id,
FirstName = firstName,
LastName = lastName,
Salary = salary,
Store = store
};
db.IceCreamSellers.Add(seller);
db.SaveChanges();
sellersListBox.Items.Add(seller.ToString());
}
}
catch (Exception ex)
{
sellerErrorLabel.Text = ex.Message;
}
}
private void makerInsertButton_Click(object sender, EventArgs e)
{
try
{
using (var db = new IceCreamContext())
{
string id = makerIdTextBox.Text;
string firstName = makerFirstNameTextBox.Text;
string lastName = makerLastNameTextBox.Text;
float salary = (float)Convert.ToDouble(MakerSalaryTextBox.Text);
string number = MakerPhoneNumberTextBox.Text;
IceCreamMaker iceCreamMaker = new IceCreamMaker {
MakersPersonalId = id, FirstName = firstName, LastName = lastName, Salary = salary,
PhoneNumber = number
};
db.IceCreamMakers.Add(iceCreamMaker);
db.SaveChanges();
makersListBox.Items.Add(iceCreamMaker.ToString());
}
}
catch (Exception ex)
{
iceCreamMakerErrorLabel.Text = ex.Message;
}
}
private void StoreDeleteButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(StoreListBox, 0);
using (var db = new IceCreamContext())
{
var deleteStore = (from store in db.IceCreamStores
where store.Address == keyText
select store).First();
db.IceCreamStores.Remove(deleteStore);
db.SaveChanges();
StoreListBox.Items.Remove(StoreListBox.SelectedItem);
}
}
catch (Exception ex)
{
storeErrorLabel.Text = ex.Message;
}
}
private void storeInsertButton_Click(object sender, EventArgs e)
{
try
{
using (var db = new IceCreamContext())
{
string address = AddressTextBox.Text;
string workingHours = workingHoursTextBox.Text;
IceCreamStore store = new IceCreamStore {
Address = address, WorkingHours = workingHours
};
db.IceCreamStores.Add(store);
db.SaveChanges();
////StoreListBox.Items.Add(store);
}
}
catch (Exception ex)
{
storeErrorLabel.Text = ex.Message;
}
}
private void sellingDeleteButton_Click(object sender, EventArgs e)
{
try
{
var id = new Guid(DatabaseWorker.getWordFromListBox(sellingListBox, 0));
using (var db = new IceCreamContext())
{
var deleteSelling = (from selling in db.IceCreamSelling
where selling.SellingId == id
select selling).First();
db.IceCreamSelling.Remove(deleteSelling);
db.SaveChanges();
sellingListBox.Items.Remove(sellingListBox.SelectedItem);
}
}
catch (Exception ex)
{
sellingErrorLabel.Text = ex.Message;
}
}
private void sellerDeleteButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(sellersListBox, 0);
using (var db = new IceCreamContext())
{
var deleteSeller = (from seller in db.IceCreamSellers
where seller.PersonalId == keyText
select seller).First();
db.IceCreamSellers.Remove(deleteSeller);
db.SaveChanges();
sellersListBox.Items.Remove(sellersListBox.SelectedItem);
}
}
catch (Exception ex)
{
sellerErrorLabel.Text = ex.Message;
}
}
private void deleteIceCreamButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(IceCreamListBox, 0);
using (var db = new IceCreamContext())
{
var deleteIceCream = (from iceCream in db.IceCreamFlavors
where iceCream.Flavor == keyText
select iceCream).First();
db.IceCreamFlavors.Remove(deleteIceCream);
db.SaveChanges();
IceCreamListBox.Items.Remove(IceCreamListBox.SelectedItem);
}
}
catch (Exception ex)
{
iceCreamErrorLabel.Text = ex.Message;
}
}
