public AddEditPayRateForm(EmployeeAddEditForm parentForm, PayRate currPayRate, bool isEdit) { this.parentForm = parentForm; this.currPayRate = currPayRate; this.isEdit = isEdit; InitializeComponent(); }
public AddEditPayRateForm(EmployeeAddEditForm parentForm, List<Job> alreadyAssignedJobList, PayRate currPayRate, bool isEdit) { this.alreadyAssignedJobList = alreadyAssignedJobList; this.parentForm = parentForm; this.currPayRate = currPayRate; this.isEdit = isEdit; InitializeComponent(); }
public bool editPayRate(PayRate p) { for (int i = 0; i < this.empJobDataGridView.Rows.Count; i++) { if (p.Job.JobName.Equals(this.empJobDataGridView.Rows[i].Cells[2].Value.ToString()) && p.Job.RefCode.Equals(this.empJobDataGridView.Rows[i].Cells[3].Value.ToString())) { this.empJobDataGridView.Rows[i].Cells[4].Value = p.Active; this.empJobDataGridView.Rows[i].Cells[5].Value = String.Format("{0:0.00}",p.HourlyPayRate); } } for (int i = 0; i < this.currEmp.PayRateList.Count; i++) { if (p.Job.JobName == this.currEmp.PayRateList[i].Job.JobName && p.Job.RefCode == this.currEmp.PayRateList[i].Job.RefCode) { this.currEmp.PayRateList[i].Active = p.Active; this.currEmp.PayRateList[i].HourlyPayRate = p.HourlyPayRate; } } return true; }
private void updatePayRate(Employee emp, PayRate p) { using (SqlConnection conn = DBUtils.getConnection("MCLabor")) { conn.Open(); using (SqlCommand cmd = new SqlCommand("UPDATE PAY_RATE " + "SET employeeId = @employeeId, jobId = @jobId, hourlyPayRate = @hourlyPayRate, active = @active " + "WHERE payRateId = @payRateId", conn)) { cmd.Parameters.AddWithValue("@employeeId", emp.EmployeeId); cmd.Parameters.AddWithValue("@jobId", p.Job.JobId); cmd.Parameters.AddWithValue("@hourlyPayRate", p.HourlyPayRate); cmd.Parameters.AddWithValue("@active", p.Active); cmd.Parameters.AddWithValue("@payRateId", p.PayRateId); cmd.ExecuteNonQuery(); } } }
public void addPayRate(PayRate p) { this.currEmp.PayRateList.Add(p); this.empJobDataGridView.Rows.Add(new Object[] { -1, p.Job.JobId, p.Job.JobName, p.Job.RefCode, p.Active, String.Format("{0:0.00}",p.HourlyPayRate) }); }
private int insertNewPayRate(Employee emp, PayRate p) { using (SqlConnection conn = DBUtils.getConnection("MCLabor")) { conn.Open(); using (SqlCommand cmd = new SqlCommand("INSERT INTO PAY_RATE (employeeId, jobId, hourlyPayRate, active) " + "VALUES (@employeeId, @jobId, @hourlyPayRate, @active); " + "SELECT cast(Scope_Identity() as int)", conn)) { cmd.Parameters.AddWithValue("@employeeId", emp.EmployeeId); cmd.Parameters.AddWithValue("@jobId", p.Job.JobId); cmd.Parameters.AddWithValue("@hourlyPayRate", p.HourlyPayRate); cmd.Parameters.AddWithValue("@active", p.Active); return (int)cmd.ExecuteScalar(); } } }
private void editPayRateBtn_Click(object sender, EventArgs e) { PayRate currSelectedPayRate = new PayRate(); if(this.empJobDataGridView.SelectedRows.Count > 1) { MessageBox.Show("Please select just one job record to edit.", "Invalid Input"); } else if (this.empJobDataGridView.SelectedRows.Count < 1) { MessageBox.Show("Please select a job record to edit.", "Invalid Input"); } else { if (this.empJobDataGridView.SelectedRows[0].Cells[0].Value != null) { currSelectedPayRate.PayRateId = (int)this.empJobDataGridView.SelectedRows[0].Cells[0].Value; } if (this.empJobDataGridView.SelectedRows[0].Cells[1].Value != null) { currSelectedPayRate.Job.JobId = (int)this.empJobDataGridView.SelectedRows[0].Cells[1].Value; } currSelectedPayRate.Job.JobName = this.empJobDataGridView.SelectedRows[0].Cells[2].Value.ToString(); currSelectedPayRate.Job.RefCode = this.empJobDataGridView.SelectedRows[0].Cells[3].Value.ToString(); currSelectedPayRate.Active = (bool)this.empJobDataGridView.SelectedRows[0].Cells[4].Value; currSelectedPayRate.HourlyPayRate = Decimal.Parse(this.empJobDataGridView.SelectedRows[0].Cells[5].Value.ToString()); AddEditPayRateForm addEditPayRateForm = new AddEditPayRateForm(this, currSelectedPayRate, true); this.Enabled = false; addEditPayRateForm.Show(); } }