public List <Car> SelectCars()
{
using (SqlCommand command = new SqlCommand("SELECT * FROM Car ", CarConnection.GetInstance().SqlConnection))
{
//
// Add new SqlParameter to the command.
//
//command.Parameters.Add(new SqlParameter("Name", dogName));
//
// Read in the SELECT results.
//
List <Car> carsList = new List <Car>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Car newCar = new Car(reader.GetInt32(0), reader.GetString(2), reader.GetInt32(1), reader.GetInt32(3), reader.GetString(4));
carsList.Add(newCar);
//ListViewItem lvi = new ListViewItem();
//lvi.Text = newCar.Id.ToString() ;
//lvi.SubItems.Add(newCar.Company);
//lvi.SubItems.Add(newCar.Comments);
//lvi.SubItems.Add(newCar.Size.ToString());
//lvi.SubItems.Add(newCar.Color.ToString());
//listView1.Items.Add(lvi);
}
return(carsList);
}
}
public List <Driver> SelectDrivers()
{
using (SqlCommand command = new SqlCommand("SELECT * FROM Driver ", CarConnection.GetInstance().SqlConnection))
{
//
// Add new SqlParameter to the command.
//
//command.Parameters.Add(new SqlParameter("Name", dogName));
//
// Read in the SELECT results.
//
List <Driver> driverList = new List <Driver>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Driver newDriver = new Driver(reader.GetInt32(0), reader.GetString(2), reader.GetInt32(1), reader.GetString(3), reader.GetInt32(4));
driverList.Add(newDriver);
}
return(new List <Driver>());
}
}
public void DeleteDriver(Driver driver)
{
SqlCommand sqlCommand = new SqlCommand(@"Delete * from Drivers where Id = @Id", CarConnection.GetInstance().SqlConnection);
SqlParameter sqlParameter = new SqlParameter("ID", driver.Id);
sqlCommand.Parameters.Add(sqlParameter);
}
public void UpdateDriver(Driver driver)
{
SqlCommand sqlCommand = new SqlCommand(@"Update Drivers set DriverName = @DriverName, Age=@Age, Adress= @Adress, DriversLessonType=@DriversLessonType where Id = @Id", CarConnection.GetInstance().SqlConnection);
SqlParameter sqlParameter = new SqlParameter("ID", driver.Id);
sqlCommand.Parameters.Add(sqlParameter);
SqlParameter sqlParameter1 = new SqlParameter("DriverName", driver.DriverName);
sqlCommand.Parameters.Add(sqlParameter1);
SqlParameter sqlParameter2 = new SqlParameter("Age", driver.Age);
sqlCommand.Parameters.Add(sqlParameter2);
SqlParameter sqlParameter3 = new SqlParameter("Adress", driver.Address);
sqlCommand.Parameters.Add(sqlParameter3);
SqlParameter sqlParameter4 = new SqlParameter("DriversLessonType", driver.DriversLessonType);
sqlCommand.Parameters.Add(sqlParameter4);
}
public void InsertDriver(Driver driver)
{
SqlCommand sqlCommand = new SqlCommand(@"INSERT INTO Drivers VALUES @ID, @DriverName, @Age, @Address, @DriversLessonType", CarConnection.GetInstance().SqlConnection);
SqlParameter sqlParameter = new SqlParameter("ID", driver.Id);
sqlCommand.Parameters.Add(sqlParameter);
SqlParameter sqlParameter1 = new SqlParameter("DriverName", driver.DriverName);
sqlCommand.Parameters.Add(sqlParameter1);
SqlParameter sqlParameter2 = new SqlParameter("Age", driver.Age);
sqlCommand.Parameters.Add(sqlParameter2);
SqlParameter sqlParameter3 = new SqlParameter("Adress", driver.Address);
sqlCommand.Parameters.Add(sqlParameter3);
SqlParameter sqlParameter4 = new SqlParameter("DriversLessonType", driver.DriversLessonType);
sqlCommand.Parameters.Add(sqlParameter4);
sqlCommand.ExecuteScalar();
}
public bool CheckDriverExists(Driver driver)
{
using (SqlCommand command = new SqlCommand("SELECT * FROM Driver where id= @ID ", CarConnection.GetInstance().SqlConnection))
{
SqlParameter sqlParameter = new SqlParameter("ID", driver.Id);
command.Parameters.Add(sqlParameter);
List <Driver> driverList = new List <Driver>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
return(true);
}
return(false);
}
}
public void UpdateCar(Car car)
{
SqlCommand sqlCommand = new SqlCommand(@"Update Cars set CarSize = @CarSize, CarCompany=@CarCompany, CarColor= @CarColor, Comments=@Comments where Id = @Id", CarConnection.GetInstance().SqlConnection);
SqlParameter sqlParameter = new SqlParameter("ID", car.Id);
sqlCommand.Parameters.Add(sqlParameter);
SqlParameter sqlParameter1 = new SqlParameter("CarSize", car.Size);
sqlCommand.Parameters.Add(sqlParameter1);
SqlParameter sqlParameter2 = new SqlParameter("CarCompany", car.Company);
sqlCommand.Parameters.Add(sqlParameter2);
SqlParameter sqlParameter3 = new SqlParameter("CarColor", car.Color);
sqlCommand.Parameters.Add(sqlParameter3);
SqlParameter sqlParameter4 = new SqlParameter("Comments", car.Comments);
sqlCommand.Parameters.Add(sqlParameter4);
sqlCommand.ExecuteScalar();
}
public void InsertCar(Car car)
{
//SqlCommand sqlCommand = new SqlCommand(@"INSERT INTO Car VALUES (+" + txtId.Text + ", "+ txtSize.Text + ",'" + txtCompany.Text + "', '" + txtComments.Text +"')", cnn);
SqlCommand sqlCommand = new SqlCommand(@"INSERT INTO Car VALUES @ID, @CarSize, @CarCompany, @CarColor, Comments", CarConnection.GetInstance().SqlConnection);
SqlParameter sqlParameter = new SqlParameter("ID", car.Id);
sqlCommand.Parameters.Add(sqlParameter);
SqlParameter sqlParameter1 = new SqlParameter("CarSize", car.Size);
sqlCommand.Parameters.Add(sqlParameter1);
SqlParameter sqlParameter2 = new SqlParameter("CarCompany", car.Company);
sqlCommand.Parameters.Add(sqlParameter2);
SqlParameter sqlParameter3 = new SqlParameter("CarColor", car.Color);
sqlCommand.Parameters.Add(sqlParameter3);
SqlParameter sqlParameter4 = new SqlParameter("Comments", car.Comments);
sqlCommand.Parameters.Add(sqlParameter4);
sqlCommand.ExecuteScalar();
}
