public int DeleteEmp(int empid)
{
EmployeeEntities1 empdb = new EmployeeEntities1();
EmployeeDetail empdtl = new EmployeeDetail();
empdtl.EmpId = empid;
empdb.Entry(empdtl).State = System.Data.Entity.EntityState.Deleted;
int r = empdb.SaveChanges();
return(r);
}
public EmployeeDetail RetreiveEmployeeByID(int id)
{
var employee = context.EmployeeDetails.Find(id);
var result = new EmployeeDetail();
if (employee != null)
{
result.Id = employee.Id;
result.Name = employee.Name;
result.Designation = employee.Designation;
}
return(result);
}
public List <EmployeeDetail> UpdateEmployee(EmployeeDetail employee)
{
var worker = context.EmployeeDetails.Find(employee.Id);
if (worker != null)
{
worker.Name = employee.Name;
worker.Designation = employee.Designation;
context.SaveChanges();
}
var employeesList = context.EmployeeDetails.ToList();
return(employeesList);
}
public int UpdateEmp(Employee e)
{
EmployeeEntities1 empdb = new EmployeeEntities1();
EmployeeDetail empdtl = new EmployeeDetail();
empdtl.EmpId = e.empId;
empdtl.EmpName = e.empName;
empdtl.EmpMail = e.empMail;
empdtl.EmpPhone = e.empPhone;
empdb.Entry(empdtl).State = System.Data.Entity.EntityState.Modified;
int r = empdb.SaveChanges();
return(r);
}
public int AddEmp(Employee emp)
{
EmployeeEntities1 empdb = new EmployeeEntities1();
EmployeeDetail empdtl = new EmployeeDetail();
empdtl.EmpId = emp.empId;
empdtl.EmpName = emp.empName;
empdtl.EmpMail = emp.empMail;
empdtl.EmpPhone = emp.empPhone;
empdb.EmployeeDetails.Add(empdtl);
int r = empdb.SaveChanges();
return(r);
}
public EmployeeDetail GetAllUserById(int empId)
{
EmployeeEntities1 empdb = new EmployeeEntities1();
var emplst = from e in empdb.EmployeeDetails where e.EmpId == empId select e;
EmployeeDetail employee = new EmployeeDetail();
foreach (var item in emplst)
{
employee.EmpId = item.EmpId;
employee.EmpName = item.EmpName;
employee.EmpMail = item.EmpMail;
employee.EmpPhone = item.EmpPhone;
}
return(employee);
}
public string AddEmployee(EmployeeDetail employee)
{
var employeesList = context.EmployeeDetails.ToList();
if (employeesList != null && employeesList.Count != 0)
{
employee.Id = employeesList[employeesList.Count - 1].Id + 1;
}
else
{
employee.Id = 1;
}
context.EmployeeDetails.Add(employee);
context.SaveChanges();
return("success");
}
public List <EmployeeDetail> GetAllEmp()
{
List <EmployeeDetail> emplist = new List <EmployeeDetail>();
EmployeeEntities1 empdb = new EmployeeEntities1();
var emplst = from e in empdb.EmployeeDetails select e;
foreach (var item in emplst)
{
EmployeeDetail em = new EmployeeDetail();
em.EmpId = item.EmpId;
em.EmpName = item.EmpName;
em.EmpMail = item.EmpMail;
em.EmpPhone = item.EmpPhone;
emplist.Add(em);
}
return(emplist);
}