public bool SaveFdTransfer(Fdtransfersave _Fdtransfersave, string Connectionstring) { bool IsSaved = false; try { con = new NpgsqlConnection(Connectionstring); if (con.State != ConnectionState.Open) { con.Open(); } trans = con.BeginTransaction(); if (string.IsNullOrEmpty(_Fdtransfersave.pTransferdate)) { _Fdtransfersave.pTransferdate = "null"; } else { _Fdtransfersave.pTransferdate = "'" + FormatDate(_Fdtransfersave.pTransferdate) + "'"; } string SbsaveReferences = string.Empty; SbsaveReferences = "INSERT INTO Transfer(from_member_id, to_member_id, from_fd_account_id, to_fd_account_id,transfer_date, status) VALUES ( " + _Fdtransfersave.pFromMemberId + ", '" + _Fdtransfersave.pToMemberId + "', '" + _Fdtransfersave.pFromAccountId + "', '" + _Fdtransfersave.pToAccountId + "', " + _Fdtransfersave.pTransferdate + ",'true');"; if (!string.IsNullOrEmpty(SbsaveReferences)) { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, SbsaveReferences); trans.Commit(); IsSaved = true; } } catch (Exception) { trans.Rollback(); throw; } finally { if (con.State == ConnectionState.Open) { con.Dispose(); con.Close(); con.ClearPool(); trans.Dispose(); } } return(IsSaved); }
public IActionResult SaveFdTransfer([FromBody] Fdtransfersave _Fdtransfersave) { try { if (FdtransferDAL.SaveFdTransfer(_Fdtransfersave, Con)) { return Ok(true); } else { return StatusCode(StatusCodes.Status304NotModified); } } catch (Exception) { return StatusCode(StatusCodes.Status500InternalServerError); } }