Total Count divided range calculation in c#

Jaffer Sadiq

7y974Visual Basic .NET

Hi,

I have a task ,which if records contains more than 299, i need to pass the value 299 for each call to the backend

eg :

Total Rows = 1000, i need to send each call as 299 i,e(0-299, 300-599, 600-899 ......)

Coding:

output : response. totalrows = 1000;

/// how to write a condition/calculation here

Readdata(reponsexml, response)

///

return response ; //after that i need to add all the Readdata statement output and bind in final response .

Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kapil Gaur7y ago
Accepted answer
Yes Jaffer, the way you have implemented is also fine so there can be multiple ways to do this. Both of below ways of achieving this are good.

Just a small suggestion do not hardcode values inside your code. Use variables to have flexibility to change this 299 value at anytime. Such business requirement may come anytime.
+1
Jaffer Sadiq7y ago
Dear Kapil,

Thanks for your response..

I done by using the below method

if (response.TotalCountRows > 299)

{

for (int i = 300; i <= response.TotalCountRows; i++)

{

search.firstvalue = i;

if ((i + 299) <= response.TotalCountRows)

search.lastvalue = i + 299;

else

search.lastvalue = response.TotalCountRows;

SplitData(search, messageID, response);

i = i + 299;

}

}

0
Kapil Gaur7y ago
Hi Jaffer,
If I understood your scenaio correctly, You want to implement some kind of paging in your application.
So you must write something like this
First Record row = (PageSize * (PageNumber - 1))
Last Record row = (PageSize * (PageNumber)) -1
So for first time it will take
299*(1-1) =0 and (299*1)-1=298

Second time it will execute
299*(2-1)= 299 and (299*2)-1= 597

Third time
299*(3-1) = 598 and (299*3)-1= 896

So in this logic all pairs will be of 299 records I considered 0 to be initial record.

You can write a condition if record count is <= 299 then you can simply return all rows.

I hope this will resolve your problem. Do tweak little bit if required. But you would definitely have got an idea on how to proceed.
+3