public static SQLDefinition <TVTProgramme> GetProgrammeSQLDefinition() { var definition = new SQLDefinition <TVTProgramme>(); definition.Table = "tvt_programmes"; AddNamesSQLDefinition(definition); definition.Add(x => x.FakeDescriptionDE); definition.Add(x => x.FakeDescriptionEN); definition.Add(x => x.ProductType); definition.Add(x => x.ProgrammeType); definition.Add(x => x.Country); definition.Add(x => x.Year); definition.Add(x => x.MainGenre); definition.Add(x => x.SubGenre); definition.Add(x => x.Blocks); definition.Add(x => x.LiveHour); definition.Add(x => x.DistributionChannel); definition.Add(x => x.Flags); definition.Add(x => x.TargetGroups); definition.Add(x => x.ProPressureGroups); definition.Add(x => x.ContraPressureGroups); definition.Add(x => x.ImdbId); definition.Add(x => x.TmdbId); definition.Add(x => x.RottenTomatoesId); definition.Add(x => x.ImageUrl); //definition.Add( x => x.Director, null, "_id" ); //definition.Add( x => x.Participants, "participant1_id", null, 0 ); //definition.Add( x => x.Participants, "participant2_id", null, 1 ); //definition.Add( x => x.Participants, "participant3_id", null, 2 ); definition.Add(x => x.BettyBonus); definition.Add(x => x.PriceMod); definition.Add(x => x.CriticsRate); definition.Add(x => x.ViewersRate); definition.Add(x => x.BoxOfficeRate); definition.Add(x => x.MasterId); definition.Add(x => x.EpisodeIndex); //Zusatzinfos AdditionalFields(definition); definition.AddSubDefinition(x => x.Staff, GetStaffSQLDefinition()); return(definition); }
public static SQLDefinition <TVTNews> GetNewsSQLDefinition() { var definition = new SQLDefinition <TVTNews>(); definition.Table = "tvt_news"; AddNamesBasicSQLDefinition(definition); definition.Add(x => x.NewsType); definition.Add(x => x.NewsThreadId); definition.Add(x => x.Genre); definition.Add(x => x.Price); definition.Add(x => x.Quality); definition.Add(x => x.AvailableAfterDays); definition.Add(x => x.YearRangeFrom); definition.Add(x => x.YearRangeTo); definition.Add(x => x.MinHoursAfterPredecessor); definition.Add(x => x.TimeRangeFrom); definition.Add(x => x.TimeRangeTo); definition.Add(x => x.Resource1Type); definition.Add(x => x.Resource2Type); definition.Add(x => x.Resource3Type); definition.Add(x => x.Resource4Type); //definition.Add( x => x.Effects ); definition.Add(x => x.ProPressureGroups); definition.Add(x => x.ContraPressureGroups); //Zusatzinfos AdditionalFields(definition); definition.AddSubDefinition(x => x.Effects, GetNewsEffectSQLDefinition()); //definition.AfterInsert = new Action<MySqlConnection, TVTNews>( ( x, y ) => //{ //}); //var definition = GetNewsSQLDefinition(); //var sqlCommandText = "INSERT INTO tvt_news (" + definition.GetFieldNames( ',' ) + ") VALUES (" + definition.GetFieldNames( ',', "?" ) + ")"; //foreach ( var aNews in news ) //{ // var command = connection.CreateCommand(); // command.CommandText = sqlCommandText; // var enumerator = definition.GetEnumerator(); // while ( enumerator.MoveNext() ) // { // var field = enumerator.Current; // command.Parameters.AddWithValue( "?" + field.FieldName, field.GetValue( aNews ) ); // } // command.ExecuteNonQuery(); // if ( definition.AfterInsert != null ) // definition.AfterInsert( connection, aNews ); //} return(definition); }