public List<Vehicle> GetAllVehicle() { aConnection.Open(); string query = string.Format("SELECT * FROM t_vehicle_information"); SqlCommand aCommand = new SqlCommand(query, aConnection); SqlDataReader aReader = aCommand.ExecuteReader(); List<Vehicle> vehicles = new List<Vehicle>(); if (aReader.HasRows) { while (aReader.Read()) { aVehicle = new Vehicle(); aVehicle.Id = (int) aReader[0]; aVehicle.RegNO = aReader[1].ToString(); aVehicle.OwnerName = aReader[2].ToString(); aVehicle.Deal = Convert.ToInt32(aReader[3]); aVehicle.DriverName = aReader[4].ToString(); aVehicle.Model = aReader[5].ToString(); aVehicle.Status = aReader[6].ToString(); vehicles.Add(aVehicle); } } aConnection.Close(); return vehicles; }
public string GetDriverName(string regNo) { aConnection.Open(); string query = string.Format("SELECT * FROM t_vehicle_information WHERE reg_no='{0}'",regNo); SqlCommand aCommand = new SqlCommand(query, aConnection); SqlDataReader aReader = aCommand.ExecuteReader(); if (aReader.HasRows) { while (aReader.Read()) { aVehicle = new Vehicle(); aVehicle.DriverName = aReader[4].ToString(); } } aConnection.Close(); return aVehicle.DriverName; }
public Vehicle GetVehicleDetails(int vehicleId) { aConnection.Open(); string query = string.Format("SELECT * FROM t_vehicle_information WHERE id = {0}", vehicleId); SqlCommand aCommand = new SqlCommand(query, aConnection); SqlDataReader aReader = aCommand.ExecuteReader(); Vehicle vehicles = new Vehicle(); if (aReader.HasRows) { while (aReader.Read()) { vehicles.Id = (int)aReader[0]; vehicles.RegNO = aReader[1].ToString(); vehicles.OwnerName = aReader[2].ToString(); vehicles.Deal = Convert.ToInt32(aReader[3].ToString()); vehicles.DriverName = aReader[4].ToString(); vehicles.Model = aReader[5].ToString(); vehicles.Status = aReader[6].ToString(); } } aConnection.Close(); return vehicles; }