public bool Update(Department department)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand command = db.GetStoredProcCommand("usp_DepartmentUpdate");
db.AddInParameter(command, "@DepartmentId", DbType.Int32, department.DepartmentId);
db.AddInParameter(command, "@CompanyId", DbType.Int32, department.CompanyId);
db.AddInParameter(command, "@DepartmentName", DbType.String, department.DepartmentName);
db.AddInParameter(command, "@UpdatedBy", DbType.Int32, department.UpdatedBy);
db.AddInParameter(command, "@UpdatedDate", DbType.DateTime, department.UpdatedDate);
db.ExecuteNonQuery(command);
return true;
}