/// <summary> /// To Get Major shock /// </summary> /// <param name="householdID"></param> /// <returns></returns> public major_shockList GetMshock(int householdID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_SHOCK"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("HHID_", householdID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); MajorshockBO Majorshockobj = null; major_shockList major_shockListobj = new major_shockList(); while (dr.Read()) { Majorshockobj = new MajorshockBO(); Majorshockobj.PAP_SHOCKID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_SHOCKID"))); Majorshockobj.SHOCKEXPERIENCED1 = dr.GetString(dr.GetOrdinal("shockexperienced")); Majorshockobj.SUPPORTEDBY1 = dr.GetString(dr.GetOrdinal("supportedby")); Majorshockobj.COP_MECHANISM1 = dr.GetString(dr.GetOrdinal("cop_mechanism")); Majorshockobj.ISDELETED1 = dr.GetString(dr.GetOrdinal("ISDELETED")); major_shockListobj.Add(Majorshockobj); } dr.Close(); return(major_shockListobj); }
/// <summary> /// To Get Pap ShocK Id /// </summary> /// <param name="PAP_SHOCKID1"></param> /// <returns></returns> public MajorshockBO GetPapShochId(int PAP_SHOCKID1) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_SHOCK"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("S_PAP_SHOCKID", PAP_SHOCKID1); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); MajorshockBO Majorshockobj = null; major_shockList major_shockListobj = new major_shockList(); Majorshockobj = new MajorshockBO(); while (dr.Read()) { if (ColumnExists(dr, "pap_shockid") && !dr.IsDBNull(dr.GetOrdinal("pap_shockid"))) { Majorshockobj.PAP_SHOCKID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_shockid"))); } if (ColumnExists(dr, "shockid") && !dr.IsDBNull(dr.GetOrdinal("shockid"))) { Majorshockobj.SHOCKID1 = dr.GetInt32(dr.GetOrdinal("shockid")); } if (ColumnExists(dr, "cop_mechanismid") && !dr.IsDBNull(dr.GetOrdinal("cop_mechanismid"))) { Majorshockobj.COP_MECHANISMID1 = dr.GetInt32(dr.GetOrdinal("cop_mechanismid")); } if (ColumnExists(dr, "supportid") && !dr.IsDBNull(dr.GetOrdinal("supportid"))) { Majorshockobj.SUPPORTID1 = dr.GetInt32(dr.GetOrdinal("supportid")); } } dr.Close(); return(Majorshockobj); }