/// <summary> /// To Get Vaccination By Id /// </summary> /// <param name="VaccinationID"></param> /// <returns></returns> public VaccinationBO GetVaccinationById(int VaccinationID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_VACCIN"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("V_VACCINATIONID", VaccinationID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); VaccinationBO Vaccinationobj = null; VaccinationList VaccinationListobj = new VaccinationList(); Vaccinationobj = new VaccinationBO(); while (dr.Read()) { if (ColumnExists(dr, "VACCINATIONNAME") && !dr.IsDBNull(dr.GetOrdinal("VACCINATIONNAME"))) { Vaccinationobj.VACCINATIONNAME = dr.GetString(dr.GetOrdinal("VACCINATIONNAME")); } if (ColumnExists(dr, "VACCINATIONID") && !dr.IsDBNull(dr.GetOrdinal("VACCINATIONID"))) { Vaccinationobj.VACCINATIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("VACCINATIONID"))); } } dr.Close(); return(Vaccinationobj); }
/// <summary> /// To Get Vaccination /// </summary> /// <returns></returns> public VaccinationList GetVaccination() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SEL_VACCINATION"; 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); VaccinationBO Vaccinationobj = null; VaccinationList VaccinationListobj = new VaccinationList(); while (dr.Read()) { Vaccinationobj = new VaccinationBO(); Vaccinationobj.VACCINATIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("vaccinationid"))); Vaccinationobj.VACCINATIONNAME = dr.GetString(dr.GetOrdinal("vaccinationname")); // Vaccinationobj.ISDELETED = dr.GetString(dr.GetOrdinal("isdeleted")); VaccinationListobj.Add(Vaccinationobj); } dr.Close(); return(VaccinationListobj); }