public Boolean GetBool()
{
MySqlConnection conn = conDB.OpenConnection();
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = "select * from autologin";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AutoLogin = Convert.ToBoolean((System.SByte)reader["bool"]);
}
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(AutoLogin);
}
public List <SaleModel> SelectOrderList(string WhereSql)
{
MySqlConnection conn = conDB.OpenConnection();
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = "SELECT * FROM kiosk.order " + WhereSql;
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
List <SaleModel> sales = new List <SaleModel>();
SaleModel sale;
while (reader.Read())
{
sale = new SaleModel();
sale.category = (String)reader["category"];
sale.price = (int)reader["price"];
sale.sale = (int)reader["sale"];
sale.count = (int)reader["count"];
sales.Add(sale);
}
return(sales);
}
catch (MySqlException ex)
{
Console.WriteLine(ex);
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(null);
}
public void SetMenuSetting(MenuModel instance)
{
MySqlConnection conn = conDB.OpenConnection();
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = "UPDATE " + instance.category + " SET sale =" + instance.sale + " WHERE id = " + instance.id;
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "UPDATE " + instance.category + " SET soldout =" + instance.soldOut + " WHERE id = " + instance.id;
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
}
public List <TableModel> GetTable()
{
TableModel table;
List <TableModel> list = new List <TableModel>();
MySqlConnection conn = conDB.OpenConnection();
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = "SELECT * FROM kiosk.table;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
table = new TableModel();
table.id = (int)reader["id"];
table.OrderTime = DateTime.Parse((string)reader["OrderTime"]);
list.Add(table);
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex);
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(list);
}
public List <TimeSpan> GetTime()
{
MySqlConnection conn = conDB.OpenConnection();
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = "select * from energizingtime";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
times.Add((TimeSpan)reader["time"]);
}
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(times);
}
public List <UserModel> GetUser()
{
MySqlConnection conn = conDB.OpenConnection();
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
UserModel user;
string sql = "select * from kiosk.user";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
user = new UserModel();
user.name = (String)reader["name"];
user.barcode = (String)reader["barcode"];
users.Add(user);
}
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(users);
}
public bool GetUserName(String barcode)
{
MySqlConnection conn = conDB.OpenConnection();
bool returnType = false;
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = "SELECT * FROM user WHERE barcode=\"" + barcode + "\"";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
App.userData.name = (string)reader["name"];
returnType = true;
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex);
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(returnType);
}
public bool SetOrderData(int orderIdx, string day, string time)
{
MySqlConnection conn = conDB.OpenConnection();
bool returnType = false;
try
{
conn.Open();
Console.WriteLine("DataBase연동 성공");
string sql = string.Format($"INSERT INTO kiosk.order(`menu`, `category`, `user`, `day`, `price`, `seat`, `sale`, `payment_method`, `time`, `count`) VALUES (" +
$"'{OrderModel.GetInstance()[orderIdx].Name}', '{OrderModel.GetInstance()[orderIdx].category}', '{App.userData.barcode}', '{day}', " +
$"{OrderModel.GetInstance()[orderIdx].Price}, {App.userData.seat}, {OrderModel.GetInstance()[orderIdx].sale}, '{App.userData.payment}','{time}', " +
$"{OrderModel.GetInstance()[orderIdx].Count});");
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
Console.WriteLine(ex);
switch (ex.Number)
{
case 0:
Console.WriteLine("데이터베이스 서버에 연결할 수 없습니다.");
break;
case 1045:
Console.WriteLine("유저 ID 또는 Password를 확인해주세요.");
break;
}
}
finally
{
conn.Close();
}
return(returnType);
}