private void CallUpdateUserFilter(RequestType ARequestType, int AFilterId, string ADescr,
string AFilterExpr)
{
try
{
UserFiltersOpsmgrDal userFiltersDal = new UserFiltersOpsmgrDal(sqlConnectionStr);
UserFiltersOpsmgrDto filterData = new UserFiltersOpsmgrDto();
filterData.Id = AFilterId;
filterData.UserId = p_UserId;
filterData.Descr = ADescr;
filterData.FilterExpr = AFilterExpr;
switch (ARequestType)
{
case RequestType.Insert:
{
Int32 newId = userFiltersDal.Insert(filterData);
if (newId > 0)
{
DataRow row = userFiltersView.NewRow();
row["Id"] = newId;
row["Descr"] = filterData.Descr;
row["FilterExpr"] = filterData.FilterExpr;
userFiltersView.Rows.Add(row);
luedUserFilter.EditValue = newId;
}
break;
}
case RequestType.Update:
{
Int32 rowsUpdated = userFiltersDal.Update(filterData);
if (rowsUpdated > 0)
{
DataRow row = userFiltersView.Rows.Find(filterData.Id);
row["Descr"] = filterData.Descr;
row["FilterExpr"] = filterData.FilterExpr;
userFiltersView.AcceptChanges();
}
break;
}
case RequestType.Delete:
{
Int32 rowsDeleted = userFiltersDal.Delete(filterData.Id);
if (rowsDeleted > 0)
{
DataRow row = userFiltersView.Rows.Find(filterData.Id);
row.Delete();
userFiltersView.AcceptChanges();
}
break;
}
}
}
catch (Exception ex)
{
throw new Exception("An error occurred while updating the User Filter data used internally by " + APP_NAME + "." + Environment.NewLine +
"Error CNF-059 in " + FORM_NAME + ".CallUpdateUserFilter(): " + ex.Message);
}
}
private void CallGetUserFilters()
{
try
{
UserFiltersOpsmgrDal userFiltersDal = new UserFiltersOpsmgrDal(sqlConnectionStr);
IList<UserFiltersOpsmgrDto> userFilterList;
//if (isTestMode)
// userFilterList = userFiltersDal.GetAllStub();
//else
userFilterList = userFiltersDal.GetAll(p_UserId);
if (userFilterList != null)
for (int i = 0; i < userFilterList.Count; i++)
{
DataRow row = userFiltersView.NewRow();
row["Id"] = userFilterList[i].Id;
row["Descr"] = userFilterList[i].Descr;
row["FilterExpr"] = userFilterList[i].FilterExpr;
userFiltersView.Rows.Add(row);
}
}
catch (Exception ex)
{
throw new Exception("An error occurred while populating the User Filter data used internally by " + APP_NAME + "." + Environment.NewLine +
"Error CNF-058 in " + FORM_NAME + ".CallGetUserFilters(): " + ex.Message);
}
}