/// <summary>
/// Takes a dictonary of headr and values and pushes it to database.
/// </summary>
/// <param name="skillName"></param>
/// <param name="skillDesc"></param>
/// <returns></returns>
public int PushNewSkillToDatabase(Dictionary <string, string> dict)
{
int result;
result = _dbPush.PushStringDataToDB("skillTable", dict);
return(result);
}
/// <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);
}
}
/// <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);
}