/// <summary> /// To Get Data /// </summary> /// <param name="CULTURALNEGOID"></param> /// <returns></returns> public Nego GetData(int CULTURALNEGOID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_NGO";//"USP_TRN_GET_DAMAGE_CROPS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("N_CULTURALNEGOID", CULTURALNEGOID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Nego Ngoobj = null; NegoList Listobj = new NegoList(); Ngoobj = new Nego(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("CULTURALNEGOID"))) { Ngoobj.CULTURALNEGOID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALNEGOID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPID"))) { Ngoobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALPROPID"))); } if (!dr.IsDBNull(dr.GetOrdinal("NEGO_APPOINTMENTDATE"))) { Ngoobj.NEGO_APPOINTMENTDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("NEGO_APPOINTMENTDATE"))); } if (!dr.IsDBNull(dr.GetOrdinal("NEGO_VENUE"))) { Ngoobj.NEGO_VENUE = dr.GetString(dr.GetOrdinal("NEGO_VENUE")); } if (!dr.IsDBNull(dr.GetOrdinal("NEGO_DATE"))) { Ngoobj.NEGO_DATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("NEGO_DATE"))); } if (!dr.IsDBNull(dr.GetOrdinal("NEGO_PROBLEMDESC"))) { Ngoobj.NEGO_PROBLEMDESC = dr.GetString(dr.GetOrdinal("NEGO_PROBLEMDESC")); } } dr.Close(); return(Ngoobj); }
/// <summary> /// To Get NGO DATA /// </summary> /// <param name="culturalPropertyID"></param> /// <returns></returns> public NegoList GetNGODATA(int culturalPropertyID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_NGO"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CULTURALPROPERTYID_", culturalPropertyID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Nego Ngoobj = null; NegoList Listobj = new NegoList(); while (dr.Read()) { Ngoobj = new Nego(); if (!dr.IsDBNull(dr.GetOrdinal("culturalnegoid"))) { Ngoobj.CULTURALNEGOID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalnegoid"))); } if (!dr.IsDBNull(dr.GetOrdinal("nego_appointmentdate"))) { Ngoobj.NEGO_APPOINTMENTDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("nego_appointmentdate"))); } if (!dr.IsDBNull(dr.GetOrdinal("nego_venue"))) { Ngoobj.NEGO_VENUE = dr.GetString(dr.GetOrdinal("nego_venue")); } if (!dr.IsDBNull(dr.GetOrdinal("nego_date"))) { Ngoobj.NEGO_DATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("nego_date"))); } if (!dr.IsDBNull(dr.GetOrdinal("nego_problemdesc"))) { Ngoobj.NEGO_PROBLEMDESC = dr.GetString(dr.GetOrdinal("nego_problemdesc")); } Listobj.Add(Ngoobj); } dr.Close(); return(Listobj); }