// Data Source -- delete Employee
public bool DSdeleteEmployee(int id)
{
try
{
// set adapter
pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter();
eta = new canoeDataSetTableAdapters.Canoe_EmployeeTableAdapter();
// delete
eta.DeleteEmployeeQuery(id);
pta.DeletePersonQuery(id);
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSdeleteEmployee", ex.Message);
}
}
// Data Source -- insert Employee
public bool DSinsertEmployee(Employee employee)
{
try
{
// set adapter
pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter();
// insert
// storedProcedure execute
pta.CanoeInsertEmployee(
0,
employee.Name,
employee.Address,
employee.Telephone_Number,
0,
employee.OfficeAddress,
employee.PhoneExtNo,
employee.UserName,
employee.Password,
employee.Role
);
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSinsertEmployee", ex.Message);
}
}
// Data Source -- update Employee
public bool DSupdateEmployee(Employee employee)
{
try
{
// set adapter
pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter();
eta = new canoeDataSetTableAdapters.Canoe_EmployeeTableAdapter();
// update
pta.UpdatePersonQuery(
employee.Name,
employee.Address,
employee.Telephone_Number,
employee.ID
);
eta.UpdateEmployeeQuery(
employee.OfficeAddress,
employee.PhoneExtNo,
employee.UserName,
employee.Password,
employee.Role,
employee.EID
);
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSupdateEmployee", ex.Message);
}
}
// Data Source -- search Employee
public DataTable DSsearchEmployee(string id, string name, string role)
{
try
{
// set adapter
pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter();
pdt = new canoeDataSet.Canoe_PersonDataTable();
// select
if (id.Length > 0)
{
pta.FillEmployeeByID(pdt, int.Parse(id));
}
else if (name.Length > 0)
{
pta.FillEmployeeByName(pdt, name);
}
else if (role.Length > 0)
{
pta.FillEmployeeByRole(pdt, role);
}
else
{
pta.FillEmployeeByNone(pdt);
}
return pdt;
}
catch (Exception ex)
{
throw new CanoeException("DSsearchEmployee", ex.Message);
}
}
