/// <summary> /// To fetch details from database /// </summary> /// <returns></returns> public CulturePropertiesList GetCulturalPropertyType() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_NAME_CULTURPROP"; 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); CulturPropertiesBO BOobj = null; CulturePropertiesList Listobj = new CulturePropertiesList(); while (dr.Read()) { BOobj = new CulturPropertiesBO(); BOobj.CULTUREPROPTYPEID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID")))); BOobj.CULTUREPROPTYP = dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPE")).ToString(); Listobj.Add(BOobj); } dr.Close(); return(Listobj); }
/// <summary> /// To fetch details from database /// </summary> /// <param name="householdID"></param> /// <returns></returns> public CulturePropertiesList GetCultureProp(int householdID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_CULTURPROP"; 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); CulturPropertiesBO CulturPropertiesobj = null; CulturePropertiesList Listobj = new CulturePropertiesList(); while (dr.Read()) { CulturPropertiesobj = new CulturPropertiesBO(); CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalpropid"))); if (!dr.IsDBNull(dr.GetOrdinal("cultureproptype"))) { CulturPropertiesobj.CULTUREPROPTYP = dr.GetString(dr.GetOrdinal("cultureproptype")); } if (!dr.IsDBNull(dr.GetOrdinal("culturepropdescription"))) { CulturPropertiesobj.CULTUREPROPDESCRIPTION = dr.GetString(dr.GetOrdinal("culturepropdescription")); } else { CulturPropertiesobj.CULTUREPROPDESCRIPTION = " "; } CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("cult_valuationamount"))); Listobj.Add(CulturPropertiesobj); } dr.Close(); return(Listobj); }
/// <summary> /// To fetch details from database /// </summary> /// <param name="culTURALPROPID"></param> /// <returns></returns> public CulturPropertiesBO GetData(int culTURALPROPID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_CULTURPROP";//"USP_TRN_GET_DAMAGE_CROPS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("C_CULTURALPROPID", culTURALPROPID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CulturPropertiesBO CulturPropertiesobj = null; CulturePropertiesList Listobj = new CulturePropertiesList(); CulturPropertiesobj = new CulturPropertiesBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPID"))) { CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALPROPID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULTUREPROPTYPEID"))) { CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULTUREPROPDESCRIPTION"))) { CulturPropertiesobj.CULTUREPROPDESCRIPTION = dr.GetString(dr.GetOrdinal("CULTUREPROPDESCRIPTION")); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_DIMEN_LENGTH"))) { CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULT_DIMEN_LENGTH"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_DIMEN_WIDTH"))) { CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULT_DIMEN_WIDTH"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_DEPRECIATEDVALUE"))) { CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULT_DEPRECIATEDVALUE"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_VALUATIONAMOUNT"))) { CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULT_VALUATIONAMOUNT"))); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CulturPropertiesobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CulturPropertiesobj); }