private void Button_Click(object sender, RoutedEventArgs e)
{
if (nameTb.Text == "" || idTb.Text == "" || pwPb.Password == "")
{
MessageBox.Show("칸을 모두 채워주세요.", "알림", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
var MyRead = MysqlConn.ExecuteQuery("select id from user where id='" + idTb.Text + "'");
if (MyRead.Read())
{
MessageBox.Show("이미 존재하는 아이디입니다.", "알림", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
int a = MysqlConn.ExecuteNonQuery("insert into user value('" + nameTb.Text + "', '" + idTb.Text + "', '" + MainWindow.Sha512Hash(pwPb.Password) + "')");
if (a == 1)
{
MessageBox.Show("회원가입 성공", "알림", MessageBoxButton.OK);
this.Visibility = Visibility.Collapsed;
}
else
{
MessageBox.Show("회원가입 실패", "알림", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
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;
}
private void GetMenu(int mealType)
{
var myRead = MysqlConn.ExecuteQuery("select * from meal natural join food where meal_date = '" + DateTime.Now.ToShortDateString() + "' and meal_type=" + mealType + ";");
string menuString = "";
while (myRead.Read())
{
menuString += myRead["food_info"] + "\n";
}
if (menuString == "")
{
return;
}
switch (mealType)
{
case 1:
type1Tb.Text = menuString;
break;
case 2:
type2Tb.Text = menuString;
break;
case 3:
type3Tb.Text = menuString;
break;
}
return;
}
private void LoginBtn_Click(object sender, RoutedEventArgs e)
{
if (idTb.Text == "" || pwPb.Password == "")
{
MessageBox.Show("아이디 또는 비밀번호를 입력하세요.", "알림", MessageBoxButton.OK, MessageBoxImage.Error);
}
var MyRead = MysqlConn.ExecuteQuery("select name from user where id='" + idTb.Text + "' and pw='" + Sha512Hash(pwPb.Password.ToString()) + "'");
if (MyRead.Read())
{
userName = MyRead["name"].ToString();
MessageBox.Show(userName + "님 환영합니다!", "알림", MessageBoxButton.OK);
MyRead.Close();
ShowMealCtrl.Visibility = Visibility.Visible;
//로그인 성공 이후 로직 구현.
InitData();
}
else
{
MessageBox.Show("로그인에 실패하였습니다.", "알림", MessageBoxButton.OK, MessageBoxImage.Error);
MyRead.Close();
return;
}
}
