Miscellany

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;

public partial class TestHydro : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            WMS.DAL.Drawings drawingDAL = new WMS.DAL.Drawings();
            DataSet drawings = new DataSet();
            drawings = drawingDAL.GetDrawingsByProjectId(1);

            DataTable drawingsTable = drawings.Tables["Drawings"];
            DataRow drawingRow;

            for (int i = 0; i < drawingsTable.Rows.Count; i++)
            {
                drawingRow = drawingsTable.Rows[i];

                if(drawingRow["DrawingTypeId"].ToString().Equals("1"))
                {
                    MWPProjectDrawings.Items.Add(drawingRow["InternalDrawingNumber"].ToString());
                }
                if (drawingRow["DrawingTypeId"].ToString().Equals("2"))
                {
                    CWPProjectDrawings.Items.Add(drawingRow["InternalDrawingNumber"].ToString());
                }
                if (drawingRow["DrawingTypeId"].ToString().Equals("3"))
                {
                    PNIDProjectDrawings.Items.Add(drawingRow["InternalDrawingNumber"].ToString());
                }
                if (drawingRow["DrawingTypeId"].ToString().Equals("4"))
                {
                    IsometricProjectDrawings.Items.Add(drawingRow["InternalDrawingNumber"].ToString());
                }
            }
        }

    }

    #region ListBoxFunctions
    protected void MWPAdd_Click(object sender, EventArgs e)
    {
        while (MWPProjectDrawings.Items.Count > 0 && MWPProjectDrawings.SelectedItem != null)
        {
            ListItem selectedItem = MWPProjectDrawings.SelectedItem;
            selectedItem.Selected = false;
            MWPHydroDrawings.Items.Add(selectedItem);
            MWPProjectDrawings.Items.Remove(selectedItem);
        }
    }
    protected void MWPDelete_Click(object sender, EventArgs e)
    {
        while (MWPHydroDrawings.Items.Count > 0 && MWPHydroDrawings.SelectedItem != null)
        {
            ListItem selectedItem = MWPHydroDrawings.SelectedItem;
            selectedItem.Selected = false;
            MWPProjectDrawings.Items.Add(selectedItem);
            MWPHydroDrawings.Items.Remove(selectedItem);
        }
    }
    protected void CWPAdd_Click(object sender, EventArgs e)
    {
        while (CWPProjectDrawings.Items.Count > 0 && CWPProjectDrawings.SelectedItem != null)
        {
            ListItem selectedItem = CWPProjectDrawings.SelectedItem;
            selectedItem.Selected = false;
            CWPHydroDrawings.Items.Add(selectedItem);
            CWPProjectDrawings.Items.Remove(selectedItem);
        }
    }
    protected void CWPDelete_Click(object sender, EventArgs e)
    {
        while (CWPHydroDrawings.Items.Count > 0 && CWPHydroDrawings.SelectedItem != null)
        {
            ListItem selectedItem = CWPHydroDrawings.SelectedItem;
            selectedItem.Selected = false;
            CWPHydroDrawings.Items.Add(selectedItem);
            CWPProjectDrawings.Items.Remove(selectedItem);
        }
    }
    protected void PNIDAdd_Click(object sender, EventArgs e)
    {
        while (PNIDProjectDrawings.Items.Count > 0 && PNIDProjectDrawings.SelectedItem != null)
        {
            ListItem selectedItem = PNIDProjectDrawings.SelectedItem;
            selectedItem.Selected = false;
            PNIDHydroDrawings.Items.Add(selectedItem);
            PNIDProjectDrawings.Items.Remove(selectedItem);
        }
    }
    protected void PNIDDelete_Click(object sender, EventArgs e)
    {
        while (PNIDHydroDrawings.Items.Count > 0 && PNIDHydroDrawings.SelectedItem != null)
        {
            ListItem selectedItem = PNIDHydroDrawings.SelectedItem;
            selectedItem.Selected = false;
            PNIDProjectDrawings.Items.Add(selectedItem);
            PNIDHydroDrawings.Items.Remove(selectedItem);
        }
    }
    protected void IsometricAdd_Click(object sender, EventArgs e)
    {
        while (IsometricProjectDrawings.Items.Count > 0 && IsometricProjectDrawings.SelectedItem != null)
        {
            ListItem selectedItem = IsometricProjectDrawings.SelectedItem;
            selectedItem.Selected = false;
            IsometricHydroDrawings.Items.Add(selectedItem);
            IsometricProjectDrawings.Items.Remove(selectedItem);
        }
    }
    protected void IsometricDelete_Click(object sender, EventArgs e)
    {
        while (IsometricHydroDrawings.Items.Count > 0 && IsometricHydroDrawings.SelectedItem != null)
        {
            ListItem selectedItem = IsometricHydroDrawings.SelectedItem;
            selectedItem.Selected = false;
            IsometricProjectDrawings.Items.Add(selectedItem);
            IsometricHydroDrawings.Items.Remove(selectedItem);
        }
    }
    #endregion ListBoxFunctions

    protected void updateHydroTest_Click(object sender, EventArgs e)
    {
        int hydroTestId = 5;//dataHydroTestId.DataValueField;
        int drawingId;

        WMS.DAL.HydroTestDrawings hydroTestDrawingDAL = new WMS.DAL.HydroTestDrawings();
        WMS.DAL.Drawings drawingDAL = new WMS.DAL.Drawings();
        DataSet drawings = new DataSet();
        drawings = drawingDAL.GetDrawingsByProjectId(1);

        DataTable drawingsTable = drawings.Tables["Drawings"];
        DataRow drawingRow;

        ListItem internalDrawingNumber = new ListItem();
        

        for (int i = 0; i < drawingsTable.Rows.Count; i++)
        {
            drawingRow = drawingsTable.Rows[i];
            internalDrawingNumber.Value = drawingRow["InternalDrawingNumber"].ToString();

            if (drawingRow["DrawingTypeId"].ToString().Equals("1"))
            {
                if (MWPHydroDrawings.Items.Contains(internalDrawingNumber))
                {
                    drawingId = (int)Int32.Parse(drawingRow["DrawingId"].ToString());
                    hydroTestDrawingDAL.AddNewHydroTestDrawing(hydroTestId, drawingId);
                }
            }else if (drawingRow["DrawingTypeId"].ToString().Equals("2"))
            {
                if (CWPHydroDrawings.Items.Contains(internalDrawingNumber))
                {
                    drawingId = (int)Int32.Parse(drawingRow["DrawingId"].ToString());
                    hydroTestDrawingDAL.AddNewHydroTestDrawing(hydroTestId, drawingId);
                }
            }else if (drawingRow["DrawingTypeId"].ToString().Equals("3"))
            {
                if (PNIDHydroDrawings.Items.Contains(internalDrawingNumber))
                {
                    drawingId = (int)Int32.Parse(drawingRow["DrawingId"].ToString());
                    hydroTestDrawingDAL.AddNewHydroTestDrawing(hydroTestId, drawingId);
                }
            }else if (drawingRow["DrawingTypeId"].ToString().Equals("4"))
            {
                if (IsometricHydroDrawings.Items.Contains(internalDrawingNumber))
                {
                    drawingId = (int)Int32.Parse(drawingRow["DrawingId"].ToString());
                    hydroTestDrawingDAL.AddNewHydroTestDrawing(hydroTestId, drawingId);
                }
            }
        }
    }
}