public string FindAkasseLederEmail(string afdeling) { BrugdataEntities brugdataDB = new BrugdataEntities(); string email = brugdataDB.tbl_Manager.Where(t => t.Company == afdeling && t.Department.StartsWith("A-kasse")).Select(t => t.E_Mail).ToList()[0]; return(email); }
public string FindLederEmail(string afdeling) { BrugdataEntities brugdataDB = new BrugdataEntities(); // Først prøver vi at finde personale-ansvarligs mail List <string> email = brugdataDB.tbl_Manager.Where(t => t.Company == afdeling && !(t.Department.StartsWith("A-kasse"))).Select(t => t.PersAnsvarligMail).ToList(); // Hvis der ikke findes en personale-ansvarlig tager vi bare lederens mail if (email[0] == null) { email = brugdataDB.tbl_Manager.Where(t => t.Company == afdeling && !(t.Department.StartsWith("A-kasse"))).Select(t => t.E_Mail).ToList(); } return(email[0]); }