public DataTable Meeseva_Response_SP(RootMeesevaResponseObject objmeeseva) { OracleCommand cmd = new OracleCommand(); try { con = new OracleConnection(oradb); cmd.Connection = con; cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_IN_MEESEVA_PMT_RESP"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = "1"; cmd.Parameters.Add("PTRANS_ID", OracleDbType.Varchar2).Value = objmeeseva.TRANSID; cmd.Parameters.Add("PMEESEVA_APPLICATION_NO", OracleDbType.Varchar2).Value = objmeeseva.MEESEVAAPPLNO; cmd.Parameters.Add("PREQUEST_ID", OracleDbType.Varchar2).Value = objmeeseva.REQUESTID; cmd.Parameters.Add("PERROR_NO", OracleDbType.Varchar2).Value = objmeeseva.ERRORNO; cmd.Parameters.Add("PERROR_MESSAGE", OracleDbType.Varchar2).Value = objmeeseva.ERRORMESSAGE; cmd.Parameters.Add("PRECEIPT_PARAM_KEY", OracleDbType.Varchar2).Value = objmeeseva.RECEIPTPARAMDESC; cmd.Parameters.Add("PRECEIPT_PARAM_VALUE", OracleDbType.Varchar2).Value = objmeeseva.RECEIPTDETAILS; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataAdapter oda = new OracleDataAdapter(cmd); DataTable data = new DataTable(); oda.Fill(data); return(data); } catch (Exception ex) { throw ex; } finally { con.Close(); cmd.Dispose(); } }
public IHttpActionResult PaymentResponseByMeeseva(dynamic data) { try { dynamic obj = new ExpandoObject(); string serialized_data = JsonConvert.SerializeObject(data); string mappath = HttpContext.Current.Server.MapPath("PaymentResponseByMeesevaLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log(mappath, serialized_data)); RootMeesevaResponseObject _objmeeseva = JsonConvert.DeserializeObject <RootMeesevaResponseObject>(serialized_data); //obj.Status = "100"; // obj.Reason = "Data Submitted Successfully"; // return Ok(obj); return(Ok(_Hel.SavePaymentResponse(_objmeeseva))); } catch (Exception ex) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public dynamic SavePaymentResponse(RootMeesevaResponseObject objres) { dynamic obj = new ExpandoObject(); try { DataTable dt = Meeseva_Response_SP(objres); if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1") { obj.Status = "100"; obj.Reason = "Data Submitted Successfully"; } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("MeesevaExceptions"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "SavePaymentResponse:" + ex.Message.ToString())); obj.Status = "102"; obj.Reason = ex.Message.ToString(); } return(obj); }