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