private void showData() { MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); var universityCollection = database.GetCollection <University>("University"); var query1 = from University in universityCollection.AsQueryable <University>() where University.Name == university select University; u = query1.First(); list.Items.Clear(); foreach (MongoDBRef tmpRef in u.generatedData) { Animal tmp = database.FetchDBRefAs <Animal>(tmpRef); Topic t = database.FetchDBRefAs <Topic>(tmp.topic); list.Items.Add((list.Items.Count + 1) + ". " + tmp.name + ", date: " + tmp.date + " - topic:" + t.name); } }
private void btnDeleteTopic_Click(object sender, EventArgs e) { if (comboTopic.SelectedItem == null) { MessageBox.Show("Pick a topic"); return; } MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); var topicCollection = database.GetCollection <Topic>("Topics"); var query1 = from Topics in topicCollection.AsQueryable <Topic>() where Topics.name == comboTopic.SelectedItem.ToString() select Topics; Topic t = query1.First(); //foreach (MongoDBRef animalRef in university.generatedData) //{ // Animal tmp = database.FetchDBRefAs<Animal>(animalRef); // //MessageBox.Show(tmp.name); // collection.Remove(Query.EQ("_id", tmp.Id)); //} topicCollection.Remove(Query.EQ("_id", t.Id)); }
private void comboProp_SelectedIndexChanged(object sender, EventArgs e) { MongoDatabase database = MongoService.getDatabase(); Animal animal = database.FetchDBRefAs <Animal>(u.generatedData[list.SelectedIndex]); lblName.Text = animal.name; lblDate.Text = animal.date.ToShortDateString(); textPropName.Text = animal.properties[comboProp.SelectedIndex].Name; textPropValue.Text = animal.properties[comboProp.SelectedIndex].Value; }
public void getTopics() { MongoDatabase database = MongoService.getDatabase(); var topicCollecion = database.GetCollection <Topic>("Topics"); comboTopic.Items.Clear(); foreach (Topic t in topicCollecion.FindAll()) { comboTopic.Items.Add(t.name); } }
public void getUniversities() { MongoDatabase database = MongoService.getDatabase(); var collecion = database.GetCollection <University>("University"); comboUniversity.Items.Clear(); foreach (University u in collecion.FindAll()) { comboUniversity.Items.Add(u.Name); } }
private void list_MouseClick(object sender, MouseEventArgs e) { if (list.SelectedItem == null) { return; } MongoDatabase database = MongoService.getDatabase(); Animal animal = database.FetchDBRefAs <Animal>(u.generatedData[list.SelectedIndex]); lblName.Text = animal.name; lblDate.Text = animal.date.ToShortDateString(); addComboData(animal); }
private void btnDelete_Click(object sender, EventArgs e) { MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); var UniversityCollection = database.GetCollection <University>("University"); MongoDBRef animalRef = u.generatedData[list.SelectedIndex]; Animal animal = database.FetchDBRefAs <Animal>(animalRef); u.generatedData.RemoveAt(list.SelectedIndex); UniversityCollection.Save(u); collection.Remove(Query.EQ("_id", animal.Id)); showData(); }
private void btnAdd_Click(object sender, EventArgs e) { if (comboTopic.SelectedItem == null) { MessageBox.Show("Pick a topic"); return; } if (textName.TextLength < 1) { MessageBox.Show("Enter name"); return; } MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); var topicCollecion = database.GetCollection <Topic>("Topics"); var universityCollection = database.GetCollection <University>("University"); var query1 = from Topics in topicCollecion.AsQueryable <Topic>() where Topics.name == comboTopic.SelectedItem.ToString() select Topics; Topic t = query1.First(); Animal a = new Animal { name = this.textName.Text, date = this.dateTime.Value, properties = tmpProps, topic = new MongoDBRef("Topics", t.Id), //university = new MongoDBRef("University", university.Id) }; collection.Insert <Animal>(a); university.generatedData.Add(new MongoDBRef("Animals", a.Id)); //topicCollecion.Save(t); universityCollection.Save(university); tmpProps.Clear(); listProp.Items.Clear(); textName.Clear(); }
private void btnAddProp_Click(object sender, EventArgs e) { if (textPropName.TextLength < 1 || textPropValue.TextLength < 1) { MessageBox.Show("Enter property"); return; } MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); Animal animal = database.FetchDBRefAs <Animal>(u.generatedData[list.SelectedIndex]); animal.properties.Add(new Property { Name = textPropName.Text, Value = textPropValue.Text }); collection.Save(animal); addComboData(animal); }
private void showData() { MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); var topicCollection = database.GetCollection <Topic>("Topics"); var query1 = from Topics in topicCollection.AsQueryable <Topic>() where Topics.name == topic select Topics; t = query1.First(); //var query = from Animals in collection.AsQueryable<Animal>() // where Animals.properties // select Animals; //foreach(Animal a in query) //{ // MessageBox.Show(a.name); //} //list.Items.Clear(); List <Animal> lista = new List <Animal>(); List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.EQ("topic.$id", t.Id)); foreach (Animal tmp in collection.Find(Query.And(queries))) { Topic t = database.FetchDBRefAs <Topic>(tmp.topic); lista.Add(tmp); } list.DataSource = lista; list.DisplayMember = "name"; list.ValueMember = "Id"; }
private void button1_Click(object sender, EventArgs e) { if (textTopicName.Text.Length < 1) { MessageBox.Show("Enter topic name"); return; } MongoDatabase database = MongoService.getDatabase(); var topicCollecion = database.GetCollection <Topic>("Topics"); Topic t = new Topic { name = textTopicName.Text }; topicCollecion.Insert <Topic>(t); parent.getTopics(); this.Close(); }
private void list_MouseDoubleClick(object sender, MouseEventArgs e) { if (list.SelectedItem == null) { return; } MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); Animal animal = collection.FindOne(Query.EQ("_id", ObjectId.Parse(list.SelectedValue.ToString()))); String props = ""; int brojac = 1; foreach (Property tmp in animal.properties) { props += " " + brojac + ". " + tmp.Name + ": " + tmp.Value + " \n"; brojac++; } //MessageBox.Show(list.SelectedItem.ToString()); MessageBox.Show(props, animal.name + " properties", MessageBoxButtons.OK); }
private void btnSave_Click(object sender, EventArgs e) { MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); Animal animal = database.FetchDBRefAs <Animal>(u.generatedData[list.SelectedIndex]); if (textName.TextLength > 0) { animal.name = textName.Text; } animal.date = dateTime.Value; if (textPropName.TextLength > 0 && textPropValue.TextLength > 0) { animal.properties[comboProp.SelectedIndex].Name = textPropName.Text; animal.properties[comboProp.SelectedIndex].Value = textPropValue.Text; } collection.Save(animal); clearAll(); showData(); }
private void btnExport_Click(object sender, EventArgs e) { MongoDatabase database = MongoService.getDatabase(); var collection = database.GetCollection <Animal>("Animals"); var topicCollection = database.GetCollection <Topic>("Topics"); int dataCount = 9999999; List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.EQ("topic.$id", t.Id)); if (textCount.TextLength > 0) { dataCount = Int32.Parse(textCount.Text); } if (textNoPops.TextLength > 0) { queries.Add(Query.Size("properties", Int32.Parse(textNoPops.Text))); } if (textName.TextLength > 0) { queries.Add(Query.EQ("name", textName.Text)); } if (rbProp.Checked && textPropName.TextLength > 0 && textPropValue.TextLength > 0) { //db.collection.find( { {properties : {Name: }} : { $exists: true } } ); var jsonQuery = "{ properties : {\"Name\" : \"" + textPropName.Text + "\", \"Value\" : \"" + textPropValue.Text + "\" }}"; BsonDocument doc = MongoDB.Bson.Serialization .BsonSerializer.Deserialize <BsonDocument>(jsonQuery); queries.Add(new QueryDocument(doc)); //queries.Add(Query.Find()}; } String text = ""; int i = 1; foreach (Animal a in collection.Find(Query.And(queries)).SetLimit(dataCount)) { if (text == "") { text += "Topic: " + t.name + System.Environment.NewLine + System.Environment.NewLine; } text += i + ". Name: " + a.name + ", date: " + a.date + "; \n \t Properties: \n"; foreach (Property p in a.properties) { text += "\t \t Name:" + p.Name + ", Value: " + p.Value + System.Environment.NewLine; } text += System.Environment.NewLine; i++; } dataView f = new dataView(text); f.Show(); }
private void btnRegister_Click(object sender, EventArgs e) { if (textUsername.TextLength < 1) { MessageBox.Show("Enter username"); return; } if (textPass1.TextLength < 1 || textPass2.TextLength < 1) { MessageBox.Show("Enter password"); return; } else { if (textPass1.Text != textPass2.Text) { MessageBox.Show("Passwords does not match"); return; } } if (!cbScietist.Checked && !cbUser.Checked) { MessageBox.Show("Pick a role"); return; } MongoDatabase database = MongoService.getDatabase(); var topicCollecion = database.GetCollection <User>("User"); var universityCollection = database.GetCollection <University>("University"); var queryUser = from User in topicCollecion.AsQueryable() where User.username == textUsername.Text select User; if (queryUser.Count() > 0) { MessageBox.Show("That username already exists"); textUsername.Text = ""; return; } User u; if (cbScietist.Checked) { var query = from University in universityCollection.AsQueryable <University>() where University.Name == comboUniversity.SelectedItem.ToString() select University; University uni = query.First(); u = new Scientist { username = textUsername.Text, password = textPass1.Text, //type = "scientist", university = new MongoDBRef("University", uni.Id) }; } else { u = new User { username = textUsername.Text, password = textPass1.Text, //type = "user", }; } topicCollecion.Insert(u); //University u1 = new University { Name = "Univerzitet u Nisu" }; //University u2 = new University { Name = "Univerzitet u Beogradu" }; //University u3 = new University { Name = "Univerzitet u Novom Sadu" }; //universityCollection.Insert<University>(u1); //universityCollection.Insert<University>(u2); //universityCollection.Insert<University>(u3); parent.enableBtn(); this.Close(); }
private void logIn_Click(object sender, EventArgs e) { if (textPassword.TextLength < 1 || TextUsername.TextLength < 1) { MessageBox.Show("Invalid username/password combination"); return; } MongoDatabase database = MongoService.getDatabase(); var userCollecion = database.GetCollection <Scientist>("User"); var query = from User in userCollecion.AsQueryable() where User.username == TextUsername.Text select User; //var u=userCollecion.FindOne<>(Query.EQ("username", TextUsername.Text)); //MessageBox.Show(query.GetType().ToString()); if (query.Count() == 0) { MessageBox.Show("Invalid username/password combination"); return; } //var u=query.First(); //if(query.GetType()==typeof(Scientist)) // var u = query.Cast<>(); if (query.First().GetType() == typeof(Scientist) && query.First().university != null) { var u = query.First(); if (u.password == textPassword.Text) { Form1 f = new Form1(this, (Scientist)u); f.Show(); clearText(); this.Hide(); } else { MessageBox.Show("Invalid username/password combination"); return; } } else { var u = query.First(); if (u.password == textPassword.Text) { devTopic.BackColor = Color.FromArgb(150, 255, 255, 255); lblTopic.Visible = true; btnTopic.Visible = true; comboTopic.Visible = true; getTopics(); logIn.Enabled = false; Register.Enabled = false; textPassword.Enabled = false; TextUsername.Enabled = false; } else { MessageBox.Show("Invalid username/password combination"); return; } } //if (u.password==textPassword.Text) //{ // if (query.GetType() == typeof(User)) // { // devTopic.BackColor=Color.FromArgb(150, 255, 255, 255); // lblTopic.Visible = true; // btnTopic.Visible = true; // comboTopic.Visible=true; // getTopics(); // logIn.Enabled = false; // Register.Enabled = false; // textPassword.Enabled = false; // TextUsername.Enabled = false; // } // else // { // Form1 f = new Form1(this,(Scientist)u); // f.Show(); // clearText(); // this.Hide(); // } // //Form1 f = new Form1(this); // //f.Show(); // //clearText(); // //this.Hide(); //} //else //{ // MessageBox.Show("Invalid username/password combination"); // return; //} }
private void getUniversity() { MongoDatabase database = MongoService.getDatabase(); university = database.FetchDBRefAs <University>(logedUser.university); }