public static bool AddDatasets(IBindingList datasetBindingList, IList <int> selectedDatasets, string providerUrl, string UserName, string Password) { using (var localDb = new geosyncDBEntities()) { foreach (int selected in selectedDatasets) { var ds = (Dataset)datasetBindingList[selected]; try { ds.DatasetId = GetNextDatasetID(); ds.LastIndex = 0; ds.ClientWfsUrl = ""; ds.UserName = UserName; ds.Password = Password; ds.SyncronizationUrl = providerUrl; localDb.AddObject(ds.EntityKey.EntitySetName, ds); localDb.SaveChanges(); localDb.AcceptAllChanges(); } catch (Exception ex) { logger.LogException(LogLevel.Error, "Error saving selected datasets!", ex); return(false); } } } return(true); }
private void ReadGetCapabilities(geosyncDBEntities db, REP_CapabilitiesType rootCapabilities) { //Build Cababilities.XML //ServiceIndentification Dataset ds; m_DatasetBindingList = new MySortableBindingList <Dataset>(); foreach (DatasetType dst in rootCapabilities.datasets) { ds = db.CreateObject <Dataset>(); ds.EntityKey = db.CreateEntityKey("Dataset", ds); ds.ProviderDatasetId = dst.datasetId; ds.Name = dst.name; DomainType dt = GetConstraint("CountDefault", rootCapabilities.OperationsMetadata.Constraint); if (dt != null) { ds.MaxCount = Convert.ToInt32(dt.DefaultValue.Value); } ds.Applicationschema = dst.applicationSchema; Operation op = GetOperation("OrderChangelog", rootCapabilities.OperationsMetadata.Operation); if (op != null) { string PostUrl = GetPostURL(op.DCP); ds.SyncronizationUrl = PostUrl; } m_DatasetBindingList.Add(ds); } }
/// <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 <SubscriberDataset> datasetBindingList, IList <int> selectedDatasets) { using (var localDb = new geosyncDBEntities()) { foreach (int selected in selectedDatasets) { var geoClientDataset = (SubscriberDataset)datasetBindingList[selected]; Dataset 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.LogException(LogLevel.Error, "Error removing selected datasets!", ex); return(false); } } } return(true); }
public static string GetDatasource() { using (var localDb = new geosyncDBEntities()) { return(localDb.Connection.DataSource); } }
public static bool UpdateDataset(SubscriberDataset geoClientDataset) { using (var localDb = new geosyncDBEntities()) { Dataset 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.SynchronizationUrl; dataset.ClientWfsUrl = geoClientDataset.ClientWfsUrl; dataset.Applicationschema = geoClientDataset.Applicationschema; 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; } localDb.SaveChanges(); return(true); } }
public static int GetMaxCount(int datasetID) { using (var localDb = new geosyncDBEntities()) { var res = (from d in localDb.Dataset where d.DatasetId == datasetID select d.MaxCount).FirstOrDefault(); return(res.GetValueOrDefault()); } }
public static List <string> GetDatasetNames() { using (var localDb = new geosyncDBEntities()) { var res = (from d in localDb.Dataset select d.Name).ToList(); return(res); } }
public static IDictionary <int, string> GetDatasetNamesAsDictionary() { using (var localDb = new geosyncDBEntities()) { var dict = localDb.Dataset.Select(t => new { t.DatasetId, t.Name }) .ToDictionary(t => t.DatasetId, t => t.Name); return(dict); } }
public static IList <Int32> GetListOfDatasetIDs() { using (var localDb = new geosyncDBEntities()) { IList <Int32> idList = new List <Int32>(); var res = from d in localDb.Dataset select d.DatasetId; foreach (Int32 id in res) { idList.Add(id); } return(idList); } }
public static SubscriberDataset GetDataset(int datasetId) { using (var localDb = new geosyncDBEntities()) { Dataset dataset = (from d in localDb.Dataset where d.DatasetId == datasetId select d).FirstOrDefault(); if (dataset == null) { return(null); } var geoClientDataset = MapToGeoClientDataset(dataset); return(geoClientDataset); } }
public static List <SubscriberDataset> GetAllDataset() { using (var localDb = new geosyncDBEntities()) { List <Dataset> datasets = (from d in localDb.Dataset select d).ToList(); var geoClientDatasets = new List <SubscriberDataset>(); foreach (var dataset in datasets) { geoClientDatasets.Add(MapToGeoClientDataset(dataset)); } return(geoClientDatasets); } }
public static string MappingFile(Int32 DatasetID) { using (var localDb = new geosyncDBEntities()) { var res = from d in localDb.Dataset where d.DatasetId == DatasetID select d.MappingFile; if (res.First() != null) { return(res.First().ToString()); } else { return(""); } } }
public static string TargetNamespace(Int32 DatasetID) { using (var localDb = new geosyncDBEntities()) { var res = from d in localDb.Dataset where d.DatasetId == DatasetID select d.Applicationschema; if (res.First() != null) { return(res.First().ToString()); } else { return(""); } } }
public static string GetLastIndex(int datasetID) { using (var localDb = new geosyncDBEntities()) { var res = from d in localDb.Dataset where d.DatasetId == datasetID select d.LastIndex; if (res.FirstOrDefault() != null) { return(res.First().ToString()); } else { return(""); } } }
public static string ClientWfsUrl(int datasetID) { using (var localDb = new geosyncDBEntities()) { var res = from d in localDb.Dataset where d.DatasetId == datasetID select d.ClientWfsUrl; if (res.First() != null) { return(res.First().ToString()); } else { return(""); } } }
public CapabilitiesDataBuilder(string ProviderURL, string UserName, string Password) { geosyncDBEntities db = new geosyncDBEntities(); WebFeatureServiceReplicationPortClient client = new WebFeatureServiceReplicationPortClient(); client.ClientCredentials.UserName.UserName = UserName; client.ClientCredentials.UserName.Password = Password; client.Endpoint.Address = new System.ServiceModel.EndpointAddress(ProviderURL); GetCapabilitiesType1 req = new GetCapabilitiesType1(); REP_CapabilitiesType rootCapabilities = client.GetCapabilities(req); ReadGetCapabilities(db, rootCapabilities); }
public static int GetNextDatasetID() { int max = 0; using (var localDb = new geosyncDBEntities()) { var res = from d in localDb.Dataset select d.DatasetId; foreach (Int32 id in res) { if (max < id) { max = id; } } } return(max + 1); }
public static bool AddEmptyDataset() { using (var localDb = new geosyncDBEntities()) { var ds = new Dataset(); try { ds.DatasetId = GetNextDatasetID(); ds.LastIndex = 0; ds.ClientWfsUrl = ""; localDb.AddObject("Dataset", ds); localDb.SaveChanges(); localDb.AcceptAllChanges(); } catch (Exception ex) { logger.LogException(LogLevel.Error, "Error saving selected datasets!", ex); return(false); } } return(true); }