public int?GetAccountTypeIdFromAccountName(string accountName) { MyDbContext db = new MyDbContext(); return(db.AccountMappings.FirstOrDefault(a => a.Account.AccountName == accountName)?.AccountTypeId); }
public User GetUserFromUserName(string userName) { MyDbContext db = new MyDbContext(); return(db.Users.FirstOrDefault(u => u.UserName == userName)); }
public bool DoesItemExist <T>(T item) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); return(db.Set <T>().Any(i => i.ObjectId == item.ObjectId)); }
public bool DoesItemExist <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); return(db.Set <T>().Any(a => a.ObjectId == objectId)); }
public T GetItem <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); return(db.Set <T>().First(a => a.ObjectId == objectId)); }
public List <T> GetList <T>() where T : class { MyDbContext db = new MyDbContext(); return(db.Set <T>().ToList()); }
public string GetOption(string optionName) { MyDbContext db = new MyDbContext(); return(db.Options.FirstOrDefault(o => o.OptionKey == optionName)?.OptionValue); }