public bool SaveBondsPrint(Bonds_PrintDTO ObjBondsprint, string Connectionstring)
{
bool Issaved = false;
StringBuilder sbInsert = new StringBuilder();
try
{
con = new NpgsqlConnection(Connectionstring);
if (con.State != ConnectionState.Open)
{
con.Open();
}
trans = con.BeginTransaction();
if (ObjBondsprint.lstBonds_Print != null)
{
for (int i = 0; i < ObjBondsprint.lstBonds_Print.Count; i++)
{
sbInsert.Append("insert into Bonds_Print(fd_account_id, print_date, print_status)values(" + ObjBondsprint.lstBonds_Print[i].pDeposit_id + ",'" + FormatDate(ObjBondsprint.lstBonds_Print[i].pPrint_Date) + "','N');");
}
}
if (!string.IsNullOrEmpty(sbInsert.ToString()))
{
NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbInsert.ToString());
}
trans.Commit();
Issaved = true;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Dispose();
con.Close();
con.ClearPool();
trans.Dispose();
}
}
return(Issaved);
}
public IActionResult SaveBondsPrint([FromBody] Bonds_PrintDTO ObjBondsprint)
{
try
{
if (objBondprview.SaveBondsPrint(ObjBondsprint, Con))
{
return(Ok(true));
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
