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