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); }
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); }