What's New?

Two Grids - Update/Insert/Del - Ignoring 2nd ReaderID

  1. #1
    Dec 22, 2008, 5:37 PM

    Two Grids - Update/Insert/Del - Ignoring 2nd ReaderID

    Ok - I have two GPs, within two windows. Click on the last col in GP 1, Window2 pops up and GP2 is loaded with the "details" of the selected row (TermID) from GP1. Insert, Update, Delete work great on Window1/GP1.

    GP2, selects as needed - however, when I insert, it does not insert, when I update - it updates same values for all rows (same for deletes). The ReaderID on GP2 is DefID - the ReaderID on GP1 is TermID - it looks like GP2 is ignoring the DEFID and updating and deleting on the TermID

    


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Beta1.aspx.cs" Inherits="Beta1" %>


<%@ Register Assembly="Coolite.Ext.Web" Namespace="Coolite.Ext.Web" TagPrefix="ext" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">


<head runat="server">


<title>Contracts Beta</title>


<style type="text/css">


.x-grid3-td-fullName .x-grid3-cell-inner


{


font-family: tahoma, verdana;


display: block;


font-weight: normal;


font-style: normal;


color: #385F95;


white-space: normal;


}


.x-grid3-row-body p


{


margin: 5px 5px 10px 5px !important;


width: 99%;


color: Gray;


}


.container


{


padding-left: 40px;


padding-top: 40px;


}


</style>


<script type="text/javascript">


var fullName = function(value, metadata, record, rowIndex, colIndex, store) {


return '' + record.data.LastName + ' ' + record.data.FirstName + '';


};





var comments = function(v) {


if(v != null)


{


return '<p>' + v + '</p>';


} 


else{


return '';


} 


};





var pctChange = function(v) {


var returnVal='';


if((v==null)||(v=='')){


return returnVal


}else{returnVal


return returnVal=(parseFloat(v) * 100.0).toFixed(0) + '%';


}


};





function deleteRows(grid) {


Ext.Msg.confirm('Term Deletion Confirmation', 'Are you sure you would like to delete the selected Terms?', function(btn) {


if (btn == 'yes') {


grid.deleteSelected();


}


//return focus


grid.view.focusEl.focus();


})


}





function deleteRows2(grid) {


Ext.Msg.confirm('Term Definition Deletion Confirmation', 'Are you sure you would like to delete the selected Term Definition(s)?', function(btn) {


if (btn == 'yes') {


grid.deleteSelected();


}


//return focus


grid.view.focusEl.focus();


})


}





var employeeDetailsRender = function () {


return '<img class="imgEdit" alt="Click to view/edit Contract Term Definitions" style="cursor:pointer;" src="application_form_edit.png" />';


}





var cellClick = function (grid, rowIndex, columnIndex, e) {


var t = e.getTarget();


var record = grid.getStore().getAt(rowIndex); // Get the Record


var columnId = grid.getColumnModel().getColumnId(columnIndex); // Get column id


var linha = grid.selModel.getSelected().data;


if (t.className == 'imgEdit' &amp;&amp; columnId == 'Details') {


Window2.setTitle(linha['TermDesc'] + ' : Term Definitions');


var hdn = &#100;ocument.getElementById('Hidden1');


hdn.value = linha['TermID'];


Store2.reload();


Window2.shadow == false;


Window2.show();





} 


}


</script>


</head>


<body>


<form id="form1" runat="server">


<ext:ScriptManager ID="ScriptManager1" runat="server">


</ext:ScriptManager>


<asp:SqlDataSource ID="sdsTerms" runat="server" ConnectionString="<%$ ConnectionStrings:dbPDE %>"


SelectCommand="SELECT [TermID], [ContractID], [TermDesc], [PTP], [ReimbLevelID], [PercentCharge], [NTE], [DollarRate], [PercentFeeSched], [Comments], [CoPayPercent], [CoPayAmount], [ASCLevel], [ASCReimb], [ProFeeAmount], [ProFeePercent] FROM [CM_tblContractTerms]"


