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