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