1. Alex Mackey, Introducing .NET 4.0: with Visual Studio 2010, Apress - 2010 г.

2. Steven Sanderson, Pro ASP.NET MVC Framework, Apress - 2009 г.

3. Trey Nash, Accelerated C# 2010, Apress - 2010 г.

4. Даниэль Арсеновски, Рефакторинг в C# и ASP.NET для профессионалов, Wrox - 2011 г.

ПРИЛОЖЕНИЕ

Содержание файла cabinet.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="cabinet.aspx.cs" Inherits="MonolitMebel.cabinet" Theme="Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Content" runat="server">

<script runat="server">

protected void Page_Load(object sender, EventArgs e)

{

if (IsPostBack && Tb_L.Text == "root" && Tb_P.Text == "root")

MV1.ActiveViewIndex = 1;

Pl.Visible = MV1.ActiveViewIndex == 0 ? false : true;

}

protected void Lb_Command(object sender, CommandEventArgs e)

{

MV1.ActiveViewIndex = Convert.ToInt16(((LinkButton)sender).CommandName);

}

protected void Lb2_Command(object sender, CommandEventArgs e)

{

SqlDataPrdSales.UpdateCommand = "UPDATE [Sales] SET [Purchased] = 1 WHERE ([SaleID] = " + ((LinkButton)sender).CommandName + ")";

SqlDataPrdSales.Update();

}

</script>

<asp:Panel ID="Pl" runat="server" Font-Size="Large">

<asp:LinkButton ID="LbS" runat="server" Text="Заказы" CommandName="1" oncommand="Lb_Command" /> |

<asp:LinkButton ID="LbP" runat="server" Text="Товары" CommandName="2" oncommand="Lb_Command" />

</asp:Panel>

<hr />

<br />

<asp:MultiView ID="MV1" runat="server" ActiveViewIndex="0">

<asp:View ID="View1" runat="server">

<table border="0" cellpadding="0" cellspacing="0">

<tr>

<td>Логин:</td>

<td><asp:TextBox ID="Tb_L" runat="server" /></td>

</tr>

<tr>

<td>Пароль:</td>

<td><asp:TextBox ID="Tb_P" runat="server" TextMode="Password" /></td>

</tr>

<tr>

<td align="center" colspan="2">

<asp:Button ID="Bn_Login" runat="server" Text="Войти" /></td>

</tr>

</table>

</asp:View>

<asp:View ID="View2" runat="server">

<asp:Repeater ID="RPS" runat="server" DataSourceID="SqlDataPrdSales">

<HeaderTemplate><table width="100%" border="0" cellpadding="0" cellspacing="0"></HeaderTemplate>

<ItemTemplate>

<tr><td><%# Eval("PurchasedDate")%></td>

<tr><td><%# Eval("FIO")%></td>

<tr><td><%# Eval("Phone")%></td>

<tr><td><%# Eval("Adress")%></td>

<tr><td><%# Eval("Caption")%></td>

<tr><td><%# Eval("Price") + " руб."%></td>

<tr><td><asp:LinkButton ID="Lb_Succes" runat="server" Text="Готово" oncommand="Lb2_Command" CommandName='<%# Eval("SaleID")%>' /></td>

<tr><td><hr /></td>

</ItemTemplate>

<FooterTemplate></table></FooterTemplate>

</asp:Repeater>

<asp:SqlDataSource ID="SqlDataPrdSales" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>"

SelectCommand="SELECT [SaleID], [Caption], [Price], [FIO], [Phone], [Adress], [PurchasedDate] FROM [SaleProducts] WHERE ([Purchased] = @Purchased)">

<SelectParameters>

<asp:Parameter DefaultValue="false" Name="Purchased" Type="Boolean" />

</SelectParameters>

</asp:SqlDataSource>

</asp:View>

<asp:View ID="View3" runat="server">

<asp:ListView ID="LVPrd" runat="server" DataKeyNames="ProductID" DataSourceID="SqlDataPrd" InsertItemPosition="LastItem">

<EditItemTemplate>

<span style="">№:

<asp:Label ID="ProductIDLabel1" runat="server" Text='<%# Eval("ProductID") %>' />

<br />

Категория:

<asp:TextBox ID="TypeIDTextBox" runat="server" Text='<%# Bind("TypeID") %>' />

<br />

Товар:

