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