public Complain Getcomplain(string cId) { Complain c = null; string query = "SELECT * from Complains WHERE CId = '" + cId + "'"; dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { c = new Complain(); c.CId = sdr["CId"].ToString(); c.Csub = sdr["Csub"].ToString(); c.Cbody = sdr["Cbody"].ToString(); c.CuserId = sdr["CuserId"].ToString(); } dcc.CloseConnection(); return(c); }
public Tenant GetTenant(string tId) { Tenant t = null; string query = "SELECT * from Tenants WHERE TId = '" + tId + "'"; dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { t = new Tenant(); t.TId = sdr["TId"].ToString(); t.Tname = sdr["Tname"].ToString(); t.TphnNumber = sdr["TphnNumber"].ToString(); t.Rent = Convert.ToDouble(sdr["Rent"].ToString()); t.Institution = sdr["Institution"].ToString(); } dcc.CloseConnection(); return(t); }
public Applications GetApplication(string s) { Applications a = null; string query = "SELECT * from Applications WHERE AppId = '" + s + "'"; dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { a = new Applications(); a.AppId = sdr["AppId"].ToString(); a.AppuserId = sdr["Appuserid"].ToString(); a.Astatus = sdr["Astatus"].ToString(); a.Appsub = sdr["Appsub"].ToString(); a.Appbody = sdr["Appbody"].ToString(); } dcc.CloseConnection(); return(a); }
public Employee GetEmployee(string empId) { Employee emp = null; string query = "SELECT * from Employees WHERE EmpId = '" + empId + "'"; dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { emp = new Employee(); emp.EmpId = sdr["EmpId"].ToString(); emp.Name = sdr["Name"].ToString(); emp.PhnNumber = sdr["PhnNumber"].ToString(); emp.Salary = Convert.ToDouble(sdr["Salary"].ToString()); emp.Designation = sdr["Designation"].ToString(); } dcc.CloseConnection(); return(emp); }
public Airport SearchByString(string text) { string query = "SELECT * from Airport WHERE Name = '%" + text + "%' OR City LIKE '%" + text + "%'"; Airport air1 = null; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { air1 = new Airport(); air1.AirportId = Convert.ToInt32(sdr["AirportId"]); air1.AirportName = sdr["Name"].ToString(); air1.City = sdr["City"].ToString(); } dcc.CloseConnection(); return(air1); }
public Airplane getAirplanes(string airplaneId) { string query = "SELECT * from Airplane WHERE AirplaneId = '" + airplaneId + "'"; Airplane air = null; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { air = new Airplane(); air.AirplaneId = sdr["AirplaneId"].ToString(); air.AirplaneName = sdr["AirplaneName"].ToString(); air.Capacity = Convert.ToInt32(sdr["Capacity"]); } dcc.CloseConnection(); return(air); }
public AllUsers GetUser(string userId) { string query = "SELECT * from UserInfo WHERE UserId = '" + userId + "' or UserType Like '" + userId + "' or UserName Like '" + userId + "' "; AllUsers a = null; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { a = new AllUsers(); a.UserId = sdr["UserId"].ToString(); a.UserName = sdr["UserName"].ToString(); a.UserType = Convert.ToString(sdr["UserType"]); } dcc.CloseConnection(); return(a); }
public Login GetUser(string id, string password) { Login l = null; string query = "SELECT * from Login WHERE Id = '" + id + "' AND Password = '******'"; dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { l = new Login(); l.Id = sdr["Id"].ToString(); l.Password = sdr["Password"].ToString(); l.Role = Convert.ToInt32(sdr["Role"]); } dcc.CloseConnection(); return(l); }
public Airport GetAirports(string airportId) { string query = "SELECT * from Airpprt WHERE AirportId = '" + airportId + "'"; Airport air1 = null; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { air1 = new Airport(); air1.AirportId = sdr["AirportID"].ToString(); air1.AirportName = sdr["AirportName"].ToString(); air1.City = sdr["City"].ToString(); air1.Airportcode = sdr["AirportCode"].ToString(); } dcc.CloseConnection(); return(air1); }
public List <Airplane> GetAllAirplanes() { string query = "SELECT * from Airplane"; List <Airplane> airList = new List <Airplane>(); DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { Airplane air = new Airplane(); air.AirplaneId = sdr["AirplaneId"].ToString(); air.AirplaneName = sdr["AirplaneName"].ToString(); air.Capacity = Convert.ToInt32(sdr["Capacity"]); airList.Add(air); } dcc.CloseConnection(); return(airList); }
public List <AllUsers> GetAllUsers() { string query = "SELECT * from UserInfo"; List <AllUsers> userList = new List <AllUsers>(); DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { AllUsers a = new AllUsers(); a.UserId = sdr["UserId"].ToString(); a.UserName = sdr["UserName"].ToString(); a.UserType = Convert.ToString(sdr["UserType"]); userList.Add(a); } dcc.CloseConnection(); return(userList); }
public AllUsers GetUserById(int uid) { string query = "SELECT * from AllUsers WHERE UserId = " + uid + " "; AllUsers au = new AllUsers(); DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { //au = new AllUsers(); au.UserId = Convert.ToInt32(sdr["UserId"]); au.UserFullName = sdr["Fullname"].ToString(); au.UserName = sdr["Username"].ToString(); au.UserType = Convert.ToString(sdr["UserType"]); au.UserPassword = sdr["Password"].ToString(); au.UserQuestion = sdr["Question"].ToString(); } dcc.CloseConnection(); return(au); }
public Flight GetFlight(string flightId) { string query = "SELECT * from Flight WHERE FlightID = '" + flightId + "' or AirlineName LIKE '%" + flightId + "%' "; Flight f = null; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { f = new Flight(); f.FlightId = sdr["FlightID"].ToString(); f.AirlineName = sdr["AirlineName"].ToString(); f.Source = sdr["Source"].ToString(); f.Destination = sdr["Destination"].ToString(); f.Arrival = Convert.ToString(sdr["Arrival"]); f.Departure = Convert.ToString(sdr["Departure"]); f.Cost = Convert.ToInt32(sdr["Cost"]); } dcc.CloseConnection(); return(f); }
public List <BookedSeats> getBookedTicket(int bId) { string query = "SELECT * from BookedSeats WHERE BookTicketId = " + bId + ""; BookedSeats b = null; List <BookedSeats> bList = new List <BookedSeats>(); DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); if (sdr.Read()) { b = new BookedSeats(); b.BookedSeatId = Convert.ToInt32(sdr["BookedSeatsId"]); b.Seats = sdr["Seats"].ToString(); b.BookTicketId = Convert.ToInt32(sdr["BookTicketId"]); b.FlightId = Convert.ToInt32(sdr["FlightId"]); bList.Add(b); } dcc.CloseConnection(); return(bList); }
public List <Airport> GetAllAirports() { string query = "SELECT * from Airport"; List <Airport> airList = new List <Airport>(); DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { Airport air1 = new Airport(); air1 = new Airport(); air1.AirportId = Convert.ToInt32(sdr["AirportId"]); air1.AirportName = sdr["Name"].ToString(); air1.City = sdr["City"].ToString(); airList.Add(air1); } dcc.CloseConnection(); return(airList); }
public Admin GetAdmins(string adminId) { string query = "SELECT * from Admin WHERE Name LIKE '%" + adminId + "'% OR Username LIKE '" + adminId + "'"; Admin a = null; string query2 = "SELECT * FROM Passengers WHERE AdminId = " + adminId + ""; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); float y; try { y = Convert.ToInt32(adminId) / 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()) { a = new Admin(); a.AdminId = Convert.ToInt32(sdr2["AdminId"]); a.Username = sdr2["Username"].ToString(); a.Name = sdr2["Name"].ToString(); a.Email = sdr2["Email"].ToString(); a.Gender = Convert.ToString(sdr2["Gender"]); a.Address = sdr2["Address"].ToString(); a.Age = Convert.ToInt32(sdr2["Age"]); a.Question = sdr2["Question"].ToString(); a.Password = sdr2["Password"].ToString(); } dcc.CloseConnection(); return(a); } else { SqlDataReader sdr = dcc.GetData(query); List <Passenger> pList = new List <Passenger>(); if (sdr.Read()) { a = new Admin(); a.AdminId = Convert.ToInt32(sdr["AdminId"]); a.Username = sdr["Username"].ToString(); a.Name = sdr["Name"].ToString(); a.Email = sdr["Email"].ToString(); a.Gender = Convert.ToString(sdr["Gender"]); a.Address = sdr["Address"].ToString(); a.Age = Convert.ToInt32(sdr["Age"]); a.Question = sdr["Question"].ToString(); a.Password = sdr["Password"].ToString(); } dcc.CloseConnection(); return(a); } }
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); } }
public Flight GetFlight(string flightId) { string query = "SELECT * from Flight WHERE AirlineName LIKE '%" + flightId + "%' "; Flight f = null; DatabaseConnection dcc = new DatabaseConnection(); dcc.ConnectWithDB(); string query2 = "SELECT * from Flight WHERE FlightId = " + flightId + ""; float y; try { y = Convert.ToInt32(flightId) / 2; y = 1; } catch (Exception er) { y = -10; } if (y + 1 >= 1) { SqlDataReader sdr2 = dcc.GetData(query2); List <Flight> fList2 = new List <Flight>(); //id if (sdr2.Read()) { f = new Flight(); f.FlightId = Convert.ToInt32(sdr2["FlightId"]); f.AirlineName = sdr2["AirlineName"].ToString(); f.Source = sdr2["Source"].ToString(); f.Destination = sdr2["Destination"].ToString(); f.Departure = Convert.ToString(sdr2["Departure"]); f.Cost = Convert.ToInt32(sdr2["Cost"]); fList2.Add(f); } dcc.CloseConnection(); return(f); } else { SqlDataReader sdr = dcc.GetData(query); List <Flight> fList = new List <Flight>(); if (sdr.Read()) { f = new Flight(); f.FlightId = Convert.ToInt32(sdr["FlightId"]); f.AirlineName = sdr["AirlineName"].ToString(); f.Source = sdr["Source"].ToString(); f.Destination = sdr["Destination"].ToString(); f.Departure = Convert.ToString(sdr["Departure"]); f.Cost = Convert.ToInt32(sdr["Cost"]); fList.Add(f); //Console.WriteLine("s"); } dcc.CloseConnection(); return(f); } dcc.CloseConnection(); return(f); }