must practice code

 https://www.learnrxjs.io/learn-rxjs/subjects/behaviorsubject

must do it 

https://dev.to/rfornal/creating-a-data-store-in-angular-1f8a

English sites

 https://thesaurus.plus/synonyms/provide_with_food

https://www.code-sample.com/

react with mobile country code

 https://stackblitz.com/edit/staff-form-myzsmb?file=StaffForm.js

 click on menu show list in angular after click that should hide

comands

 ng g c downloadapp --module ../app

ng generate module module-test --module app --routing true --route test

Imp redux angular counter ex

 https://www.youtube.com/watch?v=oTTNHZMjcbo

redux concept 

core db first approach

 https://www.youtube.com/watch?v=CLVJVA9cTuU&t=897s

most important

sql pagelist filter

 >>sql get page list with filter values and pagenation.

if id is not passing make it null then get all values.

hre i am passing id as int so if i pass id 0 then make it null.

COALESCE(NULLIF(@AgentID, '')

here is code.

  

ALTER PROC  [Master].[usp_AccountPageView] 

      

  @AgentID int,  

    

 @Status bit,      

 @PageNo smallint,      

 @Rows smallint ,

@ProfileStatus bit

   

AS       

BEGIN     

   

 ;with AdminStatus as (select lookupid,lookupdescription from config.lookup where LookupCategory='ADMINSTATUS')      

 SELECT Ac.[ID], Ac.[AgentID], Ac.[AccountName], Ac.[ContactPerson], Ac.[EmailID], Ac.[Password], Ac.[MobileNo], Ac.[AdminStatus], Ac.[Status], Ac.[CreatedOn], Ac.[CreatedBy],      

 ISNULL(b.LookupDescription,'') As AdminStatusDescription,Ag.AgencyName ,Ac.ProfileStatus      

 FROM   [Master].[Account] Ac      

 left outer join AdminStatus b on       

  Ac.adminstatus = b.LookupID      

 Left Outer Join Master.Agent Ag ON      

  Ac.AgentID = Ag.ID      

 Where       

  Ac.AgentID = COALESCE(NULLIF(@AgentID, ''), Ac.AgentID)  

  And Ac.Status = @Status 

  And Ac.ProfileStatus=@ProfileStatus

 ORDER BY Ac.[ID]        

 OFFSET @Rows * @PageNo ROWS      

 Fetch NEXT @Rows ROWS ONLY      

      

END      

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

-- END              [Master].[usp_AccountPageView]      

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

go

ALTER PROC [Master].[usp_AccountRecordCount] 

@AgentID int,

@Status bit,

@PageNo smallint,

@Rows smallint,

@ProfileStatus bit

AS 

BEGIN

if @AgentID = 0

select @AgentID=null

SELECT COUNT(0) 

FROM   [Master].[Account] Ac

Left Outer Join Master.Agent Ag ON

Ac.AgentID = Ag.ID

Where

Ac.AgentID = COALESCE(NULLIF(@AgentID, ''), Ac.AgentID)  

And Ac.Status = @Status 

And Ac.ProfileStatus =@ProfileStatus 

END

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

-- END  [Master].[usp_AccountRecordCount]

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

GO

when input 0 make it null

 

ALter PROC [Master].[usp_AccountPageView]     0,'false',0,10 

    

  @AgentID int,

  

 @Status bit,    

 @PageNo smallint,    

 @Rows smallint    

 

AS     

BEGIN    

     SET  @AgentID = CASE WHEN @AgentID= 0 THEN 'null' END

 ;with AdminStatus as (select lookupid,lookupdescription from config.lookup where LookupCategory='ADMINSTATUS')    

 SELECT Ac.[ID], Ac.[AgentID], Ac.[AccountName], Ac.[ContactPerson], Ac.[EmailID], Ac.[Password], Ac.[MobileNo], Ac.[AdminStatus], Ac.[Status], Ac.[CreatedOn], Ac.[CreatedBy],    

 ISNULL(b.LookupDescription,'') As AdminStatusDescription,Ag.AgencyName ,Ac.ProfileStatus    

 FROM   [Master].[Account] Ac    

 left outer join AdminStatus b on     

  Ac.adminstatus = b.LookupID    

 Left Outer Join Master.Agent Ag ON    

  Ac.AgentID = Ag.ID    

 Where     

  Ac.AgentID =  ISNULL(@AgentID, 0 )    

  And Ac.Status = @Status    

 ORDER BY Ac.[ID]      

 OFFSET @Rows * @PageNo ROWS    

 Fetch NEXT @Rows ROWS ONLY    

    

END    

     

deploy angular project free

verify this link to deploy free website here

free app sample

my link  test

SQL

 sql quries

https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

error

 vscode errors

debugging

git errors

 remove last pull use this

git reset --hard HEAD~1

migrationissues

 

1.first error due to microsoft.tools.not installed

2.due to not closed string in appsetting.json

3.this is using model create table cmds.

azureAppDeploy

here how to deploy multiple application in one azure appservice 
1.goto configuration

2.go to tap virtualdirector

3.select add path

4.add /webapi and folder name site\api and main thing is to uncheck directory then it will run as application.

5.deploy files to the virtual path folder site/api later run app with /webapi 

booom u will get result

angular issues

 in template ngtemplate

the value ngmodel not work for thia use

 <mat-radio-group aria-label="Select an option" >

                                <mat-radio-button value="true" name="isInclude" ngDefaultControl [(ngModel)]="targetingdata.isInclude">Include</mat-radio-button>

                                <mat-radio-button value="false" name="isInclude"  ngDefaultControl [(ngModel)]="targetingdata.isInclude">Exclude</mat-radio-button>

                            </mat-radio-group>