DeleteCommand="DELETE FROM CM_tblContractTerms WHERE TermID = @TermID" InsertCommand="INSERT INTO [dbPDE].[dbo].[CM_tblContractTerms]


([ContractID]


,[TermDesc]


,[PTP]


,[ReimbLevelID]


,[PercentCharge]


,[NTE]


,[DollarRate]


,[PercentFeeSched]


,[Comments]


,[CoPayPercent]


,[CoPayAmount]


,[ASCLevel]


,[ASCReimb]


,[ProFeeAmount]


,[ProFeePercent])


VALUES


(1


,@TermDesc


,@PTP


,@ReimbLevelID


,@PercentCharge


,@NTE


,@DollarRate


,@PercentFeeSched


,@Comments


,@CoPayPercent


,@CoPayAmount


,@ASCLevel


,@ASCReimb


,@ProFeeAmount


,@ProFeePercent)" UpdateCommand="UPDATE [dbPDE].[dbo].[CM_tblContractTerms]


SET [ContractID] = @ContractID


,[TermDesc] = @TermDesc


,[PTP] = @PTP


,[ReimbLevelID] = @ReimbLevelID


,[PercentCharge] = @PercentCharge


,[NTE] = @NTE


,[DollarRate] = @DollarRate


,[PercentFeeSched] = @PercentFeeSched


,[Comments] = @Comments


,[CoPayPercent] = @CoPayPercent


,[CoPayAmount] = @CoPayAmount


,[ASCLevel] = @ASCLevel


,[ASCReimb] = @ASCReimb


,[ProFeeAmount] = @ProFeeAmount


,[ProFeePercent] = @ProFeePercent


WHERE TermID = @TermID">


<DeleteParameters>


<asp:Parameter Name="TermID" Type="Int32" />


</DeleteParameters>


<UpdateParameters>


<asp:Parameter Name="ContractID" />


<asp:Parameter Name="TermDesc" />


<asp:Parameter Name="PTP" />


<asp:Parameter Name="ReimbLevelID" />


<asp:Parameter Name="PercentCharge" />


<asp:Parameter Name="NTE" />


<asp:Parameter Name="DollarRate" />


<asp:Parameter Name="PercentFeeSched" />


<asp:Parameter Name="Comments" />


<asp:Parameter Name="CoPayPercent" />


<asp:Parameter Name="CoPayAmount" />


<asp:Parameter Name="ASCLevel" />


<asp:Parameter Name="ASCReimb" />


<asp:Parameter Name="ProFeeAmount" />


<asp:Parameter Name="ProFeePercent" />


<asp:Parameter Name="TermID" />


</UpdateParameters>


<InsertParameters>


<asp:Parameter Name="TermDesc" />


<asp:Parameter Name="PTP" />


<asp:Parameter Name="ReimbLevelID" />


<asp:Parameter Name="PercentCharge" />


<asp:Parameter Name="NTE" />


<asp:Parameter Name="DollarRate" />


<asp:Parameter Name="PercentFeeSched" />


<asp:Parameter Name="Comments" />


<asp:Parameter Name="CoPayPercent" />


<asp:Parameter Name="CoPayAmount" />


<asp:Parameter Name="ASCLevel" />


<asp:Parameter Name="ASCReimb" />


<asp:Parameter Name="ProFeeAmount" />


<asp:Parameter Name="ProFeePercent" />


</InsertParameters>


</asp:SqlDataSource>


<asp:SqlDataSource ID="sdsDefs" runat="server" ConnectionString="<%$ ConnectionStrings:dbPDE %>"


SelectCommand="SELECT DefID, TermID, DefTypeID, DefValue, Comments, SecondaryCodes, ExcludeCodes FROM CM_tblContract_TermDefs WHERE TermID = @TermID"


DeleteCommand="DELETE FROM [dbPDE].[dbo].[CM_tblContract_TermDefs] WHERE @DefID = @DefID"


InsertCommand="INSERT INTO [dbPDE].[dbo].[CM_tblContract_TermDefs]


