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