private void button_remove_user_Click(object sender, EventArgs e) { if (cached_users.Count == 0) { MessageBox.Show("Please refresh the users list."); return; } if (comboBox_users.SelectedIndex < 0) { MessageBox.Show("Please select a user."); return; } int id = cached_users[comboBox_users.SelectedIndex].id; TableTopDataClassesDataContext db = Configurations.GetTableTopDB(); var users = from u in db.Users where u.id == id select u; if (users.Count() != 1) { MessageBox.Show("Error. User not found."); return; } User the_user = users.Single <User>(); var collections = from c in db.Collections where c.user_id == the_user.id select c; if (collections.Count() > 0) { MessageBox.Show("This user cannot be deleted, because of his/her collections."); return; } var feedbacks = from f in db.Feedbacks where f.user_id == the_user.id select f; if (feedbacks.Count() > 0) { MessageBox.Show("This user cannot be deleted, because of his/her feedbacks."); return; } db.Users.DeleteOnSubmit(the_user); sync.classes.Action action = new classes.Action(); action.type_id = 3; action.user_id = 0; action.date = DateTime.UtcNow; action.object_type = "nature_net.User"; action.object_id = the_user.id; db.Actions.InsertOnSubmit(action); action.technical_info = the_user.name; try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } }
private void button_remove_activity_Click(object sender, EventArgs e) { if (cached_activities.Count == 0) { MessageBox.Show("Please refresh the activities list."); return; } if (comboBox_activities.SelectedIndex < 0) { MessageBox.Show("Please select an activity."); return; } int id = cached_activities[comboBox_activities.SelectedIndex].id; TableTopDataClassesDataContext db = Configurations.GetTableTopDB(); var activities = from u in db.Activities where u.id == id select u; if (activities.Count() != 1) { MessageBox.Show("Error. Activity not found."); return; } Activity the_activity = activities.Single <Activity>(); var collections = from c in db.Collections where c.activity_id == the_activity.id select c; if (collections.Count() > 0) { MessageBox.Show("This activity cannot be deleted, because of the contributions in the activity."); return; } db.Activities.DeleteOnSubmit(the_activity); sync.classes.Action action = new classes.Action(); action.type_id = 3; action.user_id = 0; action.date = DateTime.UtcNow; action.object_id = the_activity.id; action.object_type = "nature_net.Activity"; action.technical_info = the_activity.technical_info; db.Actions.InsertOnSubmit(action); try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } MessageBox.Show("Removed from the local database. It will be synced once (Local -> Server) is enabled."); }
private void button_update_activity_Click(object sender, EventArgs e) { if (cached_activities.Count == 0) { MessageBox.Show("Please refresh the activities list."); return; } if (comboBox_activities.SelectedIndex < 0) { MessageBox.Show("Please select an activity."); return; } if (textBox_activity_name.Text == "" || textBox_activity_description.Text == "") { MessageBox.Show("Please fill the name and description textboxes."); return; } int id = cached_activities[comboBox_activities.SelectedIndex].id; TableTopDataClassesDataContext db = Configurations.GetTableTopDB(); var activities = from u in db.Activities where u.id == id select u; if (activities.Count() != 1) { MessageBox.Show("Error. Activity not found."); return; } Activity the_activity = activities.Single <Activity>(); the_activity.name = textBox_activity_name.Text; the_activity.description = textBox_activity_description.Text; the_activity.avatar = textBox_activity_icon_url.Text; sync.classes.Action action = new classes.Action(); action.type_id = 2; action.user_id = 0; action.date = DateTime.UtcNow; action.object_id = the_activity.id; action.object_type = "nature_net.Activity"; action.technical_info = "Updating name/desc."; db.Actions.InsertOnSubmit(action); try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } MessageBox.Show("Updated in the local database. It will be synced once (Local -> Server) is enabled."); }
private void button_remove_idea_Click(object sender, EventArgs e) { if (cached_ideas.Count == 0) { MessageBox.Show("Please refresh the ideas list."); return; } if (comboBox_ideas.SelectedIndex < 0) { MessageBox.Show("Please select an idea."); return; } int id = cached_ideas[comboBox_ideas.SelectedIndex].id; TableTopDataClassesDataContext db = Configurations.GetTableTopDB(); var ideas = from u in db.Contributions where u.id == id select u; if (ideas.Count() != 1) { MessageBox.Show("Error. Design idea not found."); return; } Contribution the_idea = ideas.Single <Contribution>(); var mappings = from m in db.Collection_Contribution_Mappings where m.contribution_id == the_idea.id select m; db.Collection_Contribution_Mappings.DeleteAllOnSubmit(mappings); db.Contributions.DeleteOnSubmit(the_idea); sync.classes.Action action = new classes.Action(); action.type_id = 3; action.user_id = 0; action.date = DateTime.UtcNow; action.object_id = the_idea.id; action.object_type = "nature_net.Contribution"; action.technical_info = the_idea.technical_info; db.Actions.InsertOnSubmit(action); try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } }
private void button_update_affiliation_Click(object sender, EventArgs e) { if (cached_users.Count == 0) { MessageBox.Show("Please refresh the users list."); return; } if (comboBox_users.SelectedIndex < 0) { MessageBox.Show("Please select a user."); return; } int id = cached_users[comboBox_users.SelectedIndex].id; TableTopDataClassesDataContext db = Configurations.GetTableTopDB(); var users = from u in db.Users where u.id == id select u; if (users.Count() != 1) { MessageBox.Show("Error. User not found."); return; } User the_user = users.Single <User>(); the_user.affiliation = textBox_affiliation.Text; sync.classes.Action action = new classes.Action(); action.type_id = 2; action.user_id = 0; action.date = DateTime.UtcNow; action.object_id = the_user.id; action.object_type = "nature_net.User"; action.technical_info = "Updating affiliation."; db.Actions.InsertOnSubmit(action); try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } }
private void button_add_activity_Click(object sender, EventArgs e) { if (textBox_activity_name.Text == "" || textBox_activity_description.Text == "") { MessageBox.Show("Please fill the name and description textboxes."); return; } Activity a = new Activity(); a.name = textBox_activity_name.Text; a.description = textBox_activity_description.Text; a.avatar = textBox_activity_icon_url.Text; a.avatar = ""; a.creation_date = DateTime.UtcNow; a.location_id = 0; TableTopDataClassesDataContext db = Configurations.GetTableTopDB(); db.Activities.InsertOnSubmit(a); sync.classes.Action action = new classes.Action(); action.type_id = 1; action.user_id = 0; action.date = DateTime.UtcNow; action.object_type = "nature_net.Activity"; action.technical_info = "Adding an activity."; try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } action.object_id = a.id; db.Actions.InsertOnSubmit(action); db.SubmitChanges(); try { db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Error (" + ex.Message + "):\r\n" + ex.StackTrace); return; } MessageBox.Show("Added to the local database. It will be synced once (Local -> Server) is enabled."); }