private void update_button_Click(object sender, EventArgs e)
{
bool WorkState;
if (active.Checked == true)
{
WorkState = true;
}
else
{
WorkState = false;
}
EmployeeArtifact artifactObj = new EmployeeArtifact();
artifactObj.Active = WorkState;
artifactObj.Address = address_txtbox.Text;
artifactObj.ContactDetails = contact_txtbox.Text;
artifactObj.DateOfBirth = dob_pick.Value.Date.ToString();
artifactObj.Deleted = leave.Checked ? true : false;
artifactObj.Designation = designation_txtbox.Text;
artifactObj.FirstName = empname_combobox.Text;
artifactObj.MiddleName = mname_txtbox.Text;
artifactObj.LastName = lname_txtbox.Text;
artifactObj.Qualification = qualification_txtbox.Text;
artifactObj.Id = int.Parse(empid_txtbox.Text);
if (artifactObj.EditEmployee(artifactObj))
{
MessageBox.Show("Successfully updated");
}
else
{
MessageBox.Show("Failed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool EditEmployee(EmployeeArtifact obj)
{
string query = "update employee set lname ='" + obj.LastName + "', middlename='" + obj.MiddleName + "' ,designation='" + obj.Designation
+ "',address='" + obj.Address + "',contactdetails = '" + obj.ContactDetails
+ "',active = '" + obj.Active + "', deleted= '" + obj.Deleted + "', dateofbirth = '" + obj.DateOfBirth + "',qualification = '"+obj.Qualification+"' where id = " + obj.Id;
DbConnectionManager dbConnectionManager = new DbConnectionManager();
SqlConnection connection = dbConnectionManager.connectToDb();
SqlCommand command = new SqlCommand(query);
command.Connection = connection;
int result = command.ExecuteNonQuery();
dbConnectionManager.diconnectFromDb(connection);
if (result > 0)
{
return true;
}
else
{
return false;
}
}
private void EditEmployeeDetails_Load(object sender, EventArgs e)
{
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List <EmployeeArtifact> list = new List <EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
empname_combobox.DataSource = list;
empname_combobox.DisplayMember = "FirstName";
empname_combobox.ValueMember = "Id";
/*
* DbConnectionManager connect = new DbConnectionManager();
* SqlConnection conn = connect.connectToDb();
* string query = "select * from employee";
* SqlCommand cmd = new SqlCommand(query);
* cmd.Connection = conn;
* SqlDataAdapter da = new SqlDataAdapter();
* da.SelectCommand = cmd;
* DataSet ds = new DataSet();
* da.Fill(ds, "employee");
* empname_combobox.DataSource = ds.Tables["employee"];
* empname_combobox.DisplayMember = "fname";
* empname_combobox.ValueMember = "id";
* DataRowView id = (DataRowView)empname_combobox.SelectedItem;
*
* DisplayEmployeeDetails(empname_combobox.SelectedValue.ToString());
* connect.diconnectFromDb(conn);
* */
}
private void EditEmployeeDetails_Load(object sender, EventArgs e)
{
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List<EmployeeArtifact> list = new List<EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
empname_combobox.DataSource = list;
empname_combobox.DisplayMember = "FirstName";
empname_combobox.ValueMember = "Id";
/*
DbConnectionManager connect = new DbConnectionManager();
SqlConnection conn = connect.connectToDb();
string query = "select * from employee";
SqlCommand cmd = new SqlCommand(query);
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "employee");
empname_combobox.DataSource = ds.Tables["employee"];
empname_combobox.DisplayMember = "fname";
empname_combobox.ValueMember = "id";
DataRowView id = (DataRowView)empname_combobox.SelectedItem;
DisplayEmployeeDetails(empname_combobox.SelectedValue.ToString());
connect.diconnectFromDb(conn);
* */
}
private void DisplayEmployeeDetails(string employeename)
{
EmployeeArtifact selectedEmployee = (EmployeeArtifact)empfname_combobox.SelectedItem;
empid_txtbox.Text = selectedEmployee.Id.ToString();
emplname_txtbox.Text = selectedEmployee.LastName;
designation_txtbox.Text = selectedEmployee.Designation;
}
private void ViewEmployee_Load(object sender, EventArgs e)
{
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List <EmployeeArtifact> list = new List <EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
view_employee.DataSource = list;
}
private void SalaryCredentialAssigner_Load(object sender, EventArgs e)
{
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List<EmployeeArtifact> list = new List<EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
empname_combobox.DataSource = list;
empname_combobox.DisplayMember = "FirstName";
empname_combobox.ValueMember = "Id";
}
private void DailyAttendance_Load(object sender, EventArgs e)
{
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List <EmployeeArtifact> list = new List <EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
empfname_combobox.DataSource = list;
empfname_combobox.DisplayMember = "FirstName";
empfname_combobox.ValueMember = "Id";
}
private void SalaryCredentialAssigner_Load(object sender, EventArgs e)
{
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List <EmployeeArtifact> list = new List <EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
empname_combobox.DataSource = list;
empname_combobox.DisplayMember = "FirstName";
empname_combobox.ValueMember = "Id";
}
private void DisplayEmployeeDetails(string employeename)
{
EmployeeArtifact selectedEmployee = (EmployeeArtifact)empname_combobox.SelectedItem;
SalaryDetails salaryParameter = new SalaryDetails();
SalaryDetails tempObj = salaryParameter.GetSalaryCredentialsByEmpId(selectedEmployee.Id.ToString());
emp_idtxtbox.Text = selectedEmployee.Id.ToString();
emplname_txtbox.Text = selectedEmployee.LastName;
designation_txtbox.Text = selectedEmployee.Designation;
basicSalary_txt.Text = tempObj.BasicSalary.ToString();
allowance_txt.Text = tempObj.Allowance.ToString();
insurance_txt.Text = tempObj.Insurance.ToString();
}
private void PerspectivePayslip_Load(object sender, EventArgs e)
{
Month monthObj = new Month();
selectMonth_combobox.DataSource = monthObj.GetMonths();
selectMonth_combobox.DisplayMember = "Name";
selectMonth_combobox.ValueMember = "Id";
EmployeeArtifact empArtifactObj = new EmployeeArtifact();
List <EmployeeArtifact> list = new List <EmployeeArtifact>();
list = empArtifactObj.GetAllEmployee();
fname_combobox.DataSource = list;
fname_combobox.DisplayMember = "FirstName";
fname_combobox.ValueMember = "Id";
}
private void DisplayEmployeeDetails(string employeename)
{
EmployeeArtifact selectedEmployee = (EmployeeArtifact)empname_combobox.SelectedItem;
empid_txtbox.Text = selectedEmployee.Id.ToString();
lname_txtbox.Text = selectedEmployee.LastName;
mname_txtbox.Text = selectedEmployee.MiddleName;
address_txtbox.Text = selectedEmployee.Address;
contact_txtbox.Text = selectedEmployee.ContactDetails;
dob_pick.Value = DateTime.Parse(selectedEmployee.DateOfBirth);
qualification_txtbox.Text = selectedEmployee.Qualification;
designation_txtbox.Text = selectedEmployee.Designation;
active.Checked = selectedEmployee.Active;
leave.Checked = selectedEmployee.Deleted;
inactive.Checked = active.Checked ? false: true;
}
private void DisplayEmployeeDetails()
{
EmployeeArtifact selectedEmployee = (EmployeeArtifact)fname_combobox.SelectedItem;
lname_txtbox.Text = selectedEmployee.LastName;
Month selectedMonth = (Month)selectMonth_combobox.SelectedItem;
SalaryDetails salaryParameter = new SalaryDetails();
SalaryDetails tempObj = salaryParameter.GetMonthlySalaryByEmpId(selectedEmployee.Id.ToString(), selectedMonth.Id.ToString(), selectYear_combobox.SelectedItem.ToString(), selectedMonth.NumberOfDays.ToString());
emp_idtxtbox.Text = selectedEmployee.Id.ToString();
designation_txtbox.Text = selectedEmployee.Designation;
monthlySalary_txtbox.Text = tempObj.MonthlySalary.ToString();
netSalary_txtbox.Text = tempObj.NetSalary.ToString();
allowance_txt.Text = tempObj.Allowance.ToString();
insurance_txt.Text = tempObj.Insurance.ToString();
}
public List <EmployeeArtifact> GetAllEmployee()
{
DbConnectionManager connect = new DbConnectionManager();
SqlConnection conn = connect.connectToDb();
string employeeQuery = "select * from employee ";
SqlCommand cmd1 = new SqlCommand(employeeQuery);
cmd1.Connection = conn;
SqlDataAdapter da1 = new SqlDataAdapter();
da1.SelectCommand = cmd1;
DataSet ds1 = new DataSet();
da1.Fill(ds1, "employee");
List <EmployeeArtifact> empArtifactList = new List <EmployeeArtifact>();
foreach (DataRow dr in ds1.Tables["employee"].Rows)
{
EmployeeArtifact temp = new EmployeeArtifact();
temp.DateOfBirth = dr["dateofbirth"].ToString();
temp.FirstName = dr["fname"].ToString();
temp.Address = dr["address"].ToString();
temp.Id = int.Parse(dr["id"].ToString());
temp.LastName = dr["lname"].ToString();
temp.MiddleName = dr["middlename"].ToString();
temp.Designation = dr["designation"].ToString();
temp.Qualification = dr["qualification"].ToString();
temp.ContactDetails = dr["contactdetails"].ToString();
temp.Active = bool.Parse(dr["active"].ToString());
temp.Deleted = bool.Parse(dr["deleted"].ToString());
empArtifactList.Add(temp);
}
return(empArtifactList);
}
public bool EditEmployee(EmployeeArtifact obj)
{
string query = "update employee set lname ='" + obj.LastName + "', middlename='" + obj.MiddleName + "' ,designation='" + obj.Designation
+ "',address='" + obj.Address + "',contactdetails = '" + obj.ContactDetails
+ "',active = '" + obj.Active + "', deleted= '" + obj.Deleted + "', dateofbirth = '" + obj.DateOfBirth + "',qualification = '" + obj.Qualification + "' where id = " + obj.Id;
DbConnectionManager dbConnectionManager = new DbConnectionManager();
SqlConnection connection = dbConnectionManager.connectToDb();
SqlCommand command = new SqlCommand(query);
command.Connection = connection;
int result = command.ExecuteNonQuery();
dbConnectionManager.diconnectFromDb(connection);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public List<EmployeeArtifact> GetAllEmployee()
{
DbConnectionManager connect = new DbConnectionManager();
SqlConnection conn = connect.connectToDb();
string employeeQuery = "select * from employee ";
SqlCommand cmd1 = new SqlCommand(employeeQuery);
cmd1.Connection = conn;
SqlDataAdapter da1 = new SqlDataAdapter();
da1.SelectCommand = cmd1;
DataSet ds1 = new DataSet();
da1.Fill(ds1, "employee");
List<EmployeeArtifact> empArtifactList = new List<EmployeeArtifact>();
foreach (DataRow dr in ds1.Tables["employee"].Rows)
{
EmployeeArtifact temp = new EmployeeArtifact();
temp.DateOfBirth = dr["dateofbirth"].ToString();
temp.FirstName = dr["fname"].ToString();
temp.Address = dr["address"].ToString();
temp.Id = int.Parse(dr["id"].ToString());
temp.LastName = dr["lname"].ToString();
temp.MiddleName = dr["middlename"].ToString();
temp.Designation = dr["designation"].ToString();
temp.Qualification = dr["qualification"].ToString();
temp.ContactDetails = dr["contactdetails"].ToString();
temp.Active = bool.Parse(dr["active"].ToString());
temp.Deleted = bool.Parse(dr["deleted"].ToString());
empArtifactList.Add(temp);
}
return empArtifactList;
}
private void update_button_Click(object sender, EventArgs e)
{
bool WorkState;
if (active.Checked == true)
{
WorkState = true;
}
else
{
WorkState = false;
}
EmployeeArtifact artifactObj = new EmployeeArtifact();
artifactObj.Active = WorkState;
artifactObj.Address = address_txtbox.Text;
artifactObj.ContactDetails = contact_txtbox.Text;
artifactObj.DateOfBirth = dob_pick.Value.Date.ToString();
artifactObj.Deleted = leave.Checked ? true : false;
artifactObj.Designation = designation_txtbox.Text;
artifactObj.FirstName = empname_combobox.Text;
artifactObj.MiddleName = mname_txtbox.Text;
artifactObj.LastName = lname_txtbox.Text;
artifactObj.Qualification = qualification_txtbox.Text;
artifactObj.Id = int.Parse(empid_txtbox.Text);
if (artifactObj.EditEmployee(artifactObj))
{
MessageBox.Show("Successfully updated");
}
else
{
MessageBox.Show("Failed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
