public void Delete(FoodOrder foodOrder)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "DELETE FROM FoodOrders WHERE Id = @Id";
db.Execute(sqlQuery, foodOrder);
}
}
public void Update(FoodOrder foodOrder)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "UPDATE FoodOrders SET DishName = @DishName, Count = @Count WHERE Id = @Id";
db.Execute(sqlQuery, foodOrder);
}
}
public void Create(FoodOrder foodOrder)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
var sqlQuery = "INSERT INTO FoodOrders (DishName, Count) VALUES(@DishName, @Count); SELECT CAST(SCOPE_IDENTITY() as int)";
int orderId = dbConnection.Query <int>(sqlQuery, foodOrder).FirstOrDefault();
foodOrder.Id = orderId;
}
}
public FoodOrder Get(int?id)
{
FoodOrder foodOrder = null;
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
foodOrder = dbConnection.Query <FoodOrder>("SELECT * FROM FoodOrders f WHERE f.Id = @id", new { id }).FirstOrDefault();
}
return(foodOrder);
}
public void Delete(FoodOrder foodOrder)
{
foodContext.Entry(foodOrder).State = EntityState.Deleted;
foodContext.SaveChanges();
}
public void Update(FoodOrder foodOrder)
{
foodContext.Entry(foodOrder).State = EntityState.Modified;
foodContext.SaveChanges();
}
public void Create(FoodOrder foodOrder)
{
foodContext.Entry(foodOrder).State = EntityState.Added;
foodContext.SaveChanges();
}
