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