<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Popup.aspx.vb" Inherits="DX2.Popup" %>
<%@ Register assembly="DevExpress.Web.v15.1, Version=15.1.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web" tagprefix="dx" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
var keyValue;
function OnMoreInfoClick(element, key) {
callbackPanel.SetContentHtml("");
popup.ShowAtElement(element);
keyValue = key;
}
function popup_Shown(s, e) {
callbackPanel.PerformCallback(keyValue);
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SDS_Dep" KeyFieldName="DepID">
<Columns>
<dx:GridViewCommandColumn ShowEditButton="True" ShowNewButtonInHeader="True" VisibleIndex="0">
</dx:GridViewCommandColumn>
<dx:GridViewDataTextColumn FieldName="DepID" ReadOnly="True" Visible="False" VisibleIndex="1">
<EditFormSettings Visible="False" />
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn Caption="Department" FieldName="DepName" VisibleIndex="2">
<GroupRowTemplate>
<dx:ASPxHyperLink ID="ASPxHyperLink1" runat="server" Text="View" />
</GroupRowTemplate>
</dx:GridViewDataTextColumn>
<dx:GridViewDataHyperLinkColumn VisibleIndex="3" Caption="Detalis">
<DataItemTemplate>
<a href="javascript:void(0);" onclick="OnMoreInfoClick(this, '<%# Container.KeyValue %>')">
View...</a>
</DataItemTemplate>
<PropertiesHyperLinkEdit Target="_blank" Text="View">
</PropertiesHyperLinkEdit>
</dx:GridViewDataHyperLinkColumn>
</Columns>
</dx:ASPxGridView>
<dx:ASPxPopupControl ID="ASPxPopupControl1" runat="server" DataSourceID="SqlDataSource1">
</dx:ASPxPopupControl>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HrConnectionString19 %>" DeleteCommand="DELETE FROM [Emp] WHERE [EmpID] = @EmpID" InsertCommand="INSERT INTO [Emp] ([DepID], [EmpName], [EmpAdrees], [Phone], [IsActive]) VALUES (@DepID, @EmpName, @EmpAdrees, @Phone, @IsActive)" SelectCommand="SELECT * FROM [Emp]" UpdateCommand="UPDATE [Emp] SET [DepID] = @DepID, [EmpName] = @EmpName, [EmpAdrees] = @EmpAdrees, [Phone] = @Phone, [IsActive] = @IsActive WHERE [EmpID] = @EmpID">
<DeleteParameters>
<asp:Parameter Name="EmpID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="DepID" Type="Int32" />
<asp:Parameter Name="EmpName" Type="String" />
<asp:Parameter Name="EmpAdrees" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
<asp:Parameter Name="IsActive" Type="Boolean" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="DepID" Type="Int32" />
<asp:Parameter Name="EmpName" Type="String" />
<asp:Parameter Name="EmpAdrees" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
<asp:Parameter Name="IsActive" Type="Boolean" />
<asp:Parameter Name="EmpID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SDS_Dep" runat="server" ConnectionString="<%$ ConnectionStrings:HrConnectionString %>" DeleteCommand="DELETE FROM [Dep] WHERE [DepID] = @DepID" InsertCommand="INSERT INTO [Dep] ([DepName]) VALUES (@DepName)" SelectCommand="SELECT * FROM [Dep]" UpdateCommand="UPDATE [Dep] SET [DepName] = @DepName WHERE [DepID] = @DepID">
<DeleteParameters>
<asp:Parameter Name="DepID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="DepName" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="DepName" Type="String" />
<asp:Parameter Name="DepID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
