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;
}
}
