private void RestaurantLocationUpdate_SelectedValueChanged(object sender, EventArgs e)
{
RESTAURANT r = ent.RESTAURANTs.Where(re => re.RESTAURANT_NAME == RestaurantsNamesUpdate.Text && re.RESTAURANT_LOCATION == RestaurantLocationUpdate.Text).First();
RestaurantRatingUpdate.Value = r.RATING;
CusineTypeUpdate.Text = r.CUISINE_TYPE;
}
private void RestaurantsNamesUpdate_SelectedValueChanged(object sender, EventArgs e)
{
RESTAURANT r = ent.RESTAURANTs.Where(re => re.RESTAURANT_NAME == RestaurantsNamesUpdate.Text).First();
RestaurantRatingUpdate.Text = r.RATING.ToString();
RestaurantLocationUpdate.DataSource = ent.RESTAURANTs.Where(re => re.RESTAURANT_NAME == RestaurantsNamesUpdate.Text).Select(ree => ree.RESTAURANT_LOCATION).ToList();
CusineTypeUpdate.Text = r.CUISINE_TYPE;
}
private void updateRatingBtn_Click(object sender, EventArgs e)
{
if (CustomMsgBox.Show("Are you sure you want to update this restaurant?", 2) == DialogResult.Yes)
{
RESTAURANT r = ent.RESTAURANTs.Where(x => x.RESTAURANT_NAME == RestaurantsNamesUpdate.Text && x.RESTAURANT_LOCATION == RestaurantLocationUpdate.Text).First();
r.RATING = Convert.ToInt32(RestaurantRatingUpdate.Text);
r.CUISINE_TYPE = CusineTypeUpdate.Text;
ent.SaveChanges();
CustomMsgBox.Show("Restaurant Updated");
updateRest();
}
}
private void addResBtn_Click(object sender, EventArgs e)
{
if (CustomMsgBox.Show("Are you sure you want to add this restaurant?", 2) == DialogResult.Yes)
{
if (ent.RESTAURANTs.Where(x => x.RESTAURANT_NAME == RestaurantsNamesAdd.Text && x.RESTAURANT_LOCATION == RestaurantLocationAdd.Text).Count() > 0)
{
CustomMsgBox.Show("This restaurant already exists");
return;
}
RESTAURANT r = new RESTAURANT();
r.RESTAURANT_NAME = RestaurantsNamesAdd.Text;
r.RESTAURANT_LOCATION = RestaurantLocationAdd.Text;
r.RATING = int.Parse(ratingRest.Text);
r.CUISINE_TYPE = CusineTypeAdd.Text;
ent.RESTAURANTs.Add(r);
ent.SaveChanges();
CustomMsgBox.Show("Restaurant added");
updateRest();
}
}
