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 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 sellingUpdateButton_Click(object sender, EventArgs e)
{
try
{
var id = new Guid(DatabaseWorker.getWordFromListBox(sellingListBox, 0));
string address = DatabaseWorker.getWordFromListBox(sellingListBox, 1);
string flavor = DatabaseWorker.getWordFromListBox(sellingListBox, 2);
using (var db = new IceCreamContext())
{
var updateSelling = (from selling in db.IceCreamSelling
where selling.SellingId == id
select selling).First();
var newStore = (from store in db.IceCreamStores
where store.Address == address
select store).First();
var newIceCream = (from iceCream in db.IceCreamFlavors
where iceCream.Flavor == flavor
select iceCream).First();
string updateInfo = "update IceCreamSelling set Store='" + newStore + "',IceCreamFlavor='"
+ newIceCream + "' where SellingId='" + updateSelling.SellingId + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateSellingListBox(sellingListBox);
}
}
catch (Exception ex)
{
sellingErrorLabel.Text = ex.Message;
}
}
private void sellerUpdateNumber_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(sellersListBox, 0);
string work = DatabaseWorker.getWordFromListBox(sellersListBox, 4);
using (var db = new IceCreamContext())
{
var updateSeller = (from seller in db.IceCreamSellers
where seller.PersonalId == keyText
select seller).First();
var iceCreamStore = (from store in db.IceCreamStores
where store.Address == work
select store).First();
string updateInfo = "update IceCreamSellers set PersonalId='" + sellerPersonalIdTextBox.Text + "',FirstName='"
+ sellerFirstNameTextBox.Text + "',LastName='" + sellerLastNameTextBox.Text + "',Salary='" + sellerSalaryTextBox.Text
+ "',IceCreamStore='" + iceCreamStore + "' where Address='" + updateSeller.PersonalId + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateSellersListBox(sellersListBox);
}
}
catch (Exception ex)
{
sellerErrorLabel.Text = ex.Message;
}
}
private void updateIceCreamButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(IceCreamListBox, 0);
string makerId = DatabaseWorker.getWordFromListBox(IceCreamListBox, 2);
using (var db = new IceCreamContext())
{
var updateIceCream = (from iceCream in db.IceCreamFlavors
where iceCream.Flavor == keyText
select iceCream).First();
var iceCreamMaker = (from maker in db.IceCreamMakers
where maker.MakersPersonalId == makerId
select maker).First();
string updateInfo = "update IceCreamFlavors set Flavor='" + flavorTextBox.Text + "',PricePerKilo='" + pricePerKiloTextBox.Text
+ "',IceCreamMaker='" + iceCreamMaker + "' where Flavor='" + updateIceCream.Flavor + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateIceCreamListBox(IceCreamListBox);
}
}
catch (Exception ex)
{
iceCreamErrorLabel.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;
}
}
public static void updateStoreListBox(ListBox StoreListBox)
{
StoreListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var query = from b in db.IceCreamStores
orderby b.Address
select b;
foreach (var item in query)
{
StoreListBox.Items.Add(item.ToString());
}
}
}
private void button1_Click(object sender, EventArgs e)
{
worksListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var iceCreamPrice = (from iceCream in db.IceCreamFlavors
select iceCream.PricePerKilo).ToArray();
double sum = iceCreamPrice.Aggregate((a, b) => b + a);
int count = iceCreamPrice.Count();
worksListBox.Items.Add(sum / count);
}
}
public static void updateMakersListBox(ListBox makersListBox)
{
makersListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var query = from b in db.IceCreamMakers
orderby b.MakersPersonalId
select b;
foreach (var item in query)
{
makersListBox.Items.Add(item.ToString());
}
}
}
public static void updateSellingListBox(ListBox sellingListBox)
{
sellingListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var sellingList = from selling in db.IceCreamSelling
orderby selling.SellingId
select selling;
foreach (var selling in sellingList)
{
sellingListBox.Items.Add(selling.ToString());
}
}
}
public static void updateIceCreamListBox(ListBox IceCreamListBox)
{
IceCreamListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var iceCreamList = from iceCream in db.IceCreamFlavors
orderby iceCream.Flavor
select iceCream;
foreach (var iceCream in iceCreamList)
{
IceCreamListBox.Items.Add(iceCream.ToString());
}
}
}
public static void ShowSellersWorks(ListBox worksListBox)
{
worksListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var sellersWorks = from seller in db.IceCreamSellers
join store in db.IceCreamStores on seller.Address equals store.Address
select new { FirstName = seller.FirstName,
LastName = seller.LastName,
Work = seller.Address,
Time = store.WorkingHours };
foreach (var sellerWork in sellersWorks)
{
worksListBox.Items.Add(sellerWork.FirstName + ", " + sellerWork.LastName + ", " + sellerWork.Work + ", " + sellerWork.Time);
}
}
}
private void iceCreambyMakersButton_Click(object sender, EventArgs e)
{
worksListBox.Items.Clear();
using (var db = new IceCreamContext())
{
var queryIceCreamByMakers =
from iceCream in db.IceCreamFlavors
group iceCream by iceCream.MakersPersonalId into newGroup
orderby newGroup.Key
select newGroup;
foreach (var makerId in queryIceCreamByMakers)
{
foreach (var iceCream in makerId)
{
worksListBox.Items.Add(makerId.Key + ", " + iceCream.Flavor);
}
}
}
}
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 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 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;
}
}
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 StoreUpdateButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(StoreListBox, 0);
using (var db = new IceCreamContext())
{
var updateStore = (from store in db.IceCreamStores
where store.Address == keyText
select store).First();
string updateInfo = "update IceCreamStores set Adress='" + AddressTextBox.Text + "',WorkingHours='" + workingHoursTextBox.Text
+ "' where Adress='" + updateStore.Address + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateStoreListBox(StoreListBox);
}
}
catch (Exception ex)
{
storeErrorLabel.Text = ex.Message;
}
}
private void makerUpdateButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(makersListBox, 0);
using (var db = new IceCreamContext())
{
var updateMaker = (from maker in db.IceCreamMakers
where maker.MakersPersonalId == keyText
select maker).First();
string updateInfo = "update IceCreamMakers set MakersPersonalID='" + makerIdTextBox.Text + "',FirstName='"
+ makerFirstNameTextBox.Text + "',LastName='" + makerLastNameTextBox.Text + "',Salary='" + MakerSalaryTextBox.Text
+ "',PhoneNumber='" + MakerPhoneNumberTextBox.Text + "' where makersPersonalID='" + updateMaker.MakersPersonalId + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateMakersListBox(makersListBox);
}
}
catch (Exception ex)
{
makerErrorLabel.Text = ex.Message;
}
}
