private void update_user_for_contribution(TableTopDataClassesDataContext db, int contribution_id, int new_user_id, DateTime dt)
{
var mapping = from m in db.Collection_Contribution_Mappings
where m.contribution_id == contribution_id
select m;
if (mapping.Count() == 0)
{
return;
}
Collection_Contribution_Mapping c1 = mapping.First <Collection_Contribution_Mapping>();
if (mapping.Count() == 1)
{
var colls = from c in db.Collections
where c.id == c1.collection_id
select c;
if (colls.Count() == 1)
{
Collection c2 = colls.First <Collection>();
c2.user_id = new_user_id;
db.SubmitChanges();
}
//var mapping2 = from m in db.Collection_Contribution_Mappings
// where m.collection_id == c1.collection_id
// select m;
//if (mapping2.Count() != 1)
// should_create_collection = true;
}
}
private bool create_contribution(SNote note, SMedia media, DateTime note_date, DateTime note_mod_date, string content, string note_id, bool is_design_idea, int collection_id, string status, TableTopDataClassesDataContext db)
{
Contribution c = new Contribution();
c.date = note_date;
c.modified_date = note_mod_date;
c.location_id = find_location_id(note);
string note_content = content;
if (media != null)
{
c.media_url = media.link;
}
else
{
c.media_url = "";
}
c.note = note_content;
c.status = status;
if (is_design_idea)
{
c.tags = "Design Idea";
}
else
{
if (media != null)
{
c.tags = media.kind;
}
else
{
c.tags = note.kind;
}
}
c.technical_info = note_id;
c.web_username = note.webusername;
db.Contributions.InsertOnSubmit(c);
if (!SubmitChangesToLocalDB(db))
{
return(false);
}
//
Collection_Contribution_Mapping map = new Collection_Contribution_Mapping();
map.collection_id = collection_id;
map.contribution_id = c.id;
map.date = note_date;
db.Collection_Contribution_Mappings.InsertOnSubmit(map);
if (!SubmitChangesToLocalDB(db))
{
return(false);
}
return(true);
}
private void button_add_contrib_Click(object sender, EventArgs e)
{
try
{
int uid = cached_users[comboBox_users_addcontrib.SelectedIndex].id;
int cid = cached_user_collections[comboBox_collections_addcontrib.SelectedIndex].id;
int lid = cached_locations[comboBox_locations_addcontrib.SelectedIndex].id;
TableTopDataClassesDataContext db = Configurations.GetTableTopDB();
Contribution c = new Contribution();
c.date = DateTime.Now;
c.modified_date = DateTime.Now;
c.location_id = lid;
c.media_url = textBox_mediaurl_addcontrib.Text;
c.note = textBox_desc_addcontrib.Text;
c.tags = textBox_tags_addcontrib.Text;
c.status = "";
db.Contributions.InsertOnSubmit(c);
db.SubmitChanges();
if (checkBox_new_collection.Checked)
{
Collection c2 = new Collection();
c2.activity_id = cached_activities_addcontrib[comboBox_activities_addcontrib.SelectedIndex].id;
c2.date = DateTime.Now;
c2.user_id = uid;
c2.name = Configurations.GetDate_Formatted(c2.date);
db.Collections.InsertOnSubmit(c2);
db.SubmitChanges();
cid = c2.id;
}
Collection_Contribution_Mapping ccm = new Collection_Contribution_Mapping();
ccm.collection_id = cid;
ccm.contribution_id = c.id;
ccm.date = DateTime.Now;
db.Collection_Contribution_Mappings.InsertOnSubmit(ccm);
db.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\r\n--\r\n" + ex.StackTrace);
}
MessageBox.Show("Contribution was added successfully.");
}
private void update_or_create_collection(TableTopDataClassesDataContext db, int contribution_id, int new_activity_id, DateTime dt)
{
bool should_create_collection = false;
var mapping = from m in db.Collection_Contribution_Mappings
where m.contribution_id == contribution_id
select m;
if (mapping.Count() == 0)
{
return;
}
Collection_Contribution_Mapping c1 = mapping.First <Collection_Contribution_Mapping>();
if (mapping.Count() != 1)
{
should_create_collection = true;
}
else
{
var colls = from c in db.Collections
where c.id == c1.collection_id
select c;
if (colls.Count() == 1)
{
Collection c2 = colls.First <Collection>();
c2.activity_id = new_activity_id;
db.SubmitChanges();
}
//var mapping2 = from m in db.Collection_Contribution_Mappings
// where m.collection_id == c1.collection_id
// select m;
//if (mapping2.Count() != 1)
// should_create_collection = true;
}
//int user_id = c1.Collection.user_id;
//if (should_create_collection)
//{
// // create new collection
// Collection c2 = new Collection();
// c2.activity_id = new_activity_id;
// c2.date = dt;
// c2.name = Configurations.GetDate_Formatted(dt);
// c2.user_id = user_id;
// db.Collections.InsertOnSubmit(c2);
// db.SubmitChanges();
// var mapping_old = from m in db.Collection_Contribution_Mappings
// where m.contribution_id == contribution_id
// select m;
// db.Collection_Contribution_Mappings.DeleteAllOnSubmit(mapping_old);
// db.SubmitChanges();
// Collection_Contribution_Mapping mapping_new = new Collection_Contribution_Mapping();
// mapping_new.collection_id = c2.id;
// mapping_new.contribution_id = contribution_id;
// mapping_new.date = dt;
// db.SubmitChanges();
//}
//else
//{
// c1.Collection.activity_id = new_activity_id;
// db.SubmitChanges();
//}
}
void submit_text(RoutedEventArgs e)
{
bool is_design_idea = hide_expander;
if (is_design_idea)
{
Contribution idea = new Contribution();
idea.date = DateTime.Now;
idea.location_id = 0;
idea.note = this.GetActiveTextBox().Text;
idea.tags = "Design Idea";
database_manager.InsertDesignIdea(idea, this.comment_user_id);
int collection_id = configurations.get_or_create_collection(this.comment_user_id, 1, DateTime.Now);
Collection_Contribution_Mapping map = new Collection_Contribution_Mapping();
map.collection_id = collection_id;
map.contribution_id = idea.id;
map.date = DateTime.Now;
database_manager.InsertCollectionContributionMapping(map);
if (the_item.Content != null)
((design_ideas_listbox)the_item.Content).list_all_design_ideas();
//window_manager.load_design_ideas();
log.WriteInteractionLog(42, "Idea" + "; Text: " + this.GetActiveTextBox().Text + "; object_type: " + _object_type + "; object_id: " + _object_id.ToString(), ((TouchEventArgs)e).TouchDevice);
window_manager.close_submit_design_idea_window((window_frame)this.parent, idea.note);
//if (((design_ideas_listbox)the_item.Content).parent != null)
// ((design_ideas_listbox)the_item.Content).parent.list_all_design_ideas();
}
else
{
Feedback comment = new Feedback();
comment.date = DateTime.Now;
comment.note = this.GetActiveTextBox().Text;
comment.object_id = this._object_id;
comment.object_type = this._object_type.ToString();
//if (comments_listbox._list.SelectedIndex == -1)
// comment.parent_id = 0;
//else
//{
//int p_id = (int)((item_generic)comments_listbox._list.Items[comments_listbox._list.SelectedIndex]).Tag;
if (is_reply)
comment.parent_id = reply_id;
else
comment.parent_id = 0;
//}
comment.technical_info = "";
comment.type_id = 1;
comment.user_id = this.comment_user_id;
database_manager.InsertFeedback(comment);
if (is_reply)
log.WriteInteractionLog(42, "Comment; Reply id: " + reply_id + "; Text: " + this.GetActiveTextBox().Text + "; object_type: " + _object_type + "; object_id: " + _object_id.ToString(), ((TouchEventArgs)e).TouchDevice);
else
log.WriteInteractionLog(42, "Comment; Text: " + this.GetActiveTextBox().Text + "; object_type: " + _object_type + "; object_id: " + _object_id.ToString(), ((TouchEventArgs)e).TouchDevice);
if (this.the_item.Content != null)
{
try
{
item_generic_v2 v2 = (item_generic_v2)this.the_item.Content;
v2.number.Text = (Convert.ToInt32(v2.number.Text) + 1).ToString();
}
catch (Exception) { }
}
this.list_all_comments();
if (this._object_type.ToString() == "nature_net.Contribution")
window_manager.load_design_ideas_sync();
}
//this.GetActiveTextBox().SelectAll();
cancel_comment_auth_clicked(null, null);
GotoDefaultMode();
comment_textbox_default.Text = "";
comment_textbox_reply.Text = "";
CheckTextBoxText();
}
