public void getItem()
        {
            GlazingRepository glazrRepository = new GlazingRepository();
            Glazing           myGlazing       = new Glazing();

            myGlazing = glazrRepository.Select(sPrjnoFromDwg, sModelnoFromDwg, elevationName);
            txtBoxSPTotalWallArea.Text        = Convert.ToString(myGlazing.TotalSpWallAraea);
            txtBoxSPLimitingDistance.Text     = Convert.ToString(myGlazing.SptLimitingDistance);
            txtBoxSPAllpowablePct.Text        = Convert.ToString(myGlazing.SpAllowablePercrntage);
            txtBoxSPAllowableOpenings.Text    = Convert.ToString(myGlazing.SpAllowableOpenings);
            txtBoxSPActualOpenings.Text       = Convert.ToString(myGlazing.SpActualOpenings);
            txtBoxGZFstFloorPeriPheral.Text   = Convert.ToString(myGlazing.FirstFloorPeripheral);
            txtBoxGzFstFloorHeight.Text       = Convert.ToString(myGlazing.FirstFloorHeight);
            txtBoxGzWDSecFloorPeripheral.Text = Convert.ToString(myGlazing.SecondFloorHeight);
            txtBoxGzThrdFloorPeripheral.Text  = Convert.ToString(myGlazing.ThirdFloorPeripheral);
            txtBoxGzThrdFloorHeight.Text      = Convert.ToString(myGlazing.ThirdFloorHeight);
            txtBoxForthFloorPeripheral.Text   = Convert.ToString(myGlazing.FourthFloorPeripheral);
            txtBoxGzforthFloorHeight.Text     = Convert.ToString(myGlazing.FourthFloorHeight);
            txtBoxGzTotalSFArea.Text          = Convert.ToString(myGlazing.PeriPheralSquareFootArea);
            txtBoxGzTotalSMArea.Text          = Convert.ToString(myGlazing.PeriPheralSquareMeterArea);
            txtBoxFront.Text   = Convert.ToString(myGlazing.FrontArea);
            textBoxRear.Text   = Convert.ToString(myGlazing.RearArea);
            txtBoxLeft.Text    = Convert.ToString(myGlazing.LeftArea);
            txtBoxRight.Text   = Convert.ToString(myGlazing.RightArea);
            txtBoxSFTotal.Text = Convert.ToString(myGlazing.TotalGlazingSquareFootArea);
            txtBoxSMTotal.Text = Convert.ToString(myGlazing.TotalGlazingSquareMeterArea);
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            Glazing glaze = new Glazing();

            glaze.ProjectNumber             = sPrjnoFromDwg;
            glaze.ModelNumber               = sModelnoFromDwg;
            glaze.Elevation                 = elevationName;
            glaze.TotalSpWallAraea          = getDoubleValue(txtBoxSPTotalWallArea.Text);
            glaze.SptLimitingDistance       = getDoubleValue(txtBoxSPLimitingDistance.Text);
            glaze.SpAllowablePercrntage     = getDoubleValue(txtBoxSPAllpowablePct.Text);
            glaze.SpAllowableOpenings       = getDoubleValue(txtBoxSPAllowableOpenings.Text);
            glaze.SpActualOpenings          = getDoubleValue(txtBoxSPActualOpenings.Text);
            glaze.FirstFloorPeripheral      = getDoubleValue(txtBoxGZFstFloorPeriPheral.Text);
            glaze.FirstFloorHeight          = getDoubleValue(txtBoxGzFstFloorHeight.Text);
            glaze.SecondFloorPeripheral     = getDoubleValue(txtBoxGzWDSecFloorPeripheral.Text);
            glaze.SecondFloorHeight         = getDoubleValue(txtBoxGzSecFloorHeight.Text);
            glaze.ThirdFloorPeripheral      = getDoubleValue(txtBoxGzThrdFloorPeripheral.Text);
            glaze.ThirdFloorHeight          = getDoubleValue(txtBoxGzThrdFloorHeight.Text);
            glaze.FourthFloorPeripheral     = getDoubleValue(txtBoxForthFloorPeripheral.Text);
            glaze.FourthFloorHeight         = getDoubleValue(txtBoxGzforthFloorHeight.Text);
            glaze.PeriPheralSquareFootArea  = getDoubleValue(txtBoxGzTotalSFArea.Text);
            glaze.PeriPheralSquareMeterArea = getDoubleValue(txtBoxGzTotalSMArea.Text);
            glaze.FrontArea                 = getDoubleValue(txtBoxFront.Text);
            glaze.RearArea  = getDoubleValue(textBoxRear.Text);
            glaze.LeftArea  = getDoubleValue(textBoxRear.Text);
            glaze.RightArea = getDoubleValue(txtBoxRight.Text);
            glaze.TotalGlazingSquareFootArea  = getDoubleValue(txtBoxSFTotal.Text);
            glaze.TotalGlazingSquareMeterArea = getDoubleValue(txtBoxSMTotal.Text);
            //gz.TotalGlazingPercentage= Convert.ToDouble();todo
            //result = (gridCol1 ) ? Convert.ToDouble(gridCol1) : defaultArea
            GlazingRepository glazrRepository = new GlazingRepository();

            glazrRepository.Add(glaze);
            System.Windows.Forms.MessageBox.Show("Record is added successfully");
        }