public void Add(IMealModel mealModel)
{
//throw new NotImplementedException();
DataAccessStatus dataAccesStatus = new DataAccessStatus();
using (SQLiteConnection sqLiteConnection = new SQLiteConnection(_connectionString))
{
try
{
sqLiteConnection.Open();
}
catch (SQLiteException e)
{
dataAccesStatus.setValues(status: "Error", operationSucceded: false, exceptionMessage: e.Message, customMessage: "Unable to open db connection", helpLink: e.HelpLink, errorCode: e.ErrorCode, stackTrace: e.StackTrace);
throw new DataAccessException(e.Message, e.InnerException, dataAccesStatus);
}
string sql = "INSERT INTO Meals (MealName, MealPrice, MealRestaurant, MealSaltTaste, MealSourTaste, MealSpicyTaste, MealSweetTaste, MealBitterTaste)" +
"VALUES (@MealName, @MealPrice, @MealRestaurant, @MealSaltTaste, @MealSourTaste, @MealSpicyTaste, @MealSweetTaste, @MealBitterTaste)";
using (SQLiteCommand cmd = new SQLiteCommand(sql, sqLiteConnection))
{
cmd.CommandText = sql;
cmd.Prepare();
cmd.Parameters.AddWithValue("@MealName", mealModel.MealName);
cmd.Parameters.AddWithValue("@MealPrice", mealModel.MealPrice);
cmd.Parameters.AddWithValue("@MealRestaurant", mealModel.MealRestaurant);
cmd.Parameters.AddWithValue("@MealSaltTaste", mealModel.MealSaltTaste);
cmd.Parameters.AddWithValue("@MealSourTaste", mealModel.MealSourTaste);
cmd.Parameters.AddWithValue("@MealSpicyTaste", mealModel.MealSpicyTaste);
cmd.Parameters.AddWithValue("@MealSweetTaste", mealModel.MealSweetTaste);
cmd.Parameters.AddWithValue("@MealBitterTaste", mealModel.MealBitterTaste);
try
{
cmd.ExecuteNonQuery();
}
catch (SQLiteException e)
{
dataAccesStatus.setValues(status: "Error", operationSucceded: false, exceptionMessage: e.Message, customMessage: "Unable to add Meal to db", helpLink: e.HelpLink, errorCode: e.ErrorCode, stackTrace: e.StackTrace);
throw new DataAccessException(e.Message, e.InnerException, dataAccesStatus);
}
sqLiteConnection.Close();
}
}
}
public void Delete(IMealModel mealModel)
{
//throw new NotImplementedException();
DataAccessStatus dataAccesStatus = new DataAccessStatus();
using (SQLiteConnection sqLiteConnection = new SQLiteConnection(_connectionString))
{
try
{
sqLiteConnection.Open();
}
catch (SQLiteException e)
{
dataAccesStatus.setValues(status: "Error", operationSucceded: false, exceptionMessage: e.Message, customMessage: "Unable to open db connection", helpLink: e.HelpLink, errorCode: e.ErrorCode, stackTrace: e.StackTrace);
throw new DataAccessException(e.Message, e.InnerException, dataAccesStatus);
}
string sql = "DELETE FROM Meals WHERE MealID=@MealID";
using (SQLiteCommand cmd = new SQLiteCommand(sql, sqLiteConnection))
{
/*try
* {
* UserExistsCheck(cmd, userModel, TypeOfExsistenceCheck.DoesNotExistInDB, RequestType.Add)
* }*/
cmd.CommandText = sql;
cmd.Prepare();
cmd.Parameters.AddWithValue("@MealID", mealModel.MealID);
try
{
cmd.ExecuteNonQuery();
}
catch (SQLiteException e)
{
dataAccesStatus.setValues(status: "Error", operationSucceded: false, exceptionMessage: e.Message, customMessage: "Unable to remove Meal from db", helpLink: e.HelpLink, errorCode: e.ErrorCode, stackTrace: e.StackTrace);
throw new DataAccessException(e.Message, e.InnerException, dataAccesStatus);
}
sqLiteConnection.Close();
}
}
}
public void Update(IMealModel mealModel)
{
throw new NotImplementedException();
}
public void ValidateModelDataAnnotations(IMealModel mealModel)
{
_modelDataAnnotationCheck.ValidateModelDataAnnotations(mealModel);
}
public void ValidateModel(IMealModel mealModel)
{
//throw new NotImplementedException();
_modelDataAnnotationCheck.ValidateModelDataAnnotations(mealModel);
}
public void Delete(IMealModel mealModel)
{
//throw new NotImplementedException();
_mealRepository.Delete(mealModel);
}
public void Add(IMealModel mealModel)
{
//throw new NotImplementedException();
_mealRepository.Add(mealModel);
}
