public ComplainRepo() { dcc = new DatabaseConnection(); }
public Passenger GetPassengers(string userId) { Passenger p = null; string query = "SELECT * FROM Passengers WHERE Name LIKE '%" + userId + "%' " + " OR Username LIKE '%" + userId + "%' " + " OR Email LIKE '%" + userId + "%' "; string query2 = "SELECT * FROM Passengers WHERE PassengerId = " + userId + ""; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); float y; try { y = Convert.ToInt32(userId) / 2; y = 1; } catch (Exception er) { y = -10; } if (y + 1 >= 1) { SqlDataReader sdr2 = dcc.GetData(query2); List <Passenger> pList = new List <Passenger>(); //id if (sdr2.Read()) { p = new Passenger(); p.PassengerId = Convert.ToInt32(sdr2["PassengerId"]); p.Pusername = sdr2["Username"].ToString(); p.Pname = sdr2["Name"].ToString(); p.Pemail = sdr2["Email"].ToString(); p.Pgender = sdr2["Gender"].ToString(); p.Paddress = sdr2["Address"].ToString(); p.Page = Convert.ToInt32(sdr2["Age"]); p.Pquestion = sdr2["Question"].ToString(); p.Ppassword = sdr2["Password"].ToString(); pList.Add(p); } dcc.CloseConnection(); return(p); } else { SqlDataReader sdr = dcc.GetData(query); List <Passenger> pList = new List <Passenger>(); if (sdr.Read()) { p = new Passenger(); p.PassengerId = Convert.ToInt32(sdr["PassengerId"]); p.Pusername = sdr["Username"].ToString(); p.Pname = sdr["Name"].ToString(); p.Pemail = sdr["Email"].ToString(); p.Pgender = sdr["Gender"].ToString(); p.Paddress = sdr["Address"].ToString(); p.Page = Convert.ToInt32(sdr["Age"]); p.Pquestion = sdr["Question"].ToString(); p.Ppassword = sdr["Password"].ToString(); pList.Add(p); } dcc.CloseConnection(); return(p); } }