public HttpResponseMessage Put([FromBody] Game game)
{
using (NBAEntities entities = new NBAEntities())
{
try
{
var entity = entities.Games.FirstOrDefault(e => e.ID == game.ID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found"));
}
else
{
entity.Team1 = game.Team1;
entity.Team2 = game.Team2;
entity.Period = game.Period;
entity.Time = game.Time;
entity.Description = game.Description;
entity.ScoreTeam1 = game.ScoreTeam1;
entity.ScoreTeam2 = game.ScoreTeam2;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, game));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
private void btnSell_Click(object sender, RoutedEventArgs e)
{
NBAEntities ctx = new NBAEntities();
Customer cust = new Customer();
cust.Age = int.Parse(ageTextBox.Text);
cust.Licence_Number = licence_NumberTextBox.Text;
ctx.Customers.Add(cust);
Person psn = new Person();
psn.Address = addressTextBox.Text;
psn.Name = nameTextBox.Text;
psn.Telephone = telephoneTextBox.Text;
DataStore.addCustomer(cust, psn);
int Car_for_sale_ID = int.Parse(car_For_Sale_IdTextBox.Text);
Cars_Sold cs = ctx.Cars_Sold.Where(sc => sc.Car_For_Sale_Id == Car_for_sale_ID).FirstOrDefault();
Cars_Sold sale = new Cars_Sold();
sale.Car_For_Sale_Id = Car_for_sale_ID;
sale.Customer = cust;
sale.Date_Sold = DateTime.Now;
ctx.Cars_Sold.Add(sale);
ctx.SaveChanges();
MessageBox.Show("Car has been sold to new customer");
}
public HttpResponseMessage Post([FromBody] Game game)
{
try
{
using (NBAEntities entities = new NBAEntities())
{
entities.Games.Add(game);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, game);
message.Headers.Location = new Uri(Request.RequestUri + game.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void Save()
{
context.SaveChanges();
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
ctx.SaveChanges();
}
private void updateButton_Click(object sender, RoutedEventArgs e)
{
MessageBox.Show("Car Details Updated Successfully");
ctx.SaveChanges();
}
