public ActionResult CreateUser(LoginModel model) { try { //this checks if there is valid data in the required fields On the SignUp page if (ModelState.IsValid) { MongoCRUD db = new MongoCRUD("BZBugs"); //This checks if the username is unique or not. if (db.CheckIfUsernameIsUnique<LoginModel>(model.Username) == true) { //Failure State ModelState.AddModelError("Username", "This Username already exists."); return View("SignUp", model); } GenerateSaltedHash(model, 64, model.Password); db.InsertRecord("Users", model); //I want to Redirect this action to something more relevant like a Profile page or something. //Success return View("~/Views/Home/Profile.cshtml", model); } //Failure State return View("SignUp", model); } catch { //Failure State return View("SignUp", model); } }
public vorhandeneNachbestellungenViewModel(string hv) { try { //connecting to database var crud = new MongoCRUD("avdb"); //get filtered records (filtered by Id which is "Hv": hv) var erg = crud.LoadRecords <Nachbestellung>("nachbestellungen", hv); //filtered List is an ObservableCollection which is updated with OnPropertyChanged method CollTop = new ObservableCollection <Nachbestellung>(erg); //same procedure for the articles collection.... //var arterg = crud.LoadRecords<Artikel>("bestellteArtikel", hv); CollBot = new ObservableCollection <Artikel>(); for (int i = 0; i < CollTop.Count; i++) { foreach (var a in CollTop[i].artikelliste) { CollBot.Add(a); } } //wenn Abfrageergebnis null ist, dann Messagebox-Info (Zu dieser Hv wurde keine Nachbestellung gefunden!) if (CollBot.Count <= 0) { MessageBox.Show("Zu dieser Hv wurde keine Nachbestellung gefunden!", "Keine Daten vorhanden!", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception e) { MessageBox.Show(e.Message); } }
public List <UserModel> Get() { MongoCRUD db = new MongoCRUD("BbgCluster"); var results = db.Get <UserModel>("Users"); return(results); }
public ActionResult VerifyLocation(string areaName, string locName) { Trace.WriteLine("I AM ACCESSED VERIFY"); bool exists = false; List <AreaInfo> areas = null; if (MongoCRUD.GetInstance().DBConnectionStatus()) { areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", "areaName", areaName); if (areas != null) { foreach (AreaInfo ai in areas) { foreach (LocationObject ld in ai.locationsList) { if (ld.locName == locName) { exists = true; } } Trace.WriteLine(ai.areaName); } } } return(Json(exists, JsonRequestBehavior.AllowGet)); }
public ActionResult VerifyCaseExists(string caseID) { Trace.WriteLine("VERIFYCASE CALLED " + caseID); bool exists = false; List <CaseInfo> cases = null; if (MongoCRUD.GetInstance().DBConnectionStatus()) { cases = MongoCRUD.GetInstance().LoadRecords <CaseInfo>("Cases", "caseID", caseID); if (cases != null) { foreach (CaseInfo ci in cases) { if (ci.caseID == caseID) { exists = true; } Trace.WriteLine(ci.caseID); } } } return(Json(exists, JsonRequestBehavior.AllowGet)); }
public static void RegisterDefaultConventionPack_Should_Register_Custom_ConventionPack() { // arrange & act (register) MongoCRUD.RegisterDefaultConventionPack(t => t == typeof(ConventionPackTestClass)); var serializerRegistry = BsonSerializer.SerializerRegistry; var documentSerializer = serializerRegistry.GetSerializer <ConventionPackTestClass>(); var builder = FilterBuilder.GetFilterBuilder <ConventionPackTestClass>(); var myTest = new ConventionPackTestClass { MyGuid = Guid.NewGuid(), MyTest = ConventionPackTestEnum.Test2 }; FilterDefinition <ConventionPackTestClass> filter1 = builder.Eq(r => r.MyGuid, myTest.MyGuid); FilterDefinition <ConventionPackTestClass> filter2 = builder.Eq(r => r.MyTest, myTest.MyTest); // act (using) var rendered1 = filter1?.Render(documentSerializer, serializerRegistry); var rendered2 = filter2?.Render(documentSerializer, serializerRegistry); // assert Assert.NotNull(rendered1); Assert.Single(rendered1); Assert.Equal("myGuid", rendered1?.FirstOrDefault().Name); Assert.True(rendered1?.FirstOrDefault().Value.IsString); Assert.NotNull(rendered2); Assert.Single(rendered2); Assert.Equal("myTest", rendered2?.FirstOrDefault().Name); Assert.Equal(myTest.MyTest.ToString(), rendered2?.FirstOrDefault().Value); // Cleanup MongoCRUD.UnregisterDefaultConventionPack(); }
public static void Create_Many_Should_Works() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithIdProperty>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(mongoClient, "SomeDB"); var document1 = new GenericTestWithIdProperty { Id = "123", SomeTest = "test" }; var document2 = new GenericTestWithIdProperty { Id = "124", SomeTest = "test2" }; var documents = new List <GenericTestWithIdProperty> { document1, document2 }; // act mongoCRUD.Create(documents); // assert // if no exception, create has success }
public static void Contructor_Empty_Should_Return_An_Instance_Without_MongoClient_Instance() { // arrange & act var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(); // assert Assert.Null(mongoCRUD.MongoClient); }
// GET api/values public List <AreaInfo> Get(string id) { List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>(id, null, null); Trace.WriteLine("IM ACCESED"); return(areas); }
public void ValidateCase(string areaName, string locName, string caseID, List <string> serialList) { foreach (string item in serialList) { SerialInfo si = new SerialInfo(); si.serial = item; LocationData d = new LocationData(); d.curCase = caseID; d.date = DateTime.UtcNow.Date.ToString("dd/MM/yyyy"); d.time = DateTime.Now.ToString("h:mm:ss tt"); d.location = locName; d.lastLocation = true; d.userID = "311015"; si.locationData.Add(d); if (MongoCRUD.GetInstance().RecordExists <SerialInfo>("Serial", item, "serial")) { MongoCRUD.GetInstance().AppendRecord <SerialInfo>("Serial", item, d); } else { MongoCRUD.GetInstance().InsertRecord("Serial", si, item, caseID); } } CaseInfo ci = new CaseInfo(); ci.caseID = caseID; ci.curLoc = locName; ci.ageInfo = DateTime.Now.ToString("MM-dd-yyyy hh: mm tt"); MongoCRUD.GetInstance().InsertRecord("Cases", ci, caseID, null); List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", "areaName", areaName); if (areas.Count != 0) { foreach (LocationObject lo in areas[0].locationsList) { if (lo.locName == ci.curLoc) { if (!lo.casesList.Contains(ci)) { MongoCRUD.GetInstance().UpdateLocationCases(lo, areas[0], ci); } } } } }
static void Main(string[] args) { MongoCRUD db = new MongoCRUD("AngularApplicationDB"); db.insertRecord("Movies", new Movie { Title = "Justice League", Plot = "Fueled by his restored faith in humanity and inspired by Superman's selfless act, Bruce Wayne enlists the help of his new-found ally, Diana Prince, to face an even greater enemy.", Fullplot = "Fueled by his restored faith in humanity and inspired by Superman's selfless act, Bruce Wayne enlists the help of his new-found ally, Diana Prince, to face an even greater enemy.", Directors = new List <string>() { "Zack Snyder" }, Writers = new List <string>() { "Jerry Siegel (Superman created by)", "Joe Shuster (Superman created by)" }, Lastupdated = DateTime.Now, Poster = "", Cast = new List <string>() { " Ben Affleck", " Gal Gadot", "Jason Momoa" }, Imdb = new Imdb() { Rating = 6.2, Votes = 39029 }, Tomatoes = new Tomato() { Viewer = new TomatoViewer() { NumReviews = 23, Rating = 4.5f }, Production = "test" } } ); // db.insertRecord("Courseposts", new Coursepost { Author="Test", Full_Desc="Book1", Title = "Book1", IsActive=1, Image = "bookjpg",EnteredDate = DateTime.Now }); Console.WriteLine("Updated"); //var recs = db.Get<Employee>("Employees"); //foreach(var rec in recs) //{ // Console.WriteLine($"{rec.Id} : {rec.FirstName} : {rec.Lastname} : {rec.Entereddate} "); //} //ar rec= db.GetById<Employee>("Employees", "21c10c57-64f3-4a05-ab94-f91c0340de15"); // var em = new Employee {Id= "ab7aa38e-757b-4d8d-b2e2-3c1dbb56d6db",FirstName="Neethu", EmailId = "*****@*****.**" }; // db.UpsertRecord("Employees", "ab7aa38e-757b-4d8d-b2e2-3c1dbb56d6db", em); Console.Read(); }
public ActionResult GetCaseSerials(string caseID) { List <SerialInfo> list = MongoCRUD.GetInstance().LoadRecords <SerialInfo>("Serial", "caseID", caseID); foreach (SerialInfo li in list) { Trace.WriteLine(li.serial); } return(Json(list, JsonRequestBehavior.AllowGet)); }
private void LoadPersonData() { MongoCRUD db = new MongoCRUD(dbName); people = db.LoadRecords <PersonModel>(personTable); people.Insert(0, new PersonModel { FirstName = "<add new person>" }); existingRecordDropDown.DataSource = people; }
public ActionResult Get() { MongoCRUD db = new MongoCRUD("Blog"); var results = db.LoadRecords <PostsModel>("Posts"); foreach (var rec in results) { Console.WriteLine(rec.Id + " " + rec.Name); } Console.ReadLine(); return(results); }
async public Task <IActionResult> Get(string id) { try { var result = await MongoCRUD.LoadRecordById <TodoModel>("todos", new ObjectId(id)); return(Ok(result)); } catch (Exception e) { return(StatusCode(500, e.Message)); } }
public static void DeleteByQuery_Should_Works_With_Null_Filter() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithIdProperty>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(mongoClient, "SomeDB"); FilterDefinition <GenericTestWithIdProperty> filters = null; // act var isAcknowledged = mongoCRUD.DeleteByQuery(filters); // assert Assert.True(isAcknowledged); }
public async Task <IActionResult> Create(TodoModel todo) { try { await MongoCRUD.InsertRecord("todos", todo); return(Ok()); } catch (Exception e) { return(StatusCode(500, e.Message)); } }
public ValuesController() { MongoCRUD.GetInstance().ConnectToDB("Serials"); if (MongoCRUD.GetInstance().DBConnectionStatus()) { Trace.WriteLine("CONNECTED BROHAM"); } else { Trace.WriteLine("NOT NOT NOT NOT CONNECTED BROHAM"); } }
// This method deletes data from the database and then redisplays the data. public ActionResult DeleteBug(Guid id) { try { MongoCRUD db = new MongoCRUD("BZBugs"); db.DeleteRecord<BugsModel>("Bugs", id); return RedirectToAction(nameof(ListBugs)); } catch { return View(); } }
public ActionResult Profile(LoginModel model) { try { MongoCRUD db = new MongoCRUD("BZBugs"); LoginModel details = db.LoadRecordById <LoginModel>("Users", model.Id); return(View(details)); } catch { return(View()); } }
public ActionResult BugDetails(Guid id) { try { MongoCRUD db = new MongoCRUD("BZBugs"); BugsModel details = db.LoadRecordById<BugsModel>("Bugs", id); return View(details); } catch { return RedirectToAction(nameof(ListBugs)); } }
public static void Get_Should_Throws_Exception_When_Id_Is_Null() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithIdProperty>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(mongoClient, "SomeDB"); // act Exception ex = Assert.Throws <ArgumentNullException>(() => mongoCRUD.Get(null)); // assert Assert.Equal("Value cannot be null.\r\nParameter name: id", ex.Message); }
async public Task <IActionResult> Get() { try { var result = await MongoCRUD.LoadRecords <TodoModel>("todos"); return(Ok(result)); } catch (Exception e) { return(StatusCode(500, e.Message)); } }
public static void DeleteByQuery_Should_Works_With_Filter() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithIdProperty>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(mongoClient, "SomeDB"); var filters = FilterBuilder.GetFilterBuilder <GenericTestWithIdProperty>().Eq(r => r.SomeTest, "test"); // act var isAcknowledged = mongoCRUD.DeleteByQuery(filters); // assert Assert.True(isAcknowledged); }
public static void Delete_Should_Works() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithIdProperty>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(mongoClient, "SomeDB"); var id = "123"; // act var isAcknowledged = mongoCRUD.Delete(id); // assert Assert.True(isAcknowledged); }
public static void Contructor_With_MongoClient_Should_Returns_Instance() { // arrange IMongoClient client = new MongoClient(); string database = "MyDB"; // act var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(client, database); // assert Assert.NotNull(mongoCRUD); Assert.NotNull(mongoCRUD.MongoClient); Assert.Null(mongoCRUD.Configuration); }
public static void Upsert_Should_Throws_Exception_When_Document_Is_Null() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithBsonIdAnnotation>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithBsonIdAnnotation>(mongoClient, "SomeDB"); GenericTestWithBsonIdAnnotation document = null; // act Exception ex = Assert.Throws <ArgumentNullException>(() => mongoCRUD.Upsert(document)); // assert Assert.Equal("Value cannot be null.\r\nParameter name: document", ex.Message); }
public static void Create_Many_Should_Throws_Exception_When_Document_Is_Null() { // arrange var mongoClient = FakeMongoClient.GetMongoClientMock <GenericTestWithIdProperty>(true).Object; var mongoCRUD = new MongoCRUD <GenericTestWithIdProperty>(mongoClient, "SomeDB"); List <GenericTestWithIdProperty> documents = null; // act Exception ex = Assert.Throws <ArgumentNullException>(() => mongoCRUD.Create(documents)); // assert Assert.Equal("Value cannot be null.\r\nParameter name: documents", ex.Message); }
static void Main(string[] args) { var db = new MongoCRUD("Test"); // db.AddAsync<Person>("person", new Person { Age = 12, Name = "Ho3n" }).GetAwaiter(); var result = db.GetAllAsync <Person>("person").GetAwaiter().GetResult(); // db.UpdateByNameAsync<Person>("person", "Hamed", new Person { Name = "Ali" }); foreach (var item in result) { Console.WriteLine($"{item.Name} / {item.Age}"); } Console.ReadKey(); }
public async Task <IActionResult> Update(TodoModel todo) { try { var updateInstructions = Builders <TodoModel> .Update.Set("done", todo.done); await MongoCRUD.UpdateRecord("todos", todo.Id, updateInstructions); return(Ok()); } catch (Exception e) { return(StatusCode(500, e.Message)); } }