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); }