private Privs(Datamodel.UserPrivs p) { canPromote = p.canPromote; canCertify = p.canCertify; canAssign = p.canAssign; canStartOps = p.canStartOps; isFleetAdmin = p.isFleetAdmin; }
/// <summary> /// Gets the privilege set for a user /// </summary> /// <param name="userId"></param> /// <returns></returns> public static Privs FetchByUser(int userId) { Datamodel.UserPrivs p = null; if (Datamodel.UserPrivs.FetchByUser(ref p, userId)) { return(new Privs(p)); } else { return(null); } }
/// <summary> /// </summary> /// <param name="output"></param> /// <param name="user"></param> /// <returns></returns> public static bool FetchByUser(ref UserPrivs output, int user) { SQLiteDataReader reader = DBI.DoPreparedQuery( "SELECT * FROM UserPrivs WHERE user=@user;", new Tuple <string, object>("@user", user)); if (reader != null && reader.Read()) { output = UserPrivs.Factory(reader); return(true); } return(false); }
public static UserPrivs Factory(int user, bool canPromote, bool canCertify, bool canAssign, bool canStartOps, bool isFleetAdmin) { UserPrivs result = new UserPrivs( user: user, canPromote: canPromote, canCertify: canCertify, canAssign: canAssign, canStartOps: canStartOps, isFleetAdmin: isFleetAdmin ); return(result); }
/// <summary> /// Creates a new set of privileges for a user /// </summary> /// <param name="output"></param> /// <param name="user"></param> /// <param name="canPromote"></param> /// <param name="canCertify"></param> /// <param name="canAssign"></param> /// <param name="canStartOps"></param> /// <param name="isFleetAdmin"></param> /// <returns></returns> public static bool Create(ref UserPrivs output, int user, bool canPromote, bool canCertify, bool canAssign, bool canStartOps, bool isFleetAdmin) { int result = DBI.DoPreparedAction( @"INSERT INTO UserPrivs (user, canPromote, canCertify, canAssign, canStartOps, isFleetAdmin) VALUES (@user, @promote, @cert, @assign, @ops, @fleetad);" , new Tuple <string, object>("@user", user), new Tuple <string, object>("@promote", canPromote), new Tuple <string, object>("@cert", canCertify), new Tuple <string, object>("@assign", canAssign), new Tuple <string, object>("@ops", canStartOps), new Tuple <string, object>("@fleetad", isFleetAdmin)); if (result == 1) { return(UserPrivs.FetchByUser(ref output, user)); } return(false); }