/// <summary>
/// To Get Contracted ID
/// </summary>
/// <param name="ContractedID"></param>
/// <returns></returns>
public HIVContractedBO GetContractedID(int ContractedID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_HIVC";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CONTRACTEDID_", ContractedID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
HIVContractedBO objHIVContracted = null;
HIVContractedList Users = new HIVContractedList();
objHIVContracted = new HIVContractedBO();
while (dr.Read())
{
if (ColumnExists(dr, "CONTRACTED_THROUGH") && !dr.IsDBNull(dr.GetOrdinal("CONTRACTED_THROUGH")))
{
objHIVContracted.ContractedThrough = dr.GetString(dr.GetOrdinal("CONTRACTED_THROUGH"));
}
if (ColumnExists(dr, "CONTRACTED_ID") && !dr.IsDBNull(dr.GetOrdinal("CONTRACTED_ID")))
{
objHIVContracted.ContractedID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONTRACTED_ID")));
}
}
dr.Close();
return(objHIVContracted);
}
/// <summary>
/// To Get HIV Contracted
/// </summary>
/// <returns></returns>
public HIVContractedList GetHIVContracted()
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_HIVC";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
HIVContractedBO objHIVContracted = null;
HIVContractedList objHIV = new HIVContractedList();
while (dr.Read())
{
objHIVContracted = new HIVContractedBO();
objHIVContracted.ContractedID = dr.GetInt32(dr.GetOrdinal("CONTRACTED_ID"));
objHIVContracted.ContractedThrough = dr.GetString(dr.GetOrdinal("CONTRACTED_THROUGH"));
// objHIVContracted.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
objHIV.Add(objHIVContracted);
}
dr.Close();
return(objHIV);
}
