/// <summary> /// Read in all apartments /// </summary> /// <returns></returns> public IEnumerable <Departments1> ReadInDepartments() { var getCx = from cx in ADC.Departments select MapDepartments.Map(cx); return(getCx); }
/// <summary> /// Create new Department /// </summary> /// <param name="Departments"></param> public void CreateDepartment(Departments1 Departments) { if (ADC.Departments.Any(d => d.DEPT_NAME == Departments.DEPT_NAME)) { Console.WriteLine($"This Department {Departments.DEPT_NAME} already exists and cannot be added"); return; } else { ADC.Departments.Add(MapDepartments.Map(Departments)); // this will generate insertMapper.Map(Departments) } ADC.SaveChanges(); // this will execute the above generate insert query }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public Departments1 ReadInDepartment(int id) { var getCx = ADC.Departments.FirstOrDefault(e => e.ID == id); return(MapDepartments.Map(getCx)); }