Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <asp:GridView ID="EntryListGridView" runat="server" AllowPaging="True" AllowSorting="True"
- AutoGenerateColumns="False" CellPadding="5" DataKeyNames="MasterDetailID" DataSourceID="UserEntryList"
- EmptyDataText="No records found. <i>Revise your search terms or report this as a bug or error.</i>"
- Font-Names="Helvetica Neue,Lucida Grande,Segoe UI,Arial,Helvetica,Verdana,sans-serif"
- Font-Size="Small" CssClass="Gridview" GridLines="None" OnDataBound="EntryListGridView_DataBound"
- OnPageIndexChanging="EntryListGridView_PageIndexChanging" OnSelectedIndexChanged="EntryListGridView_OnSelectedIndexChanged"
- HeaderStyle-BackColor="White" SortedDescendingHeaderStyle-VerticalAlign="Top"
- SortedAscendingCellStyle-BackColor="LightGray" SortedAscendingHeaderStyle-Font-Bold="true"
- SortedDescendingCellStyle-BackColor="Beige" SortedDescendingHeaderStyle-Font-Bold="true"
- Width="100%" OnRowCommand="EntryListGridView_RowCommand" OnRowCreated="EntryListGridView_RowCreated"
- OnSelectedIndexChanging="EntryListGridView_SelectedIndexChanging" Visible="False">
- <Columns>
- <asp:TemplateField InsertVisible="False" ShowHeader="False" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <asp:ImageButton ID="imgViewDetail" runat="server" CausesValidation="False" CommandName="Select"
- CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" ImageUrl="magglass.png"
- Width="20" Height="20" AlternateText="View"></asp:ImageButton>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField ConvertEmptyStringToNull="False" InsertVisible="False" ShowHeader="False">
- <ItemTemplate>
- <asp:ImageButton ID="imgEntryListAction" runat="server" CausesValidation="false"
- CommandName="EntryListAction" AlternateText="Add" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>"
- ImageUrl="~/Images/addtowordlist.png" Height="20px" Width="20px" />
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField ConvertEmptyStringToNull="False" InsertVisible="False" ShowHeader="False">
- <ItemTemplate>
- <asp:ImageButton ID="imgRemove" runat="server" CausesValidation="false" CommandName="Remove"
- AlternateText="Remove" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>"
- ImageUrl="~/Images/remove.png" Height="20px" Width="20px" />
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField InsertVisible="False" ShowHeader="False" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <asp:HyperLink ID="hlnkForumID" NavigateUrl='<%# String.Format("EntryDetail.aspx?MasterDetailID={0}", Eval("MasterDetailID")) %>'
- runat="server" Text="<img src='Images/forum.jpg' alt='Discuss in forum.' height='20' width='20' border='0'/>"
- Target="_blank"></asp:HyperLink>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField InsertVisible="False" ShowHeader="False" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <asp:ImageButton ID="imgReport" runat="server" CausesValidation="False" CommandName="ReportEntry"
- CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" ToolTip="Report content."
- OnClick="imgReport_Click" ImageUrl="~/Images/reportentry.png" Width="20" Height="20"
- AlternateText="Report."></asp:ImageButton>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField InsertVisible="False" ShowHeader="False" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <asp:ImageButton ID="btnBookmark" runat="server" CausesValidation="false" CommandName="BookmarkEntry"
- CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" ImageUrl="~/Images/bookmark.jpg"
- Height="20px" Width="20px" AlternateText="Bookmark" />
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField InsertVisible="False" ShowHeader="False" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <asp:ImageButton ID="btnWatchWord" runat="server" CausesValidation="false" CommandName="WatchEntry"
- CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" ImageUrl="~/Images/watch.png"
- Height="25px" Width="25px" AlternateText="Watch" />
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField InsertVisible="False" ShowHeader="False" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <asp:ImageButton ID="imgMove" runat="server" CausesValidation="false" CommandName="MoveEntry"
- CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" ImageUrl="~/Images/move.png"
- Height="25px" Width="25px" AlternateText="Move" />
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="ID" InsertVisible="False"
- SortExpression="MasterDetailID">
- <ItemTemplate>
- <asp:Label ID="lblMasterDetailID" runat="server" CssClass="MasterDetailID" Text='<%# Bind("MasterDetailID") %>'></asp:Label>
- </ItemTemplate>
- <HeaderStyle HorizontalAlign="Left" Font-Bold="False" />
- </asp:TemplateField>
- </Columns>
- <HeaderStyle HorizontalAlign="Left" />
- <PagerSettings FirstPageText="First" LastPageText="Last" Mode="NumericFirstLast"
- NextPageText=">>" PageButtonCount="15" Position="TopAndBottom" PreviousPageText="<<" />
- <PagerStyle HorizontalAlign="Center" />
- <SortedAscendingCellStyle BackColor="LightGray"></SortedAscendingCellStyle>
- <SortedAscendingHeaderStyle Font-Bold="True"></SortedAscendingHeaderStyle>
- <SortedDescendingCellStyle BackColor="Beige"></SortedDescendingCellStyle>
- <SortedDescendingHeaderStyle VerticalAlign="Top" />
- </asp:GridView>
- <asp:Button ID="btnShowSelectEntryList" runat="server" Style="display: none" />
- <ajaxToolkit:ModalPopupExtender runat="server" ID="mdlSelectEntryList" TargetControlID="btnShowSelectEntryList"
- PopupControlID="divPopUp_SelectEntryList" DropShadow="True" BackgroundCssClass="modalBackground"
- CancelControlID="btnCloseSelectEntryList" Enabled="True">
- </ajaxToolkit:ModalPopupExtender>
- <asp:Panel ID="pnlSelectEntryList" runat="server" HorizontalAlign="Center" Height="25px"
- Width="500px" Wrap="true" CssClass="drag" Style="display: none">
- </asp:Panel>
- <div class="modalPopup" id="divPopUp_SelectEntryList" style="display: none;">
- <div id="mdlHeaderSelectEntryList" align="left">
- <asp:Label ID="lblEntry_SelectEntryList" runat="server" Text='<%# Bind("Entry") %>'></asp:Label>
- </div>
- <asp:DetailsView ID="SelectEntryListDetailsView" runat="server" Height="100px" Width="300px"
- AutoGenerateRows="False" DataKeyNames="MasterDetailID" DataSourceID="EntryDetail"
- HeaderText="Select list" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Left"
- HeaderStyle-Font-Size="Larger" GridLines="None" OnDataBound="SelectEntryListDetailsView_DataBound"
- OnItemCommand="SelectEntryListDetailsView_ItemCommand">
- <Fields>
- <asp:TemplateField HeaderText="MasterDetailID" InsertVisible="False" SortExpression="MasterDetailID"
- ConvertEmptyStringToNull="False" Visible="False">
- <ItemTemplate>
- <asp:Label ID="lblMasterDetailID_SelectEntryList" runat="server" Text='<%# Bind("MasterDetailID") %>'
- Visible="False"></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField ShowHeader="false" ConvertEmptyStringToNull="False">
- <ItemTemplate>
- <table>
- <tr>
- <td>
- <asp:HyperLink ID="hlnkForum_SelectEntryList" Target="_blank" runat="server" Font-Size="Large"
- Font-Underline="true" Text='<%# Bind("Entry") %>' NavigateUrl='<%# String.Format("EntryDetail.aspx?MasterDetailID={0}", Eval("MasterDetailID")) %>'></asp:HyperLink>
- </td>
- </tr>
- </table>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="Move to:" HeaderStyle-Font-Bold="true">
- <ItemTemplate>
- <table>
- <tr>
- <td>
- <asp:ListBox ID="lboSelectUserList_SelectEntryList" runat="server" DataSourceID="UserLists"
- DataTextField="UserEntryListName" DataValueField="UserEntryListID" OnSelectedIndexChanged="lboSelectUserList_SelectedIndexChanged"
- Style="font-family: 'Helvetica Neue', 'Lucida Grande', 'Segoe UI', Arial, Helvetica, Verdana, sans-serif"
- Height="50" Width="100px"></asp:ListBox>
- </td>
- </tr>
- </table>
- </ItemTemplate>
- </asp:TemplateField>
- </Fields>
- <HeaderStyle Font-Bold="True" Font-Size="Larger" HorizontalAlign="Left" />
- <FooterTemplate>
- <asp:ImageButton ID="imgSelect" runat="server" Height="20px" Width="20px" CommandName="Add"
- ImageUrl="/Images/btnyes.jpg" />
- <asp:ImageButton ID="imgSelectCancel" runat="server" Height="20px" Width="20px" CommandName="Cancel"
- ImageUrl="/Images/btnno.jpg" />
- </FooterTemplate>
- </asp:DetailsView>
- <table align="left">
- <tr>
- <td>
- <asp:Button ID="btnCloseSelectEntryList" runat="server" Height="10px" Width="10px"
- Style="font-family: 'Helvetica Neue', 'Lucida Grande', 'Segoe UI', Arial, Helvetica, Verdana, sans-serif;
- display: none" Text="Close" />
- </td>
- </tr>
- </table>
- </div>
- </ContentTemplate>
- </asp:UpdatePanel>
- GridViewRow row = (GridViewRow)(((Control)e.CommandSource).NamingContainer);
- //Label lblMasterDetailID = row.FindControl("lblMasterDetailID") as Label;
- string username = GetUserName;
- string constr = ConfigurationManager.ConnectionStrings["POOPS"].ConnectionString;
- using (SqlConnection con = new SqlConnection(constr))
- switch (e.CommandName)
- {
- case "Select":
- using (SqlCommand cmd = new SqlCommand("GetDetail"))
- {
- //Retrieve the row index stored in the CommandArgument property.
- int index = Convert.ToInt32(e.CommandArgument);
- //Retrieve the row that contains the button from the Rows collection.
- GridViewRow idxrow = EntryListGridView.Rows[index];
- int MasterDetailID = Convert.ToInt32(EntryListGridView.DataKeys[idxrow.RowIndex].Value);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@MasterDetailID", MasterDetailID);
- cmd.Connection = con;
- con.Open();
- //Insert the row.
- cmd.ExecuteNonQuery();
- con.Close();
- EntryListDetailsView.PageIndex = MasterDetailID;
- mdlEntryDetail.Show();
- break;
- }
- case "MoveEntry":
- using (SqlCommand cmd = new SqlCommand("GetDetail"))
- {
- ////Retrieve the row index stored in the CommandArgument property.
- int index = Convert.ToInt32(e.CommandArgument);
- ////Retrieve the row that contains the button from the Rows collection.
- GridViewRow idxrow = EntryListGridView.Rows[index];
- int MasterDetailID = Convert.ToInt32(EntryListGridView.DataKeys[idxrow.RowIndex].Value);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@MasterDetailID", MasterDetailID);
- cmd.Connection = con;
- con.Open();
- ////Insert the row.
- cmd.ExecuteNonQuery();
- con.Close();
- EntryListDetailsView.PageIndex = MasterDetailID;
- mdlEntryList.Show();
- break;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement