Now we will edit the Publisher objects .

Add a new WebForm , name it frmPublisher_Insert.aspx and make sure the “Place code in separate file” and “Select master page” are both selected by default.

Change in source view the title from “Untitled Page” to “Insert Publisher”

Now we must put controls in place to insert publishers

There must be the name and site of the publisher.

I prefer enter a table for this and the page will look like this:

<%@ Page Language="C#" MasterPageFile="~/Book.master" AutoEventWireup="true" CodeFile="frmPublisher_Insert.aspx.cs" Inherits="frmPublisher_Insert" Title="Insert Publisher" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <table>

        <tr>

            <td colspan="2">Enter values

            </td>

        </tr>

        <tr>

            <td>

               Name

            </td>

            <td>

                <asp:TextBox ID="txtName" runat="server">

                </asp:TextBox>

            </td>

        </tr>

        <tr>

            <td>

               Site

            </td>

            <td>

                <asp:TextBox ID="txtSite" runat="server">

                </asp:TextBox>

            </td>

        </tr>

        <tr>

            <td><asp:Button ID="btnSave" Text="Insert" runat="server" />

            </td>

            <td><asp:Button ID="btnCancel" Text="Cancel" runat="server" />

            </td>

        </tr>

    </table>

</asp:Content>

Now switch to design view and double click on Insert button in order to generate Click event. Double click in solution explorer the frmPublisher_Insert.aspx and , in Design view, double click on Cancel button in order to generate Click event.

For cancel it is clear what we must do – redirect to the frmPublisherList.aspx

Response.Redirect("frmPublisherList.aspx", false);

For save button, we must create a new publisher and save

  Publisher p = new Publisher();

        p.Name = txtName.Text;

        p.Site = txtSite.Text;

        p.Insert();

        Response.Redirect("frmPublisherList.aspx", false);

Please try it by setting the frmPublisher_Insert.aspx as start page and run the project (F5)

If all works well (please ensure that Insert has a call to Save()) you will see in the frmPublisherList.aspx the item you just selected.

It is clear that frmPublisherList.aspx has a need for a new button . Let’s put it

<asp:Button ID="btnNew" runat="server" Text="New" OnClick="btnNew_Click" />

And on code:

protected void btnNew_Click(object sender, EventArgs e)

    {

        Response.Redirect("frmPublisher_Insert.aspx", false);

    }

That will be ok for adding a new publisher.

Now for editing and deleting we can make on list… but I prefer having 2 new pages.

So modify a little bit the code on the grid, in order to have the edit and delete operations : the edit will be a link , and the delete will be a button to see how different is the model on the two implementations.

The list page now looks like this:

<%@ Page Language="C#" MasterPageFile="~/Book.master" AutoEventWireup="true" CodeFile="frmPublisherList.aspx.cs" Inherits="frmPublisherList" Title="Publisher Lists" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <asp:GridView ID="grdPublisher" runat="server" AutoGenerateColumns="false">

        <Columns>

            <asp:BoundField DataField="Site" HeaderText="Site" />

            <asp:BoundField DataField="Name" HeaderText="Name" />

            <asp:TemplateField HeaderText="Operations">

                <ItemTemplate>

                    <asp:Button runat="server" ID="btnDelete" CommandName="deletepub" CommandArgument='<%# Eval("IDPublisher") %>' Text="Delete" />

                    <asp:HyperLink runat="server" ID="hkEdit" NavigateUrl='<%# Eval("IDPublisher","~/frmPublisher_Edit.aspx?ID={0}") %>' Text="Edit"></asp:HyperLink>

                </ItemTemplate>

            </asp:TemplateField>

        </Columns>

    </asp:GridView>

    <br />

    <asp:Button ID="btnNew" runat="server" Text="New" OnClick="btnNew_Click" />

</asp:Content>

The link hkEdit is self explanatory – it goes to the frmPublisher_Edit.aspx with the ID of publisher in the row.

For the button we must create the event – and the event is on the grid itself – is the RowCommand

On the .cs file:

    protected void grdPublisher_RowCommand(object sender, GridViewCommandEventArgs e)

    {

        switch(e.CommandName)

        {

            case "deletepub":

                int idPublisher;

                if(int.TryParse(e.CommandArgument.ToString(),out idPublisher))

                {

                    Response.Redirect("frmPublisher_Delete.aspx?ID="+ idPublisher, false);

                    return;

                }

                Response.Write("Can not find id:" + idPublisher);

                break;

            default:

                Response.Write("Do not know command : " + e.CommandName);

                break;

        }

    }

Now create the two pages frmPublisher_Delete and frmPublisher_Edit 

On both we will copy the table from the new page and the source – without the class declaration. One more thing is to retrieve from ID the editing publisher:

  int idPublisher;

        if(!int.TryParse(Request.QueryString["ID"],out idPublisher))

        {

            Response.Redirect("frmPublisherList.aspx", false);

            return;

        }

        //we have id of the publisher

