public List <InvoiceItemcs> getAllAccounts() { List <InvoiceItemcs> ListAccount = new List <InvoiceItemcs>(); string Query = "SELECT id, code, name, price, quantity, codeinvoice, nota FROM facturaitem WHERE active=1;"; MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection()); MySqlDataReader reader; reader = Cmm.ExecuteReader(); Cmm.Connection.Close(); if (reader.HasRows) { while (reader.Read()) { newItem = new InvoiceItemcs(); newItem.Id = (int)reader["id"]; newItem.Code = (string)reader["code"]; newItem.Name = (string)reader["name"]; newItem.Price = (double)reader["price"]; newItem.Quantity = (int)reader["quantity"]; newItem.CodeInvoice = (string)reader["codeinvoice"]; newItem.Note = (string)reader["nota"]; ListAccount.Add(newItem); } } return(ListAccount); }
public void insertItemInvoice(InvoiceItemcs _ItemInvoice) { try { Query = "INSERT INTO facturaitem(code, name, price, quantity, codeinvoice, nota) values('" + _ItemInvoice.Code.Trim() + "','" + _ItemInvoice.Name.Trim() + "','" + _ItemInvoice.Price.ToString() + "','" + _ItemInvoice.Quantity + "','" + _ItemInvoice.CodeInvoice + "','" + _ItemInvoice.Note + "');"; MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection()); Cmm.ExecuteNonQuery(); Cmm.Connection.Close(); updateStock(_ItemInvoice.Code, _ItemInvoice.Quantity); } catch (Exception ex) { MessageBox.Show(ex.Message + "\ninsertBand", "Error del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error); } }