/// <summary> /// Connects to the /// </summary> /// <returns></returns> private bool ConnectAndExtract() { bool success = true; _connection = base.Login(); if (_connection != null) { _dBPushFunctions = new DBPushFunctions(_connection); _dBPullFunctions = new DBPullFunctions(_connection); // try // { Extract(); //} //catch (ExceptionName e ) //{ // success = false; //} } else { success = false; } _connection.Dispose(); return(success); }
/// <summary> /// /// </summary> /// <param name="groupModelPublish"></param> public static void CreateNewGroup(GroupModelPublish groupModelPublish) { MySqlConnection connection = new MySqlConnection(connectionString); DBPushFunctions pushFunction = new DBPushFunctions(connection); int j = pushFunction.PushStringDataToDB("allGroups", CreateDictonaryFromModel(ref groupModelPublish)); groupModelPublish.ID = j; AddUsersToNewGroup(ref groupModelPublish, ref pushFunction); }
/// <summary> /// Since a way to push information is needed then this will be added. /// </summary> /// <param name="dbUtil"></param> public void AddDbPushFunctions(DBPushFunctions dbPush) { _dbPush = dbPush; }
/// <summary> /// Add all the users to the group. /// </summary> /// <param name="groupModelPublish"></param> /// <param name="dBPushFunctions"></param> private static void AddUsersToNewGroup(ref GroupModelPublish groupModelPublish, ref DBPushFunctions dBPushFunctions) { for (int i = 0; i < groupModelPublish.Users.Count(); i++) { Dictionary <string, string> valuesDict = new Dictionary <string, string>(); valuesDict.Add("groupID", groupModelPublish.ID.ToString()); valuesDict.Add("userID", groupModelPublish.Users[i].ToString()); dBPushFunctions.PushStringDataToDB("userGroup", valuesDict); } }