public List <Seat> GetAllSeats()
{
string query = "SELECT * from Seat";
List <Seat> sList = new List <Seat>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Seat s = new Seat();
s.Seatid = sdr["Seatid"].ToString();
s.Seatname = sdr["Seatname"].ToString();
s.Price = Convert.ToDouble(sdr["Price"]);
sList.Add(s);
}
dcc.CloseConnection();
return(sList);
}
public List <Notice> GetAllNotice()
{
string query = "SELECT * from Notice";
List <Notice> nList = new List <Notice>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Notice n = new Notice();
n.Noticeid = sdr["Noticeid"].ToString();
n.Noticesubject = sdr["Noticesubject"].ToString();
n.Noticedetails = sdr["Noticedetails"].ToString();
nList.Add(n);
}
dcc.CloseConnection();
return(nList);
}
public List <Seat> SearchSeatPrice(string text)
{
string query = "SELECT * from Seat Where Seatid like'%" + text + "%' or Seatname like'%" + text + "%'"; //or Price like %" + Convert.ToDouble(text) + "%";
List <Seat> sList = new List <Seat>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Seat s = new Seat();
s.Seatid = sdr["Seatid"].ToString();
s.Seatname = sdr["Seatname"].ToString();
s.Price = Convert.ToDouble(sdr["Price"]);
sList.Add(s);
}
dcc.CloseConnection();
return(sList);
}
public RAdmin Profile(string id)
{
string query = "SELECT * from Admin WHERE Id = '" + id + "'";
RAdmin a = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
a = new RAdmin();
a.Id = sdr["Id"].ToString();
a.Name = sdr["Name"].ToString();
a.Position = sdr["Position"].ToString();
a.Password = sdr["Password"].ToString();
a.Salary = Convert.ToDouble(sdr["Salary"]);
a.Type = Convert.ToInt32(sdr["Type"]);
}
dcc.CloseConnection();
return(a);
}
public bool UserLoginValidation(RLogin l)
{
string query = "SELECT * from Login WHERE Id = '" + l.Id + "' AND Password='******'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
// dcc.CloseConnection();
if (sdr.Read())
{
l.Name = sdr["Name"].ToString();
l.Type = Convert.ToInt32(sdr["Type"]);
dcc.CloseConnection();
return(true);
}
else
{
dcc.CloseConnection();
return(false);
}
}
public Train TrainSearch(string trainid)
{
string query = "SELECT * from Train WHERE Trainid = '" + trainid + "'";
Train t = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
t = new Train();
t.Trainid = sdr["Trainid"].ToString();
t.Trainname = sdr["Trainname"].ToString();
t.From = sdr["StartingPoint"].ToString();
t.To = sdr["Destination"].ToString();
t.StartingTime = sdr["StartingTime"].ToString();
t.ReachingTime = sdr["ReachingTime"].ToString();
t.Noofseats = Convert.ToInt32(sdr["Noofseats"]);
}
dcc.CloseConnection();
return(t);
}
public RPassenger Profile(string id)
{
string query = "SELECT * from Passenger WHERE Id = '" + id + "'";
RPassenger p = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
p = new RPassenger();
p.Id = sdr["Id"].ToString();
p.Name = sdr["Name"].ToString();
p.Dateofbirth = sdr["Dateofbirth"].ToString();
p.Password = sdr["Password"].ToString();
p.Gender = sdr["Gender"].ToString();
p.Nationality = sdr["Nationality"].ToString();
p.Type = Convert.ToInt32(sdr["Type"]);
}
dcc.CloseConnection();
return(p);
}
public REmployee Profile(string id)
{
string query = "SELECT * from Employee WHERE Id = '" + id + "'";
REmployee e = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
e = new REmployee();
e.Id = sdr["Id"].ToString();
e.Name = sdr["Name"].ToString();
e.Designation = sdr["Designation"].ToString();
e.Password = sdr["Password"].ToString();
e.Salary = Convert.ToDouble(sdr["Salary"]);
e.Phoneno = sdr["Phoneno"].ToString();
e.Email = sdr["Email"].ToString();
e.Type = Convert.ToInt32(sdr["Type"]);
}
dcc.CloseConnection();
return(e);
}
public List <RPassenger> GetAllPassengers()
{
string query = "SELECT * from Passenger";
List <RPassenger> pList = new List <RPassenger>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
RPassenger p = new RPassenger();
p.Id = sdr["Id"].ToString();
p.Name = sdr["Name"].ToString();
//p.Password = sdr[""].ToString();
p.Dateofbirth = sdr["DateOfbirth"].ToString();
p.Gender = sdr["Gender"].ToString();
p.Nationality = sdr["Nationality"].ToString();
pList.Add(p);
}
dcc.CloseConnection();
return(pList);
}
public List <RPassenger> SearchPassenger(string text)
{
string query = "SELECT * from Passenger Where Id like'%" + text + "%' or Name like'%" + text + "%' or Dateofbirth like'%" + text + "%' or Nationality like'%" + text + "%'";
List <RPassenger> plist = new List <RPassenger>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
RPassenger p = new RPassenger();
p.Id = sdr["Id"].ToString();
p.Name = sdr["Name"].ToString();
//p.Password = sdr[""].ToString();
p.Dateofbirth = sdr["DateOfbirth"].ToString();
p.Gender = sdr["Gender"].ToString();
p.Nationality = sdr["Nationality"].ToString();
plist.Add(p);
}
dcc.CloseConnection();
return(plist);
}
