private void AddButton_Click(object sender, EventArgs e)
{
if (NameTextBox.Text == "")
{
MessageBox.Show("Employee name not entered.");
NameTextBox.Focus();
return;
}
int IDNumber;
try {
IDNumber = int.Parse(IDTextBox.Text);
} catch {
MessageBox.Show("Invalid Employee ID.");
IDTextBox.Focus();
return;
}
myEmployee.NewEmployee(NameTextBox.Text, IDNumber, DepartmentTextBox.Text, PositionTextBox.Text);
NameTextBox.Clear();
IDTextBox.Clear();
DepartmentTextBox.Clear();
PositionTextBox.Clear();
ListBox.Items.Add("Employee: " + IDNumber + " added!");
NameTextBox.Focus();
}
/// <summary>
/// Inicjuje i otwiera okno z wyborem departementu.
/// </summary>
/// <param name="Crit">Ciąg znaków, wg których ma wyszukiwać w DataGridView.</param>
private void InitShowForm(string Crit)
{
//string Query = "SELECT kod_depart as [id], LTRIM(RTRIM(departam)) AS [Departament] FROM departam ORDER BY departam;";
SqlCommand Command = new SqlCommand();
Command.CommandText = "EXEC Akcesja_ListaDepartamentow; ";
DataGridViewColumn[] Columns = new DataGridViewColumn[2];
Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell());
Columns[0].DataPropertyName = "id";
Columns[0].Name = "id";
Columns[0].Visible = false;
Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell());
Columns[1].DataPropertyName = "departament";
Columns[1].Name = "departament";
Columns[1].HeaderText = _translationsDictionary.ContainsKey("department") ? _translationsDictionary["department"] : "Departament";
ShowForm SF = new ShowForm(Command, Columns, Crit, "departament", "departament");
if (SF.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
DepartmentID = Int32.Parse(SF.DGVRow.Cells["id"].Value.ToString());
DepartmentTextBox.Text = SF.DGVRow.Cells["departament"].Value.ToString();
}
else
{
DepartmentID = -1;
}
DepartmentTextBox.Text = DepartmentTextBox.Text.Trim();
DepartmentTextBox.Focus();
DepartmentTextBox.Select(DepartmentTextBox.Text.Length, 0);
}
void ClearTextBox()
{
NameTextBox.Clear();
GenderTextBox.Clear();
AgeTextBox.Clear();
DepartmentTextBox.Clear();
}
public void DepartmentNameDDList()
{
try
{
DataSet Ds = new DataSet();
Ds = NSM.DepartmentSelectAll();
DepartmentTextBox.DataSource = Ds.Tables[0];
DepartmentTextBox.DataTextField = "DepName";
DepartmentTextBox.DataValueField = "DepName";
DepartmentTextBox.DataBind();
}
catch (Exception e1)
{
}
}