<asp:TextBox ID="CaptionTextBox" runat="server" Text='<%# Bind("Caption") %>' />

<br />

Описание:

<asp:TextBox ID="DescriptionTextBox" runat="server" Text='<%# Bind("Description") %>' />

<br />

Размер:

<asp:TextBox ID="SizeTextBox" runat="server" Text='<%# Bind("Size") %>' />

<br />

Цвет:

<asp:TextBox ID="ColorTextBox" runat="server" Text='<%# Bind("Color") %>' />

<br />

Цена:

<asp:TextBox ID="PriceTextBox" runat="server" Text='<%# Bind("Price") %>' />

<br />

<asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Обновить" />

<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Отмена" />

<br />

<br />

</span>

</EditItemTemplate>

<InsertItemTemplate>

<table border="0" cellpadding="0" cellspacing="0">

<tr>

<td>Категория:</td>

<td><asp:TextBox ID="TypeIDTextBox" runat="server" Text='<%# Bind("TypeID") %>' />

<asp:RequiredFieldValidator ID="RFV1" runat="server" ControlToValidate="TypeIDTextBox" ErrorMessage="*" /></td>

</tr>

<tr>

<td>Наименование:</td>

<td><asp:TextBox ID="CaptionTextBox" runat="server" Text='<%# Bind("Caption") %>' /></td>

</tr>

<tr>

<td>Описание:</td>

<td><asp:TextBox ID="DescriptionTextBox" runat="server" Text='<%# Bind("Description") %>' /></td>

</tr>

<tr>

<td>Размер:</td>

<td><asp:TextBox ID="SizeTextBox" runat="server" Text='<%# Bind("Size") %>' /></td>

</tr>

<tr>

<td>Цвет:</td>

<td><asp:TextBox ID="ColorTextBox" runat="server" Text='<%# Bind("Color") %>' /></td>

</tr>

<tr>

<td>Цена:</td>

<td><asp:TextBox ID="PriceTextBox" runat="server" Text='<%# Bind("Price") %>' /></td>

</tr>

<tr>

<td>

<asp:Button ID="Button1" runat="server" CommandName="Insert" Text="Вставить" />

<asp:Button ID="Button2" runat="server" CommandName="Cancel" Text="Очистить" />

</td>

<td></td>

</tr>

</table>

</InsertItemTemplate>

<ItemTemplate>

<span style="">№:

<asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />

<br />

Категория:

<asp:Label ID="TypeIDLabel" runat="server" Text='<%# Eval("TypeID") %>' />

<br />

Заголовок:

<asp:Label ID="CaptionLabel" runat="server" Text='<%# Eval("Caption") %>' />

<br />

Описание:

<asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>' />

<br />

Размер:

<asp:Label ID="SizeLabel" runat="server" Text='<%# Eval("Size") %>' />

<br />

Цвет:

<asp:Label ID="ColorLabel" runat="server" Text='<%# Eval("Color") %>' />

<br />

Цена:

<asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price") %>' />

<br />

<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Изменить" />

<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Удалить" />

<br />

<br />

</span>

</ItemTemplate>

<LayoutTemplate>

<div ID="itemPlaceholderContainer" runat="server" style="">

<span runat="server" id="itemPlaceholder" />

</div>

<div style="">

<asp:DataPager ID="DataPager1" runat="server">

<Fields>

<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />

<asp:NumericPagerField />

<asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />

</Fields>

</asp:DataPager>

</div>

</LayoutTemplate>

</asp:ListView>

<asp:SqlDataSource ID="SqlDataPrd" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" DeleteCommand="DELETE FROM [Products] WHERE [ProductID] = @ProductID" InsertCommand="INSERT INTO [Products] ([TypeID], [Caption], [Description], [Size], [Color], [Price]) VALUES (@TypeID, @Caption, @Description, @Size, @Color, @Price)" SelectCommand="SELECT * FROM [Products]" UpdateCommand="UPDATE [Products] SET [TypeID] = @TypeID, [Caption] = @Caption, [Description] = @Description, [Size] = @Size, [Color] = @Color, [Price] = @Price WHERE [ProductID] = @ProductID">

<DeleteParameters>

<asp:Parameter Name="ProductID" Type="Int32" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Name="TypeID" Type="Int32" />

<asp:Parameter Name="Caption" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Size" Type="String" />

<asp:Parameter Name="Color" Type="String" />

