public void InsertSalaryPaymentDetail(SalaryPaymentDetailDTO salaryPaymentDetail)
{
try
{
SalaryPaymentDetailDAO.Instance.InsertSalaryPaymentDetail(salaryPaymentDetail);
}
catch (MySqlException ex)
{
throw new BUSException(ex.Message);
}
}
public MySqlDataReader InsertSalaryPaymentDetail(SalaryPaymentDetailDTO salaryPaymentDetail)
{
try
{
// query
string query = string.Format(@"insert into SALARYPAYMENTDETAIL values('{0}', (select SalaryPaymentStatementID from SALARYPAYMENTSTATEMENT where SalaryPaymentStatementID='{1}'),
(select StaffID from STAFF where StaffID='{2}'),'{3}')", salaryPaymentDetail.ID, salaryPaymentDetail.SalaryPaymentStatementID,
salaryPaymentDetail.StaffID, salaryPaymentDetail.PaidAmount);
// excute query
return(MySqlConnectionDAO.Instance.ExcuteQuery(query));
}
finally
{
}
}
