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