private static void DeleteEmployee(int empId)
{
var context = new TestDBEntities();
var emp = context.EmployeeDetails.SingleOrDefault(e => e.Emp_Id == empId);
context.EmployeeDetails.Remove(emp);
context.SaveChanges();
}
private static void UpdateEmployeeDetails(int empId, int mgrId, string name, string designation)
{
var context = new TestDBEntities();
var emp = context.EmployeeDetails.Find(empId);
emp.Emp_MgrId = mgrId;
emp.Emp_Name = name;
emp.Emp_Designation = designation;
context.SaveChanges();
}
private static void ReadData(string message)
{
var context = new TestDBEntities();
var empSal = (from det in context.EmployeeDetails
join
sal in context.Emp_Salary
on det.Emp_Id equals sal.Emp_Id
select new { det.Emp_Name, sal.Emp_Salary1 }).ToList();
foreach (var e in context.EmployeeDetails)
{
Console.WriteLine(message + " - Read " + e.Emp_Name + " : " + e.Emp_Designation);
}
}
private static void SaveEmployeeDetails(int empId, int mgrId, string name, string designation)
{
var context = new TestDBEntities();
var emp = new EmployeeDetail()
{
Emp_Id = empId,
Emp_MgrId = mgrId,
Emp_Name = name,
Emp_Designation = designation
};
context.EmployeeDetails.Add(emp);
context.SaveChanges();
}
static void Main(string[] args)
{
var context = new TestDBEntities();
SaveEmployeeDetails(101, 102, "Dipak Salve", "SR");
Console.WriteLine("After Create");
ReadData(string.Empty);
UpdateEmployeeDetails(101, 103, "Dipak Y Salve", "SR");
Console.WriteLine("After Update");
ReadData(string.Empty);
DeleteEmployee(101);
Console.WriteLine("After Delete");
ReadData(string.Empty);
var emp = (from empl in context.EmployeeDetails
group empl by empl.Emp_MgrId into grp_ems
where grp_ems.Count() > 1
select grp_ems);
//var emp = context.EmployeeDetails.
// GroupBy(item => item.Emp_MgrId).
// Where(group => group.Count() > 1).
// Select(group => group);
foreach (var groupItem in emp)
{
Console.WriteLine(groupItem.Key.HasValue ? groupItem.Key.Value : 0);
foreach (var e in groupItem)
{
Console.WriteLine(e.Emp_Name + " : " + e.Emp_Designation);
}
}
Console.ReadLine();
}