Devart Forums

Code: Select all

<asp:Content ID="Table" ContentPlaceHolderID="ContentHolder" runat="Server">
    <dx:ASPxGridView ID="LayerView" runat="server" DataSourceID="Layers" AutoGenerateColumns="False" DataSourceForceStandardPaging="True" Width="100%" Theme="Office2010Black" KeyFieldName="Name" OnHtmlRowPrepared="Prepare">
        <Columns>
            <dx:GridViewCommandColumn ShowEditButton="True" ShowNewButtonInHeader="True" VisibleIndex="3">
            </dx:GridViewCommandColumn>
            <dx:GridViewDataTextColumn Caption="Origin" FieldName="Origin" Name="Origin" Visible="False" VisibleIndex="0">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Name" FieldName="Name" Name="Name" VisibleIndex="1" Width="200px">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Description" FieldName="Description" Name="Description" VisibleIndex="2" Width="100%">
            </dx:GridViewDataTextColumn>
        </Columns>
        <SettingsEditing EditFormColumnCount="4" Mode="EditForm">
        </SettingsEditing>
        <SettingsDataSecurity AllowDelete="true" />
    </dx:ASPxGridView>
  <asp:LinqDataSource ID="Layers" runat="server"
      ContextTypeName="IG.Data.GFX.Context" TableName="Layers" EntityTypeName="" OnSelecting="Layer_Selecting"  
      EnableInsert="True" OnInserting="Layer_Inserting"
      EnableDelete="true" OnDeleting="Layer_Deleting"
      EnableUpdate="true" OnUpdating="Layer_Updating">
  </asp:LinqDataSource>

Code: Select all

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;
using IG.Data.GFX;

namespace IG.Creator
{
	public class LayerDataSource : ObjectDataSource
	{
		public IEnumerable<Layer> SelectEntities ()
		{
			var tLayers = new List<Layer>();

			foreach (var tLayer in this.Context.GetSupportDatabase().GetLayers())
			{
				tLayer.Origin = DataOrigin.SupportDB;
				tLayers.Add(tLayer);
			}

			foreach (var tLayer in this.Context.GetProjectDatabase().GetLayers())
			{
				tLayer.Origin = DataOrigin.ProjectDB;
				tLayers.Add(tLayer);
			}

			return tLayers.AsEnumerable<Layer>();
		}

		public void InsertEntity (string name, string description)
		{
			var tContext = this.Context.GetProjectDatabase().Context;

			var tQuery = from layer in tContext.Layers
						 where layer.Name.Equals(name)
						 select layer;

			if (tQuery.Count<Layer>() > 0)
				return;

			tContext.Layers.InsertOnSubmit(new Layer() 
			{
				Name = name,
				Description = description
			});

            tContext.SubmitChanges();
		}

		public void UpdateEntity (string name, string description)
		{			
			var tContext = this.Context.GetProjectDatabase().Context;
	
			var tDone = false;

			// Too bad we don't have the previous state...

			var tQuery = from layer in tContext.Layers
				where layer.Name.Equals (name)
                select layer;

			Layer[] tLayers;

			tLayers = tQuery.ToArray<Layer>();
			if (tLayers.Length == 1)
			{
				tLayers[0].Description = description;
				tDone = true;
			}

			if (tDone == false)
			{
				tQuery = from layer in tContext.Layers
						 where layer.Description.Equals(description)
						 select layer;

				tLayers = tQuery.ToArray<Layer>();
				if (tLayers.Length == 1)
				{
					tLayers[0].Name = name;
					tDone = true;
				}
			}

			if (tDone == true)
				tContext.SubmitChanges();
			else
				this.InsertEntity(name, description);
		}

		public void DeleteEntity (string name)
		{
			var tContext = this.Context.GetProjectDatabase().Context;

			var tQuery = from layer in tContext.Layers
				where layer.Name.Equals (name)
                select layer;	

			var tLayers = tQuery.ToArray<Layer>();
			if (tLayers.Length == 1)
			{
				tContext.Layers.DeleteOnSubmit(tLayers[0]);
				tContext.SubmitChanges();
			}
		}
	}
}