public GetChallanaPaymentsDTO GetChallanaPaymentDetails(string connectionstring, string ChallanaNO)
{
GetChallanaPaymentsDTO lstChallanaPayments = new GetChallanaPaymentsDTO();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select distinct pv.paymentid as voucherno,pv.paymentdate,tt.bankname,tt.chequenumber from challana_entry ce join challana_entry_details ced on ce.challana_id=ced.challana_id join tbltranspaymentvoucher pv on pv.recordid=ced.voucher_id left join tbltranspaymentreference tt on tt.paymentid=pv.paymentid where ce.challana_no ='" + ChallanaNO + "' and ced.status='true' and ce.challana_id not in(select challana_id from cin_entry ); "))
{
while (dr.Read())
{
lstChallanaPayments = new GetChallanaPaymentsDTO()
{
pVoucherno = dr["voucherno"],
pPaymentdate = dr["paymentdate"],
pBankname = dr["bankname"],
pChequenumber = dr["chequenumber"],
ChallanaPaymentList = GetChallanaPaymentDetailsList(connectionstring, ChallanaNO)
};
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstChallanaPayments);
}
public IActionResult GetChallanaPaymentDetails(string ChallanaNO)
{
GetChallanaPaymentsDTO ChallanaDetailsList = new GetChallanaPaymentsDTO();
try
{
ChallanaDetailsList = objChallana.GetChallanaPaymentDetails(Con, ChallanaNO);
return(ChallanaDetailsList != null?Ok(ChallanaDetailsList) : (IActionResult)StatusCode(StatusCodes.Status204NoContent));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw ex;
}
}
