public BaseResponse <DrinkSelection> SelectDrink(string badgeReference, Guid drinkId, int sugarQuantity)
{
var drinkSelectionToAdd = new DrinkSelection()
{
BadgeReference = badgeReference,
Drink_Id = drinkId,
SugarQuantity = sugarQuantity
};
return(service.AddOrUpdateDrinkSelection(drinkSelectionToAdd));
}
public BaseResponse <DrinkSelection> AddOrUpdateDrinkSelection(DrinkSelection drinkSelection)
{
if (drinkSelection.BadgeReference == null || drinkSelection.Drink_Id == Guid.Empty)
{
return(new BaseResponse <DrinkSelection>(ResultCodeEnum.InvalidData, message: null));
}
var drinkSelectionInDb = dataLayer.GetDrinkSelectionByBadgeReference(drinkSelection.BadgeReference);
if (drinkSelectionInDb == null)
{
dataLayer.Insert(drinkSelection);
}
else
{
dataLayer.Update(drinkSelection);
}
return(new BaseResponse <DrinkSelection>(ResultCodeEnum.Success, message: null, resultItem: drinkSelection));
}
public void Save(DrinkSelection drink)
{
var insert = @"
INSERT INTO tbDrinks (DrinkName, DateOfOrder, Qty, UserName, UserCompany)
VALUES (@DrinkName, @DateOfOrder, @Qty, @UserName, @UserCompany)
";
var parameters = new[]
{
new SqlParameter("@DrinkName", SqlDbType.Varchar)
{
Value = drink.Name
},
new SqlParameter("@DateOfOrder", SqlDbType.DateTime)
{
Value = DateTime.Today
},
new SqlParameter("@Qty", SqlDbType.Varchar)
{
Value = drink.Qty
},
new SqlParameter("@UserName", SqlDbType.Varchar)
{
Value = _userName
},
new SqlParameter("@UserCompany", SqlDbType.Varchar)
{
Value = _userCompany
}
};
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand())
{
command.CommandText = insert;
command.Parameters.AddRange(parameters);
connection.Open();
command.ExecuteNonQuery();
}
}
