/// <summary> /// to bind the data from the database to the dropdown ddlRoof /// </summary> private void bindDDLRoofs() { objRoofTypeBLL = new RoofTypeBLL(); objRoofTypeList = objRoofTypeBLL.GetRoofType(); ddlRoof.DataSource = objRoofTypeList; ddlRoof.DataTextField = "RoofTypeName"; ddlRoof.DataValueField = "RoofTypeID"; ddlRoof.DataBind(); }
/// <summary> /// To Get Roof Type /// </summary> /// <returns></returns> public RoofTypeList GetRoofType() { proc = "USP_MST_GET_ROOF"; cnn = new OracleConnection(con); RoofTypeBO objRoofType = null; RoofTypeList lstRoofTypeList = new RoofTypeList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objRoofType = new RoofTypeBO(); if (ColumnExists(dr, "roofid") && !dr.IsDBNull(dr.GetOrdinal("roofid"))) { objRoofType.RoofTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("roofid"))); } if (ColumnExists(dr, "RoofType") && !dr.IsDBNull(dr.GetOrdinal("RoofType"))) { objRoofType.RoofTypeName = dr.GetString(dr.GetOrdinal("RoofType")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objRoofType.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } lstRoofTypeList.Add(objRoofType); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstRoofTypeList); }