<asp:Parameter Name="Price" Type="Int32" />

</InsertParameters>

<UpdateParameters>

<asp:Parameter Name="TypeID" Type="Int32" />

<asp:Parameter Name="Caption" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Size" Type="String" />

<asp:Parameter Name="Color" Type="String" />

<asp:Parameter Name="Price" Type="Int32" />

<asp:Parameter Name="ProductID" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

</asp:View>

</asp:MultiView>

</asp:Content>

Содержание файла default.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="default.aspx.cs" Inherits="MonolitMebel._default" Theme="Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Content" runat="server">

<script runat="server">

protected void Page_Load(object sender, EventArgs e)

{

if (Request.Params["catId"] != null)

MV1.ActiveViewIndex = 1;

if (Request.Params["prdId"] != null)

MV1.ActiveViewIndex = 2;

if (Request.Params["pageId"] != null)

MV1.ActiveViewIndex = 3;

if (IsPostBack)

SqlDataPrdDsc.Insert();

Tb_Adress.Text = null;

Tb_Phone.Text = null;

Tb_FIO.Text = null;

}

</script>

<asp:MultiView ID="MV1" runat="server" ActiveViewIndex="0">

<asp:View ID="View1" runat="server">

<img border="0" alt="" src="img/pages/np.jpg" />

<asp:Repeater ID="RPrdCat" runat="server" DataSourceID="SqlDataPrdCat">

<HeaderTemplate><div style="background-color: #f5f5f5"></HeaderTemplate>

<ItemTemplate>

<div style="width: 33px; background-color: #f5f5f5; vertical-align: top; display: block; float: left;">

<table bgcolor="white" style="border: 1px solid #e0e0e0; margin: 15px;">

<tbody>

<tr>

<td valign="top" align="center">

<a href="<%# "/?catId=" + Eval("TypeID") %>">

<img border="0" alt="" src="<%# "/img/cat/" + Eval("TypeID") + ".jpg" %>">

</a></td>

</tr>

<tr>

<td valign="middle" bgcolor="#155daf" align="center">

<a href="<%# "/?catId=" + Eval("TypeID") %>"><font color="white"><b><%# Eval("Name")%></b> </font></a>

</td>

</tr>

</tbody>

</table>

</div>

</ItemTemplate>

<FooterTemplate></div></FooterTemplate>

</asp:Repeater>

<asp:SqlDataSource ID="SqlDataPrdCat" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" SelectCommand="SELECT [TypeID], [Name] FROM [ProductsCategory]"></asp:SqlDataSource>

</asp:View>

<asp:View ID="View2" runat="server">

<img border="0" alt="" src="img/pages/np.jpg" />

<asp:ListView ID="LVPrdItm" runat="server" DataKeyNames="ProductID" DataSourceID="SqlDataPrdItm">

<ItemTemplate>

<div style="width: 33%; height: 225px; background-color: #f5f5f5; vertical-align: top; display: block; float: left; border: 1px solid #04478d">

<table style="text-align: center; width: 100%">

<tr>

<td>

<a href="<%# "/?prdId=" + Eval("ProductID") %>"><strong><%# Eval("Caption") %></strong></a>

</td>

</tr>

<tr>

<td>

<a href="<%# "/?prdId=" + Eval("ProductID") %>"><img src="<%# "/img/products/" + Eval("ProductID") + ".jpg" %>" style="max-height: 120px; max-width: 120px" width="120" height="120" /></a>

</td>

</tr>

<tr>

<td>

<strong><%# Eval("Size") %></strong>

</td>

</tr>

<tr>

<td>

Цена: <strong><%# Eval("Price", "{0:n0}") + " руб." %></strong>

</td>

</tr>

<tr>

<th>

<a href="<%# "/?prdId=" + Eval("ProductID") %>">Купить</a>

</th>

</tr>

</table>

</div>

</ItemTemplate>

<LayoutTemplate>

<div ID="itemPlaceholderContainer" runat="server" style="">

<span runat="server" id="itemPlaceholder" />

</div>

<div style="text-align: center;">

<asp:DataPager ID="DataPager1" runat="server" PageSize="9">

<Fields>

<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="False" ShowNextPageButton="False" ShowPreviousPageButton="False" />

<asp:NumericPagerField />

<asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="False" ShowNextPageButton="False" ShowPreviousPageButton="False" />

</Fields>

</asp:DataPager>

</div>