([TermID]


,[DefTypeID]


,[DefValue]


,[Comments]


,[SecondaryCodes]


,[ExcludeCodes])


VALUES


(@TermID;


,@DefTypeID;


,@DefValue;


,@Comments;


,@SecondaryCodes;


,@ExcludeCodes)" UpdateCommand="UPDATE [dbPDE].[dbo].[CM_tblContract_TermDefs]


SET [DefTypeID] = @DefTypeID


,[DefValue] = @DefValue


,[Comments] = @Comments


,[SecondaryCodes] = @SecondaryCodes


,[ExcludeCodes] = @ExcludeCodes


WHERE @DefID = @DefID">


<SelectParameters>


<asp:ControlParameter ControlID="Hidden1" Name="TermID" PropertyName="Value" />


</SelectParameters>


<DeleteParameters>


<asp:Parameter Name="DefID" />


</DeleteParameters>


<UpdateParameters>


<asp:Parameter Name="DefTypeID" Type="String" />


<asp:Parameter Name="DefValue" Type="String" />


<asp:Parameter Name="Comments" Type="String" />


<asp:Parameter Name="SecondaryCodes" Type="String" />


<asp:Parameter Name="ExcludeCodes" Type="String" />


<asp:Parameter Name="DefID" Type="Int32" />


</UpdateParameters>


<InsertParameters>


<asp:Parameter Name="TermID" Type="Int32" />


<asp:Parameter Name="DefTypeID" />


<asp:Parameter Name="DefValue" />


<asp:Parameter Name="Comments" />


<asp:Parameter Name="SecondaryCodes" />


<asp:Parameter Name="ExcludeCodes" />


</InsertParameters>


</asp:SqlDataSource>


<ext:Store ID="Store1" runat="server" DataSourceID="sdsTerms" OnAfterAjaxEvent="Store1_AfterAjaxEvent"


OnRefreshData="Store1_RefershData">


<Reader>


<ext:JsonReader ReaderID="TermID">


<Fields>


<ext:RecordField Name="TermID" />


<ext:RecordField Name="ContractID" />


<ext:RecordField Name="TermDesc" />


<ext:RecordField Name="PTP" />


<ext:RecordField Name="ReimbLevelID" />


<ext:RecordField Name="PercentCharge" Type="Float" />


<ext:RecordField Name="NTE" />


<ext:RecordField Name="DollarRate" />


<ext:RecordField Name="PercentFeeSched" Type="Float" />


<ext:RecordField Name="Comments" />


<ext:RecordField Name="CoPayPercent" Type="Float" />


<ext:RecordField Name="CoPayAmount" />


<ext:RecordField Name="ASCLevel" />


<ext:RecordField Name="ASCReimb" />


<ext:RecordField Name="ProFeeAmount" />


<ext:RecordField Name="ProFeePercent" Type="Float" />


</Fields>


</ext:JsonReader>


</Reader>


<Listeners>


<LoadException Handler="Ext.Msg.alert('Terms - Load failed', e.message || e )" />


<CommitFailed Handler="Ext.Msg.alert('Terms - Commit failed', 'Reason: ' + msg)" />


<SaveException Handler="Ext.Msg.alert('Terms - Save failed', e.message || e)" />


</Listeners>


</ext:Store>


<ext:Store ID="Store2" runat="server" DataSourceID="sdsDefs" OnRefreshData="Store2_Refresh"


RefreshAfterSaving="Always">


<Reader>


<ext:JsonReader ReaderID="DefID">


<Fields>


<ext:RecordField Name="DefID" Type="Int" />


<ext:RecordField Name="TermID" Type="Int" />


<ext:RecordField Name="DefTypeID" Type="String" />


<ext:RecordField Name="DefValue" Type="String" />


<ext:RecordField Name="SecondaryCodes" Type="String" />


<ext:RecordField Name="ExcludeCodes" Type="String" />


<ext:RecordField Name="Comments" Type="String" />


</Fields>


