public static void set_task_user_ID( Context context, String Event_ID, int task_id, String user_id) { set_task_user_ID_MySQL(Event_ID, task_id, user_id); set_task_user_ID_ServerSQL(context, Event_ID, task_id, user_id); String message = Constants.Update_Task_User_ID + "|" + Event_ID + "^" + task_id + "^" + user_id; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static String create_event(Context context) { // Generate Event_ID. int id = 0; String Event_ID = Constants.MY_User_ID + " - " + id; ArrayList<String> allIDS = new ArrayList<>(); ArrayList<String>[] dbResult = sqlHelper.select(null, Table_Events.Table_Name, null, null, null); for (String t_id : dbResult[0]) { allIDS.add(t_id); } while (allIDS.contains(Event_ID)) { id++; Event_ID = Constants.MY_User_ID + " - " + id; } Event_Helper.details[Table_Events.Event_ID_num] = Event_ID; Date time = Calendar.getInstance().getTime(); Event_Helper.details[Table_Events.Update_Time_num] = time.toString(); // Create event in app sql + server sql. Create_Event_MySQL(); Create_Event_ServerSQL(context); // Send message to all users_ to create the event. String message = Constants.New_Event + "|" + Event_ID; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); return Event_ID; }
public static void delete_vote_date_User_ID(Context context, int Vote_ID, String User_ID) { String Event_ID = Event_Helper.details[Table_Events.Event_ID_num]; delete_vote_date_User_ID_MySQL(Event_ID, Vote_ID, User_ID); delete_vote_date_User_ID_ServerSQL(context, Event_ID, Vote_ID, User_ID); // Send message to all users. String message = Constants.Delete_Vote_Date + "|" + Event_ID + "^" + Vote_ID + "^" + User_ID; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static void delete_event(Context context, String Event_ID) { // Delete event in app sql + server sql. Delete_Event_MySQL(Event_ID); Delete_Event_ServerSQL(context, Event_ID); // Send message to all users to delete the event. String message = Constants.Delete_Event + "|" + Event_ID; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static void add_vote_location_User_ID(Context context, int Vote_ID, String User_ID) { String Event_ID = Event_Helper.details[Table_Events.Event_ID_num]; add_vote_location_User_ID_MySQL(Event_ID, Vote_ID, User_ID); add_vote_location_User_ID_ServerSQL(context, Event_ID, Vote_ID, User_ID); // Send message to all users. String message = Constants.Insert_Vote_Location + "|" + Event_ID + "^" + Vote_ID + "^" + User_ID; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static void update_Event_details_field( Context context, String Event_ID, String field_name, String update) { update_Event_details_field_MySQL(Event_ID, field_name, update); update_Event_details_field_ServerSQL(context, Event_ID, field_name, update); // Send message to all users. String message = Constants.Update_Event_Details_Filed + "|" + Event_ID + "^" + field_name + "^" + update; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static void leave_event(Context context, String Event_ID, String User_ID) { // Delete event in app sql. Delete_Event_MySQL(Event_ID); // Delete user from server sql. new EventUser_AsyncTask_delete(context).execute(Event_ID, User_ID); // Send message to all users to delete the event. String message = Constants.Delete_User + "|" + Event_ID + "^" + User_ID; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static void update_attending( Context context, String Event_ID, String User_ID, String attending) { update_attending_MySQL(Event_ID, User_ID, attending); update_attending_ServerSQL(context, Event_ID, User_ID, attending); // Send message to all users. String message = Constants.Update_User_Attending + "|" + Event_ID + "^" + Constants.MY_User_ID + "^" + attending; Send_Message_To_All_My_Friend_By_Event_ServerSQL(context, Event_ID, message); }
public static void delete_chat_message( Context context, String Chat_ID, String Message_ID, String User_ID) { // Remove from MySql sqlHelper.delete( Chat_ID, new String[] {Table_Chat.Message_ID, Table_Chat.User_ID}, new String[] {Message_ID, User_ID}, new int[] {1}); // Remove from server. new Chat_AsyncTask_delete(context).execute(Chat_ID, Message_ID, User_ID); // Send message to all friends. String message = Constants.Delete_Chat_Message + "|" + Chat_ID + "^" + Message_ID + "^" + User_ID; Send_Message_To_All_My_Friend_By_Event_ServerSQL( context, Event_Helper.details[Table_Events.Event_ID_num], message); }
public static void Send_Chat_Message_ServerSQL(Context context, String Chat_ID, String[] chat) { // Add chat message to server. String[] chat_server = new String[] { Chat_ID, chat[Table_Chat.Message_ID_num], chat[Table_Chat.User_ID_num], chat[Table_Chat.Message_num], chat[Table_Chat.Date_num], chat[Table_Chat.Time_num] }; new Chat_AsyncTask_insert(context).execute(chat_server); // Update all friends form the event. String message = Constants.New_Chat_Message + "|" + Chat_ID + "^" + chat[Table_Chat.Message_ID_num] + "^" + chat[Table_Chat.User_ID_num]; Send_Message_To_All_My_Friend_By_Event_ServerSQL( context, Event_Helper.details[Table_Events.Event_ID_num], message); }