private void paidbutton_Click(object sender, EventArgs e)
{
if(totalPayableSalarytextBox.Text.Length!=0)
{
try
{
Employee aEmployee=new Employee();
aEmployee.EmployeeId = EmployeeId;
aEmployee.LastPaidAmount = Convert.ToDouble(totalPayableSalarytextBox.Text);
EmployeeDAO aDao=new EmployeeDAO();
string sr = aDao.UpdateAmount(aEmployee);
if (sr == "Update Sucessfully")
{
SalaryTransaction aSalaryTransaction=new SalaryTransaction();
aSalaryTransaction.EmployeeId = EmployeeId;
aSalaryTransaction.WorkingDay = Convert.ToInt32("0" + workingdaystextBox.Text);
aSalaryTransaction.AttendingDay = Convert.ToInt32("0" + attendingtextBox.Text);
aSalaryTransaction.Salary = Convert.ToDouble("0" + salarystructuretextBox.Text);
aSalaryTransaction.DeductedSalary = Convert.ToDouble("0" + deductedsalarytextBox.Text);
aSalaryTransaction.PayableSalary = Convert.ToDouble("0" + payablesalarytextBox.Text);
aSalaryTransaction.ServiceCharge = Convert.ToDouble("0" + servicechargetextBox.Text);
aSalaryTransaction.FoodAndRoomAllowance = Convert.ToDouble("0" + foodAndRoomtextBox.Text);
aSalaryTransaction.TotalPayableSalary = Convert.ToDouble("0" +totalPayableSalarytextBox.Text);
aSalaryTransaction.Remarks = remarkstextBox.Text;
aDao.InsertPaidAmountReport(aSalaryTransaction,monthcomboBox.Text, yearcomboBox.Text);
this.Close();
}
}
catch (Exception)
{
MessageBox.Show("Please Check Your Input");
}
}
else MessageBox.Show("Please Check Your Input");
}
public void InsertPaidAmountReport(SalaryTransaction aSalaryTransaction, string month, string year)
{
try
{
DateTime aDateTime = DateTime.Now.Date;
this.OpenConnection();
string sqlComm = string.Format(SqlQueries.GetQuery(Query.InsertPaidAmountReport), aSalaryTransaction.EmployeeId,
aSalaryTransaction.WorkingDay , aSalaryTransaction.AttendingDay ,aSalaryTransaction.Salary , aSalaryTransaction.DeductedSalary ,
aSalaryTransaction.PayableSalary, aSalaryTransaction.ServiceCharge,aSalaryTransaction.FoodAndRoomAllowance, aSalaryTransaction.TotalPayableSalary,
aDateTime, aSalaryTransaction.Remarks,month,year );
this.ExecuteNonQuery(sqlComm);
}
catch (Exception ex)
{
//throw new Exception(ex.ToString());
}
finally
{
this.CloseConnection();
}
}