</ext:JsonReader>


</Reader>


<Listeners>


<LoadException Handler="Ext.Msg.alert('Terms - Load failed', e.message || e )" />


<CommitFailed Handler="Ext.Msg.alert('Terms - Commit failed', 'Reason: ' + msg)" />


<SaveException Handler="Ext.Msg.alert('Terms - Save failed', e.message || e)" />


</Listeners>


</ext:Store>


<div class="container">


<ext:Window ID="Window1" runat="server" Collapsible="true" Maximizable="true" Icon="Table"


Title="Contract Terms" Width="900" AutoHeight="true" X="50" Y="50" CenterOnLoad="false"


Resizable="false" Closable="False" Draggable="False">


<Body>


<ext:FitLayout ID="FitLayout1" runat="server">


<ext:GridPanel runat="server" AutoExpandColumn="TermDesc" ID="GridPanel1" AutoWidth="true"


AutoHeight="true" StoreID="Store1" HideBorders="False" BodyBorder="False" Border="False"


StripeRows="true">


<ColumnModel ID="ColumnModel1" runat="server">


<Columns>


<ext:Column DataIndex="TermDesc" ColumnID="TermDesc" Header="Description" Width="180">


<Editor>


<ext:TextField ID="TextField1" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="PTP" Header="PTP" Align="Center" Width="60">


<Editor>


<ext:ComboBox ID="cbPTPs" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="PercentCharge" Header="% Chrg" Align="Center" Width="60">


<Renderer Fn="pctChange" />


<Editor>


<ext:TextField ID="TextField2" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="NTE" Header="NTE" Align="Right" Width="60">


<Renderer Format="UsMoney" />


<Editor>


<ext:TextField ID="TextField3" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="DollarRate" Header="$ Rate" Align="Right" Width="60">


<Renderer Format="UsMoney" />


<Editor>


<ext:TextField ID="TextField4" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="PercentFeeSched" Header="% Fee Sch" Align="Center" Width="60">


<Renderer Fn="pctChange" />


<Editor>


<ext:TextField ID="TextField5" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="CoPayPercent" Header="CoPay %" Align="Center" Width="60">


<Renderer Fn="pctChange" />


<Editor>


<ext:TextField ID="TextField6" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="CoPayAmount" Header="CoPay $" Align="Right" Width="60">


<Renderer Format="UsMoney" />


<Editor>


<ext:TextField ID="TextField7" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="ASCLevel" Header="ASC Level" Width="60">


<Editor>


<ext:TextField ID="TextField8" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="ASCReimb" Header="ASC Reimb" Width="70">


<Editor>


<ext:TextField ID="TextField9" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="ProFeeAmount" Header="ProFee $" Align="Right" Width="60">


<Renderer Format="UsMoney" />


<Editor>


<ext:TextField ID="TextField10" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="ProFeePercent" Header="ProFee %" Align="Center" Width="60">


<Renderer Fn="pctChange" />


<Editor>


<ext:TextField ID="TextField11" runat="server" />


</Editor>


</ext:Column>


<ext:Column DataIndex="Comments" Hidden="true" Header="Notes">


<Editor>


<ext:TextArea ID="TextField12" Height="100" runat="server" />


</Editor>


</ext:Column>


<ext:Column ColumnID="Details" DataIndex="TermID" Header="Details" Width="50" Align="Center"


Fixed="true" MenuDisabled="true" Resizable="false" Tooltip="Term Definitions">


<Renderer Fn="employeeDetailsRender" />


</ext:Column>


</Columns>


</ColumnModel>


<View>


<ext:GridView ID="GridView1" runat="server" EnableRowBody="true">


<GetRowClass Handler="rowParams.body = comments(record.data.Comments); return 'x-grid3-row-expanded';" />


</ext:GridView>


</View>


<SelectionModel>


<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="false" />


</SelectionModel>


<KeyMap>


<ext:KeyBinding>


<Keys>


<ext:Key Code="DELETE" />


</Keys>


<Listeners>


