GridView/FormView CRUD via esDataSource

rated by 0 users
This post has 0 Replies | 1 Follower

Posts 905

Scott.Schecter Posted: 06-29-2007 10:36 AM | Locked

rated by 0 users

Code:

<%@ Page Language="C#" AutoEventWireup="true" Codebehind="Microsoft.aspx.cs" Inherits="EntitySpaces.DataSource.Demo.Microsoft" %>

<%@ Register Assembly="EntitySpaces.Web" Namespace="EntitySpaces.Web" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>EsDataSource Two Way Binding Sample</title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <table>
                <tr>
                    <td valign="top" style="height: 514px">
                        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
                            AutoGenerateSelectButton="True" DataKeyNames="EmployeeID" DataSourceID="EsDataSource1"
                            OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AllowPaging="True" PageSize="5">
                            <Columns>
                                <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" InsertVisible="False"
                                    ReadOnly="True" SortExpression="EmployeeID" />
                                <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />
                                <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />
                                <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                                <asp:BoundField DataField="TitleOfCourtesy" HeaderText="TitleOfCourtesy" SortExpression="TitleOfCourtesy" />
                                <asp:BoundField DataField="BirthDate" HeaderText="BirthDate" SortExpression="BirthDate" />
                                <asp:BoundField DataField="HireDate" HeaderText="HireDate" SortExpression="HireDate" />
                            </Columns>
                        </asp:GridView>
                         </td>
                    <td valign="top" style="height: 514px">
                        <asp:FormView ID="FormView1" runat="server" DataKeyNames="EmployeeID" DataSourceID="EsDataSource2"
                            EmptyDataText="Select an employee in the grid to view their details" OnItemDeleted="FormView1_ItemDeleted"
                            OnItemInserted="FormView1_ItemInserted" OnItemUpdated="FormView1_ItemUpdated"
                            DefaultMode="Insert">
                            <EditItemTemplate>
                                EmployeeID:
                                <asp:Label ID="EmployeeIDLabel1" runat="server" Text='<%# Eval("EmployeeID") %>'>
                                </asp:Label><br />
                                LastName:
                                <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>'>
                                </asp:TextBox><br />
                                FirstName:
                                <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>'>
                                </asp:TextBox><br />
                                Title:
                                <asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Title") %>'>
                                </asp:TextBox><br />
                                TitleOfCourtesy:
                                <asp:TextBox ID="TitleOfCourtesyTextBox" runat="server" Text='<%# Bind("TitleOfCourtesy") %>'>
                                </asp:TextBox><br />
                                BirthDate:
                                <asp:TextBox ID="BirthDateTextBox" runat="server" Text='<%# Bind("BirthDate") %>'>
                                </asp:TextBox><br />
                                HireDate:
                                <asp:TextBox ID="HireDateTextBox" runat="server" Text='<%# Bind("HireDate") %>'>
                                </asp:TextBox><br />
                                Address:
                                <asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>'>
                                </asp:TextBox><br />
                                City:
                                <asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>'>
                                </asp:TextBox><br />
                                Region:
                                <asp:TextBox ID="RegionTextBox" runat="server" Text='<%# Bind("Region") %>'>
                                </asp:TextBox><br />
                                PostalCode:
                                <asp:TextBox ID="PostalCodeTextBox" runat="server" Text='<%# Bind("PostalCode") %>'>
                                </asp:TextBox><br />
                                Country:
                                <asp:TextBox ID="CountryTextBox" runat="server" Text='<%# Bind("Country") %>'>
                                </asp:TextBox><br />
                                HomePhone:
                                <asp:TextBox ID="HomePhoneTextBox" runat="server" Text='<%# Bind("HomePhone") %>'>
                                </asp:TextBox><br />
                                Extension:
                                <asp:TextBox ID="ExtensionTextBox" runat="server" Text='<%# Bind("Extension") %>'>
                                </asp:TextBox><br />
                                Photo:
                                <asp:TextBox ID="PhotoTextBox" runat="server" Text='<%# Bind("Photo") %>'>
                                </asp:TextBox><br />
                                Notes:
                                <asp:TextBox ID="NotesTextBox" runat="server" Text='<%# Bind("Notes") %>'>
                                </asp:TextBox><br />
                                ReportsTo:
                                <asp:TextBox ID="ReportsToTextBox" runat="server" Text='<%# Bind("ReportsTo") %>'>
                                </asp:TextBox><br />
                                PhotoPath:
                                <asp:TextBox ID="PhotoPathTextBox" runat="server" Text='<%# Bind("PhotoPath") %>'>
                                </asp:TextBox><br />
                                <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                    Text="Update">
                                </asp:LinkButton>
                                <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                    Text="Cancel">
                                </asp:LinkButton>
                            </EditItemTemplate>
                            <InsertItemTemplate>
                                LastName:
                                <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>'>
                                </asp:TextBox><br />
                                FirstName:
                                <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>'>
                                </asp:TextBox><br />
                                Title:
                                <asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Title") %>'>
                                </asp:TextBox><br />
                                TitleOfCourtesy:
                                <asp:TextBox ID="TitleOfCourtesyTextBox" runat="server" Text='<%# Bind("TitleOfCourtesy") %>'>
                                </asp:TextBox><br />
                                BirthDate:
                                <asp:TextBox ID="BirthDateTextBox" runat="server" Text='<%# Bind("BirthDate") %>'>
                                </asp:TextBox><br />
                                HireDate:
                                <asp:TextBox ID="HireDateTextBox" runat="server" Text='<%# Bind("HireDate") %>'>
                                </asp:TextBox><br />
                                Address:
                                <asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>'>
                                </asp:TextBox><br />
                                City:
                                <asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>'>
                                </asp:TextBox><br />
                                Region:
                                <asp:TextBox ID="RegionTextBox" runat="server" Text='<%# Bind("Region") %>'>
                                </asp:TextBox><br />
                                PostalCode:
                                <asp:TextBox ID="PostalCodeTextBox" runat="server" Text='<%# Bind("PostalCode") %>'>
                                </asp:TextBox><br />
                                Country:
                                <asp:TextBox ID="CountryTextBox" runat="server" Text='<%# Bind("Country") %>'>
                                </asp:TextBox><br />
                                HomePhone:
                                <asp:TextBox ID="HomePhoneTextBox" runat="server" Text='<%# Bind("HomePhone") %>'>
                                </asp:TextBox><br />
                                Extension:
                                <asp:TextBox ID="ExtensionTextBox" runat="server" Text='<%# Bind("Extension") %>'>
                                </asp:TextBox><br />
                                Photo:
                                <asp:TextBox ID="PhotoTextBox" runat="server" Text='<%# Bind("Photo") %>'>
                                </asp:TextBox><br />
                                Notes:
                                <asp:TextBox ID="NotesTextBox" runat="server" Text='<%# Bind("Notes") %>'>
                                </asp:TextBox><br />
                                ReportsTo:
                                <asp:TextBox ID="ReportsToTextBox" runat="server" Text='<%# Bind("ReportsTo") %>'>
                                </asp:TextBox><br />
                                PhotoPath:
                                <asp:TextBox ID="PhotoPathTextBox" runat="server" Text='<%# Bind("PhotoPath") %>'>
                                </asp:TextBox><br />
                                <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                    Text="Insert">
                                </asp:LinkButton>
                                <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                    Text="Cancel">
                                </asp:LinkButton>
                            </InsertItemTemplate>
                            <ItemTemplate>
                                EmployeeID:
                                <asp:Label ID="EmployeeIDLabel" runat="server" Text='<%# Eval("EmployeeID") %>'>
                                </asp:Label><br />
                                LastName:
                                <asp:Label ID="LastNameLabel" runat="server" Text='<%# Bind("LastName") %>'></asp:Label><br />
                                FirstName:
                                <asp:Label ID="FirstNameLabel" runat="server" Text='<%# Bind("FirstName") %>'></asp:Label><br />
                                Title:
                                <asp:Label ID="TitleLabel" runat="server" Text='<%# Bind("Title") %>'></asp:Label><br />
                                TitleOfCourtesy:
                                <asp:Label ID="TitleOfCourtesyLabel" runat="server" Text='<%# Bind("TitleOfCourtesy") %>'>
                                </asp:Label><br />
                                BirthDate:
                                <asp:Label ID="BirthDateLabel" runat="server" Text='<%# Bind("BirthDate") %>'></asp:Label><br />
                                HireDate:
                                <asp:Label ID="HireDateLabel" runat="server" Text='<%# Bind("HireDate") %>'></asp:Label><br />
                                Address:
                                <asp:Label ID="AddressLabel" runat="server" Text='<%# Bind("Address") %>'></asp:Label><br />
                                City:
                                <asp:Label ID="CityLabel" runat="server" Text='<%# Bind("City") %>'></asp:Label><br />
                                Region:
                                <asp:Label ID="RegionLabel" runat="server" Text='<%# Bind("Region") %>'></asp:Label><br />
                                PostalCode:
                                <asp:Label ID="PostalCodeLabel" runat="server" Text='<%# Bind("PostalCode") %>'>
                                </asp:Label><br />
                                Country:
                                <asp:Label ID="CountryLabel" runat="server" Text='<%# Bind("Country") %>'></asp:Label><br />
                                HomePhone:
                                <asp:Label ID="HomePhoneLabel" runat="server" Text='<%# Bind("HomePhone") %>'></asp:Label><br />
                                Extension:
                                <asp:Label ID="ExtensionLabel" runat="server" Text='<%# Bind("Extension") %>'></asp:Label><br />
                                Photo:
                                <asp:Label ID="PhotoLabel" runat="server" Text='<%# Bind("Photo") %>'></asp:Label><br />
                                Notes:
                                <asp:Label ID="NotesLabel" runat="server" Text='<%# Bind("Notes") %>'></asp:Label><br />
                                ReportsTo:
                                <asp:Label ID="ReportsToLabel" runat="server" Text='<%# Bind("ReportsTo") %>'></asp:Label><br />
                                PhotoPath:
                                <asp:Label ID="PhotoPathLabel" runat="server" Text='<%# Bind("PhotoPath") %>'></asp:Label><br />
                                <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                                    Text="Edit">
                                </asp:LinkButton>
                                <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
                                    Text="Delete">
                                </asp:LinkButton>
                                <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
                                    Text="New">
                                </asp:LinkButton>
                            </ItemTemplate>
                        </asp:FormView>
                         </td>
                </tr>
            </table>
        </div>
         
        <cc1:esDataSource ID="EsDataSource1" runat="server" OnesSelect="EsDataSource1_esSelect"
            AutoPaging="true" AutoSorting="true" />
        <cc1:esDataSource ID="EsDataSource2" runat="server" OnesCreateEntity="EsDataSource2_esCreateEntity"
            OnesSelect="EsDataSource2_esSelect" />
    </form>
