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