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);
}
public bool IsUserApprover(int uid, int wonum, string proj)
{
bool lb_rtn = Convert.ToBoolean(RolesAdapter.IsUserApprover(uid, proj, wonum));
return(lb_rtn);
}
public int IsUserPMorUp(int uid)
{
int rowsAffected = (int)RolesAdapter.IsUserPMorUp(uid);
return(rowsAffected);
}
public int GetMaxRolesIndex()
{
int rowsAffected = (int)RolesAdapter.MaxRoleIndexNum();
return(rowsAffected);
}
public int DeleteWOparticipant(int Original_worl_index)
{
int rowsAffected = (int)RolesAdapter.DeleteWOparticipant(Original_worl_index);
return(rowsAffected);
}
public int GetUIDcount(int uid, int wonum, string proj)
{
int rowsAffected = (int)RolesAdapter.GetUIDcountForWO(uid, wonum, proj);
return(rowsAffected);
}
