public Bookticket GetTicket(string ticketId)
{
string query = "SELECT * from BookTicket WHERE BookTicketId = '" + ticketId + "'";
Bookticket b = null;
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
b = new Bookticket();
b.BookTicketId = sdr["BookTicketId"].ToString();
b.PassengerId = sdr["PassengerId"].ToString();
b.PassengerUsername = sdr["PassengerName"].ToString();
b.Airplane = sdr["Airplane"].ToString();
b.Source = sdr["Source"].ToString();
b.Destination = sdr["Destination"].ToString();
b.Departure = sdr["Departure"].ToString();
b.Arrival = sdr["Arrival"].ToString();
b.Seats = sdr["Seats"].ToString();
b.Cost = Convert.ToInt32(sdr["Cost"]);
}
dcc.CloseConnection();
return(b);
}
public List <Bookticket> GetAllTickets()
{
string query = "SELECT * from BookTicket";
List <Bookticket> tList = new List <Bookticket>();
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Bookticket b = new Bookticket();
b.BookTicketId = sdr["BookTicketId"].ToString();
b.PassengerId = sdr["PassengerId"].ToString();
b.PassengerUsername = sdr["PassengerName"].ToString();
b.Airplane = sdr["Airplane"].ToString();
b.Source = sdr["Source"].ToString();
b.Destination = sdr["Destination"].ToString();
b.Departure = sdr["Departure"].ToString();
b.Arrival = sdr["Arrival"].ToString();
b.Seats = sdr["Seats"].ToString();
b.Cost = Convert.ToInt32(sdr["Cost"]);
tList.Add(b);
}
dcc.CloseConnection();
return(tList);
}
public bool Insert(Bookticket bTicket)
{
try
{
string query = "INSERT into BookTicket VALUES ('" + bTicket.BookTicketId + "', '" + bTicket.PassengerId + "', '" + bTicket.PassengerUsername +
"', '" + bTicket.Source + "', '" + bTicket.Destination + "', '" + bTicket.Departure + "', '" + bTicket.Arrival +
"', '" + bTicket.Airplane + "', '" + bTicket.Seats + "', " + bTicket.Cost + ")";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
