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))); }