Flutter links

 https://www.youtube.com/@createdbykoko

Flutter Listview Continuous Auto Scroll Back and Forth Using Recursion

https://youtu.be/Vc2YLoa0Cns

https://youtu.be/koLFVJS8EOA

https://youtu.be/81nbfr37oxg

https://youtu.be/ktTajqbhIcY

c# linq links 

https://zetcode.com/csharp/filterlist/

React

 https://youtu.be/SSXA2XluIBU

https://youtu.be/7QseojHf30k

SQL

 get newly created Tables LIst

select schema_name(schema_id) as schema_name,

       name as table_name,

       create_date,

       modify_date

from sys.tables

where create_date > DATEADD(DAY, -30, CURRENT_TIMESTAMP)

order by create_date desc;

https://dataedo.com/kb/query/sql-server/find-recently-created-tables.

To know SP Names

select name,create_date,modify_date

from sys.procedures

order by modify_date desc

Angular scroll issues and DropDown

 naviagate to part of page in angular

https://stackoverflow.com/questions/40498333/angular2-how-to-navigate-to-certain-section-of-the-page-identified-with-an-id-at

   <select class="form-control" id="EmpRating" name="EmpRating" [(ngModel)]="competency.EmpRating" required>

                    <option class="dropdown-item" disabled selected value="undefined">

Select an Option</option>

                    <option *ngFor="let R of SkillRatings" [value]="R.SkillRatingID" >

                      {{ R.Title }}

                    </option>

                </select>

SP SQL

 -- =============================================

-- Author : Praveen

-- Create Date :

-- Description : USP_UpdateCountry

-- =============================================

-- Exec [USP_UpdateUser]

CREATE PROCEDURE [dbo].[USP_UpdateUser]

@dtUser [dbo].[UDTT_Users] READONLY, 

@dtUserEntities [dbo].[UDTT_UserAccessEntities] READONLY

AS

BEGIN

BEGIN TRANSACTION [UpdateDetails]

BEGIN TRY

COMMIT TRANSACTION [UpdateDetails]

END TRY    

    BEGIN CATCH

ROLLBACK TRANSACTION [UpdateDetails]

SELECT '0' AS ID, 'false' AS [Status], 'Failed to save' as [Message]

INSERT INTO tbl_Errors(ErrorNumber,ErrorState,ErrorSeverity,ErrorLine,ErrorProcedure,ErrorMessage,ErrorDateTime )

SELECT  

ERROR_NUMBER() AS ErrorNumber, ERROR_STATE() AS ErrorState, ERROR_SEVERITY() AS ErrorSeverity 

,ERROR_LINE() AS ErrorLine, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_MESSAGE() AS ErrorMessage

,GETDATE()

    END CATCH

END

------------------table--------

CREATE TABLE [dbo].[tbl_Errors](

[ErrorID] [int] IDENTITY(1,1) NOT NULL,

[UserName] [nvarchar](100) NULL,

[ErrorNumber] [int] NULL,

[ErrorState] [int] NULL,

[ErrorSeverity] [int] NULL,

[ErrorLine] [int] NULL,

[ErrorProcedure] [nvarchar](max) NULL,

[ErrorMessage] [nvarchar](max) NULL,

[ErrorDateTime] [datetime] NULL,

PRIMARY KEY CLUSTERED 

(

[ErrorID] ASC

)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SQL get data by date conditions

 select * from tbl_UserAccessEntities

 where DATEPART(yy, ModifiedOn) = 2023

 SELECT * FROM tbl_UserAccessEntities WHERE  CONVERT(VARCHAR, ModifiedOn , 120) LIKE '2023-02-13%'

To know latest Procedures crated in sql

SELECT * FROM sys.objects WHERE type='p' ORDER BY modify_date DESC

SELECT name, create_date, modify_date 

FROM sys.objects

WHERE type = 'P'

SELECT name, crdate, refdate 

FROM sysobjects

WHERE type = 'P' 

ORDER BY refdate desc

Angular Issues

to reset template driven form without data become null in data table.

 

 1.this.workFlowMembers={} as any;