How Can Collective confirmation Total Update bool

[Wen-Ting Zhuang]

May you help me?

[Vignesh Natarajan]

Hi Wen-Ting Zhuang,  

 

Thanks for contacting Syncfusion support.  

 

Query: “How Can Collective confirmation Total Update bool” 

 

We have analyzed your query and we suspect that you want to collectively update the single column value (boolean) in Grid. We have achieved this requirement using SetCellValueAsync method and GetCurrentViewDataAsync method of Grid. GetCurrentViewDataAsync method returns the current view data displayed in Grid. using that record details, we have updated the Verified column status in Grid.  

 

Refer the below code example.    

 

<SfButton Content="Update Boolean" OnClick="Update"></SfButton> 

  

<SfGrid @ref="GridInstance" DataSource="@Orders" AllowPaging="true" AllowGrouping="true" Toolbar="@(new List<string>() { "Add", "Edit", "Delete", "Cancel", "Update" })" Height="315"> 

    <GridEditSettings AllowAdding="true" AllowEditing="true" AllowDeleting="true"></GridEditSettings> 

    <GridGroupSettings Columns="@Initial"></GridGroupSettings> 

    <GridColumns> 

        <GridColumn Field=@nameof(Order.Verified) TextAlign="TextAlign.Right" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" IsPrimaryKey="true" TextAlign="TextAlign.Right" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order Date" EditType="EditType.DatePickerEdit" Format="d" TextAlign="TextAlign.Right" Width="130" Type="ColumnType.Date"></GridColumn> 

        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn> 

    </GridColumns> 

</SfGrid> 

  

@code{ 

    public List<Order> Orders { get; set; } 

  

    public SfGrid<Order> GridInstance { get; set; } 

  

    public async Task Update() 

    { 

        var data = await GridInstance.GetCurrentViewRecordsAsync(); 

        foreach (var rec in data) {             

            await GridInstance.SetCellValueAsync(rec.OrderID, "Verified", true); 

        } 

    } 

 

 

Refer the below sample for your reference 

 

Sample: https://www.syncfusion.com/downloads/support/forum/168012/ze/DataGrid_Server85159355.zip 

 

If we misunderstood your query, kindly get back to us with more details about your requirement.  

 

Regards, 

Vignesh Natarajan 

[Wen-Ting Zhuang]

  HELLO,Vignesh Natarajan:

  Function is invalid in Dapper

<SfGrid TValue="DailyReport" @ref="GridInstance"  AllowGrouping="true" AllowPaging="true" ShowColumnMenu="true" Toolbar="@(new List<string>() { "Add", "Edit", "Delete", "Update", "Cancel", "Search" })">

                <SfDataManager AdaptorInstance="typeof(DailyReportDataAdaptor)" Adaptor="Adaptors.CustomAdaptor"></SfDataManager>

                <GridGroupSettings Columns="@GroupedColumns"></GridGroupSettings>

                <GridEditSettings AllowAdding="true" AllowDeleting="true" AllowEditing="true" Mode="EditMode.Dialog" Dialog="DialogParams">

                    <GridSelectionSettings CheckboxOnly="true" PersistSelection="true"></GridSelectionSettings>

                </GridEditSettings>

                <GridPageSettings PageCount="100" PageSize="100"></GridPageSettings>

                <GridColumns>

                    <GridColumn Field="@nameof(DailyReport.UserUpdate)" AutoFit="true" HeaderText="上傳" Width="auto"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.FID)" IsPrimaryKey="true" Visible="true" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.C_DATE)" HeaderText="時間" EditType="EditType.DateTimePickerEdit" Width="auto" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.LotNo)" HeaderText="批號" Width="auto" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Doffcnt)" HeaderText="落紗總數" Width="auto" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Ncnt)" HeaderText="N數" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Mcnt)" HeaderText="M絲數" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.M_SHIFT)" HeaderText="M損" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Dcnt)" HeaderText="D絲數" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Lcnt)" HeaderText="L絲數" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Ycnt)" HeaderText="YO絲數" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Scratch)" HeaderText="伸撚不良數" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.DDwire)" HeaderText="DD絲" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.LLwire)" HeaderText="LL絲" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.BreakYarn)" HeaderText="崩紗" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Wool)" HeaderText="刮傷" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Stretch)" HeaderText="毛絲" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                    <GridColumn Field="@nameof(DailyReport.Oily)" HeaderText="油汙" EditType="EditType.NumericEdit" AutoFit="true"></GridColumn>

                </GridColumns>

            </SfGrid>

        </div>

    </div>

</div>

<style>

    .e-attr {

        background: #5DADE2;

        font-family: "Bell MT";

        color: red;

        font-size: 5px;

    }

</style>

@*@inject IDailyService DailyService

@code {

    DailyReport city = new DailyReport();

    void CreateCity()

    {

        DailyService.CreateCity();

    }

}*@

    @code{

        SfGrid<DailyReport> Grid;

        public string[] GroupedColumns = new string[] { "C_DATE" };

        private DialogSettings DialogParams = new DialogSettings { MinHeight = "400px", Width = "450px" };

        public SfGrid<DailyReport> GridInstance { get; set; }

        public async Task Update()

        {

            var data = await GridInstance.GetCurrentViewRecordsAsync();

            foreach (var rec in data)

            {

                await GridInstance.SetCellValueAsync(rec.FID, "UserUpdate",true);

            }

        }

    }

[Vignesh Natarajan]

Hi Wen-Ting Zhuang,  

 

Query: “  Function is invalid in Dapper” 

 

Previously we have provided the solution to update the Boolean column collectively in external Button Click event (Update). But in your shared code example we could not find SfButton component, hence the update function is not triggered. 

 

We are unclear about the issue you are facing. So kindly share more details about your requirement along with below requested details  

 

1. When do you want to update the Boolean column collectively?
2.  Are you facing any script error / exception in browser console. if yes share the screenshot of the issue.
3. Share more details about the issue you are facing.

 

Above requested details will be very helpful in understanding the reported issue and provide a better solution as early as possible.   

 

Regards, 

Vignesh Natarajan