<?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="MyOracle" connectionString="DATA SOURCE=*******;PASSWORD=*******;USER ID=*******" providerName="System.Data.OracleClient"/>
  </connectionStrings>
  <system.web>
    <pages theme="red">
      
    </pages>
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        
        <add assembly="System.Data.OracleClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
      </assemblies>
    </compilation>
  </system.web>
</configuration>

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Collections.Generic;
using System.Web.Configuration;


using System.Data.OracleClient;


public class clsTileConnected
{
    private static readonly string _connectionString;
    static clsTileConnected()
    { _connectionString = WebConfigurationManager.ConnectionStrings["MyOracle"].ConnectionString; }

    
    /*==========================
     * GET ALL tile Manufacturers
     * ===========================*/

    public List<ppManufacturers> GetTileManufacturers()
    {
        List<ppManufacturers> objAll = new List<ppManufacturers>();
        OracleConnection conn = new OracleConnection(_connectionString);
        OracleCommand cmd = new OracleCommand("SELECT * FROM Manufacturers", conn);

        try
        {
            conn.Open();
            OracleDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                ppManufacturers objPP = new ppManufacturers();
                objPP.ppID = int.Parse(dr["manufacturer_id"].ToString());
                objPP.ppManufacturerTitle = dr["title"].ToString();
                objPP.ppManufacturerOrigin = dr["origin"].ToString();
                objAll.Add(objPP);
             }
            return objAll;
       }
        catch (Exception ex)
        {
        
            objAll.Clear();
            ppManufacturers objPP = new ppManufacturers();
            objPP.ppID = 0;
            objPP.ppManufacturerTitle = ex.Message.ToString();
            objAll.Add(objPP);
            return objAll;
          }
        finally
        {conn.Close();}
    }


    /*================================
     * Get all tile by ManufacturerID
     * ===============================*/

    public List<ppTiles> GetTileByManufacturerID(int _id)
    {
        List<ppTiles> objAll = new List<ppTiles>();
        OracleConnection conn = new OracleConnection(_connectionString);
        OracleCommand cmd = new OracleCommand("SELECT * FROM tiles WHERE manufacturer_id=:parID", conn);
        cmd.Parameters.AddWithValue(":parID", _id);
        try
        {
            conn.Open();
            OracleDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                ppTiles objPP = new ppTiles();
                objPP.ppID = int.Parse(dr["tile_id"].ToString());
                objPP.ppTileTitle = dr["tile_title"].ToString();
                objAll.Add(objPP);
            }
            return objAll;
        }
        catch (Exception ex)
        {
            objAll.Clear();
            ppTiles objPP = new ppTiles();
            objPP.ppID = 0;
            objPP.ppTileTitle = ex.Message.ToString();
            objAll.Add(objPP);
            return objAll;
        }
        finally
        { conn.Close(); }

    }

    /*=====================
     * Get all TILE by ID
     * ====================*/

    public List<ppTiles> GetTileByID(int _id)
    {
        List<ppTiles> objAll = new List<ppTiles>();
        OracleConnection conn = new OracleConnection(_connectionString);
        OracleCommand cmd = new OracleCommand("SELECT * FROM TILES WHERE tile_id = :parID", conn);
        cmd.Parameters.AddWithValue(":parId", _id);

        try
        {
            conn.Open();
            OracleDataReader dr = cmd.ExecuteReader();

            while (dr.Read())
            {
                ppTiles objPP = new ppTiles();
              objPP.ppID = int.Parse(dr["tile_id"].ToString());
              objPP.ppTileTitle = dr["tile_title"].ToString();
              objPP.ppTileType = dr["tile_type"].ToString();
              objPP.ppTileApplication = dr["application"].ToString();
              objPP.ppTileMaterial = dr["material"].ToString();
              objPP.ppTileStyle = dr["style"].ToString();
              objPP.ppTileColor = dr["color"].ToString();
              objPP.ppTileWidth = int.Parse(dr["width"].ToString());
              objPP.ppTileHeight = int.Parse(dr["height"].ToString());
              objPP.ppTileThickness = double.Parse(dr["thickness"].ToString());
                
                objPP.ppTilePrice = int.Parse(dr["price"].ToString());
              objAll.Add(objPP);
            }
            return objAll;

        }
        catch (Exception e)
        {
            e.Message.ToString();
            return null;
        }

        finally
        {
            conn.Close();
        }
         
                
   }

}