public ParkTicket GetTicket(int ID) { ParkTicket pt = new ParkTicket(); using (var con = new SqlConnection(GC.ConnectionString)) { if (con.State == ConnectionState.Closed) { con.Open(); } Query = "select * from ParkTicketView where id='" + ID + "'"; using (var com = new SqlCommand(Query, con)) { Reader = com.ExecuteReader(); while (Reader.Read()) { pt.TicketID = Convert.ToInt32(Reader["id"].ToString()); pt.DriverName = Reader["FirstName"].ToString() + " " + Reader["LastName"].ToString(); pt.License = Reader["license"].ToString(); pt.ParkName = Reader["ParkName"].ToString(); pt.Date = Convert.ToDateTime(Reader["Date"].ToString()); } com.Dispose(); } con.Close(); } return(pt); }
public ParkTicket GetTicket(int ParkID, int CarID) { ParkTicket pt = new ParkTicket(); using (var con = new SqlConnection(GC.ConnectionString)) { con.Open(); Query = "Select * from ParkTicketView ptv inner join Park_Ticket pt on ptv.id=pt.id inner join car_park cp on pt.car_park_id=cp.id inner join car_driver cd on pt.car_driver_id=cd.id where cp.park_id='" + ParkID + "' and cd.car_id='" + CarID + "'"; using (var com = new SqlCommand(Query, con)) { Reader = com.ExecuteReader(); while (Reader.Read()) { pt.TicketID = Convert.ToInt32(Reader["id"].ToString()); pt.DriverName = Reader["FirstName"].ToString() + " " + Reader["LastName"].ToString(); pt.License = Reader["license"].ToString(); pt.ParkName = Reader["ParkName"].ToString(); pt.Date = Convert.ToDateTime(Reader["Date"].ToString()); } com.Dispose(); } con.Close(); } return(pt); }
private async void ProcessTicket(int ParkId, int CarId) { ufunctions = new UserFunctions(); ParkTicket pt = new ParkTicket(); pt = await ufunctions.GetParkTicket(ParkId, CarId); ticketid.Text = pt.TicketID.ToString(); ticketdate.Text = pt.Date.ToLongDateString(); ticketdriver.Text = pt.DriverName; ticketlicense.Text = pt.License; }