private void Button_Click_1(object sender, RoutedEventArgs e)
{
int mealIdx = 0;
int a = MysqlConn.ExecuteNonQuery("insert into meal(meal_date, meal_type) values('" + DateTime.Now.ToShortDateString() + "', " + mealType + ");");
//mealIdx 찾아서 insert
var myRead = MysqlConn.ExecuteQuery("select meal_idx from meal where meal_date ='" + DateTime.Now.ToShortDateString() + "' and meal_type = " + mealType + ";");
if (myRead.Read())
{
mealIdx = Int32.Parse(myRead["meal_idx"].ToString());
}
if (mealIdx == 0)
{
//에러
MessageBox.Show("알수없는 에러.", "알림", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string[] temp = tempTb.Text.ToString().Split(',');
for (int i = 0; i < temp.Length; i++)
{
int b = MysqlConn.ExecuteNonQuery("insert into food(food_info, meal_idx) values('" + temp[i] + "', " + mealIdx + ");");
}
MessageBox.Show("급식이 등록되었습니다.", "알림", MessageBoxButton.OK);
tempTb.Text = "";
UpdateMeal?.Invoke(mealType);
this.Visibility = Visibility.Collapsed;
}
public IActionResult Update([FromBody] Meal meal)
{
var result = new UpdateMeal(Repository, meal).Execute();
if (result == -1)
{
return(Conflict());
}
return(Ok(result));
}
public void ShouldFailUpdatingMeal()
{
var mockMealRepo = new Mock <IMealRepository>();
mockMealRepo.Setup(m => m.Update(It.IsAny <domain.Meal>())).Returns(-1);
var date = DateTime.Now;
var input = new domain.Meal(date, "patates", 0);
var updateMeal = new UpdateMeal(mockMealRepo.Object, input);
var res = updateMeal.Execute();
Assert.AreEqual(-1, res);
}
