public Boolean AddDepartment(Department_Master department)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
db.Department_Master.Add(department);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("deparment add error" + ex.InnerException);
}
return(status);
}
public Boolean updateDepartment(Department_Master department)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
Console.WriteLine("Department updated");
db.Department_Master.AddOrUpdate(department);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Update Department problem " + ex.InnerException);
}
return(status);
}
public Boolean deleteDepartmentbyId(int id)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
Department_Master department = db.Department_Master.First(b => b.Department_ID == id);
db.Department_Master.Remove(department);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("delete department error " + ex.InnerException);
}
return(status);
}
