public static Entity.Dish Get_Dish_By_ID(int id)
{
Entity.Dish dish = null;
int type = 9999;
String sql2 = "select * from menu_dish where dish_id = " + id;
DataTable dt2 = Dao.GetDataBySQL(sql2);
foreach (DataRow row in dt2.Rows)
{
type = Int32.Parse(Convert.ToString(row["menu_id"]));
}
String sql = "select * from dishs where dishs.id = " + id;
DataTable dt = Dao.GetDataBySQL(sql);
foreach (DataRow row in dt.Rows)
{
int ID = Int32.Parse(Convert.ToString(row["id"]));
String Name = Convert.ToString(row["name"]);
String avatar = Convert.ToString(row["avatar"]);
double Price = Double.Parse(Convert.ToString(row["price"]));
double Discount = Double.Parse(Convert.ToString(row["discount"]));
String Description = Convert.ToString(row["description"]);
dish = new Entity.Dish(ID, Name, type, Description, Discount, Price, avatar);
}
return(dish);
}
public static Entity.Dish Get_Dish_By_Name(String dishName)
{
Entity.Dish dish = null;
String sql = "select * from dishs where dishs.name = N'" + dishName + "'";
DataTable dt = Dao.GetDataBySQL(sql);
foreach (DataRow row in dt.Rows)
{
int ID = Int32.Parse(Convert.ToString(row["id"]));
String Name = Convert.ToString(row["name"]);
String avatar = Convert.ToString(row["avatar"]);
double Price = Double.Parse(Convert.ToString(row["price"]));
double Discount = Double.Parse(Convert.ToString(row["discount"]));
String Description = Convert.ToString(row["description"]);
dish = new Entity.Dish(ID, Name, 0, Description, Discount, Price, avatar);
}
return(dish);
}
