Esempio n. 1
0
 /// <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();
 }
Esempio n. 2
0
        /// <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);
        }