public static void RecordSale(Sale sale) { string sql = "SELECT MAX(saleId) FROM `cafe_sales`"; MySqlCommand cmd = new MySqlCommand(sql, conn); object result = cmd.ExecuteScalar(); int saleId = Convert.ToInt32(result) + 1; //Hämta högsta saleId och öka med 1 string type = sale.arbetsGladje == true ? "work" : "default"; sql = "INSERT INTO `cafe_sales` (saleId, articleId, timestamp, income, cost, type, discountId, invoiceId) VALUES (\'" + saleId + "\', \'" + sale.articleID + "\', NOW(), \'" + sale.price + "\', \'" + sale.cost + "\', \'" + type + "\', \'0\', \'0\')"; cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); }
public static Sale ArticleNameToSale(string articleName) { Sale sale = new Sale(); IEnumerable<Article> articles = from a in articleTable where a.name == articleName select a; Article article = articles.First(); sale.articleID = article.id; sale.price = article.price; sale.cost = article.cost; sale.arbetsGladje = false; return sale; }