</body>
</html>

Code:

using System;
using System.Data;
using System.Drawing;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using BusinessObjects;
using EntitySpaces.Interfaces;

namespace EntitySpaces.DataSource.Demo
{
    public partial class Microsoft : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                GetEmployeeCount();
            }
        }

        private void GetEmployeeCount()
        {
            Employees emp = new Employees();
            emp.Query.es.CountAll = true;
            emp.Query.es.CountAllAlias = "Count";
            if (emp.Query.Load())
            {
                EsDataSource1.TotalRowCount = (int)emp.GetColumn("Count");
            }

            GridView1.Sort(EmployeesMetadata.PropertyNames.LastName, SortDirection.Ascending);

        }

        protected void EsDataSource1_esSelect(object sender, EntitySpaces.Web.esDataSourceSelectEventArgs e)
        {
            EmployeesCollection employees = new EmployeesCollection();
            e.Collection = employees;
        }

        protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (EsDataSource2.State.ContainsKey("employeeid"))
                EsDataSource2.State["employeeid"] = GridView1.SelectedValue;
            else 
                EsDataSource2.State.Add("employeeid", GridView1.SelectedValue);
            
            FormView1.DataBind();
            FormView1.ChangeMode(FormViewMode.Edit);
        }

        protected void EsDataSource2_esSelect(object sender, EntitySpaces.Web.esDataSourceSelectEventArgs e)
        {
            EmployeesCollection employees = new EmployeesCollection();
            
            if (EsDataSource2.State.ContainsKey("employeeid"))
            {
                employees.Query.Where(employees.Query.EmployeeID == (int)EsDataSource2.State["employeeid"]);
                employees.Query.Load();
                e.Collection = employees;
            }
            else
            {
                e.Collection = employees;
            }
        }

        protected void EsDataSource2_esCreateEntity(object sender, EntitySpaces.Web.esDataSourceCreateEntityEventArgs e)
        {
            Employees employee = new Employees();
            if (e.PrimaryKeys == null)
            {
                employee.AddNew();
            }
            else
            {
                employee.LoadByPrimaryKey((int)e.PrimaryKeys[0]);
            }

            e.Entity = employee;
        }

        protected void FormView1_ItemUpdated(object sender, FormViewUpdatedEventArgs e)
        {
            GridView1.DataBind();
        }

        protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e)
        {
            GridView1.DataBind();
        }

        protected void FormView1_ItemDeleted(object sender, FormViewDeletedEventArgs e)
        {
            GridView1.DataBind();
        }
    }
}

Regards, Scott Schecter EntitySpaces | Blog | Twitter

Previous | Next

Page 1 of 1 (1 items) | RSS

GridView/FormView CRUD via esDataSource

rated by 0 users This post has 0 Replies | 1 Follower

Code:

Code:

rated by 0 users
This post has 0 Replies | 1 Follower