<asp:GridView ID="gv_dalamlokasi_jadwal"
                        CssClass="table table-bordered"
                        runat="server"
                        BackColor="White"
                        BorderColor="#CCCCCC"
                        BorderStyle="None"
                        BorderWidth="1px"
                        CellPadding="3"
                        DataKeyNames="tugasID"
                        ShowFooter="True"
                        AutoGenerateColumns="False" DataSourceID="ds_rekap_dalamlokasi">
                        <Columns>
                            <asp:TemplateField HeaderText="tugas_id" InsertVisible="false" Visible="False">
                                <ItemTemplate>
                                    <asp:Label ID="lbl_tugas_id" runat="server"><%#Eval("tugasID") %></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Identitas Pegawai" InsertVisible="False" SortExpression="nama">
                                <ItemTemplate>
                                    <asp:Label ID="lbl_nama" runat="server" Text='<%# Eval("nama") %>'></asp:Label>
                                    <br />
                                    <asp:Label ID="lbl_nip" runat="server" Text='<%# Bind("nip") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="edt_nip" runat="server" Text='<%# Bind("nip") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Golongan" InsertVisible="False" SortExpression="gol">
                                <EditItemTemplate>
                                    <asp:Label ID="edt_gol" runat="server" Text='<%# Eval("gol") %>'></asp:Label>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lbl_gol" runat="server" Text='<%# Bind("gol") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Peran" SortExpression="Peran">
                                <EditItemTemplate>
                                    <asp:DropDownList ID="ddl_peran" runat="server" DataSourceID="ds_peran" DataTextField="nmperan" DataValueField="kdperan"></asp:DropDownList>
                                    <asp:ObjectDataSource ID="ds_peran" runat="server" SelectMethod="TampilkanPeran" TypeName="quittance.Kelas.daftarproperti"></asp:ObjectDataSource>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lbl_peran" runat="server" Text='<%# Eval("nmperan") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Tanggal Mulai">
                                <ItemTemplate>
                                    <asp:Label ID="lbl_tgl_mulai" runat="server"><%#Eval("tgl_mulai") %></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="edt_tgl_mulai" runat="server" CssClass="calender" Text='<%#Bind("tgl_mulai") %>'></asp:TextBox>
                                    <ajax:CalendarExtender ID="tgl_mulai_calex" runat="server" TargetControlID="edt_tgl_mulai" Format="dd/MM/yyyy" PopupPosition="Right" />
                                </EditItemTemplate>

                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Tanggal Selesai">
                                <ItemTemplate>
                                    <asp:Label ID="lbl_tgl_selesai" runat="server"><%#Eval("tgl_selesai") %></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="edt_tgl_selesai" runat="server" CssClass="calender" Text='<%#Bind("tgl_selesai") %>'></asp:TextBox>
                                    <ajax:CalendarExtender ID="tgl_selesai_calex" runat="server" TargetControlID="edt_tgl_selesai" Format="dd/MM/yyyy" PopupPosition="Right" />
                                </EditItemTemplate>

                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Jumlah Hari" InsertVisible="false" SortExpression="jumlahhari1">
                                <EditItemTemplate>
                                    <asp:TextBox ID="lbl_jlhhari" runat="server" Text='<%# Eval("jumlahhari1") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="edt_jlhhari" runat="server" Text='<%# Bind("jumlahhari1") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Uang Harian" SortExpression="cst_uharian">
                                <ItemTemplate>
                                    <asp:Label ID="lbl_uharian" runat="server" Text='<%# Bind("uangharian100", "{0:c}") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField ShowHeader="False">
                                <EditItemTemplate>
                                    <asp:LinkButton ID="btn_update_dlmlokasi" runat="server" CausesValidation="True" CommandName="Update" Text="Update" CssClass="btn btn-success"></asp:LinkButton>
                                    &nbsp;
                                    <asp:LinkButton ID="btn_cancel_dlmlokasi" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" CssClass="btn btn-danger"></asp:LinkButton>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:LinkButton ID="btn_edit_dlmlokasi" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" CssClass="btn btn-primary"></asp:LinkButton>
                                    &nbsp;
                                     <asp:LinkButton ID="btn_delete_dlmlokasi" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" CssClass="btn btn-danger"></asp:LinkButton>
                                </ItemTemplate>
                                <FooterTemplate>
                                    <asp:Button ID="add_jadwal" runat="server" Text="Tambah" CssClass="btn btn-success" />
                                </FooterTemplate>
                            </asp:TemplateField>
                        </Columns>
                    </asp:GridView>



                    <asp:ObjectDataSource ID="ds_rekap_dalamlokasi"
                        runat="server"
                        OldValuesParameterFormatString="original{0}"
                        SelectMethod="AmbilJadwal"
                        TypeName="quittance.Kelas.dalamlokasi_rincian"
                        DeleteMethod="DeleteJadwal"
                        InsertMethod="InsertJadwal"
                        UpdateMethod="UpdateJadwal">
                        <DeleteParameters>
                            <asp:Parameter Name="tugasID" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="nip" Type="String" />
                            <asp:Parameter Name="gol" Type="String" />
                            <asp:Parameter Name="kdlokasi" Type="Int32" />
                            <asp:Parameter Name="tgl_mulai" Type="String" />
                            <asp:Parameter Name="tgl_selesai" Type="String" />
                        </InsertParameters>
                        <SelectParameters>
                            <asp:SessionParameter Name="nomorSt" SessionField="nomorst" Type="String" />
                        </SelectParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="tugasID" Type="Int32" />
                            <asp:Parameter Name="nip" Type="String" />
                            <asp:Parameter Name="kdperan" Type="Int32" />
                            <asp:Parameter Name="tgl_mulai" Type="String" />
                            <asp:Parameter Name="tgl_selesai" Type="String" />
                        </UpdateParameters>
                    </asp:ObjectDataSource>

public static int UpdateJadwal(int tugasID, string nip, int kdperan, string tgl_mulai, string tgl_selesai)
        {
            string CS = ConfigurationManager.ConnectionStrings["nikita_app"].ConnectionString;
            using (SqlConnection con = new SqlConnection(CS))
            {
                SqlCommand cmd = new SqlCommand("xp_dalamkota_updatejadwal", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter paramtugasID = new SqlParameter("@tugasID", tugasID);
                cmd.Parameters.Add(paramtugasID);
                SqlParameter paramnip = new SqlParameter("@nip", nip);
                cmd.Parameters.Add(paramnip);
                SqlParameter paramkdperan = new SqlParameter("@kdperan", kdperan);
                cmd.Parameters.Add(paramkdperan);
                SqlParameter paramtgl_mulai = new SqlParameter("@tgl_mulai", tgl_mulai);
                cmd.Parameters.Add(paramtgl_mulai);
                SqlParameter paramtgl_selesai = new SqlParameter("@tgl_selesai", tgl_selesai);
                cmd.Parameters.Add(paramtgl_selesai);
                con.Open();
                return cmd.ExecuteNonQuery();
            }

        }