public static void SaveDailycupMatchBatch(DailycupMatchDataSet.DailyCup_MatchDataTable matchData)
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = SqlBatchHelper.GetMyCommand(con, CommandType.StoredProcedure, "P_DailycupMatch_Insert2");
cmd.AddMyParameter("@DailyCupId", SqlDbType.Int, matchData.DailyCupIdColumn.ColumnName);
cmd.AddMyParameter("@HomeManager", SqlDbType.UniqueIdentifier, matchData.HomeManagerColumn.ColumnName);
cmd.AddMyParameter("@AwayManager", SqlDbType.UniqueIdentifier, matchData.AwayManagerColumn.ColumnName);
cmd.AddMyParameter("@HomeName", SqlDbType.VarChar, matchData.HomeNameColumn.ColumnName);
cmd.AddMyParameter("@AwayName", SqlDbType.VarChar, matchData.AwayNameColumn.ColumnName);
cmd.AddMyParameter("@HomeLogo", SqlDbType.VarChar, matchData.HomeLogoColumn.ColumnName);
cmd.AddMyParameter("@AwayLogo", SqlDbType.VarChar, matchData.AwayLogoColumn.ColumnName);
cmd.AddMyParameter("@HomeLevel", SqlDbType.Int, matchData.HomeLevelColumn.ColumnName);
cmd.AddMyParameter("@AwayLevel", SqlDbType.Int, matchData.AwayLevelColumn.ColumnName);
cmd.AddMyParameter("@HomePower", SqlDbType.Int, matchData.HomePowerColumn.ColumnName);
cmd.AddMyParameter("@AwayPower", SqlDbType.Int, matchData.AwayPowerColumn.ColumnName);
cmd.AddMyParameter("@HomeWorldScore", SqlDbType.Int, matchData.HomeWorldScoreColumn.ColumnName);
cmd.AddMyParameter("@AwayWorldScore", SqlDbType.Int, matchData.AwayWorldScoreColumn.ColumnName);
cmd.AddMyParameter("@HomeScore", SqlDbType.Int, matchData.HomeScoreColumn.ColumnName);
cmd.AddMyParameter("@AwayScore", SqlDbType.Int, matchData.AwayScoreColumn.ColumnName);
cmd.AddMyParameter("@Round", SqlDbType.Int, matchData.RoundColumn.ColumnName);
cmd.AddMyParameter("@ChipInCount", SqlDbType.Int, matchData.ChipInCountColumn.ColumnName);
cmd.AddMyParameter("@Status", SqlDbType.Int, matchData.StatusColumn.ColumnName);
cmd.AddMyParameter("@RowTime", SqlDbType.DateTime, matchData.RowTimeColumn.ColumnName);
cmd.AddMyParameter("@Idx", SqlDbType.UniqueIdentifier, matchData.IdxColumn.ColumnName);
SqlDataAdapter adap = SqlBatchHelper.GetMyBatchAdapter(null, cmd, cmd, cmd);
con.Open();
adap.Update(matchData);
cmd.Parameters.Clear();
}
}
public static void SaveDailycupMatchBulk(DailycupMatchDataSet.DailyCup_MatchDataTable matchData)
{
SqlBatchHelper.BulkInsert(ConnectionString, matchData);
}
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);
}
}
