private void butAddDetail_Click(object sender, EventArgs e)
{
DrinkDetail drinkDetail = null;
if (!textBoxPrice.Text.Equals("") || !textBoxTax.Text.Equals(""))
{
drinkDetail = new DrinkDetail
{
availability = checkBoxAva.Checked,
idSize = Convert.ToByte(comboBoxSize.SelectedValue),
idKind = Convert.ToByte(comboBoxKind.SelectedValue),
price = Convert.ToDecimal(textBoxPrice.Text),
tax = Convert.ToInt32(textBoxTax.Text),
idDrink = getSelectedIdx(dataGridDrink, "Id")
};
data.DrinkDetails.InsertOnSubmit(drinkDetail);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
loadDrinkDetail();
errorHide();
}
else
{
errorShow("Need PRICE and TAX!");
}
}
private void butAddDrink_Click(object sender, EventArgs e)
{
Description description;
if (!textBoxName.Text.Equals(""))
{
if (textBoxDesc.Text.Equals(""))
{
description = new Description
{
decription = "Null"
};
}
else
{
description = new Description
{
decription = textBoxDesc.Text
};
}
data.Descriptions.InsertOnSubmit(description);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
Drink drink = new Drink
{
name = textBoxName.Text,
idDescription = description.Id,
adults = checkBoxIsAdult.Checked
};
data.Drinks.InsertOnSubmit(drink);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
DrinkDetail drinkDetail = new DrinkDetail
{
availability = false,
idSize = 1,
idKind = 1,
price = 0,
tax = 0,
Drink = drink
};
data.DrinkDetails.InsertOnSubmit(drinkDetail);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
loadDrink();
errorHide();
}
else
{
errorShow("Drink name isEmpty!");
}
}
public CocktailDetailsView(DrinkDetail cocktail)
{
this.cocktails = cocktail;
InitializeComponent();
FlowListView.Init();
BindingContext = CocktailViewModel._viewModelInstance;
var vm = BindingContext as CocktailViewModel;
vm.getCocktailDetails(cocktail);
}
private void butEditDetail_Click(object sender, EventArgs e)
{
int selected = getSelectedIdx(dataGridDetail, "Id");
toUpdateDetail = data.DrinkDetails.SingleOrDefault(x => x.Id == selected);
checkBoxAva.Checked = Convert.ToBoolean(toUpdateDetail.availability);
comboBoxSize.SelectedValue = toUpdateDetail.idSize;
comboBoxKind.SelectedValue = toUpdateDetail.idKind;
textBoxPrice.Text = toUpdateDetail.price.ToString();
textBoxTax.Text = toUpdateDetail.tax.ToString();
}
private void butDelDetail_Click(object sender, EventArgs e)
{
try
{
int selected = getSelectedIdx(dataGridDetail, "Id");
DrinkDetail result = data.DrinkDetails.SingleOrDefault(x => x.Id == selected);
data.DrinkDetails.DeleteOnSubmit(result);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
loadDrinkDetail();
}
public void getCocktailDetails(DrinkDetail cocktail)
{
_recipeDetails = cocktail;
_recipeImage = cocktail.StrDrinkThumb.ToString();
_recipeTitle = cocktail.StrDrink;
if (cocktail.strCategory != null)
{
_recipeCategory = cocktail.strCategory;
}
_recipeIngredients = new List <string>();
_recipeMeasures = new List <string>();
if (cocktail.strIngredient1 != null)
{
if (cocktail.strIngredient1 != "")
{
_recipeIngredients.Add(cocktail.strIngredient1);
}
if (cocktail.strIngredient2 != "")
{
_recipeIngredients.Add(cocktail.strIngredient2);
}
if (cocktail.strIngredient3 != "")
{
_recipeIngredients.Add(cocktail.strIngredient3);
}
if (cocktail.strIngredient4 != "")
{
_recipeIngredients.Add(cocktail.strIngredient4);
}
if (cocktail.strIngredient5 != "")
{
_recipeIngredients.Add(cocktail.strIngredient5);
}
if (cocktail.strIngredient6 != "")
{
_recipeIngredients.Add(cocktail.strIngredient6);
}
if (cocktail.strIngredient7 != "")
{
_recipeIngredients.Add(cocktail.strIngredient7);
}
if (cocktail.strIngredient8 != "")
{
_recipeIngredients.Add(cocktail.strIngredient8);
}
if (cocktail.strIngredient9 != "")
{
_recipeIngredients.Add(cocktail.strIngredient9);
}
}
if (cocktail.strMeasure1 != null)
{
if (cocktail.strMeasure1 != "")
{
_recipeMeasures.Add(cocktail.strMeasure1);
}
if (cocktail.strMeasure2 != "")
{
_recipeMeasures.Add(cocktail.strMeasure2);
}
if (cocktail.strMeasure3 != "")
{
_recipeMeasures.Add(cocktail.strMeasure3);
}
if (cocktail.strMeasure4 != "")
{
_recipeMeasures.Add(cocktail.strMeasure4);
}
if (cocktail.strMeasure5 != "")
{
_recipeMeasures.Add(cocktail.strMeasure5);
}
if (cocktail.strMeasure6 != "")
{
_recipeMeasures.Add(cocktail.strMeasure6);
}
if (cocktail.strMeasure7 != "")
{
_recipeMeasures.Add(cocktail.strMeasure7);
}
if (cocktail.strMeasure8 != "")
{
_recipeMeasures.Add(cocktail.strMeasure8);
}
if (cocktail.strMeasure9 != "")
{
_recipeMeasures.Add(cocktail.strMeasure9);
}
}
if (cocktail.strInstructions != null)
{
_recipeInstructions = cocktail.strInstructions;
}
if (cocktail.strAlcoholic != null)
{
_recipeIsAlcoholic = cocktail.strAlcoholic;
}
OnPropertyChanged("_recipeImage");
OnPropertyChanged("_recipeTitle");
OnPropertyChanged("_recipeIngredients");
OnPropertyChanged("_recipeCategory");
OnPropertyChanged("_recipeMeasures");
OnPropertyChanged("_recipeInstructions");
OnPropertyChanged("_recipeIsAlcoholic");
}