<Event Handler="deleteRows(#{GridPanel1});" />


</Listeners>


</ext:KeyBinding>


</KeyMap>


<BottomBar>


<ext:PagingToolBar ID="PagingToolBar1" runat="server" PageSize="10" StoreID="Store1"


DisplayInfo="true" DisplayMsg="Displaying Terms {0} - {1} of {2}" EmptyMsg="No Terms to display" />


</BottomBar>


<Plugins>


<ext:GridFilters runat="server" ID="GridFilters1" Local="true">


<Filters>


<ext:StringFilter DataIndex="TermDesc" />


<ext:NumericFilter DataIndex="DollarRate" />


<ext:NumericFilter DataIndex="NTE" />


<ext:NumericFilter DataIndex="PercentFeeSched" />


<ext:NumericFilter DataIndex="PercentCharge" />


<ext:NumericFilter DataIndex="CoPayAmount" />


<ext:NumericFilter DataIndex="CoPayPercent" />


<ext:NumericFilter DataIndex="ASCLevel" />


<ext:NumericFilter DataIndex="ASCReimb" />


<ext:NumericFilter DataIndex="ProFeeAmount" />


<ext:NumericFilter DataIndex="ProFeePercent" />


<ext:StringFilter DataIndex="Comments" />


</Filters>


</ext:GridFilters>


</Plugins>


<Listeners>


<Show Handler="#{GridPanel1}.syncSize();" />


<CellClick Fn="cellClick" />


</Listeners>


<LoadMask ShowMask="true" Msg="Loading Contract Terms..." />


<SaveMask ShowMask="true" Msg="Committing Term Changes..." />


</ext:GridPanel>


</ext:FitLayout>


</Body>


<Buttons>


<ext:Button runat="server" CommandArgument="" CommandName="" OnClientClick="" Text="Save Changes"


ID="ctl990" Icon="Disk">


<Listeners>


<Click Handler="#{GridPanel1}.save();" />


</Listeners>


</ext:Button>


<ext:Button runat="server" CommandArgument="" CommandName="" OnClientClick="" Text="Insert New Term"


ID="Button1" Icon="Add">


<Listeners>


<Click Handler="#{GridPanel1}.insertRecord(0, {});#{GridPanel1}.getView().focusRow(0);#{GridPanel1}.startEditing(0, 0);" />


</Listeners>


</ext:Button>


</Buttons>


</ext:Window>


<asp:HiddenField ID="Hidden1" runat="server" />


<ext:Window ID="Window2" runat="server" Icon="Table" Title="Term Definitions" ShowOnLoad="false"


Width="530px" AutoHeight="True" Collapsible="True" Y="200" Height="400px" Resizable="False"


BodyStyle="padding: 2px;" Modal="True" Listeners-BeforeShow-Buffer="100">


<Buttons>


<ext:Button runat="server" CommandArgument="" CommandName="" OnClientClick="" Text="Save Changes"


ID="Button2" Icon="Disk">


<Listeners>


<Click Handler="#{GridPanel2}.save();" />


</Listeners>


</ext:Button>


<ext:Button runat="server" CommandArgument="" CommandName="" OnClientClick="" Text="Insert New Term Definition"


ID="Button3" Icon="Add">


<Listeners>


<Click Handler="#{GridPanel2}.insertRecord(0, {});#{GridPanel2}.getView().focusRow(0);#{GridPanel2}.startEditing(0, 0);" />


</Listeners>


</ext:Button>


</Buttons>


<Body>


<ext:GridPanel ID="GridPanel2" Hide="true" runat="server" BodyBorder="False" Border="False"


StoreID="Store2" Icon="Table" Width="500px" StripeRows="True" AutoWidth="True"


TitleCollapse="false" AutoHeight="True" Collapsible="False" AutoExpandColumn="Notes"


AutoScroll="True" AutoShow="False" IconCls="icon-table">


<ColumnModel ID="ColumnModel2" runat="server">


<Columns>


<ext:Column ColumnID="DefType" Width="80" DataIndex="DefTypeID" Header="Defintion Type"


