private void btnDocumentsFiletypes_Click(object sender, EventArgs e)
{
FiletypesForm NewFiletypesForm = new FiletypesForm();
string sql = "select DISTINCT(Filetype) from Documents (nolock) where Location <> dbo.OwnLocation() and [DOCUMENT] is not null";
{
var withBlock = NewFiletypesForm.clbFiletypes;
withBlock.Items.Clear();
var ds = mssql.SQLSelect(sql, con);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow value in ds.Tables[0].Rows)
{
withBlock.Items.Add(value.ItemArray[0]);
}
}
foreach (string value in DocumentFiletypes)
{
for (var i = 0; i <= withBlock.Items.Count - 1; i++)
{
if (withBlock.Items[i].Equals(value))
{
withBlock.SetItemChecked(i, true);
}
}
}
if (withBlock.Items.Count == 0)
{
MessageBox.Show("Es wurden keine Dateiendung in der Datenbank gefunden. Die Option wird jetzt autoamtisch deaktivert.");
btnDocumentsFiletypes.Enabled = false;
chkDocumentsFiletypes.Checked = false;
}
else
if (DocumentFiletypes.Count == 0)
{
for (int i = 0; i <= withBlock.Items.Count - 1; i++)
{
withBlock.SetItemCheckState(i, CheckState.Checked);
}
}
if (NewFiletypesForm.ShowDialog(this) == DialogResult.OK)
{
DocumentFiletypes.Clear();
foreach (string value in withBlock.CheckedItems)
{
DocumentFiletypes.Add(value);
}
if (DocumentFiletypes.Count == 0)
{
btnDocumentsFiletypes.Enabled = false;
chkDocumentsFiletypes.Checked = false;
}
}
}
}
private void btnAttachmentsFiletypes_Click(object sender, EventArgs e)
{
FiletypesForm NewFiletypesForm = new FiletypesForm();
string sql = "select DISTINCT RIGHT(UPPER(FILENAME),PATINDEX('%.%', REVERSE(UPPER(FILENAME)))-1) from MessagesAttachments (nolock) where Location <> dbo.OwnLocation() and [ATTACHMENT] is not null and len(isnull(contentid,'')) = 0";
{
var withBlock = NewFiletypesForm.clbFiletypes;
withBlock.Items.Clear();
var ds = mssql.SQLSelect(sql, con);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow value in ds.Tables[0].Rows)
{
withBlock.Items.Add(value.ItemArray[0]);
}
}
foreach (string value in AttachmentsFiletypes)
{
for (var i = 0; i <= withBlock.Items.Count - 1; i++)
{
if (withBlock.Items[i].Equals(value))
{
withBlock.SetItemChecked(i, true);
}
}
}
if (withBlock.Items.Count == 0)
{
MessageBox.Show("Es wurden keine Dateiendungen in der Datenbank gefunden. Die Option wird jetzt automatisch deaktiviert.");
btnAttachmentsFiletypes.Enabled = false;
chkAttachmentsFiletypes.Checked = false;
}
else
{
if (AttachmentsFiletypes.Count == 0)
{
for (int i = 0; i <= withBlock.Items.Count - 1; i++)
{
withBlock.SetItemCheckState(i, CheckState.Checked);
}
}
if (NewFiletypesForm.ShowDialog(this) == DialogResult.OK)
{
AttachmentsFiletypes.Clear();
foreach (string value in withBlock.CheckedItems)
{
AttachmentsFiletypes.Add(value);
}
}
if (AttachmentsFiletypes.Count == 0)
{
btnAttachmentsFiletypes.Enabled = false;
chkAttachmentsFiletypes.Checked = false;
}
}
}
}
