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