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