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();
}
