protected void ButtonDeleteExpired_Click(object sender, EventArgs e) { var context = new HHUAirDataContext(); var tickets = from c in context.Tickets where c.DepartDatetime < DateTime.Now select c; foreach (var ticket in tickets) { context.Tickets.DeleteOnSubmit(ticket); } context.SubmitChanges(); GridViewTickets.DataBind(); }
protected void ButtonPay_Click(object sender, EventArgs e) { try { //购买机票,修改数据库存票数 StringBuilder passengerNames = new StringBuilder(); StringBuilder passengerIds = new StringBuilder(); bool isNotFirst = false; foreach (var nameAndId in ListBoxPassengers.Items) { if (isNotFirst) { passengerNames.Append(", "); passengerIds.Append(", "); } else { isNotFirst = true; } string[] nai = nameAndId.ToString().Split('#'); passengerNames.Append(nai[0]); passengerIds.Append(nai[1]); } var context = new HHUAirDataContext(); var order = new Order() { Id = Guid.NewGuid(), FlightNumber = LabelFlightNumber.Text, DepartDatetime = DateTime.Parse(LabelDepartDatetime.Text), Amount = Int32.Parse(TextBoxAmount.Text), UserId = (from c in context.aspnet_Users where c.UserName == User.Identity.Name select c.UserId).First(), PassengerNames = passengerNames.ToString(), PassengerIds = passengerIds.ToString(), ContactInfo = TextBoxContactInfo.Text, Memo = TextBoxMemo.Text }; context.Orders.InsertOnSubmit(order); var ticket = context.Tickets.SingleOrDefault(c => c.FlightNumber == order.FlightNumber && c.DepartDatetime == order.DepartDatetime); ticket.SoldAmount += order.Amount; context.SubmitChanges(); MultiViewBuy.ActiveViewIndex = 4; } catch { MultiViewBuy.ActiveViewIndex = 3; } }