static void ListDepartments()
{
HRDataContext ctx = new HRDataContext();
ctx.Log = Console.Out;
// var depts = ctx.Departments.Where(dept => dept.DepartmentName.Length > 5);
var depts = from dept in ctx.Departments
// where dept.DepartmentName.Length <= 5
orderby dept.DepartmentName
select dept;
foreach (Department dept in depts)
{
Console.WriteLine("{0} - {1}", dept.DepartmentId, dept.DepartmentName);
}
}
private static void AddDepartment()
{
HRDataContext ctx = new HRDataContext();
ctx.Log = Console.Out;
Department dept = new Department {
DepartmentId = 50,
DepartmentName = "Sports"
};
ctx.Departments.InsertOnSubmit(dept);
Console.ReadLine();
ctx.SubmitChanges();
Console.WriteLine("Added Dept!");
}
private static void DeleteDepartment()
{
HRDataContext ctx = new HRDataContext();
ctx.Log = Console.Out;
var dept = (from d in ctx.Departments
where d.DepartmentId == 100
select d).SingleOrDefault();
if (dept == null)
{
Console.WriteLine("Sorry! Department not found!");
}
else
{
ctx.Departments.DeleteOnSubmit(dept);
ctx.SubmitChanges();
Console.WriteLine("Deleted Successfully!");
}
}
private static void UpdateDepartment()
{
HRDataContext ctx = new HRDataContext();
ctx.Log = Console.Out;
//var dept = (from d in ctx.Departments
// where d.DepartmentId == 50
// select d).SingleOrDefault();
var dept = ctx.Departments.Where(d => d.DepartmentId == 50).SingleOrDefault();
if (dept == null)
{
Console.WriteLine("Sorry! Department not found!");
}
else
{
dept.DepartmentName = "Sports & Fitness";
ctx.SubmitChanges();
Console.WriteLine("Updated Successfully!");
}
}
