public static void SaveCompetitorsFight(DailyCupCompetitorsDataSet.DailyCup_CompetitorsDataTable competitorsData) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = SqlBatchHelper.GetMyCommand(con, CommandType.StoredProcedure, "C_DailyCupCompetitors_SaveFight"); cmd.AddMyParameter("@Idx", SqlDbType.Int, competitorsData.IdxColumn.ColumnName); cmd.AddMyParameter("@MaxRound", SqlDbType.Int, competitorsData.MaxRoundColumn.ColumnName); cmd.AddMyParameter("@WinCount", SqlDbType.Int, competitorsData.WinCountColumn.ColumnName); cmd.AddMyParameter("@Rank", SqlDbType.Int, competitorsData.RankColumn.ColumnName); SqlDataAdapter adap = SqlBatchHelper.GetMyBatchAdapter(null, cmd, cmd, cmd); con.Open(); adap.Update(competitorsData); cmd.Parameters.Clear(); } }
public static void SaveCompetitorsPrize(DailyCupCompetitorsDataSet.DailyCup_CompetitorsDataTable competitorsData) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = SqlBatchHelper.GetMyCommand(con, CommandType.StoredProcedure, "C_DailyCupCompetitors_SavePrize"); cmd.AddMyParameter("@Idx", SqlDbType.Int, competitorsData.IdxColumn.ColumnName); cmd.AddMyParameter("@ManagerId", SqlDbType.UniqueIdentifier, competitorsData.ManagerIdColumn.ColumnName); cmd.AddMyParameter("@PrizeScore", SqlDbType.Int, competitorsData.PrizeScoreColumn.ColumnName); cmd.AddMyParameter("@PrizeSophisticate", SqlDbType.Int, competitorsData.PrizeSophisticateColumn.ColumnName); cmd.AddMyParameter("@PrizeCoin", SqlDbType.Int, competitorsData.PrizeCoinColumn.ColumnName); cmd.AddMyParameter("@PrizeItems", SqlDbType.VarChar, competitorsData.PrizeItemsColumn.ColumnName); SqlDataAdapter adap = SqlBatchHelper.GetMyBatchAdapter(null, cmd, cmd, cmd); con.Open(); adap.Update(competitorsData); cmd.Parameters.Clear(); } }
public static void SaveCompetitorsPrize(List <DailycupCompetitorsEntity> list) { DailyCupCompetitorsDataSet.DailyCup_CompetitorsDataTable competitorsData = new DailyCupCompetitorsDataSet.DailyCup_CompetitorsDataTable(); foreach (var entity in list) { var row = competitorsData.NewRow(); row["Idx"] = entity.Idx; row["DailyCupId"] = entity.DailyCupId; row["ManagerId"] = entity.ManagerId; row["ManagerName"] = entity.ManagerName; row["Logo"] = entity.Logo; row["MaxRound"] = entity.MaxRound; row["WinCount"] = entity.WinCount; row["Rank"] = entity.Rank; row["PrizeScore"] = entity.PrizeScore; row["PrizeSophisticate"] = entity.PrizeSophisticate; row["PrizeCoin"] = entity.PrizeCoin; row["PrizeItems"] = entity.PrizeItems; row["Status"] = entity.Status; row["RowTime"] = entity.RowTime; competitorsData.Rows.Add(row); } SaveCompetitorsPrize(competitorsData); }
MessageCode SaveDailycup() { try { DailyCupCompetitorsDataSet.DailyCup_CompetitorsDataTable competitorsData = new DailyCupCompetitorsDataSet.DailyCup_CompetitorsDataTable(); foreach (var entity in _Competitors) { var row = competitorsData.NewRow(); row["Idx"] = entity.Idx; row["DailyCupId"] = entity.DailyCupId; row["ManagerId"] = entity.ManagerId; row["ManagerName"] = entity.ManagerName; row["Logo"] = entity.Logo; row["MaxRound"] = entity.MaxRound; row["WinCount"] = entity.WinCount; row["Rank"] = entity.Rank; row["PrizeScore"] = entity.PrizeScore; row["PrizeSophisticate"] = entity.PrizeSophisticate; row["PrizeCoin"] = entity.PrizeCoin; row["Status"] = entity.Status; row["RowTime"] = entity.RowTime; competitorsData.Rows.Add(row); } DailycupSqlHelper.SaveCompetitorsFight(competitorsData); DailycupMatchDataSet.DailyCup_MatchDataTable matchData = new DailycupMatchDataSet.DailyCup_MatchDataTable(); foreach (var matchList in _matches) { foreach (var entity in matchList) { var row = matchData.NewRow(); row["DailyCupId"] = entity.DailyCupId; row["HomeManager"] = entity.HomeManager; row["HomeName"] = entity.HomeName; row["HomeLogo"] = entity.HomeLogo; row["AwayLogo"] = entity.AwayLogo; row["Idx"] = entity.Idx; row["Round"] = entity.Round; row["ChipInCount"] = entity.ChipInCount; row["RowTime"] = entity.RowTime; row["Status"] = entity.Status; row["HomeLevel"] = entity.HomeLevel; row["HomePower"] = entity.HomePower; row["HomeWorldScore"] = entity.HomeWorldScore; row["AwayManager"] = entity.AwayManager; row["AwayName"] = entity.AwayName; row["AwayLevel"] = entity.AwayLevel; row["AwayPower"] = entity.AwayPower; row["AwayWorldScore"] = entity.AwayWorldScore; row["AwayScore"] = entity.AwayScore; row["HomeScore"] = entity.HomeScore; matchData.Rows.Add(row); } } DailycupSqlHelper.SaveDailycupMatchBulk(matchData); return(MessageCode.Success); } catch (Exception ex) { SystemlogMgr.Error("SaveDailycup", ex); return(MessageCode.Exception); } }