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);
}
}
