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;
}
}
