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