How can we retrieve from the ID of the publisher  the object ? Remember that in Windows forms application we did pass from one form to another the publisher object. Here we have just the Id. For this, we will open again the Book.sln solution and add the method to load one single object.

I like to put the method on ColPublisher and make it static … to not apparently create a new object.

public static Publisher sLoadFromID(int ID)

        {

            DbConnection db = Settings.TheConnection;

            using (db)

            {

                db.Open();

                IDataReader ir = Settings.Load("select IDPublisher, NamePublisher, SitePublisher from Publisher where IDPublisher="+ ID, db);

                while (ir.Read())

                {

                    Publisher p = new Publisher();

                    p.FillObject(ir);

                    return p;

                }

            }

            return null;

        }

Compile and go to Web project.We can have the publisher:

//we have id of the publisher

        Publisher p = ColPublisher.sLoadFromID(idPublisher);

        if (p == null)//maybe someone deleted

        {

            Response.Redirect("frmPublisherList.aspx", false);

            return;

        }

        if (!IsPostBack)

        {

            //now fill the text boxes

            txtName.Text = p.Name;

            txtSite.Text = p.Site;

        }

Why we have put  (!IsPostBack ) ? Simply because the textboxes must be filled only once – the first time. When the user enter new name and/or new site and after clicks on save, we must preserve his data .Other problem is that when we have to save the data, we must have the same code to load the publisher – so we put this into a function into the page:

private Publisher pub

    {

        get

        {

            int idPublisher;

            if (!int.TryParse(Request.QueryString["ID"], out idPublisher))

            {

                return null;

            }

            //we have id of the publisher

            return ColPublisher.sLoadFromID(idPublisher); ;

        }

    }

The code on PageLoad will be now shorter :

protected void Page_Load(object sender, EventArgs e)

    {

        Publisher p = pub;

        if (p == null)

        {

            Response.Redirect("frmPublisherList.aspx", false);

            return;

        }

        if (!IsPostBack)

        {

            //now fill the text boxes

            txtName.Text = p.Name;

            txtSite.Text = p.Site;

        }

    }

And we must modify the code on saving also :

protected void btnSave_Click(object sender, EventArgs e)

    {

        Publisher p = pub;

        if (p == null)

        {

            //TODO : throw an exception that someone deleted the publisher

            Response.Redirect("frmPublisherList.aspx", false);

            return;

        }

        p.Name = txtName.Text;

        p.Site = txtSite.Text;

        p.Update();

        Response.Redirect("frmPublisherList.aspx", false);

    }

You can modify also the text of btnsave from “Insert” to “Save”

On the delete page we will put the same code to retrieve the Publisher .Here is the code:

using System;

using System.Data;

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 BookObjects;

public partial class frmPublisher_Delete : System.Web.UI.Page

{

    private Publisher pub

    {

        get

        {

            int idPublisher;

            if (!int.TryParse(Request.QueryString["ID"], out idPublisher))

            {

                return null;

            }

            //we have id of the publisher

            return ColPublisher.sLoadFromID(idPublisher); ;

        }

    }

    protected void Page_Load(object sender, EventArgs e)

    {

        Publisher p = pub;

        if (p == null)

        {

            Response.Redirect("frmPublisherList.aspx", false);

            return;

        }

        if (!IsPostBack)

        {

            //now fill the text boxes

            txtName.Text = p.Name;

            txtSite.Text = p.Site;

        }

    }

    protected void btnSave_Click(object sender, EventArgs e)

    {

        Publisher p = pub;

        if(p != null)

            p.Delete();

        Response.Redirect("frmPublisherList.aspx", false);

    }

    protected void btnCancel_Click(object sender, EventArgs e)

    {

        Response.Redirect("frmPublisherList.aspx", false);

    }

}

Do not forget to change the text “Insert” of btnSave to “Delete”. You also can put readonly property to true on the textboxes

<%@ Page Language="C#" MasterPageFile="~/Book.master" AutoEventWireup="true" CodeFile="frmPublisher_Delete.aspx.cs" Inherits="frmPublisher_Delete" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <table>

        <tr>

            <td colspan="2">Enter values

            </td>

        </tr>

        <tr>

            <td>

               Name

            </td>

            <td>

                <asp:TextBox ID="txtName" runat="server" ReadOnly="true">

                </asp:TextBox>

            </td>

        </tr>

        <tr>

            <td>

               Site

            </td>

            <td>

                <asp:TextBox ID="txtSite" runat="server" ReadOnly="true">

                </asp:TextBox>

            </td>

        </tr>

        <tr>

            <td><asp:Button ID="btnSave" Text="Delete" runat="server" OnClick="btnSave_Click" />

            </td>

            <td><asp:Button ID="btnCancel" Text="Cancel" runat="server" OnClick="btnCancel_Click" />

            </td>

        </tr>

    </table>

</asp:Content>

Next time we will put some modifications to the site: a site map(in order to can have indications for the user where he is)  and code to change and load resources in English and French languages at run time.