<%@ Control Language="VB" AutoEventWireup="false" CodeFile="LingInfoUserControl.ascx.vb" Inherits="controls_LingInfoUserControl" %>
<style type="text/css">
.form-horizontal .control-label {
    width: 180px;
}
.form-horizontal .controls{
    margin-left: 200px;
}
</style>


  <asp:FormView ID="dv_lingInfo" runat="server" DataSourceID="sql_pinfo" AutoGenerateRows="false" GridLines="None">

            <ItemTemplate>
                <table>
                    <tr>
                        <td>
                         Office Symbol
                        </td>
                        <td>
                            <%#Eval("office_symbol")%>
                        </td>
                        <td>
                            Phone
                        </td>
                        <td>
                            <%# Eval("phone")%>
                        </td>
                    </tr>
                    <tr>
                        <td>
                         Language Position
                        </td>
                        <td>
                            <asp:CheckBox ID="chkBx_lrdp" runat="server" Checked='<%#Eval("LRDP")%>' Enabled="false" />
                        </td>
                        <td>
                            Chandelier
                        </td>
                        <td>
                            <asp:CheckBox ID="chkBx_chandelier" runat="server" Checked='<%#Eval("chandelier")%>' Enabled="false" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                         Email
                        </td>
                        <td>
                            <%#Eval("email")%>
                        </td>
                        <td>
                            Deployed
                        </td>
                        <td>
                           <asp:CheckBox ID="chkBx_dep" runat="server" Checked='<%#Eval("pinfo_deployed")%>' Enabled="false" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            SIPR Email
                        </td>
                        <td>
                            <%#Eval("sipremail")%>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            JWICS Email
                        </td>
                        <td>
                            <%#Eval("jwicsemail")%>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            SID
                        </td>
                        <td>
                            <%#Eval("sid")%>
                        </td>
                        <td>ECampus/EClass Logon ID</td>
                        <td><%#Eval("ecampus")%>
                        </td>
                    <tr>
                        <td>
                       Portal User
                        </td>
                       <td>
                            <%#Eval("portal_user")%>
                        </td>
                        <td>Misc</td><td><%#Eval("misc")%></td>
                    </tr>
               </table>
                <div class="control-group">
                        <div class="control-label">
                        </div>
                        <div class="controls">
                            <asp:LinkButton ID="lb_edit" CommandName="Edit" runat="server" CssClass="btn btn-primary" Text="Edit"></asp:LinkButton>
                        </div>
                    </div>
            </ItemTemplate>
       <EditItemTemplate>
           <table>
                        <tr>
                            <td>
                                Office Symbol
                            </td>
                            <td>
                                <asp:TextBox ID="txtBx_offSym" runat="server" Text='<%# Bind("office_symbol")%>'></asp:TextBox>
                            </td>
                            <td>Phone</td><td><asp:TextBox ID="txtBx_phone" runat="server" Text='<%# Bind("phone")%>'></asp:TextBox></td>
                        </tr>
           <div class="control-group">
                        <div class="control-label">
                           Language Position
                        </div>
                        <div class="controls">
                         <asp:CheckBox ID="chkBx_Lrdp" runat="server" Checked='<%# Bind("LRDP")%>' />
                        </div>
           </div>
           <div class="control-group">
                            <div class="control-label">
                                EMAIL
                            </div>
                            <div class="controls">
                                <asp:TextBox ID="txtBx_email" runat="server" Text='<%# Bind("email")%>'></asp:TextBox>
                            </div>
            </div>
             <div class="control-group">
                            <div class="control-label">
                                SIPR EMAIL
                            </div>
                            <div class="controls">
                                <asp:TextBox ID="txtBx_sipremail" runat="server" Text='<%# Bind("sipremail")%>'></asp:TextBox>
                            </div>
            </div>
             <div class="control-group">
                            <div class="control-label">
                                JWICS EMAIL
                            </div>
                            <div class="controls">
                                <asp:TextBox ID="txtBx_jwicsemail" runat="server" Text='<%# Bind("jwicsemail")%>'></asp:TextBox>
                            </div>
            </div>
            <tr>
                <td>SID</td><td><asp:TextBox ID="txtBx_SID" runat="server" Text='<%# Bind("sid")%>' MaxLength ="10"></asp:TextBox></td>
                <td> Ecampus</td>
                   <td>   <asp:TextBox ID="txtBx_ecampus" runat="server" Text='<%# Bind("ecampus")%>'></asp:TextBox></td>
            </tr>
            <tr>
                            <td>
                                Portal User
                            </td>
                            <td>
                                <asp:DropDownList ID="ddl_users" runat="server" DataSourceID="sql_userName" SelectedValue='<%# Bind("portal_user")%>' DataTextField="userName" DataValueField="userName" AppendDataBoundItems="true">
                                    <asp:ListItem Text="Select" Value="" />
                                </asp:DropDownList>
                            </td>
           <td>
                                Misc
                             </td>
                            <td>
                                <asp:TextBox ID="txtBx_misc" runat="server" Text='<%# Bind("Misc")%>' TextMode="MultiLine" Rows="4"></asp:TextBox>
                          </td>
          </tr>
                </table>
                        <div class="control-group">
                            <div class="control-label">
                            </div>
                            <div class="controls">
                                <asp:LinkButton ID="lb_update" CommandName="Update" runat="server" CssClass="btn btn-primary" Text="Update"></asp:LinkButton>
                                <asp:LinkButton ID="lb_cancel" CommandName="Cancel" runat="server" CssClass="btn" Text="Cancel"></asp:LinkButton>
                            </div>
                        </div>

     </EditItemTemplate>
  </asp:FormView>


