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