public void add7upProduct(s7upDTO invoice7upDTO)
{
// databaseConnection.databaseOpenConnection();
sqlConnection.Open();
String update = "update sUp set sUp2L=" + invoice7upDTO.S2L + ",sUp1L=" + invoice7upDTO.S1L + ",sUp500ml=" + invoice7upDTO.S500ML + ",sUp250pet=" + invoice7upDTO.S250MLPET + ",sUp250mlGlass=" + invoice7upDTO.S250MLGRB + ",sUp200mlGlass=" + invoice7upDTO.S200MLGRB + ",sUp250mlCan=" + invoice7upDTO.S200MLGRB + " where sUpID=" + id + " ";
sqlCommand = new SqlCommand(update, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public void add7upProductPrice(s7upDTO invoice7upDTO)
{
// databaseConnection.databaseOpenConnection();
sqlConnection.Open();
String update = "update sUpPrice set sUp2Lp=" + invoice7upDTO.S2L + ",sUp1Lp=" + invoice7upDTO.S1L + ",sUp500mlp=" + invoice7upDTO.S500ML + ",sUp250mlpetp=" + invoice7upDTO.S250MLPET + ",sUp250mlglassp=" + invoice7upDTO.S250MLGRB + ",sUp200mlglassp=" + invoice7upDTO.S200MLGRB + ",sUp250mlcanp=" + invoice7upDTO.S200MLGRB + " where sUpPriceID=" + id + " ";
sqlCommand = new SqlCommand(update, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}