<%@ 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>
    <div class="form-horizontal">
        <table>
            <div class="row">
                <tr>
                    <td>
                        <div class="span6">
                            <div class="control-group">
                                <div class="control-label">
                                    Office Symbol
                                </div>
                                <div class="controls">
                                    <%#Eval("office_symbol")%>
                                </div>
                            </div>
                        </div>
                    </td>
                    <td>
                        <div class="span3">
                            <div class="control-group">
                                <div class="control-label">
                                    Language Position
                                </div>
                                <div class="controls">
                                    <asp:CheckBox ID="chkBx_lrdp" runat="server" Checked='<%#Eval("LRDP")%>' Enabled="false" />
                                </div>
                            </div>
                        </div>
                    </td>
                </tr>
                <tr>
                    <td>
                        <div class="span6">
                            <div class="control-group">
                                <div class="control-label">
                                    DLAB
                                </div>
                                <div class="controls">
                                    <%#Eval("dlab")%>
                                </div>
                            </div>
                        </div>
                    </td>
                    <td>
                        <div class="span3">
                            <div class="control-group">
                                <div class="control-label">
                                    Chandelier
                                </div>
                                <div class="controls">
                                    <asp:CheckBox ID="chkBx_chandelier" runat="server" Checked='<%#Eval("chandelier")%>' Enabled="false" />
                                </div>
                            </div>
                        </div>
                    </td>
                </tr>
            </div>
        </table>
    </div>
</ItemTemplate>

  </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>