private void EditBtn_Click(object sender, EventArgs e)
{
if (CheckEmptyFields())
{
return;
}
EmployeesHandler.EditEmployee(_employeeId, GetEmployeeFromFields());
this.DialogResult = DialogResult.OK;
this.Close();
}
//метод заполняет DataGridView актуальными данными
private void UpdateDataGrid()
{
employeesDGV.DataSource = EmployeesHandler.GetAllEmployees();
employeesDGV.Columns[0].Visible = false;
employeesDGV.Columns[1].HeaderText = "Фамилия";
employeesDGV.Columns[2].HeaderText = "Имя";
employeesDGV.Columns[3].HeaderText = "Отчество";
employeesDGV.Columns[4].HeaderText = "Дата рождения";
employeesDGV.Columns[5].HeaderText = "Адрес проживания";
employeesDGV.Columns[6].HeaderText = "Отдел";
employeesDGV.Columns[7].HeaderText = "О себе";
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
//если не выбрана ни одна строка - выводим сообщение об ошибке
if (employeesDGV.SelectedRows.Count == 0)
{
MessageBox.Show("Не выбран сотрудник для удаления!");
return;
}
int employeeId = (int)employeesDGV.SelectedRows[0].Cells[0].Value;
EmployeesHandler.DeleteEmployeeById(employeeId);
UpdateDataGrid();
}
public void Save()
{
currEmployee = new Employee();
//string _name = textBoxName.Text;
//string _fatherName = textBoxFatherName.Text;
//int _salary = Convert.ToInt32(textBoxSalary.Text);
#region Validation for valid employee data
//Check if all text boxes are empty
IEnumerable <TextBox> textBoxcollection = EntryGrid.Children.OfType <TextBox>();
foreach (TextBox box in textBoxcollection)
{
if (string.IsNullOrWhiteSpace(box.Text))
{
MessageBox.Show("Kindly Fill all the boxes");
return;
}
}
//CheckTextBoxes(this);
#endregion
try
{
currEmployee.Name = textBoxName.Text;
currEmployee.FatherName = textBoxFatherName.Text;
currEmployee.CNIC_No = textBoxCNIC.Text;
currEmployee.CurrentAddress = textBoxCurrentAddress.Text;
currEmployee.DutyDescription = textBoxDescription.Text;
currEmployee.PermanentAddress = textBoxPermanentAddress.Text;
currEmployee.Salary = Convert.ToInt32(textBoxSalary.Text);
currEmployee.BirthDate = datePickerDOB.SelectedDate.Value;
currEmployee.JoiningDate = datePickerJoiningDate.SelectedDate.Value;
//This line requires some care - 26 Dec
//currEmployee.Role = new EmployeeRole(roleComboBox.SelectedIndex + 1, roleComboBox.SelectedItem.ToString());
//Fixed: 31st Dec. Now its non-trivial way.
currEmployee.Role = (EmployeeRole)roleComboBox.SelectedItem;
//Insert it into Database
empHandler = new EmployeesHandler();
empHandler.AddEmployee(currEmployee);
}
catch (FormatException fexcept)
{
MessageBox.Show("Kindly Enter the Salary in correct (numeric) format.", "Invalid Entry");
return;
}
//Added - 01 Jan
//For Name/Father name not containing numbers
catch (ArgumentException aexcept)
{
MessageBox.Show(aexcept.Message, "Invalid Entry!");
return;
}
catch (InvalidOperationException invalidexcept)
{
MessageBox.Show(invalidexcept.Message, "Invalid Entry!");
return;
}
catch (Exception except)
{
MessageBox.Show(except.Message, "Invalid Entry!");
return;
}
//Clear all the TextBoxes
foreach (TextBox box in textBoxcollection)
{
box.Text = "";
}
}
private void ComboBox_Loaded(object sender, RoutedEventArgs e)
{
empHandler = new EmployeesHandler();
roleComboBox.ItemsSource = empHandler.GetEmployeeRoles();
}
private void datagridEmployee_Loaded(object sender, RoutedEventArgs e)
{
empHandler = new EmployeesHandler();
datagridEmployee.ItemsSource = empHandler.GetEmployees();
}
public void Refresh()
{
empHandler = new EmployeesHandler();
datagridEmployee.ItemsSource = empHandler.GetEmployees();
}
public void Save()
{
empHandler = new EmployeesHandler();
EmployeeAttendance empAttendance = new EmployeeAttendance();
#region Validation for valid Milking data
//Check if all text boxes are empty
IEnumerable <TextBox> textBoxcollection = EntryGrid.Children.OfType <TextBox>();
IEnumerable <ComboBox> comboBoxcollection = EntryGrid.Children.OfType <ComboBox>();
foreach (TextBox box in textBoxcollection)
{
if (box.Name == "textBoxComments")
{
//ignore
}
else
{
if (string.IsNullOrWhiteSpace(box.Text))
{
MessageBox.Show("Kindly Fill all the boxes.");
return;
}
}
}
foreach (ComboBox box in comboBoxcollection)
{
if (box.SelectedIndex == -1)
{
MessageBox.Show("Kindly Select both Employee and Attendance Status");
return;
}
}
#endregion
try
{
//Inserting values in Object
empAttendance.AttendanceDateTime = DateTime.Now;
Employee emp = new Employee();
emp.ID = ((Employee)comboBoxEmployee.SelectedItem).ID;
AttendanceStatus status = new AttendanceStatus();
status.ID = ((MasterTables)comboBoxAttendanceStatus.SelectedItem).ID;
empAttendance.Emp = emp;
empAttendance.Status = status;
empHandler.AddEmployeeAttendance(empAttendance);
}
catch (ArgumentException exc)
{
MessageBox.Show(exc.Message, "Error!");
return;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!");
return;
}
//Clear all the TextBoxes
foreach (TextBox box in textBoxcollection)
{
box.Text = "";
}
foreach (ComboBox box in comboBoxcollection)
{
box.SelectedIndex = -1;
}
//MessageBox.Show("Successfully Saved!");
//Refresh the Combobox
comboBoxEmployee.ItemsSource = new EmployeesHandler().GetEmployees_AttendanceToBeMarked();
//Window mainwin = Application.Current.Windows.OfType<Window>().SingleOrDefault(x => x.IsActive);
//mainwin.Activate();
}
/// <summary>
/// Added on March 18
/// </summary>
/// <param name="col">Column Name</param>
/// <param name="param">Column Value</param>
public void ShowFilteredList(string col, string param)
{
empHandler = new EmployeesHandler();
employeeList = empHandler.GetEmployees(col, param);
datagridEmployee.ItemsSource = employeeList;
}
