public static string GetDisplayName(string type, string code)
{
using (var db = new LMSEntitys())
{
var obj = db.Dictionarys.Where(o => o.Type == type && o.Code == code);
return(obj.FirstOrDefault().DisplayName);
}
}
public static LMSEntitys GetCurrentContext()
{
LMSEntitys _dbContext = CallContext.GetData("LibraryManageSys") as LMSEntitys;
if (_dbContext == null)
{
_dbContext = new LMSEntitys();
CallContext.SetData("LibraryManageSys", _dbContext);
}
return(_dbContext);
}
public void TestFindUserById()
{
int id = 1;
// LMSEntitys db = ContextFactory.GetCurrentContext();
LMSEntitys db = new LMSEntitys();
//var user = db.users.Where(u => u.userId == id);
var user = db.users.Where(u => u.UserId == id);
foreach (var u in user)
{
Console.Out.WriteLine(u.UserName + u.UserId + u.Password);
}
}
public static List <SelectListItem> getBookTypeItems()
{
List <SelectListItem> items = new List <SelectListItem>();
using (var db = new LMSEntitys())
{
foreach (var item in db.Dictionarys.Where(o => o.Type == "BookType"))
{
items.Add(new SelectListItem {
Text = item.DisplayName, Value = item.Code
});
}
items[0].Selected = true;
return(items);
}
}
