public MealServicesDataAccessTests(ITestOutputHelper testOutputHelper)
{
_connectionString = "Data Source=" +
Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\OO_PocketGourmet_REAL-UnitTest\MVPDB.sqlite;";
_testOutputHelper = testOutputHelper;
_mealServices = new MealServices(new MealRepository(_connectionString), new ModelDataAnnotationCheck());
}
private void addMealBtn_Click(object sender, EventArgs e)
{
string mealName = nameTB.Text;
int mealPrice = Int32.Parse(priceTB.Text);
int salt = Int32.Parse(saltTB.Text);
int sweet = Int32.Parse(sweetTB.Text);
int sour = Int32.Parse(sourTB.Text);
int spicy = Int32.Parse(spicyTB.Text);
int bitter = Int32.Parse(bitterTB.Text);
string _connectionString = "Data Source=" +
Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\OO_PocketGourmet_REAL-UnitTest\MVPDB.sqlite;";
MealServices mealServices = new MealServices(new MealRepository(_connectionString), new ModelDataAnnotationCheck());
MealModel meal = new MealModel()
{
MealName = mealName,
MealPrice = mealPrice,
MealSaltTaste = salt,
MealSweetTaste = sweet,
MealSourTaste = sour,
MealSpicyTaste = spicy,
MealBitterTaste = bitter,
MealRestaurant = rID
};
mealServices.Add(meal);
MessageBox.Show("Meal Added");
}
private void deleteBtn_Click(object sender, EventArgs e)
{
string _connectionString = "Data Source=" +
Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\OO_PocketGourmet_REAL-UnitTest\MVPDB.sqlite;";
MealServices mealServices = new MealServices(new MealRepository(_connectionString), new ModelDataAnnotationCheck());
mealServices.Delete(mealm);
Lmf.Reload();
}
public void Reload()
{
mealPanel.Controls.Clear();
string _connectionString = "Data Source=" +
Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\OO_PocketGourmet_REAL-UnitTest\MVPDB.sqlite;";
MealServices mealServices = new MealServices(new MealRepository(_connectionString), new ModelDataAnnotationCheck());
mealList = (List <MealModel>)mealServices.GetAll(rID);
AddMealList(mealList);
}
public ListMealsForm(int id)
{
InitializeComponent();
rID = id;
string _connectionString = "Data Source=" +
Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\OO_PocketGourmet_REAL-UnitTest\MVPDB.sqlite;";
MealServices mealServices = new MealServices(new MealRepository(_connectionString), new ModelDataAnnotationCheck());
mealList = (List <MealModel>)mealServices.GetAll(id);
AddMealList(mealList);
}
