public bool InsertWOroles(int worl_WOnum, int worl_uid, string worl_proj, string worl_role, bool worl_aprvl, bool worl_email)
{
WorkOrder.WOroleDataTable RolesDT = new WorkOrder.WOroleDataTable();
WorkOrder.WOroleRow roleRow = RolesDT.NewWOroleRow();
int indexnum = Convert.ToInt32(RolesAdapter.MaxRoleIndexNum());
if (indexnum == null)
{
indexnum = 1;
}
else
{
indexnum++;
}
roleRow.worl_index = indexnum;
roleRow.worl_WOnum = worl_WOnum;
roleRow.worl_proj = worl_proj;
roleRow.worl_uid = worl_uid;
roleRow.worl_role = worl_role;
roleRow.worl_aprvl = Convert.ToBoolean(worl_aprvl);
roleRow.worl_email = Convert.ToBoolean(worl_email);
RolesDT.AddWOroleRow(roleRow);
int rowsAffected = RolesAdapter.Update(RolesDT);
return(rowsAffected == 1);
}
public bool UpdateRoles(int worl_WOnum, string worl_proj, int worl_uid, string worl_role, bool worl_aprvl, int Original_worl_index, bool worl_email)
{
int worl_index = Original_worl_index;
WorkOrder.WOroleDataTable roles = RolesAdapter.GetRoleByIndexNum(Original_worl_index);
WorkOrder.WOroleRow roleRow = roles[0];
int rowsAffected = RolesAdapter.UpdateRoles(worl_index, roleRow.worl_WOnum, roleRow.worl_proj, roleRow.worl_uid, roleRow.worl_role, worl_aprvl, worl_email, Original_worl_index);
return(rowsAffected == 1);
}
