Wednesday, 31 July 2024

interview at techsoloutions

 When processing thousands of data items in a .NET API, which method will you choose in terms of balancing performance and resource usage most efficiently ? 

foreach (var item in data) { 

 ProcessItem(item); } Parallel.ForEach(data, item => { ProcessItem(item); }); foreach (var item in data) { await Task.Run(() => ProcessItem(item)); } await Task.WhenAll(data.Select(item => Task.Run(() => ProcessItem(item)



2.reverse a string without reverse


3.state management

fake APIS

 https://fakestoreapi.com/docs

https://docs.opensea.io/

https://cloudconvert.com/


https://leetcode.com/explore/learn

Tuesday, 30 July 2024

flutter

 https://github.com/Nabinji/100-DaysOf-Futter/blob/main/flutter_firebse_project/lib/main.dart

Wednesday, 24 July 2024

Templates Links

 https://lite.codedthemes.com/mash-able/angular/dashboard


https://lite.codedthemes.com/gradient-able/bootstrap/tbl_bootstrap.html


Monday, 22 July 2024

seqnce update after delete

 UPDATE tbl_WorkFlowMembers

SET Approver_Sequence = Approver_Sequence - 1

WHERE WorkFlow_ID='RAILMY00009' AND Approver_Sequence > 1;


i have sequence like this  to make proper imporved using above like this
Approver_Sequence 1 3 4 5 6 7 8

rolebased sql list

 SELECT 

  F.FormID, 

  F.GroupID,

  FG.GroupName AS GroupName, 

  F.FormName, 

  F.UpdatedOn, 

  F.UpdatedBy, 

  F.IsActive, 

  FG.GroupName

FROM [tbl_Forms] F

JOIN [tbl_FormGroups] FG ON F.GroupID = FG.GroupID

JOIN [tbl_Users] U ON F.UpdatedBy = U.UserID

JOIN [tbl_UserRoles] UR ON U.RoleID = UR.RoleID

WHERE F.IsActive = 1

AND UR.RoleName IN ('superadmin', 'divcountryadmin');


ADE JOB

  Data Engineer (Night Shift - Remote) Job ID: 378310   Remote   India   2 - 5 years Remote Job Link See all jobs Positions: Data Engineer I...