public static void OverwriteOrder(IEnumerable <Product_User> newOrderList, string barcode)
{
User user = UserHandler.GetByBarCode(barcode);
string sql = "DELETE FROM {0} WHERE userid=@userid;";
if (newOrderList.Where(x => x.amount > 0).Count() > 0)
{
sql += @" INSERT INTO {0} (userid, produkteid, amount) VALUES {1}; ";
sql = String.Format(sql, Product_User.getDbName(),
generateValueOrder(newOrderList));
}
else
{
sql = String.Format(sql, Product_User.getDbName());
}
using (IDbConnection db = new SqlConnection(ConnectionHandler.getConnectionString()))
db.Execute(sql, new { userid = user.id });
}
public User Get(string barcode)
{
return(UserHandler.GetByBarCode(barcode));
}