private void SearchWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
lstvUsers.Items.Clear();
// check if previews search matches
if (lastSearchBGW != txbSearch.Text)
{
SearchWorker.RunWorkerAsync(txbSearch.Text);
lastSearchBGW = txbSearch.Text;
return;
}
dbDataSet.EmployeesDataTable eDt = (dbDataSet.EmployeesDataTable)e.Result;
if (eDt.Count == 0)
{
return;
}
int i = 0;
//this.Text = eDt[0].GivenName;
do
{
ListViewItem lstv = new ListViewItem();
lstv.Text = eDt[i].GivenName;
lstv.SubItems.Add(eDt[i].MiddleName);
lstv.SubItems.Add(eDt[i].FamilyName);
lstv.SubItems.Add(eDt[i].LoginName);
lstv.SubItems.Add(eDt[i].Acces_Name);
lstv.SubItems.Add(eDt[i].Id + "");
lstvUsers.Items.Add(lstv);
} while (++i < eDt.Count);
}
private void btnOk_Click(object sender, EventArgs e)
{
dbDataSet.EmployeesDataTable init = new dbDataSet.EmployeesDataTable();
switch (_isEdit)
{
case true:
employeesTableAdapterMain.UpdateUserByIdQuery(txbPrefx.Text, txbFirstName.Text, txbMiddleName.Text, txbFamilyName.Text, txbSuffix.Text, txbUserName.Text, txbPassword.Text, cmbAccess.SelectedIndex == 0 ? 2 : 1, _id);
this.DialogResult = DialogResult.OK;
break;
case false:
employeesTableAdapterMain.InsertUserQuery(txbPrefx.Text, txbFirstName.Text, txbMiddleName.Text, txbFamilyName.Text, txbSuffix.Text, txbUserName.Text, txbPassword.Text, cmbAccess.SelectedIndex == 0?2:1);
if (MessageBox.Show(this, "User sucesfully added, do you want to add more?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
//employeesTableAdapterMain.FillByEmployeeId(init, _id);
txbPrefx.Clear();
txbFirstName.Clear();
txbMiddleName.Clear();
txbFamilyName.Clear();
txbSuffix.Clear();
txbPassword.Clear();
txbPassword2.Clear();
lblCheck.Text = "-";
}
else
{
this.Close();
}
break;
default:
throw new Exception("aaaaaaaaaaaaaa");
}
}
private void deleteSelected_Click(object sender, EventArgs e)
{
//MessageBox.Show(lstvUsers.SelectedItems[0].SubItems[5].Text);
dbDataSet.EmployeesDataTable init = new dbDataSet.EmployeesDataTable();
employeesTableAdapterMain.DeleteQueryById(int.Parse(lstvUsers.SelectedItems[0].SubItems[5].Text));
SearchWorker.RunWorkerAsync(txbSearch.Text);
lastSearchBGW = txbSearch.Text;
}
private void BgWorderTmp_DoWork(object sender, DoWorkEventArgs e)
{
dbDataSet.EmployeesDataTable init = new dbDataSet.EmployeesDataTable();
try {
employeesTableAdapterMain.Fill(init);
}
catch (Exception) {
e.Result = "failed";
}
//throw new NotImplementedException();
}
private void frmUserProperties_Load(object sender, EventArgs e)
{
employeesTableAdapterMain = new dbDataSetTableAdapters.EmployeesTableAdapter();
switch (_isEdit)
{
case true:
dbDataSet.EmployeesDataTable init = new dbDataSet.EmployeesDataTable();
employeesTableAdapterMain.FillByEmployeeId(init, _id);
txbPrefx.Text = init[0].NamePrefix;
txbFirstName.Text = init[0].GivenName;
txbMiddleName.Text = init[0].MiddleName;
txbFamilyName.Text = init[0].FamilyName;
txbSuffix.Text = init[0].NameSuffix;
txbUserName.Text = init[0].LoginName;
txbPassword.Text = init[0].Password;
txbPassword2.Text = init[0].Password;
if (init[0].AccesID == 1)
{
cmbAccess.SelectedIndex = 1;
}
else
{
cmbAccess.SelectedIndex = 0;
}
break;
case false:
cmbAccess.SelectedIndex = 0;
break;
default:
throw new Exception("aaaaaaaaaaaaaa");
//break;
}
}
private void SearchWorker_DoWork(object sender, DoWorkEventArgs e)
{
dbDataSet.EmployeesDataTable init = new dbDataSet.EmployeesDataTable();
employeesTableAdapterMain.FillByUsers(init, e.Argument.ToString());
e.Result = init; // stack overflow google XD
}
