using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class SearchContainer : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        

    }
    protected void btnSearchContainer_Click(object sender, EventArgs e)
    {
        string conString = @"provider=Microsoft.Jet.OLEDB.4.0;user id=;password=; data source=" + Server.MapPath("./db/DataBank.mdb");
   
        OleDbDataReader dr;
        OleDbCommand cmd;
        OleDbConnection conn = new OleDbConnection(conString);
        string query;

        if (dpSearchContainer.SelectedValue == "Vessel Name")
        {
            conn.Open();
            //query = "SELECT [ID],[VesselName],[ContainerPosition],[CustomRotationNumber],[DailyClearancePosition],[ArrivalDate] FROM [Containers] WHERE VesselName='" + txtSearchContainer.Text + "'";
            query =  "select * FROM [Containers] WHERE VesselName='" + txtSearchContainer.Text + "'";
            cmd = new OleDbCommand(query,conn);
            dr = cmd.ExecuteReader();
            dlSearchContainer.DataSource = dr;
            dlSearchContainer.DataBind();
            dr.Close();
            conn.Close();
        }
        else if (dpSearchContainer.SelectedValue == "Custom Rotation Number")
        {
            conn.Open();
            query = "SELECT [ID],[VesselName],[ContainerPosition],[CustomRotationNumber],[DailyClearancePosition],[ArrivalDate] FROM [Containers] WHERE CustomRotationNumber ='" + txtSearchContainer.Text + "'";
            cmd = new OleDbCommand(query, conn);
            dr = cmd.ExecuteReader();
            dlSearchContainer.DataSource = dr;
            dlSearchContainer.DataBind();
            dr.Close();
            conn.Close();
        }
        else if (dpSearchContainer.SelectedValue == "Container Position")
        {
            conn.Open();
            query = "SELECT [ID],[VesselName],[ContainerPosition],[CustomRotationNumber],[DailyClearancePosition],[ArrivalDate] FROM [Containers] WHERE ContainerPosition ='" + txtSearchContainer.Text + "'";
            cmd = new OleDbCommand(query, conn);
            dr = cmd.ExecuteReader();
            dlSearchContainer.DataSource = dr;
            dlSearchContainer.DataBind();
            dr.Close();
            conn.Close();

        }
    }
}