public Nullable <DateTime> GetDateOfDeviceLastVisit(Guid deviceId, Guid applicationId)
{
try
{
IMongoQuery queryBase = Query.And
(
Query <AppUsageSummary> .EQ <Guid>(mem => mem.ApplicationId, applicationId),
Query.EQ("DevicesVisits.DeviceId", BsonValue.Create(deviceId))
);
MongoCursor <AppUsageSummary> appUsageSummaries =
this.GetCollection <AppUsageSummary>().Find(queryBase);
appUsageSummaries.SetSortOrder(SortBy <AppUsageSummary> .Descending(x => x.Date));
AppUsageSummary appUsageSummary = appUsageSummaries.FirstOrDefault();
if (appUsageSummary != null)
{
return(appUsageSummary.Date);
}
return(null);
}
catch (Exception ex)
{
throw new DataAccessLayerException(ex);
}
}
/*
* The application uses local installation of MongoDb
* Database name: "Dictionary"
* Table with entries name: "Entry"
*/
public static void Main()
{
string mongoDbConnectionString = Settings.Default.MongoDbConnectionString;
MongoDatabase mongoDb = Connector.GetDb(mongoDbConnectionString, "Dictionary");
MongoCollection entryMongoDb = mongoDb.GetCollection("entry");
Console.WriteLine(new string('*', 20));
Console.WriteLine("Please enter a word:");
string newWord = Console.ReadLine();
Console.WriteLine(new string('*', 20));
Console.WriteLine("Please enter the word translation:");
string newWordTranslation = Console.ReadLine();
BsonDocument newEntry = new BsonDocument()
{
{ "word", newWord },
{ "translation", newWordTranslation }
};
entryMongoDb.Insert(newEntry);
Console.WriteLine(new string('*', 20));
Console.WriteLine("All words in the dictionary are:");
MongoCursor <BsonDocument> allWordsInDicitonary = mongoDb.GetCollection("entry").FindAll();
foreach (var word in allWordsInDicitonary)
{
string wordText = word.Elements.Single(x => x.Name == "word").Value.ToString();
string wordTranslation = word.Elements.Single(x => x.Name == "translation").Value.ToString();
Console.WriteLine("{0} - {1}", wordText, wordTranslation);
}
Console.WriteLine(new string('*', 20));
Console.WriteLine("Please enter the word you are searching for:");
string searchedWord = Console.ReadLine();
var searchedWordResult = allWordsInDicitonary.FirstOrDefault(x => x.Elements.Single(e => e.Name == "word").Value.ToString() == searchedWord);
if (searchedWordResult != null)
{
Console.WriteLine("Your word translation is: {0}", searchedWordResult.Single(x => x.Name == "translation").Value.ToString());
}
else
{
Console.WriteLine("No such word in the dictionary");
}
}
protected void Submit_Click(object sender, EventArgs e)
{
const string udcErrorMethod = "Submit_Click";
BsonDocument bsonDoc = new BsonDocument();
clsUserInfo objMongoData;
try
{
string strUserName = txtUserName.Text.Trim();
string strPass = txtUserPass.Text.Trim();
if (!string.IsNullOrWhiteSpace(strUserName) && !string.IsNullOrWhiteSpace(strPass))
{
var userId = Query.EQ("_id", strUserName);
MongoCursor <BsonDocument> cursor = objMongo.bsonReadDocument(strCollectionName, userId);
if (cursor != null && cursor.Count() > 0)
{
bsonDoc = cursor.FirstOrDefault();
objMongoData = BsonSerializer.Deserialize <clsUserInfo>(bsonDoc.ToJson());
clsLog.blnLogDebug(udcErrorSource, udcErrorMethod, "User Data successfully fetched from mongo database", "", "", "", "");
if (strPass.Equals(objMongoData.Password.Trim()))
{
//ClientScript.RegisterClientScriptBlock(this.GetType(), "Successfully Saved", "<script language=javascript>alert('Successfully logged in!!!');</script>");
//Response.Redirect("/Web Forms/RoomLayout.aspx");
Session["username"] = objMongoData._id;
Server.Transfer("/Web Forms/RoomLayout.aspx");
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Invalid Password", "<script language=javascript>alert('Invalid password');</script>");
clsLog.blnLogError(udcErrorSource, udcErrorMethod, "User Password is not correct", "");
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Invalid User ID or Password", "<script language=javascript>alert('Invalid User ID or Password');</script>");
clsLog.blnLogError(udcErrorSource, udcErrorMethod, "UserData not received from Mongo database or | User does not exist", "");
}
}
}
catch (Exception ex)
{
clsLog.blnLogError(udcErrorSource, udcErrorMethod, "Exception catched in method blnValidateLogin !! ", " | Exception : " + ex.ToString());
}
}
public T Get(Expression <Func <T, bool> > filter, Dictionary <string, sbyte> sortByMap)
{
MongoCursor <T> cursor = null;
if (null != filter)
{
var findQuery = Query <T> .Where(filter);
cursor = this._mongoCollection.FindAs <T>(findQuery);
}
else
{
cursor = this._mongoCollection.FindAllAs <T>();
}
if (null != sortByMap)
{
var orderByQuery = new SortByDocument(sortByMap);
cursor = cursor.SetSortOrder(orderByQuery);
}
return(cursor.FirstOrDefault());
}