public bool deleteEmployees(int EmployeeId)
{
using (var dbcontext = new HRDBContext())
{
try
{
var itemToRemove = dbcontext.tblEmployees.SingleOrDefault(x => x.Emp_EmployeeId == EmployeeId);
if (itemToRemove != null)
{
dbcontext.tblEmployees.Remove(itemToRemove);
dbcontext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
}
public bool insertEmployees(tblEmployee objEmployee)
{
using (var dbcontext = new HRDBContext())
{
try
{
dbcontext.tblEmployees.Add(objEmployee);
dbcontext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool insertDepartments(tblDepartment objDepartment)
{
using (var dbcontext = new HRDBContext())
{
try
{
dbcontext.tblDepartments.Add(objDepartment);
dbcontext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool updateEmployees(tblEmployee objEmployee, int EmployeeId)
{
using (var dbcontext = new HRDBContext())
{
try
{
dbcontext.tblEmployees.Add(objEmployee);
dbcontext.Entry(objEmployee).State = System.Data.Entity.EntityState.Modified;
dbcontext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
