public static DataTable walletProc(walletProcModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_RBK_REQ_RES_INS_PROC";
cmd.Parameters.Add("ptype", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("pAPPLICANT_NAME", OracleDbType.Varchar2).Value = obj.CONSUMERNAME;
cmd.Parameters.Add("prbk_name", OracleDbType.Varchar2).Value = obj.rbkName;
cmd.Parameters.Add("phub_name", OracleDbType.Varchar2).Value = obj.hubName;
cmd.Parameters.Add("puser_charges", OracleDbType.Varchar2).Value = obj.userCharges;
cmd.Parameters.Add("pservice_charges", OracleDbType.Varchar2).Value = obj.serviceAmt;
cmd.Parameters.Add("ptotal_amount", OracleDbType.Varchar2).Value = obj.totalAmount;
cmd.Parameters.Add("pdept_txn_id", OracleDbType.Varchar2).Value = obj.APPLICATIONNO;
cmd.Parameters.Add("pgsws_txn_id", OracleDbType.Varchar2).Value = obj.GSWSREFNO;
cmd.Parameters.Add("pwallet_txn_id", OracleDbType.Varchar2).Value = obj.walletTxnId;
cmd.Parameters.Add("pis_payment_status", OracleDbType.Varchar2).Value = obj.paymentStatus;
cmd.Parameters.Add("pis_txn_reversal", OracleDbType.Varchar2).Value = obj.txnReversal;
cmd.Parameters.Add("pis_txn_reversal_succ", OracleDbType.Varchar2).Value = obj.txnReversalSuccess;
cmd.Parameters.Add("pis_dept_txn_canciled", OracleDbType.Varchar2).Value = obj.deptTxnCancelled;
cmd.Parameters.Add("pgsws_code", OracleDbType.Varchar2).Value = obj.GSWSCODE;
cmd.Parameters.Add("ptxn_initiate_date ", OracleDbType.TimeStamp).Value = DateTime.Now;
cmd.Parameters.Add("ptxn_response_date ", OracleDbType.TimeStamp).Value = DateTime.Now;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable resProc(resProcModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_APSEEDS_CORP_RESP_PROC";
cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("P_TRANSACTION_ID", OracleDbType.Varchar2).Value = obj.txnId;
cmd.Parameters.Add("P_DEPT_TRANS_ID", OracleDbType.Varchar2).Value = obj.orderId;
cmd.Parameters.Add("P_DEPT_ID", OracleDbType.Varchar2).Value = obj.deptId;
cmd.Parameters.Add("P_STATUS_CODE", OracleDbType.Varchar2).Value = obj.statusCode;
cmd.Parameters.Add("P_REMARKS", OracleDbType.Varchar2).Value = obj.remarks;
cmd.Parameters.Add("P_SERVICE_ID", OracleDbType.Varchar2).Value = obj.serviceId;
cmd.Parameters.Add("P_AMOUNT", OracleDbType.Varchar2).Value = obj.userCharge;
cmd.Parameters.Add("P_SERVICE_CHARGE", OracleDbType.Varchar2).Value = obj.serviceCharge;
cmd.Parameters.Add("P_TOTAL_AMOUNT", OracleDbType.Varchar2).Value = obj.totalAmount;
cmd.Parameters.Add("P_IS_PAYMENT_SUCCESS", OracleDbType.Varchar2).Value = obj.isPaymentSuccess;
cmd.Parameters.Add("P_IS_PAYMENT_REVERSAL", OracleDbType.Varchar2).Value = obj.isPaymentReversal;
cmd.Parameters.Add("P_IS_PAY_REV_SUCCESS", OracleDbType.Varchar2).Value = obj.isPaymentRevSuccess;
cmd.Parameters.Add("P_IS_TXNID_CANCEL_SUCCESS", OracleDbType.Varchar2).Value = obj.isTxnCancelSuccess;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable cfmsChallanProc(serviceRequestModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_CFMS_CHALLAN_PROC";
cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("P_DISTRICT", OracleDbType.Varchar2).Value = obj.districtId;
cmd.Parameters.Add("P_MANDAL", OracleDbType.Varchar2).Value = obj.mandalId;
cmd.Parameters.Add("P_SEC", OracleDbType.Varchar2).Value = obj.secId;
cmd.Parameters.Add("P_DEPT_TRANS_ID", OracleDbType.Varchar2).Value = obj.deptTxnId;
cmd.Parameters.Add("P_CHALLAN_ID", OracleDbType.Varchar2).Value = obj.challanId;
cmd.Parameters.Add("P_CHALLAN_DATE", OracleDbType.Varchar2).Value = obj.challanDate;
cmd.Parameters.Add("P_IFSC_CODE", OracleDbType.Varchar2).Value = obj.ifsc_code;
cmd.Parameters.Add("P_TRANSACTION_STATUS", OracleDbType.Varchar2).Value = obj.transaction_status;
cmd.Parameters.Add("P_VALID_UPTO", OracleDbType.Varchar2).Value = obj.valid_upto;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable familyProc(familyModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "gsws_get_family_details";
cmd.Parameters.Add("ptype", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("pdist", OracleDbType.Varchar2).Value = obj.districtId;
cmd.Parameters.Add("pmandal", OracleDbType.Varchar2).Value = obj.mandalId;
cmd.Parameters.Add("psecretariat", OracleDbType.Varchar2).Value = obj.secId;
cmd.Parameters.Add("pcluster", OracleDbType.Varchar2).Value = obj.clusterId;
cmd.Parameters.Add("puid_num", OracleDbType.Varchar2).Value = obj.uidNum;
cmd.Parameters.Add("phh_id", OracleDbType.Varchar2).Value = obj.hhID;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable casteProc(casteModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CERT_CASTE_SUB_CASTE";
cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("P_CASTE_CAT_ID", OracleDbType.Varchar2).Value = obj.casteId;
cmd.Parameters.Add("P_SUB_CASTE_ID", OracleDbType.Varchar2).Value = obj.subCasteId;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}