/// <summary>
/// Creates a Region object and inserts it into the DB
/// </summary>
/// <param name="regionId"></param>
/// <param name="parentId"></param>
/// <param name="name"></param>
public static void InsertRegion(int regionId, int parentId, string name)
{
var region = new Region
{
Name = name,
RegionId = regionId,
ParentRegionId = parentId
};
using (var context = new RegionsEmployeesContext())
{
context.Regions.Add(region);
context.SaveChanges();
}
}
/// <summary>
/// Creates an Employee object and inserts it into the database
/// </summary>
/// <param name="regionId"></param>
/// <param name="name"></param>
/// <param name="surname"></param>
public static void InsertEmployee(int regionId, string name, string surname)
{
var employee = new Employee
{
Name = name,
Surname = surname,
Region = GetRegion(regionId)
};
using (var context = new RegionsEmployeesContext())
{
context.Employees.Add(employee);
context.Regions.Attach(employee.Region);
context.SaveChanges();
}
}