public static String DeptHeadEmail(int DeptId)
{
using (StationeryStoreEntities1 context1 = new StationeryStoreEntities1())
{
StationeryStoreEntities context = new StationeryStoreEntities();
AspNetRole role = context.AspNetRoles.Where(c => c.Name == "Dept Head").FirstOrDefault();
string roleid = role.Id;
List <String> DHlists = context1.AspNetUserRoles.Where(c => c.RoleId == roleid).Select <AspNetUserRole, String>(y => y.UserId).ToList();
Employee emp = context.Employee.Where(x => x.DepartmentID == DeptId && DHlists.Contains(x.Id)).FirstOrDefault();
string email = emp.Email;
return(email);
}
}
public static List <String> ManagerEmail()
{
using (StationeryStoreEntities1 context1 = new StationeryStoreEntities1())
{
StationeryStoreEntities context = new StationeryStoreEntities();
AspNetRole role = context.AspNetRoles.Where(c => c.Name == "Store Manager").FirstOrDefault();
string roleid = role.Id;
List <String> list = context1.AspNetUserRoles.Where(c => c.RoleId == roleid).Select <AspNetUserRole, String>(y => y.UserId).ToList();
List <Employee> emp = context.Employee.Where(x => list.Contains(x.Id)).ToList();
List <String> email = new List <string>();
foreach (Employee e in emp)
{
email.Add(e.Email);
}
return(email);
}
}
