private void newToolStripMenuItem1_Click(object sender, EventArgs e)
{
Form newMeal = new NewMeal(this);
newMeal.Focus();
newMeal.ShowDialog();
}
public Meal CreateMeal(string name, NewMeal nm)
{
IMealBuilder builder = new MealBuilder(name);
switch (nm)
{
case NewMeal.HappyMeal:
ConcreteMealBuilder happy = new ConcreteMealBuilder();
happy.HappyMeal(builder);
return(builder.BuildMeal());
case NewMeal.MenuClassic:
ConcreteMealBuilder classic = new ConcreteMealBuilder();
classic.MeniuClasic(builder);
return(builder.BuildMeal());
case NewMeal.MenuPremium:
ConcreteMealBuilder premium = new ConcreteMealBuilder();
premium.MeniuClasic(builder);
return(builder.BuildMeal());
}
return(null);
}
public string Load()
{
try {
SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + dataBase));
connection.Open();
string sql = @"SELECT code, title FROM codeBook WHERE codeGroup = 'MEALS' ORDER BY codeOrder ASC";
SQLiteCommand command = new SQLiteCommand(sql, connection);
List <NewMeal> xx = new List <NewMeal>();
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
NewMeal x = new NewMeal();
x.code = reader.GetValue(0) == DBNull.Value ? "B" : reader.GetString(0);
x.title = reader.GetValue(1) == DBNull.Value ? GetMealTitle("B", connection) : reader.GetString(1);
x.description = "";
x.isSelected = true;
x.isDisabled = x.code == "B" || x.code == "L" || x.code == "D" ? true : false;
xx.Add(x);
}
connection.Close();
string json = JsonConvert.SerializeObject(xx, Formatting.None);
return(json);
} catch (Exception e) { return("Error: " + e); }
}
public List <NewMeal> LoadData()
{
List <NewMeal> xx = new List <NewMeal>();
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + dataBase))) {
connection.Open();
string sql = @"SELECT code, title FROM codeBook WHERE codeGroup = 'MEALS' ORDER BY codeOrder ASC";
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
using (SQLiteDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
NewMeal x = new NewMeal();
x.code = reader.GetValue(0) == DBNull.Value ? "B" : reader.GetString(0);
x.title = reader.GetValue(1) == DBNull.Value ? GetMealTitle("B", connection) : reader.GetString(1);
x.description = "";
x.isSelected = true;
x.isDisabled = x.code == "B" || x.code == "L" || x.code == "D" ? true : false;
xx.Add(x);
}
}
}
}
return(xx);
}
public void BuildNew(NewMeal nm) => meal.NewMeal = nm;
