public void CreateMyTicket(int ticketnumber, string name)
{
var t = new TicketObject(ticketnumber, name);
t.Upgrade = ticketnumber + 2;
Repository.Save(t);
}
public Task <int> SaveTicketAsync(TicketObject item, bool isNew)
{
if (isNew)
{
return(database.UpdateAsync(item));
}
else
{
return(database.InsertAsync(item));
}
}
public SingleFeeDetailPanel(BuyRecordObject record)
{
InitializeComponent();
//record.BuyTime;
TicketObject ticket = record.Tickets[0];
string movieName = ticket.Movie.Name;
this.lbCinema.Text = string.Format(this.lbCinema.Text, record.Tickets[0].Seat.Room.Cinema.Name);
this.lbMovieName.Text = string.Format(this.lbMovieName.Text, movieName, ticket.Movie.Type == null || ticket.Movie.Type.Length == 0 ? "" : "(" + ticket.Movie.Type + ")");
DateTime playDate = Convert.ToDateTime(ticket.PlayTime);
this.lbDate.Text = string.Format(this.lbDate.Text, ticket.PlayTime.ToString("yyyy-MM-dd / HH:mm"));
//this.lbRoom.Location = new Point(this.lbTimeHint.Location.X + this.lbTimeHint.Width, this.lbTimeHint.Location.Y);
int num = 4;
string seat = string.Empty;
string[] seatArray = record.Tickets[0].Seat.SeatId.Split(',');
for (int i = 0; i < seatArray.Length; i++)
{
if (i != 0 && i % num == 0)
{
// seat += "\n座位："
seat += "\n ";
}
if (i == 0)
{
seat += seatArray[i];
}
else
{
seat += "、" + seatArray[i];
}
}
int totalPrice = record.TotalPrice;
// WinFormHelper.LocationAfter(this.lbPrice, this.lbTicketPriceHint);
this.lbNum.Text = string.Format(this.lbNum.Text, record.Tickets.Count.ToString());
// WinFormHelper.LocationAfter(this.lbTicketPriceHint, this.lbTicketCount);
//WinFormHelper.LocationAfter(this.lbTicketCount, this.lbTicketCountHint);
this.lbRoom.Text = string.Format(this.lbRoom.Text, ticket.Seat.Room.Name, seat);
this.lbAllFee.Text = string.Format(this.lbAllFee.Text, totalPrice.ToString());
FT.Commons.Tools.WinFormHelper.VerLocationAfter(this.lbRoom, this.lbAllFee, 14);
}
/// <summary>
/// Asynchronously read the information in the data store pointed to by the <paramref name="ticketID"/>.
/// </summary>
/// <param name="ticketID">The ticket ID of the row to read (string)</param>
/// <returns>Task (IDataObject) the information represented as an object</returns>
public async Task <IDataObject> ReadByIdAsync(long ticketID)
{
if (!await CheckTicketExistenceAsync(ticketID))
{
throw new ArgumentException(Constants.TicketReadDNE);
}
// Object to return -- TicketObject
TicketObject result;
// Construct the sql string to get the record where the id column equals the id parameter.
string sqlString = $"SELECT * FROM {Constants.TicketDAOTableName} WHERE {Constants.TicketDAOTicketIDColumn} = @TICKETID;";
// Get the command and data table objects inside using statements to properly dispose/close.
using (MySqlCommand command = new MySqlCommand(sqlString, dbConnection))
using (DataTable dataTable = new DataTable())
{
// Add the value to the id parameter, execute the reader asynchronously, load the reader into
// the data table, and get the first row (the result).
command.Parameters.AddWithValue("@TICKETID", ticketID);
DbDataReader reader = await command.ExecuteReaderAsync();
dataTable.Load(reader);
// Return the first result
DataRow row = dataTable.Rows[0];
// Construct the TicketObject by casting the values of the columns to their proper data types.
result = new TicketObject((long)row[Constants.TicketDAOSubmitTimestampColumn],
(string)row[Constants.TicketDAOCategoryColumn],
(string)row[Constants.TicketDAOStatusColumn],
(string)row[Constants.TicketDAOFlagColorColumn],
(string)row[Constants.TicketDAODescriptionColumn],
(bool)row[Constants.TicketDAOIsReadColumn]);
}
return(result);
}
public JsonResult Previsualizar(int id)
{
TicketObject ticket = dao.getTickect(id);
return(Json(new { ticket }, JsonRequestBehavior.AllowGet));
}
public Task <int> DeleteTicketAsync(TicketObject item)
{
return(database.DeleteAsync(item));
}
private TicketObject GetParametersToObject(string command, string commandLine, int firstSpaceIndex)
{
TicketObject ticketObject = new TicketObject();
string allParameters = commandLine.Substring(firstSpaceIndex + 1);
string[] parameters = allParameters.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].Trim();
}
switch (command)
{
case "CreateFlight":
{
ticketObject.FlightNumber = parameters[0];
ticketObject.From = parameters[1];
ticketObject.To = parameters[2];
ticketObject.CompanyName = parameters[3];
ticketObject.DateAndTime = Utils.ParseDateTime(parameters[4]);
ticketObject.Price = decimal.Parse(parameters[5]);
break;
}
case "DeleteFlight":
{
ticketObject.FlightNumber = parameters[0];
break;
}
case "CreateTrain":
{
ticketObject.From = parameters[0];
ticketObject.To = parameters[1];
ticketObject.DateAndTime = Utils.ParseDateTime(parameters[2]);
ticketObject.Price = decimal.Parse(parameters[3]);
ticketObject.StudentPrice = decimal.Parse(parameters[4]);
break;
}
case "DeleteTrain":
{
ticketObject.From = parameters[0];
ticketObject.To = parameters[1];
ticketObject.DateAndTime = Utils.ParseDateTime(parameters[2]);
break;
}
case "CreateBus":
{
ticketObject.From = parameters[0];
ticketObject.To = parameters[1];
ticketObject.CompanyName = parameters[2];
ticketObject.DateAndTime = Utils.ParseDateTime(parameters[3]);
ticketObject.Price = decimal.Parse(parameters[4]);
break;
}
case "DeleteBus":
{
ticketObject.From = parameters[0];
ticketObject.To = parameters[1];
ticketObject.CompanyName = parameters[2];
ticketObject.DateAndTime = Utils.ParseDateTime(parameters[3]);
break;
}
case "FindTickets":
{
ticketObject.From = parameters[0];
ticketObject.To = parameters[1];
break;
}
case "FindByDates":
{
ticketObject.StartFindDateTime = Utils.ParseDateTime(parameters[0]);
ticketObject.EndFindDateTime = Utils.ParseDateTime(parameters[1]);
break;
}
}
return(ticketObject);
}
public string ExecuteCommand(string line)
{
int firstSpaceIndex = line.IndexOf(' ');
if (firstSpaceIndex == -1)
{
return("Invalid command!");
}
string command = line.Substring(0, firstSpaceIndex);
TicketObject ticketObject = this.GetParametersToObject(command, line, firstSpaceIndex);
string output = "Invalid command!";
switch (command)
{
case "CreateFlight":
output = this.AddAirTicket(
ticketObject.FlightNumber,
ticketObject.From,
ticketObject.To,
ticketObject.CompanyName,
ticketObject.DateAndTime,
ticketObject.Price);
break;
case "DeleteFlight":
output = this.DeleteAirTicket(ticketObject.FlightNumber);
break;
case "CreateTrain":
output = this.AddTrainTicket(
ticketObject.From,
ticketObject.To,
ticketObject.DateAndTime,
ticketObject.Price,
ticketObject.StudentPrice);
break;
case "DeleteTrain":
output = this.DeleteTrainTicket(ticketObject.From, ticketObject.To, ticketObject.DateAndTime);
break;
case "CreateBus":
output = this.AddBusTicket(
ticketObject.From,
ticketObject.To,
ticketObject.CompanyName,
ticketObject.DateAndTime,
ticketObject.Price);
break;
case "DeleteBus":
output = this.DeleteBusTicket(
ticketObject.From,
ticketObject.To,
ticketObject.CompanyName,
ticketObject.DateAndTime);
break;
case "FindTickets":
output = this.FindTickets(ticketObject.From, ticketObject.To);
break;
case "FindByDates":
output = this.FindTicketsInRange(ticketObject.StartFindDateTime, ticketObject.EndFindDateTime);
break;
}
return(output);
}
