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