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();
}
