/// <summary> /// Removes the selected datasets from database. /// </summary> /// <param name="datasetBindingList">The dataset binding list.</param> /// <param name="selectedDatasets">The selected datasets.</param> /// <returns>True if OK, else False</returns> public static bool RemoveDatasets(List <Dataset> datasetBindingList, IList <int> selectedDatasets) { using (var localDb = new GeosyncDbEntities()) { foreach (var selected in selectedDatasets) { var geoClientDataset = datasetBindingList[selected]; var dataset = (from d in localDb.Dataset where d.DatasetId == geoClientDataset.DatasetId select d) .FirstOrDefault(); if (dataset == null) { return(false); } try { localDb.DeleteObject(dataset); localDb.SaveChanges(); } catch (Exception ex) { Logger.Error(ex, "Error removing selected datasets!"); return(false); } } } return(true); }
public static bool AddDatasets(IBindingList datasetBindingList, IList <int> selectedDatasets, string providerUrl, string userName, string password) { using (var localDb = new GeosyncDbEntities()) { foreach (var selected in selectedDatasets) { var ds = (Dataset)datasetBindingList[selected]; try { ds.LastIndex = 0; ds.ClientWfsUrl = ""; ds.UserName = userName; ds.Password = password; ds.SyncronizationUrl = providerUrl; localDb.AddObject(ds); localDb.SaveChanges(); } catch (Exception ex) { Logger.Error(ex, "Error saving selected datasets!"); return(false); } } } return(true); }
public static bool AddEmptyDataset() { using (var localDb = new GeosyncDbEntities()) { var ds = new Dataset(); try { ds.LastIndex = 0; ds.ClientWfsUrl = ""; localDb.AddObject(ds); localDb.SaveChanges(); } catch (Exception ex) { Logger.Error(ex, "Error saving selected datasets!"); return(false); } } return(true); }
public static bool UpdateDataset(Dataset geoClientDataset) { using (var localDb = new GeosyncDbEntities()) { var dataset = (from d in localDb.Dataset where d.DatasetId == geoClientDataset.DatasetId select d) .FirstOrDefault(); if (dataset == null) { return(false); } dataset.MaxCount = geoClientDataset.MaxCount; dataset.LastIndex = geoClientDataset.LastIndex; dataset.Name = geoClientDataset.Name; dataset.ProviderDatasetId = geoClientDataset.ProviderDatasetId; dataset.SyncronizationUrl = geoClientDataset.SyncronizationUrl; dataset.ClientWfsUrl = geoClientDataset.ClientWfsUrl; dataset.TargetNamespace = geoClientDataset.TargetNamespace; dataset.MappingFile = geoClientDataset.MappingFile; dataset.AbortedEndIndex = geoClientDataset.AbortedEndIndex; dataset.AbortedTransaction = geoClientDataset.AbortedTransaction; dataset.AbortedChangelogPath = geoClientDataset.AbortedChangelogPath; dataset.ChangelogDirectory = geoClientDataset.ChangelogDirectory; dataset.AbortedChangelogId = geoClientDataset.AbortedChangelogId; dataset.UserName = geoClientDataset.UserName; if (geoClientDataset.Password != "******") { dataset.Password = geoClientDataset.Password; } dataset.Version = geoClientDataset.Version; localDb.SaveChanges(); return(true); } }