public static YellowstonePathology.Business.Typing.TypingShortcutCollection GetTypingShortcutCollectionByUser(int userId)
{
YellowstonePathology.Business.Typing.TypingShortcutCollection result = new Typing.TypingShortcutCollection();
YellowstonePathology.Business.Mongo.Server transferServer = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection collection = transferServer.Database.GetCollection <BsonDocument>("TypingShortcut");
MongoCursor cursor = collection.FindAs <BsonDocument>(Query.EQ("UserId", BsonValue.Create(userId))).SetSortOrder(SortBy.Ascending("Shortcut"));
foreach (BsonDocument bsonDocument in cursor)
{
YellowstonePathology.Business.Typing.TypingShortcut typingShortcut = new YellowstonePathology.Business.Typing.TypingShortcut();
YellowstonePathology.Business.Mongo.BSONPropertyWriter.Write(bsonDocument, typingShortcut);
result.Add(typingShortcut);
}
return(result);
}
public TypingShortcutCollection GetWithMatchingText(string searchText)
{
TypingShortcutCollection result = new Typing.TypingShortcutCollection();
string upper = searchText.ToUpper();
foreach (TypingShortcut typingShortcut in this)
{
if (string.IsNullOrEmpty(typingShortcut.Text) == false)
{
string matchUpper = typingShortcut.Text.ToUpper();
if (matchUpper.Contains(upper))
{
result.Add(typingShortcut);
}
}
}
return(result);
}
public static YellowstonePathology.Business.Typing.TypingShortcutCollection GetTypingShortcutCollectionByUser(int userId)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * From tblTypingShortcut where UserId = @UserId or Type = 'Global' order by Shortcut";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
YellowstonePathology.Business.Typing.TypingShortcutCollection typingShorcutCollection = new Typing.TypingShortcutCollection();
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Typing.TypingShortcut typingShortcut = new Typing.TypingShortcut();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(typingShortcut, dr);
sqlDataReaderPropertyWriter.WriteProperties();
typingShorcutCollection.Add(typingShortcut);
}
}
}
return typingShorcutCollection;
}
