static Databases() { //Setting up local model connection if (localModel == null) { localModel = new DataModelContainer(); SetLocalDataContainer(); } if (serverModel == null) { serverModel = new DataModelContainer(); SetServerDataContainer(); } clientConn = new SqlConnection(localModel.Database.Connection.ConnectionString); serverConn = new SqlConnection(serverModel.Database.Connection.ConnectionString); syncWorker = new BackgroundWorker(); syncWorker.DoWork += syncWorker_DoWork; syncWorker.RunWorkerCompleted += syncWorker_RunWorkerCompleted; if (localModel.Database.Connection.State == ConnectionState.Closed) localModel.Database.Connection.Open(); }
public static bool AddProduct(Product p, DataModelContainer destModel) { try { destModel.ProductSet.Add(p); destModel.SaveChanges(); return true; } catch(Exception ex) { return false; } }
public static bool AddOrder(Order o, DataModelContainer destModel) { try { destModel.OrderSet.Add(o); destModel.SaveChanges(); return true; } catch (Exception ex) { return false; } }
public static bool AddOrders(List<Order> _orders, DataModelContainer destModel) { try { foreach (Order o in _orders) { destModel.OrderSet.Add(o); } destModel.SaveChanges(); return true; } catch (Exception ex) { return false; } }
public static bool AddDeal(Deal d, DataModelContainer destModel) { try { destModel.DealSet.Add(d); destModel.SaveChanges(); return true; } catch (Exception ex) { return false; } }