//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string partNum)
{
dataSource.UpdateCommand = "UPDATE tblSchematicParts SET usdPrice=" + PartUsdPrice
+ ", cadPrice=" + PartCadPrice
+ " WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string partNum)
{
int bitStatus;
if (SchematicStatus)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE tblSchematics SET description ='" + SchematicDescription + "', usdPrice=" + SchematicUsdPrice
+ ", cadPrice=" + SchematicCadPrice + ", status=" + bitStatus +
" WHERE schematicNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (Sunrail300AccessoriesStatus)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET description ='" + Sunrail300AccessoriesDescription + "', usdPrice=" + Sunrail300AccessoriesUsdPrice + ", cadPrice=" + Sunrail300AccessoriesCadPrice + ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (Status)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET width =" + VinylRollWidth + ", widthUnits='" + VinylRollWidthUnits + "', weight=" + VinylRollWeight + ", weightUnits='" + VinylRollWeightUnits
+ "', usdPrice=" + UsdPrice + ", cadPrice=" + CadPrice + ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (Sunrail400Status)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET description ='" + Sunrail400Description + "', maxLengthFeet=" + Sunrail400MaxLengthFeet + ", maxLengthInches="
+ Sunrail400MaxLengthInches + ", usdPrice=" + Sunrail400UsdPrice + ", cadPrice=" + Sunrail400CadPrice + ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (Status)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET description ='" + wallExtrusionDescription + "', maxLength=" + wallExtrusionMaxLength + ", lengthUnits='" + LengthUnits + "', usdPrice=" + UsdPrice
+ ", cadPrice=" + CadPrice + ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (Status)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET description ='" + PanelDescription + "', composition='" + PanelComposition + "', standard='" + PanelStandard + "', color='" + PanelColor + "', size=" + PanelSize
+ ", sizeUnits='" + PanelSizeUnits
+ "', maxWidth=" + PanelMaxWidth + ", widthUnits='" + MaxWidthUnits + "', maxLength='" + PanelMaxLength + "', usdPrice=" + UsdPrice
+ ", cadPrice=" + CadPrice + ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (InsulatedFloorStatus)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET description ='" + InsulatedFloorDescription + "', composition='" + InsulatedFloorComposition
+ "', size=" + InsulatedFloorSize + ", sizeUnits='" + InsulatedFloorSizeUnits
+ "', maxWidth=" + InsulatedFloorMaxWidth + ", widthUnits='" + InsulatedFloorMaxWidthUnits
+ "', maxLength='" + InsulatedFloorMaxLength + "', usdPrice=" + InsulatedFloorUsdPrice
+ ", cadPrice=" + InsulatedFloorCadPrice + ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}
//Database update
public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum)
{
int bitStatus;
if (accessoryStatus)
{
bitStatus = 1;
}
else
{
bitStatus = 0;
}
dataSource.UpdateCommand = "UPDATE " + table
+ " SET description ='" + AccessoryDescription + "', packQuantity=" + AccessoryPackQuantity + ", width=" + AccessoryWidth
+ ", widthUnits='" + AccessoryWidthUnits + "', length=" + AccessoryLength + ", lengthUnits='" + AccessoryLengthUnits
+ "', size=" + AccessorySize + ", sizeUnits='" + AccessorySizeUnits
+ "', usdPrice=" + AccessoryUsdPrice + ", cadPrice=" + AccessoryCadPrice
+ ", status=" + bitStatus +
" WHERE partNumber = '" + partNum + "'";
dataSource.Update();
}