Update multiple rows in a grid with oTrans.Update()

[Stevensi1018 (Steven Simard)]

I have multiple Dashboard where I usually have a button to update all rows at once with a value when the user clicked the button. So, when I click on the button with the code below, it changes the value in the grid. However, it only update one row at a time. I made sure that the BAQ has the ‘Allow updates of multiple rows’ checked. What am I doing wrong?

EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("f8348326-b599-4a56-98a7-388f23c674c9");
foreach (Infragistics.Win.UltraWinGrid.UltraGridRow r in myGrid.Rows)
{
r.Cells["Column"].Value = false;
}
oTrans.Update();

[hkeric.wci (Haso Keric)]

Dont update the grid, if you dont have to… the EpiDataView and DataTable (underlying data) should be accessible to you via code.

How to loop through all Quote tree nodes for Mtl?

There is a .dataView which has filters typically associated to the Parent QuoteAsm. If you want to loop through all the JobMtl’s in that Asm then you can do something like. EpiDataView edvJM = this.oTrans.Factory("JobMtl"); // I have JobMtl, perhaps its QuoteMtl in Quote. foreach (DataRowView drJM in edvJM.dataView) { // Variables decimal vQP = Convert.ToDecimal(drJM["QtyPer"]); string vPC = drJM["Class"].ToString(); // Calculate Per Order & Quantity Per Year drJM["MtlCalcQtyOrder"] = Ma…

[Stevensi1018 (Steven Simard)]

I tried to loop through the dataview with the code at the end of this post and it doesn,t update at all:

Dashboard Customization mass update Date on Grid

I managed to “tab” and move to the next line on the grid by simulating a keystroke using SendKeys.Send("{TAB}"), Then if I manually click Save all the lines are saved correctly. I still want the code to save automatically at the end. If I add oTrans.Update (); to the last line, it executes the save comand while it is still moving to the next line. Is there any code that instead of SendKeys.Send("{TAB}"); that will make sure I’m on the next line before saving? private void epiButtonC1_Click(ob…

[Stevensi1018 (Steven Simard)]

Yes it’s for a Dashboard and I’m not on the cloud

[hkeric.wci (Haso Keric)]

Im not sure if this will help you. I pulled the setRowModOnSelectedRows from Epicor’s way of doing it, this way it also supports it when you have group by… You might just need to tweak grid.Selected.Rows to just be grid.Rows for all (not just selected ones).

setRowModOnSelectedRows(false, mainGrid);
this.oTrans.Update();
this.oTrans.NotifyAll(EpiTransaction.NotifyType.DeleteRow, V_DB_APEPaymentStatusSummar_1View_Row);
MainController.AppControlPanel.HandleToolClick("RefreshTool", new Infragistics.Win.UltraWinToolbars.ToolClickEventArgs(MainController.MainToolManager.Tools["RefreshTool"], null));

private bool setRowModOnSelectedRows(bool onlyOneRec, Ice.Lib.Framework.EpiUltraGrid grid)
{
    bool success = true;
    bool useActiveRow = false;

    if (grid.Selected.Rows.Count == 0)
    {
        if (grid.ActiveRow != null)
        {
            useActiveRow = true;
        }
    }

    if (useActiveRow == false)
    {
        foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in grid.Selected.Rows)
        {
            Infragistics.Win.UltraWinGrid.UltraGridGroupByRow groupByRow = row as Infragistics.Win.UltraWinGrid.UltraGridGroupByRow;
            if (groupByRow == null) {
            	string sStatus = Convert.ToString(row.Cells["UD04_ShortChar01"].Value);
            	if (sStatus == "REJECTED") {
            		row.Cells["Calculated_MarkForDelete"].Value = true;
            	}
            }
        }
    }
    else
    {
        Infragistics.Win.UltraWinGrid.UltraGridRow singleRow = grid.ActiveRow;
    	string sStatus = Convert.ToString(singleRow.Cells["UD04_ShortChar01"].Value);
    	if (sStatus == "REJECTED") {
    		singleRow.Cells["Calculated_MarkForDelete"].Value = true;
    	}
    }

    return success;
}

Also your column must be updatable.

[Stevensi1018 (Steven Simard)]

I’m not sure I understand what this function is doing. I understand that I need to notify the system that the row should be updated by setting the ‘rowmod’ but your function is only setting the grid cells like me, isn’t it?

[hkeric.wci (Haso Keric)]

@Stevensi1018

r.Cells["Column"].Value = false;

First the “Column” should be your real column name. Lets say it is “MyCoolCheckBox” once you got that, then make sure “MyCoolCheckBox” is an updatable column in the Updatable BAQ. Possibly even in the Dashboard, it doesnt have to be visible, but must be Updatable.

[Stevensi1018 (Steven Simard)]

I found my problem. I had an advanced BPM update in my BAQ and I was only reading 1 row from the ttResults table… I added a foreach and verified for RowMod = ‘U’ and it now works great

I’ll try to see if the BeginEdit() and EndEdit() works well if I set the value inside that and set the RowMod to U too. Thanks !