ASP.NET

using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Xml;
using System.Globalization;


namespace HIV
{
    /// <summary>
    /// Summary description for run_specific_query.
    /// </summary>
    public class run_specific_query : System.Web.UI.Page
    {
        protected HIV.Controls.NavMenu navMenu;
        protected HIV.Controls.NavSubMenu navSubMenu;
        protected System.Web.UI.HtmlControls.HtmlGenericControl message;
        protected System.Web.UI.WebControls.Label resultsLabel;
        protected System.Web.UI.WebControls.DropDownList Specific_Query_DDL;
        protected System.Web.UI.WebControls.DropDownList mlno_DDL;
        //protected System.Web.UI.WebControls.TextBox date_TB;
        protected System.Web.UI.WebControls.CompareValidator dateValidator;
        protected System.Web.UI.WebControls.DataGrid resultsDatagrid;
        protected System.Web.UI.WebControls.Button submitButton;
        protected System.Web.UI.WebControls.Label data_src;
        protected System.Web.UI.WebControls.LinkButton exportLinkbutton;

        private void Page_Load(object sender, System.EventArgs e)
        {
            navMenu.SelectedMainItem = HIV.Controls.NavMenu.MainItems.QUERY;
            navSubMenu.SelectedMainItem = HIV.Controls.NavMenu.MainItems.QUERY;
            navSubMenu.SelectedSubItem = HIV.Controls.NavSubMenu.SubItems.RUN_SPECIFIC_QUERY;
            
            if (this.IsPostBack)
            {
                if(Specific_Query_DDL.SelectedItem.Value=="ResistantL")
                {
                    getMLNO(Specific_Query_DDL.SelectedItem.Value);
                }
                if(Specific_Query_DDL.SelectedItem.Value=="NegativeL")
                {
                    getMLNO(Specific_Query_DDL.SelectedItem.Value);
                }
           }
           
        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            BuildQueryForm();
            InitializeComponent();
            base.OnInit(e);
        }
        
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.exportLinkbutton.Click += new System.EventHandler(this.exportLinkbutton_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        protected void BuildQueryForm()
        {
            try
            {
                this.submitButton.Click += new System.EventHandler(this.submitButton_Click);
                this.Load += new System.EventHandler(this.Page_Load);
            }
            catch(Exception e)
            {
                message.InnerHtml = "Exception: " + e.ToString();
            }
        }

        private void getMLNO(string selectedvalue)
        {
            if(selectedvalue=="ResistantL")
            {
                string sql= "SELECT re_MLNO, MAX(re_SpecimenDate)-MIN(re_SpecimenDate) AS DaysSeronegative FROM ml_hiv_status WHERE (re_HIV1_Status=0) GROUP BY re_MLNO";
            
                OleDbConnection connection = new OleDbConnection(HIV.Database.DataConstants.CONNECTION_STRING);
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                OleDbCommand command = new OleDbCommand(sql, connection);
            
                DataSet ds = new DataSet();
                adapter.SelectCommand = command;

                if (adapter.Fill(ds) > 0)
                {
                    foreach (DataRow r in ds.Tables[0].Rows)
                    {
                        if(Convert.ToInt32(r["DaysSeronegative"]) < 2555)  
                        {
                            r.Delete();
                        }
                    }
                    DataView view = ds.Tables[0].DefaultView;
                    mlno_DDL.DataSource = view;
                    mlno_DDL.DataValueField="re_MLNO";
                    mlno_DDL.DataTextField = "re_MLNO";
                    mlno_DDL.DataBind();
                    resultsLabel.Visible= true;
                    mlno_DDL.Items.Insert(0, "ANY");
                }
                connection.Close();
            }
            if(selectedvalue=="NegativeL")
            {
                string sql= "SELECT re_MLNO,sum(re_HIV1_Status) AS hivNeg, MAX(re_SpecimenDate)- MIN(re_SpecimenDate) AS DaysSeronegative  FROM ml_hiv_status  GROUP BY re_MLNO";

                OleDbConnection connection = new OleDbConnection(HIV.Database.DataConstants.CONNECTION_STRING);
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                OleDbCommand command = new OleDbCommand(sql, connection);
            
                DataSet ds = new DataSet();
                adapter.SelectCommand = command;

                if (adapter.Fill(ds) > 0)
                {
                    foreach (DataRow r in ds.Tables[0].Rows)
                    {
                        if(Convert.ToInt32(r["hivNeg"]) != 0)
                        {
                            r.Delete();
                        }
                    }
                    DataView view = ds.Tables[0].DefaultView;
                    mlno_DDL.DataSource = view;
                    mlno_DDL.DataValueField="re_MLNO";
                    mlno_DDL.DataTextField = "re_MLNO";
                    mlno_DDL.DataBind();
                    resultsLabel.Visible= true;
                    mlno_DDL.Items.Insert(0, "ANY");
                }
                connection.Close();
            }
            
        }
        private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)
        {
        }
        private void submitButton_Click(object sender, System.EventArgs e)
        {
            if(Specific_Query_DDL.SelectedItem.Value=="default")
            {
                resultsLabel.Visible= true;
                resultsLabel.Text ="Please select a specific query from the dropdown list";
                exportLinkbutton.Visible = false;
            }
            if(Specific_Query_DDL.SelectedItem.Value=="ResistantL")
            {
                if(mlno_DDL.SelectedItem.Value=="ANY")
                {
                    executeResistantListQuery_ANY();
                }    
                else if(mlno_DDL.SelectedItem.Value!="ANY") 
                {
                    executeResistantListQuery_MLNO(mlno_DDL.SelectedItem.Value);
                }
            }
            if(Specific_Query_DDL.SelectedItem.Value=="NegativeL")
            {
                if(mlno_DDL.SelectedItem.Value=="ANY")
                {
                    executeNegativeListQuery_ANY();
                }
                else if(mlno_DDL.SelectedItem.Value!="ANY")
                {
                      executeNegativeListQuery_MLNO(mlno_DDL.SelectedItem.Value);
                }
            }
            
        }