public bool EditLocation(GymDALModel dalModel)
{
var sql = $@"UPDATE Locations
SET GymName = @{nameof(dalModel.GymName)}, OpenAfter10PM = @{nameof(dalModel.OpenAfter10PM)}, MembershipPrice = @{nameof(dalModel.MembershipPrice)}, City = @{nameof(dalModel.City)}
WHERE LocationID = @{nameof(dalModel.LocationId)}";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var results = connection.Execute(sql, dalModel);
if (results == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public bool InsertNewLocation(GymDALModel dalModel)
{
var sql = $@"INSERT INTO Locations (GymName, OpenAfter10PM, MembershipPrice, City)
VALUES (@{nameof(dalModel.GymName)}, @{nameof(dalModel.OpenAfter10PM)}, @{nameof(dalModel.MembershipPrice)}, @{nameof(dalModel.City)})";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var results = connection.Execute(sql, dalModel);
if (results == 1)
{
return(true);
}
else
{
return(false);
}
}
}
