private void btnPay_Click(object sender, EventArgs e) { if (IsValidSalaryTrans()) { salaryBll b = new salaryBll(); b.SalaryNo = txtSalaryId.Text; b.EmpName = cmbEmployeeName.Text.ToString(); b.SalaryMonth = dateTimePickerSalaryMonth.Value; b.Salary = txtSalary.Text; b.Bonus = txtBonus.Text; b.PaidDate = dateTimePickerPayDate.Value; b.Total = txtTotal.Text; b.PaidAmt = txtPaidAmt.Text; b.SalaryDues = txtSalaryDues.Text; b.Note = txtNotes.Text; if (dalObj.IsSalaryAlreadyPaid(b.EmpName, b.SalaryMonth.Month, b.SalaryMonth.Year)) { MessageBox.Show(" Salary Already Exist", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { bool success = dalObj.Insert(b); if (success == true) { MessageBox.Show("Salary Information Saved", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); Clear(); txtSalaryId.Clear(); dateTimePickerSalaryMonth.Value = DateTime.Now; // cmbSalaryMonth.SelectedItem = "January"; dateTimePickerPayDate.Value = DateTime.Now; GenarateSalaryNo(); LoadEmpName(); cmbEmployeeName.SelectedIndex = -1; var dt = dal.Select(); dgvSalary.DataSource = dt; } else { MessageBox.Show("Failed to Save Salary Information"); } } } }
private void btnUpdate_Click(object sender, EventArgs e) { if (IsValidSalaryTrans()) { salaryBll b = new salaryBll(); b.SalaryNo = txtSalaryId.Text; b.EmpName = cmbEmployeeName.Text.ToString(); b.SalaryMonth = dateTimePickerSalaryMonth.Value; b.Salary = txtSalary.Text; b.Bonus = txtBonus.Text; b.PaidDate = dateTimePickerPayDate.Value; b.Total = txtTotal.Text; b.PaidAmt = txtPaidAmt.Text; b.SalaryDues = txtSalaryDues.Text; b.Note = txtNotes.Text; DialogResult result = MessageBox.Show("Are you Sure you want to Update", "Update", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { var success = dalObj.Update(b); if (success == true) { MessageBox.Show("Successfully Updated Salary Information", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); Clear(); txtSalaryId.Clear(); // cmbSalaryMonth.SelectedItem = "January"; dateTimePickerSalaryMonth.Value = DateTime.Now; dateTimePickerPayDate.Value = DateTime.Now; GenarateSalaryNo(); LoadEmpName(); cmbEmployeeName.SelectedIndex = -1; var dt = dal.Select(); dgvSalary.DataSource = dt; btnUpdate.Enabled = false; //btnDelete.Enabled = true; btnPay.Enabled = true; } else { MessageBox.Show("Failed to Update Salary Information"); } } } }
public bool Insert(salaryBll b) { bool isSuccess = false; try { Connection.Open(); Query = "INSERT INTO Salary(SalaryNo,EmpName, SalaryMonth, Salary, Bonus, Total, PaidAmt, SalaryDues, PaidDate, Note) VALUES (@SalaryNo,@EmpName, @SalaryMonth, @Salary, @Bonus, @Total, @PaidAmt, @SalaryDues, @PaidDate, @Note)"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("@SalaryNo", b.SalaryNo); Command.Parameters.AddWithValue("@EmpName", b.EmpName); Command.Parameters.AddWithValue("@SalaryMonth", b.SalaryMonth); Command.Parameters.AddWithValue("@Salary", b.Salary); Command.Parameters.AddWithValue("@Bonus", b.Bonus); Command.Parameters.AddWithValue("@PaidDate", b.PaidDate); Command.Parameters.AddWithValue("@Total", b.Total); Command.Parameters.AddWithValue("@PaidAmt", b.PaidAmt); Command.Parameters.AddWithValue("@SalaryDues", b.SalaryDues); Command.Parameters.AddWithValue("@Note", b.Note); int rows = Command.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Connection.Close(); } return(isSuccess); }
public bool Update(salaryBll b) { bool isSuccess = false; try { Connection.Open(); Query = "UPDATE Salary SET EmpName=@EmpName, SalaryMonth=@SalaryMonth, Salary=@Salary, Bonus=@Bonus, Total=@Total, PaidAmt=@PaidAmt, SalaryDues=@SalaryDues, PaidDate=@PaidDate, Note=@Note WHERE SalaryNo=@SalaryNo"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("@SalaryNo", b.SalaryNo); Command.Parameters.AddWithValue("@EmpName", b.EmpName); Command.Parameters.AddWithValue("@SalaryMonth", b.SalaryMonth); Command.Parameters.AddWithValue("@Salary", b.Salary); Command.Parameters.AddWithValue("@Bonus", b.Bonus); Command.Parameters.AddWithValue("@PaidDate", b.PaidDate); Command.Parameters.AddWithValue("@Total", b.Total); Command.Parameters.AddWithValue("@PaidAmt", b.PaidAmt); Command.Parameters.AddWithValue("@SalaryDues", b.SalaryDues); Command.Parameters.AddWithValue("@Note", b.Note); int rows = Command.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Connection.Close(); } return(isSuccess); }