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