private static void updateinventorylogonsale(int productid, double productquantity, int saleid, string comment) { var inventorylogrepo = new inventorylogrepo(); data.dapper.inventorylog ir = new inventorylog(); ir.quantity = -productquantity; ir.date = DateTime.Now; ir.fk_product_in_inventorylog = productid; ir.note = "Detucted inventory on sale id " + saleid + comment; inventorylogrepo.save(ir); }
private static void updateinventorylogonpurchase(int productid, double productquantity, int purchaseid, string inventorylogcomment) { var inventorylogrepo = new inventorylogrepo(); data.dapper.inventorylog ir = new inventorylog(); ir.quantity = productquantity; ir.date = DateTime.Now; ir.fk_product_in_inventorylog = productid; ir.note = "Added inventory on purchase id " + purchaseid + inventorylogcomment; inventorylogrepo.save(ir); }
public static void updateinventorylogonproductcreate(data.dapper.product p) { if (p.quantity != 0) { var inventorylogrepo = new inventorylogrepo(); data.dapper.inventorylog ir = new inventorylog(); ir.quantity = p.quantity; ir.date = DateTime.Now; ir.fk_product_in_inventorylog = p.id; ir.note = "Added inventory on product create"; inventorylogrepo.save(ir); } }
public static void updateinventorylogonproductupdate(int productid, double newinventory, double oldinventory) { if (newinventory == oldinventory) { return; } var inventorylogrepo = new inventorylogrepo(); data.dapper.inventorylog ir = new inventorylog(); ir.date = DateTime.Now; ir.fk_product_in_inventorylog = productid; ir.quantity = newinventory - oldinventory; if (newinventory > oldinventory) { ir.note = "Added inventory on product update"; } else if (newinventory < oldinventory) { ir.note = "Detucted inventory on product update"; } inventorylogrepo.save(ir); }