private static void DeleteEmployee(SwabhavDBContext swabhavDBContext)
{
Department department = swabhavDBContext.Departments.Where((d) => d.Id == new Guid("00000000-0000-0000-0000-000000000000")).Single();
Console.WriteLine(department.DName);
swabhavDBContext.Departments.Remove(department);
swabhavDBContext.SaveChanges();
}
private static void ParentToChild(SwabhavDBContext swabhavDBContext)
{
Department department = swabhavDBContext.Departments.Where((d) => d.Id == new Guid("00000000-0000-0000-0000-000000000000")).Single();
IEnumerable <Employee> myEmployees = department.Employees.Select((e) => e);
foreach (var employee in myEmployees)
{
Console.WriteLine("Employee Name: {0}", employee.EmpName);
}
}
private static void IEnumerAbleExample(SwabhavDBContext swabhavDBContext)
{
var employees = swabhavDBContext.Employees.ToList()
.Where((e) => e.EmpName.StartsWith("F"))
.Select((e) => new
{
FirstName = e.EmpName.Split(' ')[0],
EmpId = e.Id
});
foreach (var employee in employees)
{
Console.WriteLine("First Name: {0}\n EmpId: {1}", employee.FirstName, employee.EmpId);
}
}
static void Main(string[] args)
{
SwabhavDBContext swabhavDBContext = new SwabhavDBContext();
/*Department department = new Department();
* department.Employees = new List<Employee>();
* department.Employees.Add(new Employee { EmpName="Chandan",EmpJob="Developer",EmpMGR="None",EmpComm=0,EmpHireDate="25/11/2018",EmpSalary=20000});
* department.DName = "IT";
* department.Location = "SURAT";
* department.Description = "Hello IT Department";*/
//Department department = swabhavDBContext.Departments.Where((d) => d.Id == new Guid("3D099213-9BFA-4E31-A716-44E1E4540B01")).Single();
//Employee employee = new Employee { EmpName = "Foo Bar", EmpJob = "Manager", EmpMGR = "None", EmpComm = 0, EmpHireDate = "28/09/2018", EmpSalary = 2000,EmpDepartment=department};
//ChildToParent(swabhavDBContext);
IQueryAbleExample(swabhavDBContext);
IEnumerAbleExample(swabhavDBContext);
//swabhavDBContext.Employees.Add(employee);
//swabhavDBContext.SaveChanges();
}
private static void ChildToParent(SwabhavDBContext swabhavDBContext)
{
Employee employee = swabhavDBContext.Employees.Where((e) => e.Id == new Guid("CFB036F3-4966-48D8-A77E-94238B661732")).Single();
Console.WriteLine("Department Id: {0}\n Department Name: {1}", employee.EmpDepartment.Id, employee.EmpDepartment.DName);
}
