public new void DictionaryDelete(Dictionary entity)
{
//check permission: Admin
PrincipalPermission permAdm = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
base.DictionaryDelete(entity);
BusinessAuditEvent.Success(
new EventParameter("DictionaryID", entity.ID)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ContinuativeID", entity.ID));
TraceCallReturnEvent.Raise(false);
throw;
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Prepage Save action
/// </summary>
// -------------------------------------------------------------------------------------
private void SaveData()
{
IDictionaryService dictSrv = ServiceFactory.GetDictionaryService();
Dictionary dict;
if (m_bNewItem)
{
CurrentID = Guid.NewGuid();
dict = new Dictionary(CurrentID);
dict.IsActive = true;
dict.Word = txtWord.Text;
}
else
{
dict = dictSrv.DictionarySelect(CurrentID);
}
// Get control values
dict.English = txtEnglish.Text;
dict.Meaning = txtMeaning.Text;
dict.Professional = rbProfessional.Checked;
DictionaryAssocContainer assocs = new DictionaryAssocContainer();
foreach (Dictionary dic in m_data.Current)
{
assocs.Add(new DictionaryAssoc(CurrentID, dic.ID));
}
dict.Relations = assocs;
// Save data
if (m_bNewItem)
dictSrv.DictionaryInsert(dict);
else
dictSrv.DictionaryUpdate(dict);
}
/// <summary>
/// Add a ThesasurusRelation to the list.
/// </summary>
private void AddRelation()
{
if (txtRelatedWord.Text.Length == 0)
{
MessageBox.Show("A kapcsolódó szó nincs megadva. Adja meg a kapcsolódó szót a beviteli mezõben!",
"NDI HelpDesk Adminisztrátor", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtRelatedWord.Select();
return;
}
if (txtRelatedWord.Text == txtWord.Text)
{
MessageBox.Show("A kapcsolódó szó nem lehet önmaga. Adjon meg egy létezõ kapcsolódó szót a beviteli mezõben!",
"NDI HelpDesk Adminisztrátor", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtRelatedWord.Select();
return;
}
try
{
// Logical checks
string relatedWord = txtRelatedWord.Text;
IDictionaryService dictSrv = ServiceFactory.GetDictionaryService();
Dictionary filter = new Dictionary(Guid.NewGuid());
filter.Word = relatedWord;
DictionaryContainer dictcont = dictSrv.DictionarySelectFiltered(filter);
if (dictcont == null || dictcont.AllCount == 0)
{
MessageBox.Show("A kapcsolódó szó nem található. Adjon meg már létezõ kapcsolódó szót a beviteli mezõben!",
"NDI HelpDesk Adminisztrátor", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtRelatedWord.Select();
return;
}
DBGuid relatedWordID = ((Dictionary) dictcont.All[0]).ID;
//van már ilyen kapcsolat
if (m_data[relatedWordID.ToString()] != null)
{
MessageBox.Show(
"A kapcsolódó szó már hozzá van rendelve az alapszóhoz. Adjon meg másik kapcsolódó szót a beviteli mezõben!",
"NDI HelpDesk Adminisztrátor", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtRelatedWord.Select();
return;
}
// Add to container
m_data.Add(dictcont[0]);
// Refresh grid
FillDatagrid(CurrentID);
txtRelatedWord.Text = "";
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a kapcsolódó szó hozzáadása során.", ex);
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public Dictionary(Dictionary origInstance)
: base(origInstance)
{
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'nID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public Dictionary(DBGuid IDVal,
Dictionary origInstance)
: base(IDVal, origInstance)
{
}
public virtual void DictionaryUpdate(Dictionary entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
int count;
m_DataContext.ndihdDictionaryUpdate(entity.ID,
entity.Word,
entity.English,
entity.Meaning,
entity.Professional,
entity.IsActive, out count);
if (count == 0) throw new ServiceUpdateException();
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual Dictionary DictionarySelect(DBGuid IDVal)
{
TraceCallEnterEvent.Raise();
try
{
Dictionary result = null;
DataSet entitySet = m_DataContext.ndihdDictionarySelect(IDVal);
if (entitySet.Tables[0].Rows.Count != 0)
{
result = new Dictionary(entitySet);
}
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual void DictionaryInsert(Dictionary entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdDictionaryInsert(entity.ID,
entity.Word,
entity.English,
entity.Meaning,
entity.Professional,
entity.IsActive);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual void DictionaryDelete(Dictionary entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdDictionaryDelete(entity.ID);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
private void PopulateAbcList()
{
IDictionaryService srvDict = ServiceFactory.GetDictionaryService();
Ndi.HelpDesk.BusinessDocuments.Dictionary filter = new Ndi.HelpDesk.BusinessDocuments.Dictionary(Guid.Empty);
if (cmbType.SelectedIndex > 0)
{
if (cmbType.SelectedIndex == 1)
{
filter.FilterOnProfessional = 1;
}
else
{
filter.FilterOnProfessional = 0;
}
}
filter.FilterOnIsactive = 1;
DataSet ds = srvDict.DictionarySelectFirstLetter(filter);
pnlAbc.Controls.Clear();
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Literal lit = new Literal();
LinkButton lnk = new LinkButton();
lit.Text = " ";
lnk.Text = ds.Tables[0].Rows[i]["cFirstLetter"].ToString();
lnk.CommandArgument = lnk.Text;
lnk.Visible = true;
lnk.ID = lnk.Text;
lnk.AccessKey = lnk.Text;
pnlAbc.Controls.Add(lnk);
pnlAbc.Controls.Add(lit);
}
}
else //Nincs találat
{
Literal lit = new Literal();
lit.Text = "Nincs találat";
pnlAbc.Controls.Add(lit);
}
}
else //Nincs találat
{
Literal lit = new Literal();
lit.Text = "Nincs találat";
pnlAbc.Controls.Add(lit);
}
}
private DictionaryContainer GetFilteredList()
{
#region lekérdezzük a DictinaryContainer -t (a szûrési feltételeknek megfelelõen)
IDictionaryService srvDict = ServiceFactory.GetDictionaryService();
Ndi.HelpDesk.BusinessDocuments.Dictionary filter = new Ndi.HelpDesk.BusinessDocuments.Dictionary(Guid.Empty);
string sortAbc;
sortAbc = Request["__EVENTTARGET"];
if (sortAbc != null)
{
if (sortAbc.Length == 1)
{
txtWord.Text = sortAbc + "*";
}
}
filter.Word = txtWord.Text;
if (cmbType.SelectedIndex > 0)
{
if (cmbType.SelectedIndex == 1)
{
filter.FilterOnProfessional = 1;
}
else
{
filter.FilterOnProfessional = 0;
}
}
filter.FilterOnIsactive = 1;
DictionaryContainer selected = srvDict.DictionarySelectFiltered(filter);
return selected;
#endregion
}
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order)
{
dataGrid.PageSize = GetCurrentPageSize();
IDictionaryService srvDict = ServiceFactory.GetDictionaryService();
Ndi.HelpDesk.BusinessDocuments.Dictionary filter = new Ndi.HelpDesk.BusinessDocuments.Dictionary(Guid.Empty);
string sortAbc;
sortAbc = Request["__EVENTTARGET"];
#region : ABC szûrés :
if (sortAbc != null)
{
sortAbc = sortAbc.Replace("ctl00$bodycontent$", "");
if (sortAbc.Length == 1)
{
txtWord.Text = sortAbc + "*";
index = 0;
}
}
#endregion
#region : Kiválasztott szó részletei :
if (sortAbc != null)
{
if ((sortAbc.IndexOf("lnkRefWord") > -1) || (sortAbc.IndexOf("lnkDictionaryWordDetails") > -1))
{
index = dataGrid.CurrentPageIndex;
if (sortAbc.IndexOf('#') > 0)
{
string id = sortAbc.Split('#')[1];
Guid currentID = new Guid(id);
ShowDetails(currentID);
}
}
}
#endregion
bool isNormalFilter = sortAbc == null ||
(sortAbc != null && (sortAbc.Length == 0 || sortAbc.Length > 1) &&
sortAbc.IndexOf("lnkRefWord") < 0 && sortAbc.IndexOf("lnkDictionaryWordDetails") < 0);
filter.Word = isNormalFilter ? Helpers.CreateLikeSearchText(txtWord.Text) : txtWord.Text;
filter.English = isNormalFilter ? Helpers.CreateLikeSearchText(txtEnglish.Text) : txtEnglish.Text;
if (cmbType.SelectedIndex > 0)
{
if (cmbType.SelectedIndex == 1)
{
filter.FilterOnProfessional = 1;
}
else
{
filter.FilterOnProfessional = 0;
}
}
filter.FilterOnIsactive = 1;
DictionaryContainer selected = srvDict.DictionarySelectFiltered(filter);
if (selected.All.Count == 0)
{
dataGrid.Visible = false;
lblNotFound.Visible = true;
}
else
{
dataGrid.Visible = true;
lblNotFound.Visible = false;
}
ArrayList sortableList;
// Sort if necessary
if (sort == null)
{
sortableList = selected.All.Items;
}
else
{
if (String.Compare(order, "Ascending", true) == 0)
{
sortableList = selected.All.SortBy(sort, true);
}
else if (String.Compare(order, "Descending", true) == 0)
{
sortableList = selected.All.SortBy(sort, false);
}
else
{
sortableList = selected.All.SortBy(sort);
}
}
// Bind list to datagrid control
dataGrid.CurrentPageIndex = index;
if (sort != null)
{
dataGrid.CurrentSortExpression = sort;
}
if (order != null)
{
dataGrid.CurrentSortOrder = order;
}
dataGrid.DataSource = sortableList;
dataGrid.DataBind();
}
public new void DictionaryInsert(Dictionary entity)
{
//check permission: Admin
PrincipalPermission permAdm = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permAdm.Demand();
DictionaryAssocService srv = new DictionaryAssocService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
// Thesaurus
base.DictionaryInsert(entity);
// ThesaurusRelations - delete and insert
m_DataContext.ndihdWordOfDictionaryDeleteBy(entity.ID);
foreach (DictionaryAssoc rel in entity.Relations.Current)
{
srv.DictionaryAssocInsert(rel);
}
m_DataContext.CommitNested();
BusinessAuditEvent.Success(
new EventParameter("DictionaryID", entity.ID)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("DictionaryID", entity.ID));
TraceCallReturnEvent.Raise(false);
throw;
}
}
public DataSet DictionarySelectFirstLetter(Dictionary filter)
{
TraceCallEnterEvent.Raise();
try
{
DataSet entitySet =
m_DataContext.ndihdDictionarySelectFirstLetter(filter.Word, filter.FilterOnProfessional,
filter.FilterOnIsactive);
TraceCallReturnEvent.Raise();
return entitySet;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public DictionaryContainer DictionarySelectFiltered(Dictionary filter)
{
TraceCallEnterEvent.Raise();
try
{
DictionaryContainer result;
DataSet entitySet =
m_DataContext.ndihdDictionarySelectFiltered(filter.Word, filter.English, filter.FilterOnProfessional,
filter.FilterOnIsactive);
result = new DictionaryContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
/// <summary>
/// Fill datagrid with data
/// </summary>
private void FillDatagrid(DBGuid ID)
{
try
{
string sSortColumn = "Word";
int nSelectedRow = -1;
// Storing the previous sort order
if (dtgMain.DataSource != null)
{
sSortColumn = ((DataTable) dtgMain.DataSource).DefaultView.Sort;
}
// Set filter
Dictionary filter = new Dictionary(ID);
if (txtWord.Text.Length > 0)
{
filter.Word = txtWord.Text;
}
filter.FilterOnIsactive = DBInt.Null;
if (cmbStatus.SelectedIndex > 0)
{
bool bIsActive = (cmbStatus.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnIsactive = Convert.ToInt32(bIsActive);
filter.IsActive = bIsActive;
}
filter.FilterOnProfessional = DBInt.Null;
if (cmbProfessional.SelectedIndex > 0)
{
bool bProfessional = (cmbProfessional.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnProfessional = Convert.ToInt32(bProfessional);
filter.IsActive = bProfessional;
}
// Retrieving data from BusinessServices
IDictionaryService srv = ServiceFactory.GetDictionaryService();
DictionaryContainer allData = srv.DictionarySelectFiltered(filter);
DataTable dt = allData.AllAsDatatable;
dt.DefaultView.Sort = sSortColumn;
dtgMain.DataSource = dt;
// Locates the row specified by ID param
if (!ID.IsNull)
{
BindingManagerBase bm = dtgMain.BindingContext[dtgMain.DataSource, dtgMain.DataMember];
DataRow dr;
for (int i = 0; i < bm.Count; i++)
{
dr = ((DataRowView) bm.Current).Row;
if (ID.Value.Equals(dr["Word"]))
{
nSelectedRow = i;
break;
}
bm.Position += 1;
}
}
// Makes the row selected
if (nSelectedRow <= ((DataTable) dtgMain.DataSource).DefaultView.Count && nSelectedRow > -1)
{
dtgMain.Select(nSelectedRow);
dtgMain.CurrentRowIndex = nSelectedRow;
}
else if (((DataTable) dtgMain.DataSource).DefaultView.Count != 0)
{
dtgMain.Select(0);
}
// Enabling or disabling the buttons according to record count.
// And is because of previous disable state.
bool bIsEmptyGrid = (((DataTable) dtgMain.DataSource).DefaultView.Count == 0);
tbbModify.Enabled = ! bIsEmptyGrid;
tbbInactivate.Enabled = ! bIsEmptyGrid;
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a lista frissítése során.", ex);
}
}