</LayoutTemplate>

</asp:ListView>

</asp:View>

<asp:View ID="View3" runat="server">

<asp:FormView ID="FVPrd" runat="server" DataKeyNames="ProductID" DataSourceID="SqlDataPrdDsc">

<ItemTemplate>

<table style="width: 100%">

<tr>

<td colspan="2">

<h2><%# Eval("Caption") %></h2>

</td>

</tr>

<tr>

<td colspan="2">

<img src="<%# "/img/products/" + Eval("ProductID") + ".jpg" %>" />

</td>

</tr>

<tr>

<td>Размер:</td>

<td><%# Eval("Size")%></td>

</tr>

<tr>

<td valign="top">Дополнительная информация:</td>

<td><%# Eval("Description") %></td>

</tr>

<tr>

<td valign="top">Цвет:</td>

<td><%# Eval("Color")%></td>

</tr>

<tr>

<td valign="top">Цена:</td>

<td><h3><%# Eval("Price", "{0:n0}") + " руб." %></h3></td>

</tr>

</table>

</ItemTemplate>

</asp:FormView>

<table style="width: 100%">

<tr>

<th colspan="2" align="center">Оформление заказа</th>

</tr>

<tr>

<td>Ф.И.О.:</td>

<td>

<asp:TextBox runat="server" ID="Tb_FIO" MaxLength="50" />

<asp:RequiredFieldValidator ID="RFVF" runat="server" ControlToValidate="Tb_FIO" ErrorMessage="*" />

</td>

</tr>

<tr>

<td>Телефон:</td>

<td>

<asp:TextBox runat="server" ID="Tb_Phone" MaxLength="15" />

<asp:RequiredFieldValidator ID="RFVP" runat="server" ControlToValidate="Tb_Phone" ErrorMessage="*" />

</td>

</tr>

<tr>

<td>Адрес:</td>

<td>

<asp:TextBox runat="server" ID="Tb_Adress" MaxLength="100" />

<asp:RequiredFieldValidator ID="RFVA" runat="server" ControlToValidate="Tb_Adress" ErrorMessage="*" />

</td>

</tr>

<tr>

<td>

<asp:Button ID="Bn_Buy" runat="server" Text="Заказать!" />

</td>

</tr>

</table>

</asp:View>

<asp:View ID="View4" runat="server">

<asp:FormView ID="FV1" runat="server" DataSourceID="SqlDataPgs">

<ItemTemplate>

<div class="top_15"><%# Eval("Caption") %></div>

<div class="m3"> </div>

<br /><br />

<%# Eval("Content") %>

</ItemTemplate>

</asp:FormView>

<asp:SqlDataSource ID="SqlDataPgs" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" SelectCommand="SELECT [Caption], [Content] FROM [Pages] WHERE ([Alias] = @Alias)">

<SelectParameters>

<asp:QueryStringParameter DefaultValue="about" Name="Alias" QueryStringField="pageId" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

</asp:View>

</asp:MultiView>

<asp:SqlDataSource ID="SqlDataPrdItm" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>"

SelectCommand="SELECT [ProductID], [Caption], [Size], [Price] FROM [Products] WHERE ([TypeID] = @TypeID)">

<SelectParameters>

<asp:QueryStringParameter Name="TypeID" QueryStringField="catId" DefaultValue="1" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataPrdDsc" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>"

SelectCommand="SELECT [ProductID], [Caption], [Description], [Size], [Color], [Price] FROM [Products] WHERE ([ProductID] = @ProductID)"

InsertCommand="INSERT INTO [Sales] ([ProductID],[FIO],[Phone],[Adress]) VALUES (@ProductID, @FIO, @Phone, @Adress)">

<SelectParameters>

<asp:QueryStringParameter Name="ProductID" QueryStringField="prdId" DefaultValue="1" />

</SelectParameters>

<InsertParameters>

<asp:QueryStringParameter Name="ProductID" QueryStringField="prdId" DefaultValue="1" />

<asp:ControlParameter Name="FIO" ControlID="Tb_FIO" PropertyName="Text" />

<asp:ControlParameter Name="Phone" ControlID="Tb_Phone" PropertyName="Text" />

<asp:ControlParameter Name="Adress" ControlID="Tb_Adress" PropertyName="Text" />

</InsertParameters>

</asp:SqlDataSource>

</asp:Content>

Размещено на Allbest.ur