private void simpleButton2_Click(object sender, System.EventArgs e) { m_ZoneLayerName = textName.Text; m_Description = textDescription.Text; m_PivotalLayer = (PivotLayerType)comboPivot.SelectedIndex; if (!IsAVR && m_PivotalLayer > 0) { m_PivotalLayer++; } }
//BufferZoneColumns public static EidssUserBufZoneLayer CreateBufZoneLayer(string name, string desc, PivotLayerType pivotLayerType) { using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); //SqlTransaction trans = conn.BeginTransaction("Create buff zones layer"); //create new metadata var layerInfo = new UserDbLayerInfo(); layerInfo.m_Id = Guid.NewGuid(); layerInfo.m_LayerType = UserDbLayerType.BuffZones; layerInfo.m_Name = name; layerInfo.m_Description = desc; layerInfo.m_UserId = (long)EidssUserContext.User.ID; layerInfo.m_PivotalLayer = pivotLayerType; InsertUserLayerMetadata(layerInfo); //, conn, trans); //create new user layer table in db var addtionalColumns = new List <DataColumn>(); addtionalColumns.Add(new DataColumn("strName", typeof(string))); addtionalColumns.Add(new DataColumn("strDescription", typeof(string))); addtionalColumns.Add(new DataColumn("dblRadius", typeof(double))); addtionalColumns.Add(new DataColumn("dblCenterX", typeof(double))); addtionalColumns.Add(new DataColumn("dblCenterY", typeof(double))); var deleted = new DataColumn("intDeleted", typeof(int)); deleted.DefaultValue = 0; deleted.AllowDBNull = false; addtionalColumns.Add(deleted); var tableName = UserTablePrefix + layerInfo.m_Id.ToString("N"); TableCreator.CreateGeomTable(conn, tableName, addtionalColumns, GisDbShema); if (UserLayersListChanged != null) { UserLayersListChanged(null, EventArgs.Empty); } return(GetUserLayer(layerInfo.m_Id) as EidssUserBufZoneLayer); } }