public void loadDataGridView() { dt_employee = Employee_Methods.loadEmployee(); employee_dataGridView.DataSource = null; employee_dataGridView.DataSource = dt_employee; employee_dataGridView.Columns["Profile"].Visible = false; }
private void remove_button_Click(object sender, EventArgs e) { if (employee_dataGridView.Rows.Count > 0) { int selectedRow = employee_dataGridView.Rows.GetFirstRow(DataGridViewElementStates.Selected); int empid = Convert.ToInt32(employee_dataGridView.Rows[selectedRow].Cells["EMPID"].Value); string path = employee_dataGridView.Rows[selectedRow].Cells["Profile"].Value.ToString(); int affectedRow = Employee_Methods.deleteEmployee(empid); if (affectedRow > 0) { AlertBox.ShowDialog("Successfully deleted.", AlertBox.AlertType.success, true); if (!string.IsNullOrEmpty(path)) { System.GC.Collect(); System.GC.WaitForPendingFinalizers(); if (File.Exists(path)) { File.Delete(path); } } select_designation_comboBox.SelectedIndex = 0; emp_details_textBox.Clear(); loadDataGridView(); } } }
private void loadDataGridView() { DataTable dt = Employee_Methods.viewsalary(); view_emp_sal_dataGridView.DataSource = dt; string month = sal_month_comboBox.Text; for (int i = 0; i < dt.Columns.Count; i++) { view_emp_sal_dataGridView.Columns[i].Visible = false; } visibleColumn("Employee Id"); visibleColumn("Employee Name"); visibleColumn("Salary"); visibleColumn("Last Paid For"); visibleColumn(month); if (paid_radioButton.Checked) { DataView dv = dt.DefaultView; dv.RowFilter = month + " <> '1/1/1900'"; } else if (due_radioButton.Checked) { DataView dv = dt.DefaultView; dv.RowFilter = month + " = '1/1/1900'"; view_emp_sal_dataGridView.Columns[month].Visible = false; } else if (all_radioButton.Checked) { view_emp_sal_dataGridView.Columns[month].Visible = false; } }
private void loadBankname() { DataTable dt_bknm = Employee_Methods.loadBankName(); Banknm_ComboBox.DisplayMember = "BankName"; Banknm_ComboBox.ValueMember = "BankID"; Banknm_ComboBox.DataSource = dt_bknm; }
private void save_button_Click(object sender, EventArgs e) { if (!isPersonalDet_validated) { AlertBox.ShowDialog("Please fill up Personal Details", AlertBox.AlertType.error, false); emp_registration_tabControl.SelectedIndex = 0; } else if (OtherDet_validation() && isPersonalDet_validated) { EmployeeEntity ey = loadEntity(); if (isUpdate) { save_next_button.Text = "Next"; Employee_Methods.updateEmployee(ey); AlertBox.ShowDialog("Successfull Updated", AlertBox.AlertType.success, true); if (isStoreImage) { File.Copy(openphoto.FileName, ImagePath, true); EmployeeProfile_pictureBox.Enabled = false; } clear_button_Click(sender, e); clear_button2_Click(sender, e); emp_registration_tabControl.SelectedIndex = 0; /*DataTable dt_employee = Employee_Methods.loadEmployee(); * searchemployeeobj.employee_dataGridView.DataSource = null; * searchemployeeobj.employee_dataGridView.DataSource = dt_employee; * //searchemployeeobj.employee_dataGridView.Columns["Profile"].Visible = false; */ } else { int FLAG = Employee_Methods.insertEmployee(ey); if (FLAG > 0) { if (isStoreImage) { File.Copy(openphoto.FileName, ImagePath, true); } AlertBox.ShowDialog("Successfull registered", AlertBox.AlertType.success, true); clear_button_Click(sender, e); clear_button2_Click(sender, e); emp_registration_tabControl.SelectedIndex = 0; EmployeeProfile_pictureBox.Image = EmployeeProfile_pictureBox.InitialImage; loadEMPID(); } } } }
private void loadDataGridView() { dt_emp = Employee_Methods.loadEmp_salary("paysal"); if (dt_emp.Rows.Count > 0) { employee_salary_dataGridView.DataSource = null; employee_salary_dataGridView.DataSource = dt_emp; employee_salary_dataGridView.Columns["Join Date"].Visible = false; } else { AlertBox.ShowDialog("There is No Employee Registered.", AlertBox.AlertType.information, false); isClose = true; } }
private void loadDataGridView() { dt_emp = Employee_Methods.loadEmp_salary("setsal"); if (dt_emp.Rows.Count > 0) { emp_salary_dataGridView.DataSource = null; emp_salary_dataGridView.DataSource = dt_emp; } else { search_groupBox.Enabled = false; AlertBox.ShowDialog("There are no Employees Registered.!!!", AlertBox.AlertType.information, false); isclose = true; } }
private void pay_sal_button_Click(object sender, EventArgs e) { EmployeeEntity ee = new EmployeeEntity(); ee.empid = tempid; ee.paymentdate = payment_dateTimePicker.Value; ee.month = sal_month_comboBox.Text; int affected = Employee_Methods.paySalary(ee); if (affected > 0) { AlertBox.ShowDialog("Salary paid successfully", AlertBox.AlertType.success, true); } emp_details_panel.Enabled = false; }
private void update_button_Click(object sender, EventArgs e) { EmployeeEntity entity = new EmployeeEntity() { empid = tempid, salary = int.Parse(emp_salary_textBox.Text) }; int affected = Employee_Methods.UpdateEmployee_salary(entity); if (affected > 0) { AlertBox.ShowDialog("Salary Updated Successfully.", AlertBox.AlertType.success, true); emp_nm_sal_panel.Enabled = false; empid_radioButton.Checked = true; loadDataGridView(); } }
private void update_button_Click(object sender, EventArgs e) { if (employee_dataGridView.Rows.Count > 0) { int selectedRow = employee_dataGridView.Rows.GetFirstRow(DataGridViewElementStates.Selected); int empid = Convert.ToInt32(employee_dataGridView.Rows[selectedRow].Cells["EmpID"].Value); DataTable dt = Employee_Methods.loadEmployeeDetails_Form(empid); employeeadd = new EmployeeRegistration(LoadUpdateForm(dt), this); employeeadd.isUpdate = true; employeeadd.TopLevel = false; employeeadd.Parent = ClassCall.mainFormObj.masterpanel; employeeadd.Dock = DockStyle.Fill; employeeadd.BringToFront(); employeeadd.Focus(); employeeadd.Show(); this.Dispose(); } }
private void loadEMPID() { int EMPID = Employee_Methods.loadEmpID(); emp_id_textbox.Text = EMPID.ToString(); }