/// <summary> /// to bind the data from the database to the dropdown ddlFloor /// </summary> private void bindDDLFloor() { objFloorTypeBLL = new FloorTypeBLL(); objFloorTypeList = objFloorTypeBLL.GetFloorType(); ddlFloor.DataSource = objFloorTypeList; ddlFloor.DataTextField = "FloorTypeName"; ddlFloor.DataValueField = "FloorTypeID"; ddlFloor.DataBind(); }
/// <summary> /// To fetch details /// </summary> /// <returns></returns> public FloorTypeList GetAllFloorType()//(FloorType oFloorType) { proc = "USP_MST_GET_ALLFLOOR"; cnn = new OracleConnection(con); FloorTypeBO objFloorType = null; FloorTypeList lstFloorTypeList = new FloorTypeList(); 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()) { objFloorType = new FloorTypeBO(); if (ColumnExists(dr, "floorid") && !dr.IsDBNull(dr.GetOrdinal("floorid"))) { objFloorType.FloorTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("floorid"))); } if (ColumnExists(dr, "floortype") && !dr.IsDBNull(dr.GetOrdinal("floortype"))) { objFloorType.FloorTypeName = dr.GetString(dr.GetOrdinal("floortype")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objFloorType.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } lstFloorTypeList.Add(objFloorType); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstFloorTypeList); }