Tooltip="Definition Type">


<Editor>


<ext:ComboBox ID="cbDefTypes" runat="server" />


</Editor>


</ext:Column>


<ext:Column ColumnID="DefValue" Width="130" DataIndex="DefValue" Header="Definition Value"


Tooltip="Code Definition">


<Editor>


<ext:TextField ID="TextField14" runat="server" />


</Editor>


</ext:Column>


<ext:Column ColumnID="SecondaryCodes" DataIndex="SecondaryCodes" Align="Center" Header="Secondary Codes"


Tooltip="Secondary Codes">


<Editor>


<ext:TextField ID="TextField15" runat="server" />


</Editor>


</ext:Column>


<ext:Column ColumnID="ExcludeCodes" DataIndex="ExcludeCodes" Align="Center" Header="Excluded Codes"


Tooltip="Exclude These Codes">


<Editor>


<ext:TextField ID="TextField16" runat="server" />


</Editor>


</ext:Column>


<ext:Column ColumnID="Notes" DataIndex="Comments" Header="Notes" Tooltip="Notes">


<Editor>


<ext:TextField ID="TextField17" runat="server" />


</Editor>


</ext:Column>


</Columns>


</ColumnModel>


<SelectionModel>


<ext:RowSelectionModel ID="RowSelectionModel2" SelectSingle="False" runat="server" />


</SelectionModel>


<KeyMap>


<ext:KeyBinding>


<Keys>


<ext:Key Code="DELETE" />


</Keys>


<Listeners>


<Event Handler="deleteRows2(#{GridPanel2});" />


</Listeners>


</ext:KeyBinding>


</KeyMap>


<BottomBar>


<ext:PagingToolBar ID="PagingToolBar2" runat="server" PageSize="10" StoreID="Store2"


DisplayInfo="true" DisplayMsg="Displaying Definitions {0} - {1} of {2}" />


</BottomBar>


<Listeners>


<Show Handler="#{GridPanel2}.syncSize();" />


</Listeners>


<SaveMask ShowMask="true" Msg="Committing Term Definition Changes..." />


<LoadMask ShowMask="true" Msg="Loading Term Definitions" />


</ext:GridPanel>


</Body>


</ext:Window>






</form>


</body>


</html>
  2. #2
    Dec 22, 2008, 5:42 PM

    RE: Two Grids - Update/Insert/Del - Ignoring 2nd ReaderID

    Tried deleting this one - but errored out on me - pleasei ignore - I am an idiot - had @defID = @defID instead of defID = @defID
  3. #3
    Dec 22, 2008, 5:50 PM

    RE: Two Grids - Update/Insert/Del - Ignoring 2nd ReaderID

    ok. Thanks for the update. I'm happy to hear you found the problem.



    Geoffrey McGill
    Founder
    Ext.NETASP.NET UI Component framework
    RetypeDocumentation website generator
    MojeeLightning fast Emoji library for .NET
    Ext.NET Examples|Ext.NET API Docs|ExtJS API Docs|Twitter

Similar Threads

  1. GridPanel - Update Firing but not insert
    By Tbaseflug in forum 1.x Help
    Replies: 0
    Last Post: Jul 22, 2010, 12:23 AM
  2. [CLOSED] Immediate update of store after update or insert
    By BerndDA in forum 1.x Legacy Premium Help
    Replies: 4
    Last Post: Jul 13, 2010, 9:16 AM
  3. How To Insert, delete, update with Store and sqlDataSource
    By denzaki in forum 1.x Help
    Replies: 0
    Last Post: Jun 10, 2010, 1:18 AM
  4. How do update a form with the auto-generated id after an insert?
    By hansweber2 in forum 1.x Help
    Replies: 0
    Last Post: Sep 01, 2009, 2:52 PM
  5. LINQ - Insert/Update
    By Tbaseflug in forum 1.x Help
    Replies: 1
    Last Post: Dec 22, 2008, 2:13 PM

Posting Permissions