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