public void AssignUsersDataFilterValues(string[] userNames, List<DataFilterEntity> dataFilterEntities)
{
// Clear selected users data filter values
this.ClearUsersDataFilterValues(userNames);
// Assign users' data fiter values
if (dataFilterEntities != null && dataFilterEntities.Count > 0)
{
List<DataFilterEntity> userDataFilterEntities = new List<DataFilterEntity>();
foreach (string username in userNames)
{
foreach (DataFilterEntity dataFilterEntity in dataFilterEntities)
{
DataFilterEntity dataFilter = new DataFilterEntity();
dataFilter.UserDataFilterValueID = Guid.NewGuid().ToString();
dataFilter.UserName = username;
dataFilter.RoleName = dataFilterEntity.RoleName;
dataFilter.DataFilterID = dataFilterEntity.DataFilterID;
dataFilter.DataFilterValueID = dataFilterEntity.DataFilterValueID;
dataFilter.RecordStatus = DataFilterRecordStatus.New;
userDataFilterEntities.Add(dataFilter);
}
}
MappingUserDataFilterValues(userDataFilterEntities);
}
}
/// <summary>
/// Delete selected data filter value
/// </summary>
/// <param name="dataFilterEntity">dataFilterEntity</param>
private void DeleteDataFilterValue(DataFilterEntity dataFilterEntity)
{
if (CheckDataFilterEntity(dataFilterEntity))
{
//NOTE:No transaction id
DbHelper helper = new DbHelper();
DbCommand command = helper.BuildDbCommand("P_IC_USERS_DATA_FILTER_VALUES_DELETE");
helper.AssignParameterValues(
command,
Membership.ApplicationName,
dataFilterEntity.UserDataFilterValueID
);
Helper.ExecuteNonQuery(command);
}
}
/// <summary>
/// Determines whether [contains] [the specified input].
/// </summary>
/// <param name="input">The input.</param>
/// <param name="dataFiltersForCurrentUser">The data filters for current user.</param>
/// <returns>
/// <c>true</c> if [contains] [the specified input]; otherwise, <c>false</c>.
/// </returns>
private bool Contains(DataFilterEntity input, List<DataFilterEntity> dataFiltersForCurrentUser)
{
bool isContained = false;
foreach (DataFilterEntity udf in dataFiltersForCurrentUser)
{
if (udf.DataFilterID.Equals(input.DataFilterID)
&& (udf.DataFilterValueID.Equals(input.DataFilterValueID) || udf.DataFilterValueID.Equals("*")))
{
isContained = true;
break;
}
}
return isContained;
}
/// <summary>
/// Add selected data filter value
/// </summary>
/// <param name="dataFilterEntity">dataFilterEntity</param>
private void CreateDataFilterValue(DataFilterEntity dataFilterEntity)
{
if (CheckDataFilterEntity(dataFilterEntity))
{
string transactionid = NCS.IConnect.ApplicationContexts.ApplicationContextFactory.GetApplicationContext().TransactionId;
DbHelper helper = new DbHelper();
DbCommand command = helper.BuildDbCommand("P_IC_USERS_DATA_FILTER_VALUES_INSERT");
helper.AssignParameterValues(
command,
Membership.ApplicationName,
dataFilterEntity.UserDataFilterValueID,
dataFilterEntity.UserName,
dataFilterEntity.RoleName,
dataFilterEntity.DataFilterID,
dataFilterEntity.DataFilterValueID,
DateTime.Now,
transactionid,
AppContext.Current.UserName
);
Helper.ExecuteNonQuery(command);
}
}
public bool CheckDataFilterEntity(DataFilterEntity dataFilterEntity)
{
return (dataFilterEntity != null) &&
!String.IsNullOrEmpty(dataFilterEntity.UserDataFilterValueID) &&
!String.IsNullOrEmpty(dataFilterEntity.UserName) &&
!String.IsNullOrEmpty(dataFilterEntity.RoleName) &&
!String.IsNullOrEmpty(dataFilterEntity.DataFilterID) &&
!String.IsNullOrEmpty(dataFilterEntity.DataFilterValueID);
}