public static String GetMealInsertQuery(Meal meal)
{
String query = "insert into meal(nationID,mealTypeID,festivalID,mealNameVN,mealPicture,descriptionVN,tutorialVN,insertedByEmail,dietID)"
+ "values('" + meal.NationID + "','" + meal.MealTypeID + "','" + meal.FesID + "','" + meal.MealName
+ "','" + meal.MealPic + "','" + meal.Description + "','" + meal.Tutorial + "','" + meal.InsertedBy + "','" + meal.DietID
+ "');";
return query;
}
public void InsertMeal(Meal meal)
{
try
{
MySqlCommand cmd = mySqlConnection.CreateCommand();
cmd.CommandText = "insert into meal(mealTypeID,mealNameVN,mealPicture,descriptionVN,tutorialVN,dietID)"
+ "values (@mealTypeID,@mealName,@mealPic,@description,@tutorial,@dietID)";
cmd.Parameters.AddWithValue("@mealTypeID", meal.MealTypeID);
cmd.Parameters.AddWithValue("@mealName", meal.MealName);
cmd.Parameters.AddWithValue("@mealPic", meal.MealPic);
cmd.Parameters.AddWithValue("@description", meal.Description);
cmd.Parameters.AddWithValue("@tutorial", meal.Tutorial);
cmd.Parameters.AddWithValue("@dietID", meal.DietID);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show("Error: " + e.Message);
throw;
}
}
private void btnUpdateMeal_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to update this(these) row(s)", "Update row", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Meal meal = new Meal();
meal.MealName = txtMealName.Text;
meal.MealTypeID = cbbMealTypeID.SelectedIndex + 1;
meal.DietID = cbbDiet.SelectedIndex + 1;
meal.MealPic = txtMealPicture.Text;
meal.Description = txtDescription.Text;
meal.Tutorial = txtTutorial.Text;
foreach (DataGridViewRow row in this.dgvMeal.SelectedRows)
{
DataGridViewCell cell = row.Cells[0];
int id = int.Parse(cell.Value.ToString());
mysqlConectionService.UpdateMeal(meal,id);
}
MessageBox.Show("Updating successfull!");
this.LoadMealData();
}
else if (dialogResult == DialogResult.No)
{
return;
}
}
private void btnInsertMeal_Click(object sender, EventArgs e)
{
if (txtMealName.Text == "")
{
MessageBox.Show("Tên món ăn ko được để trống");
return;
}
Meal meal = new Meal();
meal.MealName = txtMealName.Text;
meal.MealTypeID = cbbMealTypeID.SelectedIndex + 1;
meal.DietID = cbbDiet.SelectedIndex + 1;
string url = txtMealPicture.Text;
string file = "" ;
if ( url.Contains("http://"))
{
file = FileUtil.DownLoadFile(url);
meal.MealPic = file;
}
meal.Description = txtDescription.Text;
meal.Tutorial = txtTutorial.Text;
mysqlConectionService.InsertMeal(meal);
string query = DatabaseUtil.GetMealInsertQuery(meal);
// Export File Query
FileUtil.ExportQueryFile(query);
MessageBox.Show("Inserting successfull!");
flagInsert = 1;
this.LoadMealData();
}
public void UpdateMeal(Meal meal, int id)
{
try
{
MySqlCommand cmd = mySqlConnection.CreateCommand();
cmd.CommandText = "update meal set mealTypeID=@mealTypeID,"
+ "mealNameVN=@mealName,mealPicture=@mealPic,descriptionVN=@description,tutorialVN=@tutorial,dietID=@dietID"
+ " where mealID=" + id;
cmd.Parameters.AddWithValue("@mealTypeID", meal.MealTypeID);
cmd.Parameters.AddWithValue("@mealName", meal.MealName);
cmd.Parameters.AddWithValue("@mealPic", meal.MealPic);
cmd.Parameters.AddWithValue("@description", meal.Description);
cmd.Parameters.AddWithValue("@tutorial", meal.Tutorial);
cmd.Parameters.AddWithValue("@dietID", meal.DietID);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show("Error: " + e.Message);
throw;
}
}