private void submitBtn_Click(object sender, RoutedEventArgs e) { string attractionIDStr = attractionIDTxt.Text.Trim(); int attractionID; bool success = int.TryParse(attractionIDStr, out attractionID); if (!success) { errorLbl.Text = "TaskID must be a number!"; } else if (statusComboBox.SelectedItem == null) { errorLbl.Text = "Please input all field!"; } else { string status = (string)((ComboBoxItem)statusComboBox.SelectedValue).Content; AttractionRideMediator mediator = new AttractionRideMediator(); AttractionOrRide aor = mediator.getAttractionOrRide(attractionID); aor.status = status; aor = mediator.updateAttractionOrRide(attractionID, aor); if (aor == null) { MessageBox.Show("Update status failed!"); } else { MessageBox.Show("Update status successful!"); } this.Close(); } }
public AttractionOrRide addAttractionOrRide(AttractionOrRide aor) { Connection con = Connection.getConnection(); con.db.AttractionOrRide.Add(aor); con.db.SaveChanges(); return(aor); }
public AttractionOrRide updateAttractionOrRide(int attractionID, AttractionOrRide aor) { Connection con = Connection.getConnection(); AttractionOrRide newAor = con.db.AttractionOrRide.Find(attractionID); newAor = aor; con.db.SaveChanges(); return(newAor); }
public int getLastID() { Connection con = Connection.getConnection(); AttractionOrRide aor = (from a in con.db.AttractionOrRide orderby a.attractionID descending select a).FirstOrDefault(); if (aor == null) { return(0); } return(aor.attractionID); }
public AttractionOrRide createNewAttractionOrRide(string name, string type, string description) { AttractionRideMediator mediator = new AttractionRideMediator(); AttractionOrRide attractionOrRide = new AttractionOrRide(); attractionOrRide.attractionID = mediator.getLastID() + 1; attractionOrRide.name = name; attractionOrRide.type = type; attractionOrRide.description = description; attractionOrRide.status = "Waiting for constructing"; return(attractionOrRide); }
public AttractionOrRide updateAttractionOrRide(int attractionID, AttractionOrRide aor) { AttractionRideRepository repository = new AttractionRideRepository(); return(repository.updateAttractionOrRide(attractionID, aor)); }
public AttractionOrRide addAttractionOrRide(AttractionOrRide aor) { AttractionRideRepository repository = new AttractionRideRepository(); return(repository.addAttractionOrRide(aor)); }