private void updateListView(DataSet1.recordDataDataTable table)
{
listView1.Clear();
imageList1.Images.Clear();
DirectoryInfo dir = new DirectoryInfo(photo_dir);
if (dir.Exists)
{
for (int i = 0; i < table.Rows.Count; i++)
{
this.imageList1.Images.Add(Image.FromFile((string)table.Rows[i]["photo"]));
this.imageList1.Images.SetKeyName(i, (string)table.Rows[i]["photo"]);
}
this.listView1.View = View.LargeIcon;
this.imageList1.ImageSize = new Size(90, 115);
this.listView1.LargeImageList = this.imageList1;
for (int j = 0; j < table.Rows.Count; j++)
{
ListViewItem item = new ListViewItem();
item.ImageKey = (string)table.Rows[j]["photo"];
item.Tag = (int)table.Rows[j]["id"];
item.Text = (string)table.Rows[j]["first_name"] + " " + (string)table.Rows[j]["last_name"];
this.listView1.Items.Add(item);
}
this.editContacttoolStripButton1.Enabled = this.editContactToolStripMenuItem.Enabled =
this.removeContacttoolStripButton1.Enabled = this.removeContactToolStripMenuItem.Enabled = false;
}
else
{
createEmptyAddressbook();
ShowAdressBookName();
ShowItems();
}
}
private DataSet1.recordDataDataTable sort(DataSet1.recordDataDataTable table)
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
switch (this.sortBytoolStripComboBox1.SelectedIndex)
{
case 0:
{
newTable = sortBy(table, "last_name ASC");
break;
}
case 1:
{
newTable = sortBy(table, "last_name DESC");
break;
}
case 2:
{
newTable = sortBy(table, "first_name ASC");
break;
}
case 3:
{
newTable = sortBy(table, "first_name DESC");
break;
}
}
return(newTable);
}
private DataSet1.recordDataDataTable filterTable(DataSet1.recordDataDataTable table, string expression)
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
DataRow[] drarray;
drarray = table.Select(expression);
for (int j = 0; j < drarray.Length; j++)
{
newTable.Rows.Add(drarray[j].ItemArray);
}
return(newTable);
}
private DataSet1.recordDataDataTable sortBy(DataSet1.recordDataDataTable table, string column_name)
{
DataRow[] drarray;
drarray = table.Select("", column_name);
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
for (int i = 0; i < drarray.Length; i++)
{
newTable.Rows.Add(drarray[i].ItemArray);
}
return(newTable);
}
private void searchContacts(string text)
{
if (text != "")
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
DataRow[] drarray;
int i = 0;
int[] idArray = new int[this.dataSet1.recordData.Rows.Count];
int idArrayCounter = 0;
while (i < this.dataSet1.recordData.Columns.Count)
{
if (this.dataSet1.recordData.Columns[i].DataType == typeof(string))
{
string expression = this.dataSet1.recordData.Columns[i].ColumnName + " LIKE '*" + text + "*'";
drarray = dataSet1.recordData.Select(expression);
for (int j = 0; j < drarray.Length; j++)
{
bool idExisting = false;
for (int k = 0; k < idArrayCounter; k++)
{
if ((int)drarray[j].ItemArray[0] == idArray[k])
{
idExisting = true;
}
}
if (!idExisting)
{
newTable.Rows.Add(drarray[j].ItemArray);
idArray[idArrayCounter] = (int)drarray[j].ItemArray[0];
idArrayCounter++;
}
}
}
i++;
}
updateListView(sort(newTable));
}
}
private DataSet1.recordDataDataTable filter()
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
string expression = null;
switch (this.relationtoolStripComboBox1.SelectedIndex)
{
case 0:
expression = "relation <> ''";
break;
case 1:
expression = "relation = 'friends'";
break;
case 2:
expression = "relation = 'family'";
break;
case 3:
expression = "relation = 'work'";
break;
case 4:
expression = "relation = 'other'";
break;
}
if (filtercheckBox.Checked)
{
if (photocheckBox.Checked)
{
expression += " AND photo <> 'no_photo.jpg'";
}
if (birthcheckBox.Checked)
{
expression += " AND birthdate <> ''";
}
if (emailcheckBox.Checked)
{
expression += " AND email <> ''";
}
if (webcheckBox.Checked)
{
expression += " AND web <> ''";
}
if (nickcheckBox.Checked)
{
expression += " AND nickname <> ''";
}
if (addresscheckBox.Checked)
{
expression += " AND paddress <> ''";
}
if (citycheckBox.Checked)
{
expression += " AND pcity <> ''";
}
if (companycheckBox.Checked)
{
expression += " AND nickname <> ''";
}
}
newTable = filterTable(this.dataSet1.recordData, expression);
return(newTable);
}
private DataSet1.recordDataDataTable sortBy(DataSet1.recordDataDataTable table, string column_name)
{
DataRow[] drarray;
drarray = table.Select("", column_name);
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
for (int i = 0; i < drarray.Length; i++)
{
newTable.Rows.Add(drarray[i].ItemArray);
}
return newTable;
}
private DataSet1.recordDataDataTable sort(DataSet1.recordDataDataTable table)
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
switch (this.sortBytoolStripComboBox1.SelectedIndex)
{
case 0:
{
newTable = sortBy(table, "last_name ASC");
break;
}
case 1:
{
newTable = sortBy(table, "last_name DESC");
break;
}
case 2:
{
newTable = sortBy(table, "first_name ASC");
break;
}
case 3:
{
newTable = sortBy(table, "first_name DESC");
break;
}
}
return newTable;
}
private void searchContacts(string text)
{
if (text != "")
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
DataRow[] drarray;
int i = 0;
int[] idArray = new int[this.dataSet1.recordData.Rows.Count];
int idArrayCounter = 0;
while (i < this.dataSet1.recordData.Columns.Count)
{
if (this.dataSet1.recordData.Columns[i].DataType == typeof(string))
{
string expression = this.dataSet1.recordData.Columns[i].ColumnName + " LIKE '*" + text + "*'";
drarray = dataSet1.recordData.Select(expression);
for (int j = 0; j < drarray.Length; j++)
{
bool idExisting = false;
for (int k = 0; k < idArrayCounter; k++)
{
if ((int)drarray[j].ItemArray[0] == idArray[k]) { idExisting = true; }
}
if (!idExisting)
{
newTable.Rows.Add(drarray[j].ItemArray);
idArray[idArrayCounter] = (int)drarray[j].ItemArray[0];
idArrayCounter++;
}
}
}
i++;
}
updateListView(sort(newTable));
}
}
private DataSet1.recordDataDataTable filterTable(DataSet1.recordDataDataTable table, string expression)
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
DataRow[] drarray;
drarray = table.Select(expression);
for (int j = 0; j < drarray.Length; j++)
{
newTable.Rows.Add(drarray[j].ItemArray);
}
return newTable;
}
private DataSet1.recordDataDataTable filter()
{
DataSet1.recordDataDataTable newTable = new DataSet1.recordDataDataTable();
string expression = null;
switch (this.relationtoolStripComboBox1.SelectedIndex)
{
case 0:
expression = "relation <> ''";
break;
case 1:
expression = "relation = 'friends'";
break;
case 2:
expression = "relation = 'family'";
break;
case 3:
expression = "relation = 'work'";
break;
case 4:
expression = "relation = 'other'";
break;
}
if (filtercheckBox.Checked)
{
if (photocheckBox.Checked) { expression += " AND photo <> 'no_photo.jpg'"; }
if (birthcheckBox.Checked) { expression += " AND birthdate <> ''"; }
if (emailcheckBox.Checked) { expression += " AND email <> ''"; }
if (webcheckBox.Checked) { expression += " AND web <> ''"; }
if (nickcheckBox.Checked) { expression += " AND nickname <> ''"; }
if (addresscheckBox.Checked) { expression += " AND paddress <> ''"; }
if (citycheckBox.Checked) { expression += " AND pcity <> ''"; }
if (companycheckBox.Checked) { expression += " AND nickname <> ''"; }
}
newTable = filterTable(this.dataSet1.recordData, expression);
return newTable;
}
