public async Task <ActionResult <SpecificPrice> > PostSpecificPrice(SpecificPrice specificPrice)
{
_context.SpecificPrice.Add(specificPrice);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSpecificPrice", new { id = specificPrice.SpecificPriceID }, specificPrice));
}
public async Task <IActionResult> PutSpecificPrice(int id, SpecificPrice specificPrice)
{
if (id != specificPrice.SpecificPriceID)
{
return(BadRequest());
}
_context.Entry(specificPrice).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SpecificPriceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private async void SaveButtonClicked(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(drinkName.Text) || selectedBar.SelectedItem == null || string.IsNullOrEmpty(EntryDrinkPrice.Text))
{
await DisplayAlert("Warning", "Bad Input", "Ok");
return;
}
Bar bar = ((Bar)selectedBar.SelectedItem);
if (Regex.IsMatch(EntryDrinkPrice.Text, @"(^[1-9]\d*(.\d{1,2})?$)|(^0(\.\d{1,2})?$)"))
{
float price = (float)Convert.ToDouble(EntryDrinkPrice.Text);
Drink drink = new Drink(drinkName.Text);
drink.DrinkLocations = new List <SpecificPrice>();
var restService = new RestService();
List <Drink> DrinkList = await restService.GetData <List <Drink> >(Constants.DrinksUrl);
bool flag = false;
foreach (Drink drinkCheck in DrinkList)
{
if (drinkCheck.DrinkName == drink.DrinkName)
{
flag = true;
drink = drinkCheck;
}
}
if (flag == false)
{
await restService.SaveData <Drink>(drink, Constants.DrinksUrl, true);
}
List <SpecificPrice> SpecificPriceList = await restService.GetData <List <SpecificPrice> >(Constants.SpecificPricesUrl);
SpecificPrice drinkPrice = new SpecificPrice
{
BarID = bar.BarID,
DrinkPrice = price,
DrinkID = drink.DrinkID
};
flag = false;
foreach (SpecificPrice checkPrice in SpecificPriceList)
{
if (checkPrice.BarID == drinkPrice.BarID && checkPrice.DrinkID == drinkPrice.DrinkID)
{
await DisplayAlert("Warning", "Drink with this name already exists in this bar", "Ok");
return;
}
}
await restService.SaveData <SpecificPrice>(drinkPrice, Constants.SpecificPricesUrl, true);
}
}
private async void Button_Clicked(object sender, EventArgs e)
{
if (Regex.IsMatch(newEntryPrice.Text, @"(^[1-9]\d*(.\d{1,2})?$)|(^0(\.\d{1,2})?$)"))
{
if (barChoice.SelectedItem == null || drinkChoice.SelectedItem == null)
{
newEntryPrice.Text = "";
await DisplayAlert("Warning", "Bad Input", "Ok");
return;
}
Bar bar = ((Bar)barChoice.SelectedItem);
Drink drink = ((Drink)drinkChoice.SelectedItem);
float price = (float)Convert.ToDouble(newEntryPrice.Text);
SpecificPrice newPrice = new SpecificPrice
{
BarID = bar.BarID,
DrinkID = drink.DrinkID,
DrinkPrice = price
};
var restService = new RestService();
await restService.SaveData <SpecificPrice>(newPrice, Constants.SpecificPricesUrl, false);
}
else
{
await DisplayAlert("Warning", "Bad Input", "Ok");
}
}
public static void SaveSpecificPrice(DbContextOptions <DBContext> options, SpecificPrice specificPrice)
{
using (var dbContext = new DBContext(options))
{
dbContext.SpecificPrices.Add(specificPrice);
dbContext.SaveChanges();
}
}
private async void Button_Clicked(object sender, EventArgs e)
{
if (selectedBar.SelectedItem == null || selectedDrink.SelectedItem == null)
{
await DisplayAlert("Warning", "Bad Input", "Ok");
return;
}
Bar bar = ((Bar)selectedBar.SelectedItem);
Drink drink = ((Drink)selectedDrink.SelectedItem);
SpecificPrice newPrice = bar.AvailableDrinks.Find(x => x.DrinkID == drink.DrinkID);
var restService = new RestService();
await restService.DeleteData(Constants.SpecificPricesUrl, newPrice.SpecificPriceID.ToString());
}
public void InsertSpecificPrice(SpecificPrice specificPrice)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = con;
sqlCommand.CommandText = "Insert Into dbo.SpecificPrice (BarID, DrinkID, DrinkPrice) Values (@BarID, @DrinkID, @DrinkPrice)";
sqlCommand.Parameters.Add(new SqlParameter("@BarID", SqlDbType.VarChar).Value = specificPrice.BarID);
sqlCommand.Parameters.Add(new SqlParameter("@DrinkID", SqlDbType.VarChar).Value = specificPrice.DrinkID);
sqlCommand.Parameters.Add(new SqlParameter("@DrinkPrice", SqlDbType.Float).Value = specificPrice.DrinkPrice);
sqlCommand.ExecuteNonQuery();
}
}
