static string GameDefinitionImageTrace(List <GameInfo> Infos, GameSupplierType gst) { int i = 0; return ("INSERT INTO GameDefinitionImageTrace ([FileName],[GameDefId],[Memo]) VALUES\n" + string.Join( $",\n", Infos.Select(d => $"({d.ImageFileName},@maxDefinitionId+{++i},N'{gst}')" ))); }
static string DoAllThings(string site, GameSupplierType gst, GameCategoryType gct, HallType ht, List <SqlColSetting> data, string idName) { var gameSupplier = (int)gst; var gameHallSort = gameSupplier - 1; var gameHallName = gst.ToString(); var gameHallTitleName = new System.Globalization.CultureInfo("es-ES").TextInfo.ToTitleCase(gameHallName.ToLower()); var gameCategory = (int)gct; var discountName = gameHallTitleName + ht.ToString(); var hallType = ht.ToString(); var hallName = ht.GetDescriptionText(); var hallCategory = TransToHallCategory(ht).ToString(); string result = ""; result += Use(site); result += GameHallInfo(gameSupplier, true, gameHallSort, gameHallName); result += GameHallCategory(gameCategory, hallName, hallCategory, gameSupplier, discountName); result += RawDataSet(gameSupplier, gameHallTitleName, hallType, idName, data); return(result); }