public ResponseSerializer Put(int id, [FromBody] ThemeSerializer themeSerializer) { return(new ResponseSerializer( 200, "success", this._themeBus.UpdateTheme(id, themeSerializer))); }
/// <summary> /// /// </summary> /// <param name="layerInfo"></param> public static void UpdateUserLayerMetadata(UserDbLayerInfo layerInfo) { if (string.IsNullOrEmpty(layerInfo.m_Name) || layerInfo.m_Id == Guid.Empty) { throw new ArgumentException(Resources.gis_UserDbLayersManager_UpdateUserLayerMetadataException); } using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); var style = (layerInfo.m_Style == null) ? (Object)DBNull.Value : StyleSerializer.SerializeAsDocument(layerInfo.m_Style).InnerXml; var theme = (layerInfo.m_Theme == null) ? (Object)DBNull.Value : ThemeSerializer.SerializeAsDocument(layerInfo.m_Theme).InnerXml; using (var updCommand = new SqlCommand("spGisUpdateUserLayerMetadata", conn)) { updCommand.CommandType = CommandType.StoredProcedure; updCommand.Parameters.AddWithValue("@LAYERID", layerInfo.m_Id); updCommand.Parameters.AddWithValue("@Name", layerInfo.m_Name); updCommand.Parameters.AddWithValue("@STYLE", style); updCommand.Parameters.AddWithValue("@THEME", theme); updCommand.Parameters.AddWithValue("@DESC", string.IsNullOrEmpty(layerInfo.m_Description) ? DBNull.Value : (object)layerInfo.m_Description); updCommand.ExecuteNonQuery(); } conn.Close(); } }
public ResponseSerializer Post([FromBody] ThemeSerializer themeSerializer) { return(new ResponseSerializer( 200, "success", this._themeBus.CreateNewTheme(themeSerializer))); }
/// <summary> /// Insert new user layer metadata /// </summary> /// <param name="newLayerInfo">LayerInfo. REQUERED: Id, name, UserID, LayerType</param> /// <param name="conn"> </param> /// <param name="trans">Transaction</param> public static void InsertUserLayerMetadata(UserDbLayerInfo newLayerInfo, SqlConnection conn, SqlTransaction trans = null) { if (string.IsNullOrEmpty(newLayerInfo.m_Name)) { throw new ArgumentException(Resources.gis_UserDbLayersManager_InsertUserLayerMetadataException); } var style = (newLayerInfo.m_Style == null)?string.Empty:StyleSerializer.SerializeAsDocument(newLayerInfo.m_Style).InnerXml; var theme = (newLayerInfo.m_Theme == null) ? string.Empty : ThemeSerializer.SerializeAsDocument(newLayerInfo.m_Theme).InnerXml; //TODO[enikulin]: make with SqlHelper using (var addCommand = new SqlCommand("spGisInsertUserLayerMetadata", conn, trans)) { addCommand.CommandType = CommandType.StoredProcedure; addCommand.Parameters.AddWithValue("@ID", newLayerInfo.m_Id); addCommand.Parameters.AddWithValue("@Name", newLayerInfo.m_Name); addCommand.Parameters.AddWithValue("@UserID", newLayerInfo.m_UserId); addCommand.Parameters.AddWithValue("@LayerType", (int)newLayerInfo.m_LayerType); addCommand.Parameters.AddWithValue("@STYLE", style); addCommand.Parameters.AddWithValue("@THEME", theme); addCommand.Parameters.AddWithValue("@DESC", string.IsNullOrEmpty(newLayerInfo.m_Description) ? DBNull.Value : (object)newLayerInfo.m_Description); addCommand.Parameters.AddWithValue("@PIVOTALLAYER", newLayerInfo.m_PivotalLayer); addCommand.ExecuteNonQuery(); } }
public String CreateNewTheme(ThemeSerializer themeSerializer) { ThemeModel themeModel = new ThemeModel(); themeModel.Name = themeSerializer.name; themeModel.First = themeSerializer.first; themeModel.Second = themeSerializer.second; themeModel.Third = themeSerializer.third; return(this._themeDao.Create(themeModel)); }
public String UpdateTheme(int id, ThemeSerializer themeSerializer) { ThemeModel themeModel = new ThemeModel(); themeModel.Id = id; themeModel.Name = themeSerializer.name; themeModel.First = themeSerializer.first; themeModel.Second = themeSerializer.second; themeModel.Third = themeSerializer.third; return(this._themeDao.Update(id, themeModel)); }
public static List <UserDbLayerInfo> GetLayersMetadates(UserDbLayerType userDbLayerType = UserDbLayerType.None) { var infos = new List <UserDbLayerInfo>(); var query = string.Format("SELECT * FROM gisUserLayer WHERE intDeleted=0"); if (userDbLayerType != UserDbLayerType.None) { query += string.Format(" AND intType={0}", (int)userDbLayerType); } using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); var dt = SqlExecHelper.SqlExecTable(new SqlConnection(ConnectionString), query); foreach (DataRow row in dt.Rows) { var style = new VectorStyle(); if (row["xmlStyle"] != DBNull.Value && !string.IsNullOrEmpty(row["xmlStyle"] as string)) { XmlDocument doc = new XmlDocument(); doc.LoadXml((string)row["xmlStyle"]); style = StyleSerializer.DeserializeFromDocument(doc) as VectorStyle; } ITheme theme = null; if (row["xmlTheme"] != DBNull.Value && !string.IsNullOrEmpty(row["xmlTheme"] as string)) { XmlDocument doc = new XmlDocument(); doc.LoadXml((string)row["xmlTheme"]); theme = ThemeSerializer.DeserializeFromDocument(doc); } infos.Add(new UserDbLayerInfo { m_Id = (Guid)row["guidLayer"], m_Name = (String)row["strName"], m_UserId = (long)row["idfUser"], m_CreationDate = (DateTime)row["CreationDate"], m_LastModifiedDate = (DateTime)row["LastModifiedDate"], m_Description = row["strDescription"] as string, m_LayerType = (UserDbLayerType)row["intType"], m_PivotalLayer = (PivotLayerType)row["intPivotalLayer"], m_Style = style, m_Theme = theme }); } return(infos); } }
public static UserDbLayerInfo GetLayerMetadata(Guid layerId) { var query = string.Format("SELECT * FROM gisUserLayer WHERE guidLayer='{0}'", layerId); using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); var dataReader = SqlExecHelper.SqlExecReader(conn, query); if (!dataReader.HasRows) { throw new ApplicationException(Resources.gis_UserDbLayersManager_GetLayerMetadataException + layerId); } dataReader.Read(); var style = new VectorStyle(); if (dataReader["xmlStyle"] != DBNull.Value && !string.IsNullOrEmpty(dataReader["xmlStyle"] as string)) { XmlDocument doc = new XmlDocument(); doc.LoadXml((string)dataReader["xmlStyle"]); style = StyleSerializer.DeserializeFromDocument(doc) as VectorStyle; } ITheme theme = null; if (dataReader["xmlTheme"] != DBNull.Value && !string.IsNullOrEmpty(dataReader["xmlTheme"] as string)) { XmlDocument doc = new XmlDocument(); doc.LoadXml((string)dataReader["xmlTheme"]); theme = ThemeSerializer.DeserializeFromDocument(doc); } return(new UserDbLayerInfo { m_Id = (Guid)dataReader["guidLayer"], m_Name = (String)dataReader["strName"], m_UserId = (long)dataReader["idfUser"], m_CreationDate = (DateTime)dataReader["CreationDate"], m_LastModifiedDate = (DateTime)dataReader["LastModifiedDate"], m_Description = dataReader["strDescription"] as string, m_LayerType = (UserDbLayerType)dataReader["intType"], m_PivotalLayer = (PivotLayerType)dataReader["intPivotalLayer"], m_Style = style, m_Theme = theme }); } }
/// <summary> /// Serialize VectorLayer /// </summary> /// <param name="vectorLayer">VectorLayer to serialize</param> /// <param name="vectorLayerElement">Root element to serialize</param> public static void Serialize(EidssUserDbLayer vectorLayer, XmlElement vectorLayerElement) { XmlElement xmlElement; LayerSerializer.SerializeLayerFields(vectorLayer, vectorLayerElement); #region << Serialization >> //TODO[enikulin]: need refactoring. only one property (LayerDBguid) and type of layer is changed from VectorLayer //LayerDbGuid xmlElement = vectorLayerElement.OwnerDocument.CreateElement("LayerDbGuid"); xmlElement.InnerText = vectorLayer.LayerDbGuid.ToString(); vectorLayerElement.AppendChild(xmlElement); //LabelLayerGuid xmlElement = vectorLayerElement.OwnerDocument.CreateElement("LabelLayerGuid"); xmlElement.InnerText = vectorLayer.LabelLayerGuid.ToString(); vectorLayerElement.AppendChild(xmlElement); //ClippingEnabled xmlElement = vectorLayerElement.OwnerDocument.CreateElement("ClippingEnabled"); xmlElement.InnerText = vectorLayer.ClippingEnabled.ToString(); vectorLayerElement.AppendChild(xmlElement); //SmoothingMode xmlElement = vectorLayerElement.OwnerDocument.CreateElement("SmoothingMode"); xmlElement.InnerText = vectorLayer.SmoothingMode.ToString("D"); vectorLayerElement.AppendChild(xmlElement); //SRID xmlElement = vectorLayerElement.OwnerDocument.CreateElement("SRID"); xmlElement.InnerText = vectorLayer.SRID.ToString("F0"); vectorLayerElement.AppendChild(xmlElement); //Style try { StyleSerializer.SerializeAsNode(vectorLayer.Style, vectorLayerElement); } catch (Exception ex) { throw new VectorLayerSerializationException("Style can't be serialized: " + ex.Message, ex); } //Theme try { ThemeSerializer.SerializeAsNode(vectorLayer.Theme, vectorLayerElement); } catch (Exception ex) { throw new VectorLayerSerializationException("Theme can't be serialized: " + ex.Message, ex); } //Marker size xmlElement = vectorLayerElement.OwnerDocument.CreateElement("MarkerSize"); xmlElement.InnerText = vectorLayer.MarkerSize.ToString(); vectorLayerElement.AppendChild(xmlElement); //Marker color try { ColorSerializer.SerializeAsNode(vectorLayer.MarkerColor, vectorLayerElement, "MarkerColor"); } catch (Exception ex) { throw new VectorLayerSerializationException("'MarkerColor' can't be serialized: " + ex.Message, ex); } //Polygon Fill Style xmlElement = vectorLayerElement.OwnerDocument.CreateElement("PolygonFillStyle"); xmlElement.InnerText = vectorLayer.PolygonFillStyle; vectorLayerElement.AppendChild(xmlElement); //Polygon Fill Color try { ColorSerializer.SerializeAsNode(vectorLayer.PolygonFillColor, vectorLayerElement, "PolygonFillColor"); } catch (Exception ex) { throw new VectorLayerSerializationException("'PolygonFillColor' can't be serialized: " + ex.Message, ex); } #endregion }
/// <summary> /// Deserialize VectorLayer /// </summary> /// <param name="vectorLayerElement">Root element to deserialize</param> /// <returns>VectorLayer</returns> public static EidssUserDbLayer Deserialize(XmlElement vectorLayerElement) { EidssUserDbLayer resultVectorLayer = null; XmlNode tempNode; LayerSerializer.LayerInfo lyrInfo; bool tempBool; int tempInt; #region <<Deserialize LayerFields >> try { lyrInfo = LayerSerializer.DeserializeLayerFields(vectorLayerElement); } catch (Exception ex) { throw new VectorLayerDeserializationException("VectorLayer can't be deserialized: " + ex.Message, ex); } //LayerDbGuid tempNode = vectorLayerElement.SelectSingleNode("LayerDbGuid"); if (tempNode == null) { throw new VectorLayerDeserializationException("VectorLayer can't be deserialized: 'LayerElement' don't have element 'LayerDbGuid'!"); } var layerDbGuid = new Guid(tempNode.InnerText); //LabelLayer Guid tempNode = vectorLayerElement.SelectSingleNode("LabelLayerGuid"); if (tempNode == null) { throw new VectorLayerDeserializationException("VectorLayer can't be deserialized: 'LayerElement' don't have element 'LabelLayerGuid'!"); } var labelLayerGuid = new Guid(tempNode.InnerText); //create layer switch (vectorLayerElement.Attributes["Type"].Value) { case "eidss.gis.Layers.EidssUserDbLayer": resultVectorLayer = new EidssUserDbLayer(layerDbGuid, lyrInfo.LayerName, lyrInfo.Guid, labelLayerGuid); break; case "eidss.gis.Layers.EidssUserBufZoneLayer": resultVectorLayer = new EidssUserBufZoneLayer(layerDbGuid, lyrInfo.LayerName, lyrInfo.Guid, labelLayerGuid); break; } resultVectorLayer.ControledByUser = lyrInfo.ControledByUser; resultVectorLayer.Enabled = lyrInfo.Enabled; resultVectorLayer.MaxVisible = lyrInfo.MaxVisible; resultVectorLayer.MinVisible = lyrInfo.MinVisible; //resultVectorLayer.SRID = lyrInfo.SRID; - тут бля косяк в провайдере! нет проверки! resultVectorLayer.VisibleInTOC = lyrInfo.VisibleInTOC; resultVectorLayer.Transparency = lyrInfo.Transparency; #endregion #region << Deserialize >> //ClippingEnabled tempNode = vectorLayerElement.SelectSingleNode("ClippingEnabled"); if (tempNode == null) { throw new VectorLayerDeserializationException("'VectorLayerElement' don't have element 'ClippingEnabled'!"); } if (!bool.TryParse(tempNode.InnerText, out tempBool)) { throw new VectorLayerDeserializationException("Can't parse node 'ClippingEnabled'!"); } resultVectorLayer.ClippingEnabled = tempBool; //SmoothingMode tempNode = vectorLayerElement.SelectSingleNode("SmoothingMode"); if (tempNode == null) { throw new VectorLayerDeserializationException("'VectorLayerElement' don't have element 'SmoothingMode'!"); } if (!Int32.TryParse(tempNode.InnerText, out tempInt) || !Enum.IsDefined(typeof(SmoothingMode), tempInt)) { throw new VectorLayerDeserializationException("Can't parse node 'SmoothingMode'!"); } resultVectorLayer.SmoothingMode = (SmoothingMode)tempInt; //SRID tempNode = vectorLayerElement.SelectSingleNode("SRID"); if (tempNode == null) { throw new VectorLayerDeserializationException("'VectorLayerElement' don't have element 'SRID'!"); } if (!Int32.TryParse(tempNode.InnerText, out tempInt)) { throw new VectorLayerDeserializationException("Can't parse node 'SRID'!"); } resultVectorLayer.SRID = tempInt; //Style try { resultVectorLayer.Style = (VectorStyle)StyleSerializer.DeserializeFromNode(vectorLayerElement); } catch (Exception ex) { throw new VectorLayerSerializationException("Style can't be deserialized: " + ex.Message, ex); } //Theme try { resultVectorLayer.Theme = ThemeSerializer.DeserializeFromNode(vectorLayerElement); } catch (Exception ex) { throw new VectorLayerSerializationException("Theme can't be deserialized: " + ex.Message, ex); } //Marker size tempNode = vectorLayerElement.SelectSingleNode("MarkerSize"); if (tempNode == null) { throw new VectorLayerDeserializationException("'VectorLayerElement' don't have element 'MarkerSize'!"); } if (!Int32.TryParse(tempNode.InnerText, out tempInt)) { throw new VectorLayerDeserializationException("Can't parse node 'MarkerSize'!"); } resultVectorLayer.MarkerSize = tempInt; //Marker color try { resultVectorLayer.MarkerColor = ColorSerializer.DeserializeFromNode(vectorLayerElement, "MarkerColor"); } catch (Exception ex) { throw new VectorLayerSerializationException("MarkerColor can't be deserialized: " + ex.Message, ex); } //Polygon Fill Style tempNode = vectorLayerElement.SelectSingleNode("PolygonFillStyle"); if (tempNode == null) { throw new VectorLayerDeserializationException("'VectorLayerElement' don't have element 'PolygonFillStyle'!"); } resultVectorLayer.PolygonFillStyle = tempNode.InnerText; //Polygon Fill Color try { resultVectorLayer.PolygonFillColor = ColorSerializer.DeserializeFromNode(vectorLayerElement, "PolygonFillColor"); } catch (Exception ex) { throw new VectorLayerSerializationException("PolygonFillColor can't be deserialized: " + ex.Message, ex); } #endregion return(resultVectorLayer); }