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