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