Remove Mandatory field from model

Remove the Mandatory field from the model:                

ModelState.Remove("SyncMonth");

ModelState.Remove("NotSyncMonth");

            if (!ModelState.IsValid)

                return GetErrorMessageResult("Warning! You must fill all the required fields");

PowerShell Visual Studio Community

 

Find your new favorite web framework

 Web framework rankings - HotFrameworks

Json Web Tokens jwt.io

 https://jwt.io/

JSON Web Tokens are an open, industry standard RFC 7519 method for representing claims securely between two parties.

UW360 Setting Table : Less Code Think MOre

 

Dev Ops KHALID

 

fun_GetLastDteOfTheMonth

 ALTER FUNCTION [pksf].[fun_GetLastDteOfTheMonth] 

(

@MM nvarchar(15),

@Year INT

)

RETURNS DATE

AS

BEGIN

DECLARE @LastDayOfTheMonth DATE, @MonthName nvarchar(100)

if       @MM='1' OR @MM='01'

set @MonthName='Jan'

else if  @MM='2' OR @MM='02'

set @MonthName='Feb'

else if  @MM='3' OR @MM='03'

set @MonthName='Mar'

else if  @MM='4' OR @MM='04'

set @MonthName='Apr'

else if  @MM='5' OR @MM='05'

set @MonthName='May'

else if  @MM='6' OR @MM='06'

set @MonthName='Jun'

else if  @MM='7' OR @MM='07'

set @MonthName='Jul'

else if  @MM='8' OR @MM='08'

set @MonthName='Aug'

else if  @MM='9' OR @MM='09'

set @MonthName='Sep'

else if  @MM='10'

set @MonthName='Oct'

else if  @MM='11'

set @MonthName='Nov'

else if  @MM='12'

set @MonthName='Dec'

SET @LastDayOfTheMonth=  CAST('01-'+@MonthName+'-'+ CAST(@Year as NVARCHAR(5)) AS DATE);

SET @LastDayOfTheMonth= EOMONTH(@LastDayOfTheMonth);

RETURN @LastDayOfTheMonth

END