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); } } } } }