public bool receiver_SignIn(int id) { try { BCAspenUser user = new BCAspenUser(); user.loadData(id); if ((Label1.Text = CredentialControl.Login(user.UserName, user.Password)) == "") { return true; } } catch (Exception ex) { Label1.Text = ex.Message; } return false; }
public virtual BCAspenUser GetLockHolder() { if (IdLockHolder == null) { return null; } else { BCAspenUser result = new BCAspenUser(); result.Id = (int)IdLockHolder; result.loadData(); return result; } }
/// <summary> /// Obtain exclusive hold of all PAs within the given PAList. /// If no PA is currently held by any other user, operation is successful and /// an empty list is returned. /// If there are users currently holding some PAs, operation is not successful and /// the list of users who are holding PAs is returned. /// </summary> /// <returns></returns> public List<BCAspenUser> HoldPAListExclusive(long idPAList) { //Hold all PAs within this PAlist string whereClause = " WHERE intIdPAList = @idPAList "; List<SqlParameter> pCol = new List<SqlParameter>(); SqlParameter param = new SqlParameter("@idPAList", SqlDbType.BigInt); param.Value = idPAList; pCol.Add(param); Hold(whereClause, pCol); //check if any PA remains held by others AdoNetManager db = new AdoNetManager("table"); db.objCmd.Parameters.Clear(); db.objCmd.Parameters.Add ("@idPAList", SqlDbType.BigInt).Value = idPAList; db.objCmd.Parameters.Add ("@paLockKey", SqlDbType.VarChar).Value = LockKey; DataTable tbl = db.queryTable( " SELECT DISTINCT intIdLockHolderPA FROM APAS_PaymentAdvice " + " WHERE strLockKeyPA IS NOT NULL " + " AND strLockKeyPA != '' " + " AND strLockKeyPA != @paLockKey " + " AND intIdPAList = @idPAList " ); List<BCAspenUser> result = new List<BCAspenUser>(); if (tbl != null && tbl.Rows.Count > 0) { //has PAs held by others //hold unsuccessful //Release PAs pCol = new List<SqlParameter>(); whereClause = " WHERE intIdPAList = @idPAList "; param = new SqlParameter("@idPAList", SqlDbType.BigInt); param.Value = idPAList; pCol.Add(param); Release(whereClause, pCol); foreach (DataRow row in tbl.Rows) { BCAspenUser objStaff = new BCAspenUser(); objStaff.Id = Convert.ToInt32(row["intIdLockHolderPA"]); objStaff.loadData(); result.Add(objStaff); } return result; } else { //has no PA held by others //hold successful return result; } }