private static void delete() { Console.WriteLine("enter id"); int i = int.Parse(Console.ReadLine()); Employecontext e = new Employecontext(); var del = e.Employees.Find(i); e.Employees.Remove(del); e.SaveChanges(); }
private static void showdata() { Employecontext emp = new Employecontext(); //var emp1 = from e in empctx.Employees; var employees = emp.Employees; foreach (var ep in employees) { Console.WriteLine("{0}\t{1}\t{2}\t{3}", ep.Eid, ep.Ename, ep.Designation, ep.salary); } }
private static void search() { Console.WriteLine("enter id"); int id = int.Parse(Console.ReadLine()); Employecontext empctx = new Employecontext(); //var emp1 = from e in empctx.Employees; var employees = from d in empctx.Employees where d.Eid == id select d; foreach (var res in employees) { Console.WriteLine("{0}\t{1}\t{2}\t{3}\t", res.Eid, res.Ename, res.Designation, res.salary); } }
private static void update() { Console.WriteLine("enter id"); int eid = int.Parse(Console.ReadLine()); Console.WriteLine("enter designation"); string desg = Console.ReadLine(); Employecontext empctx = new Employecontext(); //var emp1 = from e in empctx.Employees; var employees = from d in empctx.Employees where d.Eid == eid select d; foreach (var d in employees) { d.Designation = desg; } empctx.SaveChanges(); }
private static void insertdata() { Employecontext ect = new Employecontext(); Console.WriteLine("enter Employe id"); int eid = int.Parse(Console.ReadLine()); Console.WriteLine("enter Employee name"); string name = Console.ReadLine(); Console.WriteLine("enter Employee Designation"); string Desg = Console.ReadLine(); Console.WriteLine("enter salary"); double sal = Convert.ToDouble(Console.ReadLine()); ect.Employees.Add(new Employe { Eid = eid, Ename = name, Designation = Desg, salary = sal }); Console.ReadKey(); ect.SaveChanges(); }