<asp:SqlDataSource ID="sql_pinfo" runat="server" ConnectionString="<%$ ConnectionStrings:InstantASP_ConnectionString %>"
    SelectCommand="Select office_symbol, LRDP, email, sipremail, jwicsemail, mccep, chandelier, dlab, misc, phone, sid, portal_user, ecampus, pinfo_deployed,  pinfo_cmd_id
     FROM CLPM_Pinfo WHERE Pinfo_IDNumber = @id"
    UpdateCommand="UPDATE CLPM_PINFO
                    SET Office_Symbol = @Office_Symbol,
                        pinfo_deployed = @pinfo_deployed,
                        EMAIL = @email,
                        sipremail = @sipremail
                        jwicsemail = @jwisemail
                       misc = @misc,
                       phone = @phone,
                        sid = @sid,
                        portal_user = @portal_user,
                        UpdateDate = @UpdateDate,
                         MCCEP = @MCCEP,
                        Chandelier = @Chandelier,
                        DLAB = @DLAB,
                        LRDP = @LRDP,
                        ecampus = @ecampus
                    WHERE (Pinfo_IDNumber = @id)">
    <SelectParameters>
        <asp:QueryStringParameter QueryStringField="linguist_id" Name="id" />
    </SelectParameters>
    <UpdateParameters>
        <asp:Parameter Name="Office_Symbol" />
        <asp:Parameter Name="pinfo_deployed" />
        <asp:Parameter Name="email" />
        <asp:Parameter Name="sipremail" />
        <asp:Parameter Name="jwicsemail" />
        <asp:Parameter Name="misc" />
        <asp:Parameter Name="phone" />
        <asp:Parameter Name="sid" />
        <asp:Parameter Name="portal_user" />
        <asp:Parameter Name="UpdateDate" />
        <asp:Parameter Name="MCCEP" />
        <asp:Parameter Name="Chandelier" />
        <asp:Parameter Name="DLAB" />
        <asp:Parameter Name="LRDP" />
        <asp:Parameter Name="Ecampus" />
       <%-- <asp:Parameter Name="pinfo_cmd_id" />--%>
        <asp:QueryStringParameter QueryStringField="linguist_id" Name="id" />
    </UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="sql_mccep" runat="server" ConnectionString="<%$ ConnectionStrings:InstantASP_ConnectionString %>"
    SelectCommand="SELECT [mccep] As mccepVal FROM [DDL_mccep]"></asp:SqlDataSource>
<asp:SqlDataSource ID="sql_userName" runat="server" ConnectionString="<%$ ConnectionStrings:InstantASP_ConnectionString %>"
    SelectCommand="SELECT userName FROM [dbo].[aspnet_Users] ORDER BY userName"></asp:SqlDataSource>