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