//Create
public int?Add(TeamDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO team (TeamName,TeamLogo,TeamDivisionID,TeamCaptainID,TeamMember2ID,TeamMember3ID,TeamMember4ID,TeamMember5ID)" +
" VALUES(?TeamName,?TeamLogo,?TeamDivisionID,?TeamCaptainID," +
"?TeamMember2ID,?TeamMember3ID,?TeamMember4ID,?TeamMember5ID)", conn);
//values
cmd.Parameters.AddWithValue("TeamName", entity.TeamName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamLogo", entity.TeamLogo ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamDivisionID", entity.TeamDivisionID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamCaptainID", entity.TeamCaptainID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamMember2ID", entity.TeamMember2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamMember3ID", entity.TeamMember3ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamMember4ID", entity.TeamMember4ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamMember5ID", entity.TeamMember5ID ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(LastIdAdded());
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(DivisionDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO division (DivisionName,DivisionDescription) VALUES(?DivisionName, " +
"?DivisionDescription)", conn);
//values
//cmd.Parameters.AddWithValue("DivisionID", entity.DivisionID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("DivisionName", entity.DivisionName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("DivisionDescription", entity.DivisionDescription ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
AddTeamsToDivision(entity, conn);
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(NewsDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO news (NewsTitle,NewsSubject,NewsDate,NewsArticle) " +
"VALUES(?NewsTitle,?NewsSubject,?NewsDate,?NewsArticle)", conn);
//values
cmd.Parameters.AddWithValue("NewsTitle", entity.NewsTitle ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("NewsSubject", entity.NewsSubject ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("NewsDate", entity.NewsDate ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("NewsArticle", entity.NewsArticle ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(PlayerStatDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO god (PlayerID,MatchID,TeamID,GodPlayedID,PlayerLevel," +
"PlayerKills,PlayerDeaths,PlayerAssists,PlayerDamage,PlayerDamageTaken,PlayerDamageMitigated," +
"PlayerHealing,PlayerGoldEarned,PlayerGoldPerMinute,PlayerItem1ID,PlayerItem2ID," +
"PlayerItem3ID,PlayerItem4ID,PlayerItem5ID,PlayerItem6ID," +
"PlayerRelic1ID,PlayerRelic2ID,PlayerWon,PlayerRoleID,PlayerPickOrder) VALUES(?PlayerID,?MatchID,?TeamID,?GodPlayedID,?PlayerLevel," +
"?PlayerKills,?PlayerDeaths,?PlayerAssists,?PlayerDamage,?PlayerDamageTaken,?PlayerDamageMitigated," +
"?PlayerHealing,?PlayerGoldEarned,?PlayerGoldPerMinute,?PlayerItem1ID,?PlayerItem2ID," +
"?PlayerItem3ID,?PlayerItem4ID,?PlayerItem5ID,?PlayerItem6ID," +
"?PlayerRelic1ID,?PlayerRelic2ID,?PlayerWon,?PlayerRoleID,?PlayerPickOrder)", conn);
//values
//values
cmd.Parameters.AddWithValue("PlayerID", entity.PlayerID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("MatchID", entity.MatchID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamID", entity.TeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodPlayedID", entity.GodPlayedID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerLevel", entity.PlayerLevel);
cmd.Parameters.AddWithValue("PlayerKills", entity.PlayerKills);
cmd.Parameters.AddWithValue("PlayerDeaths", entity.PlayerDeaths);
cmd.Parameters.AddWithValue("PlayerAssists", entity.PlayerAssists);
cmd.Parameters.AddWithValue("PlayerDamage", entity.PlayerDamage);
cmd.Parameters.AddWithValue("PlayerDamageTaken", entity.PlayerDamageTaken);
cmd.Parameters.AddWithValue("PlayerDamageMitigated", entity.PlayerDamageMitigated);
cmd.Parameters.AddWithValue("PlayerHealing", entity.PlayerHealing);
cmd.Parameters.AddWithValue("PlayerGoldEarned", entity.PlayerGoldEarned);
cmd.Parameters.AddWithValue("PlayerGoldPerMinute", entity.PlayerGoldPerMinute);
cmd.Parameters.AddWithValue("PlayerItem1ID", entity.PlayerItem1ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem2ID", entity.PlayerItem2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem3ID", entity.PlayerItem3ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem4ID", entity.PlayerItem4ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem5ID", entity.PlayerItem5ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerItem6ID", entity.PlayerItem6ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRelic1ID", entity.PlayerRelic1ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRelic2ID", entity.PlayerRelic2ID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerWon", entity.PlayerWon);
cmd.Parameters.AddWithValue("PlayerRoleID", entity.PlayerRoleID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerPickOrder", entity.PlayerPickOrder);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(AccountDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO account (AccountName, AccountEmail,AccountPassword,PlayerID) " +
" VALUES(?AccountName,?AccountEmail,?AccountPassword,?PlayerID)", conn);
//values
cmd.Parameters.AddWithValue("AccountName", entity.AccountName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("AccountEmail", entity.AccountEmail ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("AccountPassword", entity.AccountPassword ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerID", entity.PlayerID ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
private static void BackgroundWorker()
{
while (true)
{
WorkerEvent.WaitOne();
var connection = ConnectionContext.GetConnection();
//connection can be opened by another DataContext
if (!connection.IsConnected())
{
if (Parameters.IsAssigned)
{
connection.Connect(Parameters.Namespace, Parameters.User, Parameters.Password);
}
else
{
connection.Connect();
}
}
ThreadResult.Result = connection;
ThreadResult.WaitHandle.Set();
WorkerEvent.Reset();
}
}
internal static Connection ActiveConnection()
{
try
{
// if the connection context already has a connection, this
// will be returned. Otherwise a new one is created.
// Current problem: if Globals isn't running, this HANGS. Can we
// check whether it's running, or do we have to create a worker thread
// to check ...? Let's not get involved with multithreading for
// simple proof-of-concept examples if possible.
Connection working_conn = ConnectionContext.GetConnection();
// ensure that the connection is connected (active)
if (!working_conn.IsConnected())
{
working_conn.Connect();
}
return(working_conn);
}
catch
{
return(null);
}
}
//Create
public int?Add(PlayerDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO player (PlayerID,PlayerName,PlayerPlatformID,PlayerRoleID,PlayerTeamID) " +
"VALUES(?PlayerID,?PlayerName,?PlayerPlatformID,?PlayerRoleID,?PlayerTeamID)", conn);
//values
cmd.Parameters.AddWithValue("PlayerID", entity.PlayerID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerName", entity.PlayerName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerPlatformID", entity.PlayerPlatformID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerRoleID", entity.PlayerRoleID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PlayerTeamID", entity.PlayerTeamID ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(MatchDTO entity)
{
try
{
List <int?> GodBanList = entity.GodIDBanList.ToList();
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO match (ApiMatchID,MatchDate,MatchLength,PatchNumber,WinningTeamID,HomeTeamID,AwayTeamID,GodBan1ID,GodBan2ID,GodBan3ID,GodBan4ID,GodBan5ID,GodBan6ID,GodBan7ID,GodBan8ID,GodBan9ID,GodBan10ID) " +
"VALUES(?ApiMatchID,?MatchDate,?MatchLength,?PatchNumber,?WinningTeamID,?HomeTeamID,?AwayTeamID,?GodBan1ID,?GodBan2ID,?GodBan3ID,?GodBan4ID,?GodBan5ID,?GodBan6ID,?GodBan7ID,?GodBan8ID,?GodBan9ID,?GodBan10ID)", conn);
//values
cmd.Parameters.AddWithValue("ApiMatchID", entity.ApiMatchID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("MatchDate", entity.MatchDate);
cmd.Parameters.AddWithValue("MatchLength", entity.MatchLength);
cmd.Parameters.AddWithValue("PatchNumber", entity.PatchNumber ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("WinningTeamID", entity.WinningTeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("HomeTeamID", entity.HomeTeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("AwayTeamID", entity.AwayTeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan1ID", GodBanList[0] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan2ID", GodBanList[1] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan3ID", GodBanList[2] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan4ID", GodBanList[3] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan5ID", GodBanList[4] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan6ID", GodBanList[5] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan7ID", GodBanList[6] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan8ID", GodBanList[7] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan9ID", GodBanList[8] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodBan10ID", GodBanList[9] ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(GodDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO god (GodIDGodName,GodTitle,GodLore,GodClass,GodIcon,GodCardArt) VALUES(?GodID,?GodName," +
"?GodTitle,?GodLore,?GodClass,?GodIcon,?GodCardArt)", conn);
//values
cmd.Parameters.AddWithValue("GodID", entity.GodID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodName", entity.GodName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodTitle", entity.GodTitle ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodLore", entity.GodLore ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodClass", entity.GodClass ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodIcon", entity.GodIcon ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("GodCardArt", entity.GodCardArt ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(ScheduleDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO schedule (ScheduleID,DivisionID,ScheduleName) VALUES(?ScheduleID,?DivisionID,?ScheduleName)", conn);
//values
cmd.Parameters.AddWithValue("ScheduleID", entity.ScheduleID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("DivisionID", entity.DivisionID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ScheduleName", entity.ScheduleName ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
//add multiple scheduleDetails
AddScheduleDetails(entity.ScheduleDetailsList, conn);
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(ItemDTO entity)
{
try
{
List <string> ItemStats = entity.ItemStats.ToList();
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO item (ItemID,ItemName,ItemIcon,ItemDescription,ItemShortDescription,ItemPrice,ItemStat1,ItemStat2,ItemStat3,ItemStat4) " +
"VALUES(?ItemID,?ItemName,?ItemIcon,?ItemDescription,?ItemShortDescription,?ItemPrice,?ItemStat1,?ItemStat2,?ItemStat3,?ItemStat4)", conn);
//values
cmd.Parameters.AddWithValue("ItemID", entity.ItemID);
cmd.Parameters.AddWithValue("ItemName", entity.ItemName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemIcon", entity.ItemIcon ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemDescription", entity.ItemDescription ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemShortDescription", entity.ItemShortDescription ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemPrice", entity.ItemPrice);
cmd.Parameters.AddWithValue("ItemStat1", ItemStats[0] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemStat2", ItemStats[1] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemStat3", ItemStats[2] ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemStat4", ItemStats[3] ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
//Create
public int?Add(RoleDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO role (RoleName,RoleDescription) VALUES(?RoleName,?RoleDescription)", conn);
//values
cmd.Parameters.AddWithValue("RoleName", entity.RoleName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RoleDescription", entity.RoleDescription ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
public static void Main(String[] args)
{
Connection myConn = ConnectionContext.GetConnection();
try {
myConn.Connect("User", "_SYSTEM", "SYS");
NodeReference nodeRef = myConn.CreateNodeReference("myGlobal");
// Read both existing nodes
Console.WriteLine("Value of ^myGlobal is " + nodeRef.GetString());
Console.WriteLine("Value of ^myGlobal(\"sub1\") is " + nodeRef.GetString("sub1"));
nodeRef.Kill(); // delete entire array
nodeRef.Close();
myConn.Close();
}
catch (GlobalsException e) { Console.WriteLine(e.Message); }
} // end Main()
static Connection Connect()
{
//getting conection
Connection myConn = ConnectionContext.GetConnection();
//check if the connection is opened
if (!myConn.IsConnected())
{
Console.WriteLine("Connectiong...");
//if connection is not opened, then connect
myConn.Connect("User", "_SYSTEM", "SYS");
}
if (myConn.IsConnected())
{
Console.WriteLine("Successfully connected");
//if OK then return opened connection
return(myConn);
}
else
{
return(null);
}
}
//Create
public int?Add(StandingDTO entity)
{
try
{
using (MySqlConnection conn = _con.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO standing (DivisionID,TeamID,Score) VALUES(?DivisionID,?TeamID,?Score)", conn);
//values
cmd.Parameters.AddWithValue("DivisionID", entity.DivisionID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("TeamID", entity.TeamID ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("Score", entity.Score ?? (object)DBNull.Value);
//execute command
int rowsAffected = cmd.ExecuteNonQuery();
//should return if a row is affected or not
return(rowsAffected);
}
}
catch (Exception ex)
{
throw new ContextErrorException(ex);
}
}
