public UsersRowChangeEvent(UserData.UsersRow row, DataRowAction action) { this.eventRow = row; this.eventAction = action; }
public void RemoveUsersRow(UserData.UsersRow row) { base.Rows.Remove(row); }
/// <summary> /// Retrieves all users from the database by filter /// </summary> public UserData GetAllUsersListByFilter(string UserName = null, string FirstName = null, string LastName = null, string Email = null, int ?Admin = null) { UserData dataSet = new UserData(); //SqlParameter[] commandParameters = new SqlParameter[] { // new SqlParameter("@UserName", UserName), // new SqlParameter("@FirstName", FirstName), // new SqlParameter("@LastName", LastName), // new SqlParameter("@Email", Email), // new SqlParameter("@Administrator", Admin), //}; ArrayList commandParameters = new ArrayList(); { commandParameters.Add(new SqlParameter("@UserName", UserName).SqlValue); commandParameters.Add(new SqlParameter("@FirstName", FirstName).SqlValue); commandParameters.Add(new SqlParameter("@LastName", LastName).SqlValue); commandParameters.Add(new SqlParameter("@Email", Email).SqlValue); commandParameters.Add(new SqlParameter("@Administrator", Admin).SqlValue); } DbConnection.db.LoadDataSet("vts_spUserGetListByFilter", dataSet, new string[] { "Users" }, commandParameters.ToArray()); return dataSet; }
public void AddUsersRow(UserData.UsersRow row) { base.Rows.Add(row); }
/// <summary> /// Retrieves all users from the database /// </summary> public UserData GetAllUsersList() { UserData dataSet = new UserData(); DbConnection.db.LoadDataSet("vts_spUserGetList", dataSet, new string[] { "Users" }); return dataSet; }