public static void Set() { RepositoryHistoryChangeProduct.LoadFile(); RepositoryActionHashBox.Sync(); RepositoryProductBc.Sync(); if (SyncData.IsConnect) { if (GetAbCountFromDb() > 1000 || Config.FromLoadSyncAll || !GlobalVar.IsOpen) { Config.FromLoadSyncAll = false; } else { SyncSingleProduct(); } } else { Sync(); Config.FromLoadSyncAll = false; } Sync(); RepositoryCountry.Sync(); if (SyncData.IsConnect) { RepositoryLastUpdate.Update(false); } }
private static void UpdateFromDb(ProductType product) { product.Date = DateTime.Now; using (var connection = ConnectionFactory.CreateConnection()) { connection.Open(); var trans = connection.BeginTransaction(); var res = connection.Execute(QueryUpdateProd, product, trans); if (res != 1) { trans.Rollback(); return; } res = connection.Execute(QueryUpdateStockReal, new { product.Qty, product.Price, product.CustomerId, Config.IdEstablishment, product.CusumerIdRealStock }, trans); if (res != 1) { trans.Rollback(); return; } trans.Commit(); } RepositoryLastUpdate.Update(true); }
private static void AddToDb(ProductType product) { product.Date = DateTime.Now; using (var connection = ConnectionFactory.CreateConnection()) { connection.Open(); var trans = connection.BeginTransaction(); var res = connection.Execute(QueryInsertWeb, new { product.ProductsWebCustomerId }, trans); if (res <= 0) { trans.Rollback(); } res = connection.Execute(QueryInsertProd, product, trans); if (res <= 0) { trans.Rollback(); } res = connection.Execute(QueryInsertStockReal, new { product.CusumerIdRealStock, product.Qty, product.Price, product.CustomerId, Config.IdEstablishment }, trans); if (res <= 0) { trans.Rollback(); } trans.Commit(); } RepositoryLastUpdate.Update(true); }
private static void DeleteFromDb(ProductType product) { const string queryDeleteFromStockReal = "DELETE FROM StockReal WHERE ProductsCustumerId = @CustomerId"; const string queryDeleteFromProducts = "DELETE FROM Products WHERE CustumerId= @CustomerId"; const string queryDeleteFromProductsWeb = "DELETE FROM ProductsWeb WHERE CustomerId= @ProductsWebCustomerId"; using (var connection = ConnectionFactory.CreateConnection()) { connection.Open(); var trans = connection.BeginTransaction(); var res = connection.Execute(queryDeleteFromStockReal, product, trans); if (res < 0) { trans.Rollback(); return; } res = connection.Execute(queryDeleteFromProducts, product, trans); if (res != 1) { trans.Rollback(); return; } res = connection.Execute(queryDeleteFromProductsWeb, product, trans); if (res != 1) { trans.Rollback(); return; } trans.Commit(); } RepositoryLastUpdate.Update(true); }