public static List <UnitProductConnection> GetUnitPorductConnections()
{
MySqlCommand cmd = new MySqlCommand("GetUnitProductConnection", new MySqlConnection(connectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <UnitProductConnection> connections = new List <UnitProductConnection>();
while (rdr.Read())
{
UnitProductConnection connection = new UnitProductConnection();
connection.ConnectionId = int.Parse(rdr[0].ToString());
connection.ButtonId = int.Parse(rdr[1].ToString());
connection.ProductId = int.Parse(rdr[2].ToString());
connection.amount = double.Parse(rdr[3].ToString());
connections.Add(connection);
}
rdr.Close();
return(connections);
}
private void AddProductToUnit(int id, double amount)
{
Product productToAdd = ProductsHolder.products.Find(p => p.id == id);
//Product already exists
if (unitProducts.FindAll(product => product.id == productToAdd.id).Count > 0)
{
//increase amount localy
unitProducts.Where(product => product.id == productToAdd.id).FirstOrDefault().inUnit += amount;
//get connection info
int productId = unitProducts.Where(product => product.id == productToAdd.id).FirstOrDefault().id;
double increasedAmount = unitProducts.Where(product => product.id == productToAdd.id).FirstOrDefault().inUnit;
//increase amount in database
try
{
ButtonsClient.UpdateUnitProductConnection(btnId, productId, increasedAmount);
}
catch (Exception)
{
MessageBox.Show("Failed to update database");
}
}
//product does not exists in this unit
else
{
//add to local
unitProducts.Add(new ProductDisplay(productToAdd, amount));
//Get connectionID
connectionID = UnitProductConnectionHolder.Connections.Count == 0 ? 0 : UnitProductConnectionHolder.Connections.Max(con => con.ConnectionId) + 1;
//create connection
var connection = new UnitProductConnection
{
ConnectionId = connectionID,
ButtonId = btnId,
ProductId = productToAdd.id,
amount = amount
};
//add to database
try
{
ButtonsClient.AddUnitProuductConnection(connection);
}
catch (Exception)
{
MessageBox.Show("Failed to add to database");
}
//add to holder
UnitProductConnectionHolder.Connections.Add(connection);
}
dgvUnitProducts.DataSource = null;
dgvUnitProducts.DataSource = unitProducts;//get from local
}
public static void AddUnitProuductConnection(UnitProductConnection connection)
{
MySqlCommand cmd = new MySqlCommand("CreateUnitProductConnection", new MySqlConnection(connectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("_bondID", connection.ConnectionId));
cmd.Parameters.Add(new MySqlParameter("_btnID", connection.ButtonId));
cmd.Parameters.Add(new MySqlParameter("_productID", connection.ProductId));
cmd.Parameters.Add(new MySqlParameter("_amount", connection.amount));
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
public static void AddUnitProuductConnection(UnitProductConnection connection)
{
TcpClient.sendObject <UnitProductConnection>(new DBMsg(ManagerType.ButtonsManager, "AddUnitProuductConnection", JsonConvert.SerializeObject(connection)));
}
