public IceCreamDatabaseForm()
{
InitializeComponent();
DatabaseWorker.updateStoreListBox(StoreListBox);
DatabaseWorker.updateMakersListBox(makersListBox);
DatabaseWorker.updateIceCreamListBox(IceCreamListBox);
DatabaseWorker.updateSellersListBox(sellersListBox);
DatabaseWorker.updateSellingListBox(sellingListBox);
}
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;
}
}
