public bool EmployeeDelete(string id)
{
try
{
string query = "DELETE From Employee WHERE Id='" + id + "'";
string query2 = "DELETE From Login WHERE Id='" + id + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
int y = dcc.ExecuteSQL(query2);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool EmployeeAdd(REmployee e)
{
try
{
string query = "INSERT into Employee VALUES ('" + e.Id + "', '" + e.Name + "', '" + e.Designation + "', '" + e.Password + "', " + e.Salary + ", '" + e.Phoneno + "', '" + e.Email + "', " + e.Type + ")";
string query2 = "INSERT into Login VALUES ('" + e.Id + "', '" + e.Name + "','" + e.Password + "', " + e.Type + ")";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
int y = dcc.ExecuteSQL(query2);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool PasswordChange(REmployee e)
{
try
{
string query = "UPDATE Employee SET Password = '******'WHERE Id ='" + e.Id + "' ";
string query1 = "UPDATE Login SET Password = '******'WHERE Id ='" + e.Id + "' ";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
int y = dcc.ExecuteSQL(query1);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool AdminAdd(RAdmin a)
{
try
{
string query = "INSERT into Admin VALUES ('" + a.Id + "', '" + a.Name + "', '" + a.Position + "', '" + a.Password + "', " + a.Salary + ", " + a.Type + ")";
string query2 = "INSERT into Login VALUES ('" + a.Id + "', '" + a.Name + "','" + a.Password + "', " + a.Type + ")";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
int y = dcc.ExecuteSQL(query2);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool PassengerAdd(RPassenger p)
{
try
{
string query = "INSERT into Passenger VALUES ('" + p.Id + "', '" + p.Name + "', '" + p.Password + "', '" + p.Dateofbirth + "', '" + p.Gender + "', '" + p.Nationality + "', " + p.Type + ")";
string query2 = "INSERT into Login VALUES ('" + p.Id + "','" + p.Name + "', '" + p.Password + "', " + p.Type + ")";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
int y = dcc.ExecuteSQL(query2);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool PassengerDelete(string id)
{
try
{
string query = "DELETE From Passenger WHERE Id='" + id + "'";
string query2 = "DELETE From Ticket WHERE Passsengerid='" + id + "'";
string query3 = "DELETE From Login WHERE Id='" + id + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
int y = dcc.ExecuteSQL(query2);
int z = dcc.ExecuteSQL(query3);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool SeatDelete(string seatid)
{
try
{
string query = "DELETE From Seat WHERE Seatid='" + seatid + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool SeatAdd(Seat s)
{
try
{
string query = "INSERT into Seat VALUES ('" + s.Seatid + "', '" + s.Seatname + "', " + s.Price + ")";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool CancelReservation(string ticketid)
{
try
{
string query = "DELETE From Ticket WHERE Ticketid='" + ticketid + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool NoticeAdd(Notice n)
{
try
{
string query = "INSERT into Notice VALUES ('" + n.Noticeid + "', '" + n.Noticesubject + "', '" + n.Noticedetails + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool CancelSchedule(string trainid)
{
try
{
string query = "DELETE From Train WHERE Trainid='" + trainid + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool TrainUpdate(Train t)
{
try
{
string query = "UPDATE Train SET Trainname = '" + t.Trainname + "', StartingPoint ='" + t.From + "', Destination ='" + t.To + "', StartingTime ='" + t.StartingTime + "', ReachingTime ='" + t.ReachingTime + "', Noofseats = " + t.Noofseats + "WHERE Trainid ='" + t.Trainid + "' ";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool TrainAdd(Train t)
{
try
{
string query = "INSERT into Train VALUES ('" + t.Trainid + "', '" + t.Trainname + "', '" + t.From + "', '" + t.To + "', '" + t.StartingTime + "', '" + t.ReachingTime + "', " + t.Noofseats + ")";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
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);
}
}
