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