public async void DeleteOrderItem(int id)
{
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
await connection.ExecuteAsync(SqlQueriesFactory.DeleteOrderItem(), new { Id = id });
}
}
public async Task <Table> GetFirstOrDefault(int id)
{
Table table;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
table = await connection.QueryFirstOrDefaultAsync <Table>(SqlQueriesFactory.GetTable(), new { Id = id });
}
return(table);
}
public async Task <IEnumerable <Table> > GetAll()
{
IEnumerable <Table> tablesList;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
tablesList = await connection.QueryAsync <Table>(SqlQueriesFactory.GetAllTables());
}
return(tablesList);
}
public async Task <Meal> GetFirstOrDefault(int id)
{
Meal meal;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
meal = await connection.QueryFirstOrDefaultAsync <Meal>(SqlQueriesFactory.GetMeal(), new { Id = id });
}
return(meal);
}
public async Task <IEnumerable <Meal> > GetAll()
{
IEnumerable <Meal> mealsList;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
mealsList = await connection.QueryAsync <Meal>(SqlQueriesFactory.GetAllMeals());
}
return(mealsList);
}
public async void Register(User user, string password)
{
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
await connection.ExecuteAsync(SqlQueriesFactory.AddUser(), user);
}
}
public async Task <bool> UserExists(string username)
{
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
if (await connection.QueryFirstOrDefaultAsync <User>(SqlQueriesFactory.GetUser(), new { Username = username }) == null)
{
return(false);
}
else
{
return(true);
}
}
}
public async Task <Meal> Add(Meal entity)
{
Meal insertedMeal;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
await connection.OpenAsync();
using (var transaction = await connection.BeginTransactionAsync())
{
insertedMeal = await connection.QueryFirstOrDefaultAsync <Meal>(SqlQueriesFactory.AddMeal(), entity);
await transaction.CommitAsync();
}
}
return(insertedMeal);
}
public async Task <User> Login(UserForLoginDto userForLoginDto)
{
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
var user = await connection.QueryFirstOrDefaultAsync <User>(SqlQueriesFactory.GetUser(), new { Username = userForLoginDto.Username });
if (user == null)
{
return(null);
}
if (!VerifyPasswordHash(userForLoginDto.Password, user.PasswordHash, user.PasswordSalt))
{
return(null);
}
return(user);
}
}
public async Task <Table> Add(Table entity)
{
Table insertedTable;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
await connection.OpenAsync();
using (var transaction = await connection.BeginTransactionAsync())
{
insertedTable = await connection.QueryFirstOrDefaultAsync <Table>(SqlQueriesFactory.AddTable(), entity);
await transaction.CommitAsync();
}
}
return(insertedTable);
}
