//get all data in mst_Concern table using USP_MST_SELECTCONCERN-SP /// <summary> /// To Get Mode of Payment /// </summary> /// <returns></returns> public ModeofPaymentList GetModeofPayment() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTMODEOFPAYMENT"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ModeofPaymentBO objModeofPayment = null; ModeofPaymentList ModeofPaymentList = new ModeofPaymentList(); while (dr.Read()) { objModeofPayment = new ModeofPaymentBO(); objModeofPayment.ModeofPaymentID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("MODEOFPAYMENTID"))); objModeofPayment.ModeofPayment = dr.GetString(dr.GetOrdinal("MODEOFPAYMENT")); objModeofPayment.PaymentType = dr.GetString(dr.GetOrdinal("TYPEOFPAYMENT")); objModeofPayment.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); ModeofPaymentList.Add(objModeofPayment); } dr.Close(); return(ModeofPaymentList); }
//get the data in mst_Concern table using USP_MST_GETSELECTCONCERN-SP signal Data based on ID public ModeofPaymentBO GetModeofPaymentID(int ModeofPaymentID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTMODEOFPAY"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("PositionID_", ModeofPaymentID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ModeofPaymentBO ModeofPaymentBOObj = null; ModeofPaymentList ModeofPaymentList = new ModeofPaymentList(); ModeofPaymentBOObj = new ModeofPaymentBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("TYPEOFPAYMENT"))) { ModeofPaymentBOObj.PaymentType = dr.GetString(dr.GetOrdinal("TYPEOFPAYMENT")); } if (!dr.IsDBNull(dr.GetOrdinal("MODEOFPAYMENT"))) { ModeofPaymentBOObj.ModeofPayment = dr.GetString(dr.GetOrdinal("MODEOFPAYMENT")); } if (!dr.IsDBNull(dr.GetOrdinal("MODEOFPAYMENTID"))) { ModeofPaymentBOObj.ModeofPaymentID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("MODEOFPAYMENTID"))); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { ModeofPaymentBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(ModeofPaymentBOObj); }