public List <RTicket> GetAllTicket() { string query = "SELECT * from Ticket"; List <RTicket> tList = new List <RTicket>(); DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { RTicket t = new RTicket(); t.Ticketid = sdr["Ticketid"].ToString(); t.Journeydate = sdr["Journeydate"].ToString(); t.Tranid = sdr["Trainid"].ToString(); t.SeatClassid = sdr["SeatClassid"].ToString(); t.Passsengerid = sdr["Passsengerid"].ToString(); t.Seatno = sdr["Seatno"].ToString(); t.Price = Convert.ToDouble(sdr["Price"]);; tList.Add(t); } dcc.CloseConnection(); return(tList); }
public bool TicketSell(RTicket t) { try { string query = "INSERT into Ticket VALUES ('" + t.Ticketid + "', '" + t.Journeydate + "', '" + t.Tranid + "', '" + t.SeatClassid + "', '" + t.Passsengerid + "', '" + t.Seatno + "', " + t.Price + ")"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }