protected void btnInsert_Click(object sender, EventArgs e) { string errorMessage =""; if (Page.IsPostBack) { //get selected table from the session string tableName = Session["tableName"].ToString(); //select case statement for each possible objects switch (tableName) { #region RoofExtrusions //when roof extrusion is selected case "tblRoofExtrusions": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("roofExtrusion"); if (Page.IsValid == true) { //create new object RoofExtrusion aRoofExtrusion = new RoofExtrusion(); aRoofExtrusion.ExtrusionName = txtPartName.Text; aRoofExtrusion.ExtrusionNumber = txtPartNum.Text; aRoofExtrusion.ExtrusionDescription = txtPartDesc.Text; aRoofExtrusion.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aRoofExtrusion.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aRoofExtrusion.AngleA = Convert.ToInt32(txtRoofExtAngleA.Text); aRoofExtrusion.AngleAUnits = "Inches"; aRoofExtrusion.AngleB = Convert.ToInt32(txtRoofExtAngleB.Text); aRoofExtrusion.AngleBUnits = "Inches"; aRoofExtrusion.AngleC = Convert.ToInt32(txtRoofExtAngleC.Text); aRoofExtrusion.AngleCUnits = "Inches"; aRoofExtrusion.ExtrusionColor = ddlColors.SelectedValue; aRoofExtrusion.ExtrusionMaxLength = Convert.ToInt32(txtRoofExtMaxLength.Text); aRoofExtrusion.MaxLengthUnits = ddlRoofExtMaxLengtUnits.SelectedValue; aRoofExtrusion.ExtrusionSize = Convert.ToInt32(txtRoofExtSize.Text); aRoofExtrusion.SizeUnits = ddlRoofExtSizeUnits.SelectedValue; if (Part_Exists("tblRoofExtrusions", aRoofExtrusion.ExtrusionNumber) == true) { } else { //Insert aRoofExtrusion.Insert(datInsertDataSource, "tblRoofExtrusions"); //Set Session Variables for Display Page Session["categoryIndex"] = 5; Session["partIndex"] = 1; Session["partNumber"] = aRoofExtrusion.ExtrusionNumber; //whatever happens here } } break; //more cases here } #endregion #region Accessory case "tblAccessories": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("accessories"); if (Page.IsValid == true) { TextBox tempTxt; Accessories anAccessory = new Accessories(); Session.Add("Accessory", anAccessory); anAccessory.AccessoryName = txtPartName.Text; anAccessory.AccessoryNumber = txtPartNum.Text; anAccessory.AccessoryDescription = txtPartDesc.Text; anAccessory.AccessoryCadPrice = Convert.ToDecimal(txtCadPrice.Text); anAccessory.AccessoryUsdPrice = Convert.ToDecimal(txtUsdPrice.Text); //tempTxt = (TextBox)pnlColor.FindControl("txtColor"); //anAccessory.AccessoryColor = tempTxt.Text; tempTxt = (TextBox)pnlAccessories.FindControl("txtAccessoryWidth"); if (tempTxt.Text.Trim() != "") { anAccessory.AccessoryWidth = Convert.ToInt16(tempTxt.Text); } else { anAccessory.AccessoryWidth = 0; } if (txtPackQuantity.Text.Trim() != "") { anAccessory.AccessoryPackQuantity = Convert.ToInt16(txtPackQuantity.Text); } else { anAccessory.AccessoryPackQuantity = 0; } tempTxt = (TextBox)pnlAccessories.FindControl("txtAccessoryLength"); if (tempTxt.Text.Trim() != "") { anAccessory.AccessoryLength = Convert.ToInt16(tempTxt.Text); } else { anAccessory.AccessoryLength = 0; } anAccessory.AccessoryColor = ddlColors.SelectedValue; anAccessory.AccessoryWidthUnits = ddlAccessoryWidthUnits.SelectedValue; anAccessory.AccessoryLengthUnits = ddlAccessoryLengthUnits.SelectedValue; tempTxt = (TextBox)pnlAccessories.FindControl("txtAccessorySize"); //If they don't enter a size then make it 0 if (tempTxt.Text.Trim() == "") { anAccessory.AccessorySize = 0; } else { anAccessory.AccessorySize = Convert.ToInt16(tempTxt.Text); } anAccessory.AccessorySizeUnits = ddlAccessorySizeUnits.SelectedValue; if (Part_Exists("tblAccessories", anAccessory.AccessoryNumber) == true) { //part does exist, set error message errorMessage = "Could not add" + anAccessory.AccessoryNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert anAccessory.Insert(datInsertDataSource, "tblAccessories"); //Set Required Session Variables for Display Page Session["categoryIndex"] = 1; Session["partIndex"] = 1; Session["partNumber"] = anAccessory.AccessoryNumber; } } } break; #endregion #region DecorativeColumn case "tblDecorativeColumn": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("decorativeColumn"); if (Page.IsValid == true) { DecorativeColumn aDecorativeColumn = new DecorativeColumn(); Session.Add("DecorativeColumn", aDecorativeColumn); aDecorativeColumn.ColumnLength = Convert.ToInt32(txtDecColLength.Text); aDecorativeColumn.ColumnName = txtPartName.Text; aDecorativeColumn.PartNumber = txtPartNum.Text; aDecorativeColumn.ColumnDescription = txtPartDesc.Text; aDecorativeColumn.ColumnCadPrice = Convert.ToDecimal(txtCadPrice.Text); aDecorativeColumn.ColumnUsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aDecorativeColumn.ColumnLength = Convert.ToInt32(txtDecColLength.Text); aDecorativeColumn.ColumnLengthUnits = ddlDecColLengthUnits.SelectedValue; aDecorativeColumn.ColumnColor = ddlColors.SelectedValue; if (Part_Exists("tblDecorativeColumn", aDecorativeColumn.PartNumber) == true) { //part does not exist, set error message //part does exist, set error message errorMessage = "Could not add" + aDecorativeColumn.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert aDecorativeColumn.Insert(datInsertDataSource, "tblDecorativeColumn"); //Set Session Variables for Display Page Session["categoryIndex"] = 2; Session["partIndex"] = 1; Session["partNumber"] = aDecorativeColumn.PartNumber; } } } break; #endregion #region DoorFrameExtrusion case "tblDoorFrameExtrusion": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("doorFrameExtrusion"); if (Page.IsValid == true) { DoorFrameExtrusion aDfe = new DoorFrameExtrusion(); Session.Add("DoorFrameExtrusion", aDfe); aDfe.DfeMaxLength = Convert.ToInt32(txtDoorFrExtMaxLength.Text); aDfe.DfeName = txtPartName.Text; aDfe.PartNumber = txtPartNum.Text; aDfe.DfeDescription = txtPartDesc.Text; aDfe.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aDfe.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aDfe.DfeColor = ddlColors.SelectedValue; aDfe.DfeMaxLength = Convert.ToInt32(txtDoorFrExtMaxLength.Text); aDfe.DfeMaxLengthUnits = ddlDoorFrExtMaxLengthUnits.SelectedValue; if (Part_Exists("tblDoorFrameExtrusion", aDfe.PartNumber) == true) { //part already exists, set error message //part does exist, set error message errorMessage = "Could not add" + aDfe.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert aDfe.Insert(datInsertDataSource, "tblDoorFrameExtrusion"); //Set required session variables for display page //Set Session Variables for Display Page Session["categoryIndex"] = 3; Session["partIndex"] = 1; Session["partNumber"] = aDfe.PartNumber; } } } break; #endregion #region InsulatedFloors case "tblInsulatedFloors": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("insulatedFloor"); Page.Validate("compstand"); if (Page.IsValid == true) { InsulatedFloors anInsulatedFloor = new InsulatedFloors(); Session.Add("InsulatedFloor", anInsulatedFloor); anInsulatedFloor.InsulatedFloorName = txtPartName.Text; anInsulatedFloor.PartNumber = txtPartNum.Text; anInsulatedFloor.InsulatedFloorDescription = txtPartDesc.Text; anInsulatedFloor.InsulatedFloorCadPrice = Convert.ToDecimal(txtCadPrice.Text); anInsulatedFloor.InsulatedFloorUsdPrice = Convert.ToDecimal(txtUsdPrice.Text); anInsulatedFloor.InsulatedFloorComposition = txtComposition.Text; anInsulatedFloor.InsulatedFloorMaxLength = txtInsulatedFloorMaxLength.Text; anInsulatedFloor.InsulatedFloorMaxWidth = Convert.ToInt32(txtInsFloorPnlMaxWidth.Text); anInsulatedFloor.InsulatedFloorMaxWidthUnits = ddlInsFloorPnlMaxWidthUnits.SelectedValue; anInsulatedFloor.InsulatedFloorSize = Convert.ToInt32(txtInsFloorSize.Text); anInsulatedFloor.InsulatedFloorSizeUnits = ddlInsFloorSizeUnits.SelectedValue; if (Part_Exists("tblInsulatedFloors", anInsulatedFloor.PartNumber) == true) { //error messae would go here //part does exist, set error message errorMessage = "Could not add" + anInsulatedFloor.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert anInsulatedFloor.Insert(datInsertDataSource, "tblInsulatedFloors"); //Set Session Variables for Display Page Session["categoryIndex"] = 4; Session["partIndex"] = 1; Session["partNumber"] = anInsulatedFloor.PartNumber; } } } break; #endregion #region aRoofPanel case "tblRoofPanels": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("roofPanel"); Page.Validate("compstand"); if (Page.IsValid == true) { RoofPanels aRoofPanel = new RoofPanels(); Session.Add("RoofPanel", aRoofPanel); aRoofPanel.PanelName = txtPartName.Text; aRoofPanel.PartNumber = txtPartNum.Text; aRoofPanel.PanelDescription = txtPartDesc.Text; aRoofPanel.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aRoofPanel.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aRoofPanel.PanelComposition = txtComposition.Text; //aRoofPanel.PanelMaxLength = txtRoofPnlMaxLength.Text; aRoofPanel.PanelMaxWidth = Convert.ToInt32(txtRoofPnlMaxWidth.Text); aRoofPanel.PanelMaxLength = txtRoofPanelMaxLength.Text; aRoofPanel.MaxWidthUnits = "Inches"; aRoofPanel.PanelSize = Convert.ToInt32(txtRoofPnlSize.Text); aRoofPanel.PanelSizeUnits = "Inches"; aRoofPanel.PanelColor = ddlColors.SelectedValue; aRoofPanel.PanelStandard = txtStandard.Text; if (Part_Exists("tblRoofPanels", aRoofPanel.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aRoofPanel.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { aRoofPanel.Insert(datInsertDataSource, "tblRoofPanels"); //Set Session Variables for Display Page Session["categoryIndex"] = 6; Session["partIndex"] = 1; Session["partNumber"] = aRoofPanel.PartNumber; } } } break; #endregion #region ScreenRoll case "tblScreenRoll": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("screenroll"); if (Page.IsValid == true) { ScreenRoll aScreenRoll = new ScreenRoll(); Session.Add("ScreenRoll", aScreenRoll); aScreenRoll.ScreenRollName = txtPartName.Text; aScreenRoll.PartNumber = txtPartNum.Text; aScreenRoll.ScreenRollWidth = Convert.ToInt32(txtScreenRollWidth.Text); aScreenRoll.ScreenRollWidthUnits = ddlScreenRollWidthUnits.SelectedValue; aScreenRoll.ScreenRollLength = Convert.ToInt32(txtScreenRollLength.Text); aScreenRoll.ScreenRollLengthUnits = ddlScreenRollLengthUnits.SelectedValue; aScreenRoll.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aScreenRoll.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); if (Part_Exists("tblScreenRoll", aScreenRoll.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aScreenRoll.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //insert aScreenRoll.Insert(datInsertDataSource, "tblScreenRoll"); //Set Session Variables for Display Page Session["categoryIndex"] = 8; Session["partIndex"] = 1; Session["partNumber"] = aScreenRoll.PartNumber; } } } break; #endregion #region SunrcylicRoof case "tblSuncrylicRoof": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("suncrylicroof"); if (Page.IsValid == true) { SuncrylicRoof aSuncrylicRoof = new SuncrylicRoof(); Session.Add("SunCrylicRoof", aSuncrylicRoof); aSuncrylicRoof.SuncrylicName = txtPartName.Text; aSuncrylicRoof.PartNumber = txtPartNum.Text; aSuncrylicRoof.SuncrylicDescription = txtPartDesc.Text; aSuncrylicRoof.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aSuncrylicRoof.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aSuncrylicRoof.SuncrylicColor = ddlColors.SelectedValue; aSuncrylicRoof.SuncrylicMaxLength = Convert.ToInt32(txtSunRoofMaxLength.Text); aSuncrylicRoof.SuncrylicLengthUnits = ddlSunRoofMaxLengthUnits.SelectedValue; if (Part_Exists("tblSuncrylicRoof", aSuncrylicRoof.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aSuncrylicRoof.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert aSuncrylicRoof.Insert(datInsertDataSource, "tblSuncrylicRoof"); //Set Session Variables for Display Page Session["categoryIndex"] = 9; Session["partIndex"] = 1; Session["partNumber"] = aSuncrylicRoof.PartNumber; } } } break; #endregion #region Sunrail1000 case "tblSunrail1000": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("sunrail1000"); if (Page.IsValid == true) { Sunrail1000 aSunrail1000 = new Sunrail1000(); Session.Add("Sunrail1000", aSunrail1000); aSunrail1000.Sunrail1000Name = txtPartName.Text; aSunrail1000.PartNumber = txtPartNum.Text; aSunrail1000.Sunrail1000Description = txtPartDesc.Text; aSunrail1000.Sunrail1000CadPrice = Convert.ToDecimal(txtCadPrice.Text); aSunrail1000.Sunrail1000UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aSunrail1000.Sunrail1000Color = ddlColors.SelectedValue; //Check if they entered a value //If not then insert null into the database if (((txtSun1000MaxLengthFt.Text.Trim()) == "") || Convert.ToInt32(txtSun1000MaxLengthFt.Text) == 0) { aSunrail1000.Sunrail1000MaxLengthFeet = 0; aSunrail1000.Sunrail1000MaxLengthFeetUnits = null; } else //insert data they entered { aSunrail1000.Sunrail1000MaxLengthFeet = Convert.ToInt32(txtSun1000MaxLengthFt.Text); aSunrail1000.Sunrail1000MaxLengthFeetUnits = "Feet"; } if ((txtSun1000PnlMaxLengthInch.Text.Trim() == "") || (Convert.ToInt32(txtSun1000PnlMaxLengthInch.Text) == 0)) { aSunrail1000.Sunrail1000MaxLengthInches = null; aSunrail1000.Sunrail1000MaxLengthInchesUnits = null; } else { aSunrail1000.Sunrail1000MaxLengthInches = Convert.ToInt32(txtSun1000PnlMaxLengthInch.Text); aSunrail1000.Sunrail1000MaxLengthInchesUnits = "Inches"; } if (Part_Exists("tblSunrail1000", aSunrail1000.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aSunrail1000.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //insert aSunrail1000.Insert(datInsertDataSource, "tblSunrail1000"); //Set Session Variables for Display Page Session["categoryIndex"] = 10; Session["partIndex"] = 1; Session["partNumber"] = aSunrail1000.PartNumber; } } } break; #endregion #region Sunrail300 case "tblSunrail300": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("sunrail300"); if (Page.IsValid == true) { Sunrail300 aSunrail300 = new Sunrail300(); Session.Add("Sunrail300", aSunrail300); //Name aSunrail300.Sunrail300Name = txtPartName.Text; //Part Number aSunrail300.PartNumber = txtPartNum.Text; //Descriptions aSunrail300.Sunrail300Description = txtPartDesc.Text; //Prices aSunrail300.Sunrail300CadPrice = Convert.ToDecimal(txtCadPrice.Text); aSunrail300.Sunrail300UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); //Color aSunrail300.Sunrail300Color = ddlColors.SelectedValue; //Max Length Feet aSunrail300.Sunrail300MaxLengthFeet = Convert.ToInt32(txtSun300MaxLengthFt.Text); aSunrail300.Sunrail300MaxLengthFeetUnits = "Feet"; //Max Length Inch //If user enters nothing or 0, place a null in the Inches field if (txtSun300PnlMaxLengthInch.Text == "" || Convert.ToInt32(txtSun300PnlMaxLengthInch.Text) == 0) { aSunrail300.Sunrail300MaxLengthInches = null; aSunrail300.Sunrail300MaxLengthInchesUnits = null; //place nulls } else { aSunrail300.Sunrail300MaxLengthInches = Convert.ToInt32(txtSun300PnlMaxLengthInch.Text); aSunrail300.Sunrail300MaxLengthInchesUnits = "Inches"; } //Set Session Variables for Display Page if (Part_Exists("tblSunrail300", aSunrail300.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aSunrail300.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { Session["categoryIndex"] = 11; Session["partIndex"] = 1; Session["tableName"] = "tblSunrail300"; Session["partNumber"] = aSunrail300.PartNumber; aSunrail300.Insert(datInsertDataSource, "tblSunrail300"); } } } break; #endregion #region Sunrail300Accessory case "tblSunrail300Accessories": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("sunrail300accessories"); if (Page.IsValid == true) { Sunrail300Accessories aSunrail300Accessory = new Sunrail300Accessories(); Session.Add("Sunrail300Accessory", aSunrail300Accessory); aSunrail300Accessory.Sunrail300AccessoriesName = txtPartName.Text; aSunrail300Accessory.PartNumber = txtPartNum.Text; aSunrail300Accessory.Sunrail300AccessoriesDescription = txtPartDesc.Text; aSunrail300Accessory.Sunrail300AccessoriesCadPrice = Convert.ToDecimal(txtCadPrice.Text); aSunrail300Accessory.Sunrail300AccessoriesUsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aSunrail300Accessory.Sunrail300AccessoriesColor = ddlColors.SelectedValue; if (Part_Exists("tblSunrail300Accessories", aSunrail300Accessory.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aSunrail300Accessory.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { aSunrail300Accessory.Insert(datInsertDataSource, "tblSunrail300Accessories"); //Set Session Variables for Display Page Session["categoryIndex"] = 12; Session["partIndex"] = 1; Session["partNumber"] = aSunrail300Accessory.PartNumber; } } } break; #endregion #region Sunrail400 case "tblSunrail400": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("sunrail400"); if (Page.IsValid == true) { Sunrail400 aSunrail400 = new Sunrail400(); Session.Add("Sunrail400", aSunrail400); //Name aSunrail400.Sunrail400Name = txtPartName.Text; //Number aSunrail400.PartNumber = txtPartNum.Text; //Description aSunrail400.Sunrail400Description = txtPartDesc.Text; //Prices aSunrail400.Sunrail400CadPrice = Convert.ToDecimal(txtCadPrice.Text); aSunrail400.Sunrail400UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); //Max Length in Feet aSunrail400.Sunrail400MaxLengthFeet = Convert.ToInt32(txtSun400MaxLengthFt.Text); aSunrail400.Sunrail400MaxLengthFeetUnits = "Feet"; //Color aSunrail400.Sunrail400Color = ddlColors.SelectedValue; //Max Length in Inches //If user enters 0 or nothiung for the inches, we don't want the display page to show it //So set both to null in the object. if ((txtSun400PnlMaxLengthInch.Text == "") || (Convert.ToInt32(txtSun400PnlMaxLengthInch.Text) == 0)) { aSunrail400.Sunrail400MaxLengthInches = null; aSunrail400.Sunrail400MaxLengthInchesUnits = null; } else //Insert the values they entered for inches into the database { aSunrail400.Sunrail400MaxLengthInches = Convert.ToInt32(txtSun400PnlMaxLengthInch.Text); aSunrail400.Sunrail400MaxLengthInchesUnits = "Inches"; } //Check if part number already exists if (Part_Exists("tblSunrail400", aSunrail400.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aSunrail400.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert into the database aSunrail400.Insert(datInsertDataSource, "tblSunrail400"); //Set Session Variables for Display Page Session["categoryIndex"] = 13; Session["partIndex"] = 1; Session["partNumber"] = aSunrail400.PartNumber; } } } break; #endregion #region VinylRoll case "tblVinylRoll": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("vinylroll"); if (Page.IsValid == true) { VinylRoll aVinylRoll = new VinylRoll(); Session.Add("VinylRoll", aVinylRoll); //Name aVinylRoll.VinylRollName = txtPartName.Text; //Number aVinylRoll.PartNumber = txtPartNum.Text; //Prices aVinylRoll.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aVinylRoll.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); //Length //Weight aVinylRoll.VinylRollWeight = Convert.ToInt32(txtVinylRollWeight.Text); aVinylRoll.VinylRollWeightUnits = ddlVinylRollWeightUnits.SelectedValue; //Width aVinylRoll.VinylRollWidth = Convert.ToInt32(txtVinylRollWidth.Text); aVinylRoll.VinylRollWidthUnits = ddlVinylRollWidthUnits.SelectedValue; //Color aVinylRoll.VinylRollColor = ddlColors.SelectedValue; //Check is part number is already in database if (Part_Exists("tblVinylRoll", aVinylRoll.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aVinylRoll.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //Insert into the database aVinylRoll.Insert(datInsertDataSource, "tblVinylRoll"); } //Set Session Variables for Display Page Session["categoryIndex"] = 14; Session["partIndex"] = 1; Session["partNumber"] = aVinylRoll.PartNumber; } } break; #endregion #region WallExtrusions case "tblWallExtrusions": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("wallExtrusion"); if (Page.IsValid == true) { WallExtrusions aWallExtrusion = new WallExtrusions(); Session.Add("WallExtrusions", aWallExtrusion); aWallExtrusion.WallExtrusionName = txtPartName.Text; aWallExtrusion.PartNumber = txtPartNum.Text; aWallExtrusion.WallExtrusionDescription = txtPartDesc.Text; aWallExtrusion.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aWallExtrusion.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); aWallExtrusion.WallExtrusionColor = ddlColors.SelectedValue; aWallExtrusion.WallExtrusionMaxLength = Convert.ToInt32(txtWallExtLength.Text); aWallExtrusion.LengthUnits = ddlWallExtLengthUnits.SelectedValue; if (Part_Exists("tblWallExtrusions", aWallExtrusion.PartNumber) == true) { //error message //part does exist, set error message errorMessage = "Could not add" + aWallExtrusion.PartNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { //insert aWallExtrusion.Insert(datInsertDataSource, "tblWallExtrusions"); //Set Session Variables for Display Page Session["categoryIndex"] = 15; Session["partIndex"] = 1; Session["partNumber"] = aWallExtrusion.PartNumber; } } } break; #endregion #region WallPanels case "tblWallPanels": { Page.Validate("productInfo"); Page.Validate("pricing"); Page.Validate("wallPanel"); Page.Validate("compstand"); if (Page.IsValid == true) { WallPanels aWallPanel = new WallPanels(); Session.Add("WallPanel", aWallPanel); //Name aWallPanel.WallPanelName = txtPartName.Text; //Number aWallPanel.WallPanelNumber = txtPartNum.Text; //Description aWallPanel.WallPanelDescription = txtPartDesc.Text; //Prices aWallPanel.CadPrice = Convert.ToDecimal(txtCadPrice.Text); aWallPanel.UsdPrice = Convert.ToDecimal(txtUsdPrice.Text); //Color aWallPanel.WallPanelColor = ddlColors.SelectedValue; //Composition aWallPanel.WallPanelComposition = txtComposition.Text; //Standard aWallPanel.WallPanelStandard = txtStandard.Text; //Size aWallPanel.WallPanelSize = Convert.ToInt32(txtWallPnlSize.Text); aWallPanel.SizeUnits = ddlWallPnlSizeUnits.SelectedValue; //Max Length aWallPanel.WallPanelMaxLength = Convert.ToInt32(txtWallPnlMaxLength.Text); aWallPanel.LengthUnits = ddlWallPnlMaxLengthUnits.SelectedValue; //Max Width aWallPanel.WallPanelMaxWidth = Convert.ToInt32(txtWallPnlMaxWidth.Text); aWallPanel.WidthUnits = ddlWallPnlMaxWidthUnits.SelectedValue; if (Part_Exists("tblWallPanels", aWallPanel.WallPanelNumber) == true) { //error //part does exist, set error message errorMessage = "Could not add" + aWallPanel.WallPanelNumber + ". Part Number already exists."; valPartExists.Text = errorMessage; } else { aWallPanel.Insert(datInsertDataSource, "tblWallPanels"); //Set Session Variables for Display Page Session["categoryIndex"] = 16; Session["partIndex"] = 1; Session["partNumber"] = aWallPanel.WallPanelNumber; } } break; } #endregion } if ((Page.IsValid == true) && (errorMessage=="")) { //Check to see if temp picture exists if (System.IO.File.Exists(Server.MapPath("Images/catalogue/temp.jpg"))) { //Save picture System.IO.File.Copy(Server.MapPath("Images/catalogue/temp.jpg"), Server.MapPath("Images/catalogue/" + Session["partNumber"].ToString() + ".jpg"), true); } //redirect to Display.aspx Response.Redirect("Display.aspx"); } } }