public void UpdateSellingPrice(IList parts)
{
foreach (Part p in parts)
{
OpenConnection();
m_cmd.CommandText = p.updateSellingPrice();
m_cmd.ExecuteNonQuery();
m_cmd.CommandText = UnitConversion.GetByPartAndUnitConIDSQL(p.ID, p.UNIT.ID);
MySql.Data.MySqlClient.MySqlDataReader r = m_cmd.ExecuteReader();
UnitConversion uc = UnitConversion.GetUnitConversion(r);
r.Close();
if (uc == null)
{
continue;
}
uc.SELL_PRICE = p.NEW_SELL_PRICE;
m_cmd.CommandText = uc.GetUpdateSQL();
m_cmd.ExecuteNonQuery();
}
}
public override void Update(IEntity en)
{
OpenConnection();
MySql.Data.MySqlClient.MySqlTransaction trans = m_connection.BeginTransaction();
MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand();
aCommand.Connection = m_connection;
aCommand.Transaction = trans;
try
{
Part e = (Part)en;
aCommand.CommandText = e.GetUpdateSQL();
this.SavePicture(e.PICTURE, e.CODE);
aCommand.ExecuteNonQuery();
//Update base unit---------------------------
aCommand.CommandText = UnitConversion.GetByPartAndUnitConIDSQL(e.ID, e.UNIT.ID);
MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader();
UnitConversion uc = UnitConversion.GetUnitConversion(r);
r.Close();
if (uc == null)
{
uc = new UnitConversion();
}
uc.BARCODE = e.BARCODE;
uc.CONVERSION_QTY = 1;
uc.CONVERSION_UNIT = e.UNIT;
uc.COST_PRICE = e.COST_PRICE;
uc.ORIGINAL_QTY = 1;
uc.PART = e;
uc.SELL_PRICE = e.SELL_PRICE;
e.UNIT_CONVERSION_LIST.Add(uc);
//------------------------------
foreach (UnitConversion ucp in e.UNIT_CONVERSION_LIST)
{
if (ucp.ID > 0)
{
aCommand.CommandText = ucp.GetUpdateSQL();
aCommand.ExecuteNonQuery();
}
else
{
aCommand.CommandText = ucp.GetInsertSQL();
aCommand.ExecuteNonQuery();
aCommand.CommandText = ucp.GetMaximumIDSQL();
ucp.ID = Convert.ToInt32(aCommand.ExecuteScalar());
}
}
aCommand.CommandText = UnitConversion.DeleteUpdate(e.ID, e.UNIT_CONVERSION_LIST);
aCommand.ExecuteNonQuery();
//IList luc = UnitConversion.GetAllStatic(r);
//r.Close();
//foreach (UnitConversion chk in luc)
//{
// chk.UPDATED = e.UNIT_CONVERSION_LIST.Contains(chk);
//}
//foreach (UnitConversion chk in luc)
//{
// if (!chk.UPDATED)
// {
// aCommand.CommandText = chk.GetDeleteSQL();
// aCommand.ExecuteNonQuery();
// }
//}
trans.Commit();
}
catch (Exception x)
{
trans.Rollback();
throw new Exception(getErrorMessage(x));
}
finally
{
m_connection.Close();
}
}
