public bool UpdateCarByID(int id, string manufacter, string model, long registerNumber, string workCity, ClassOfCars classOfCars)
{
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
string Query = "UPDATE [Car] SET " +
"[manufacter] = '" + manufacter + "', " +
"[model] = '" + model + "'," +
"[registerNumber] = '" + registerNumber + "', " +
"[workCity] = '" + workCity + "', " +
"[classOfCar] = '" + classOfCars.ToString() + "'" +
"WHERE idCar = '" + id + "' ";
SqlCommand sqlCommand = new SqlCommand(Query, con);
sqlCommand.ExecuteNonQuery();
con.Close();
return(true);
}
public bool AddCar(string manufacter, string model, long registerNumber, string workCity, ClassOfCars classOfCars)
{
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
string Query = "INSERT INTO[dbo].[Car]([classOfCar],[manufacter], [model], [registerNumber], [workCity]) VALUES " +
"('" + classOfCars.ToString() + "', '" + manufacter + "', '" + model + "', '" + registerNumber + "', '" + workCity + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = Query;
sqlCommand.Connection = con;
sqlCommand.ExecuteNonQuery();
con.Close();
return(true);
}
