public static List <string> GetEmailAddressesOfAllUsers()
{
IDataContextFactory dataContextFactory = new DataContextFactory();
var allUsersEmailAddresses = dataContextFactory.CreateCommonDBContext().Query <User>().Select(user => user.EmailAddress).ToList();
return(allUsersEmailAddresses);
}
public static List <string> GetEmailAddressForRoles(int roleId)
{
IDataContextFactory dataContextFactory = new DataContextFactory();
var _commonDBContext = dataContextFactory.CreateCommonDBContext();
var allManagerUseId = _commonDBContext.Query <UtilityUserRoles>().Where(x => x.RoleId == roleId).Select(x => x.UserId).ToList(); //roleid for Reviewer=367
var manageremailAdddresses = new List <string>();
foreach (var id in allManagerUseId)
{
manageremailAdddresses.Add(_commonDBContext.Query <User>().Where(user => user.ID == id).SingleOrDefault().EmailAddress);
}
return(manageremailAdddresses);
}
//Silicus.UtilityContainerr.Entities.ICommonDataBaseContext _utilityCommonDbContext;
//public CommonMapper()
//{
// Silicus.UtilityContainerr.Entities.IDataContextFactory dataContextFactory = new Silicus.UtilityContainerr.Entities.DataContextFactory();
// _utilityCommonDbContext = dataContextFactory.CreateCommonDBContext();
//}
public ICommonDataBaseContext GetCommonDataBAseContext()
{
IDataContextFactory _dataContextFactory = new DataContextFactory();
return(_dataContextFactory.CreateCommonDBContext());
}
