HttpUtility encode vs WebUtility encode

Santhosh N — Mon, 14 Jun 2021 11:23:48 +0000

Hello guys, Today I have learned a difference between HttpUtility.HtmlEncode and WebUtility.HtmlEncode. If you use dot net version less than 4.7 then HttpUtility.HtmlEncode encodes the regional languages. If you want to only html tags need to encode then use WebUtility.HtmlEncode.

var regionalText = "தமிழ்";
        var htmlText = "<script>alert('OK')";

        var httpUtilityRegionalText = HttpUtility.HtmlEncode(regionalText); //&#2980;&#2990;&#3007;&#2996;&#3021;
        var httpUtilityHtmlText = HttpUtility.HtmlEncode(htmlText); //&lt;script&gt;alert(&#39;OK&#39;)

        regionalText = "தமிழ்";
        htmlText = "<script>alert('OK')";

        var webUtilityRegionalText = WebUtility.HtmlEncode(regionalText); //தமிழ்
        var webUtilityHtmlText = WebUtility.HtmlEncode(htmlText); //&lt;script&gt;alert(&#39;OK&#39;)

SQL: Calculate Bussiness Days

Santhosh N — Wed, 24 Feb 2021 13:16:20 +0000

In this example I'm going to give the query to find the business days between two days.

Use this function to calculate the number of business days excluding Saturday and Sunday. Also it will exclude start date and it will include end date.

go
-- Select [dbo].[CalculateBussinessDays]  ('02/18/2021', '03/06/2021')
CREATE or ALTER FUNCTION [dbo].[CalculateBussinessDays] ( 
    @StartDate DATETIME,
    @EndDate  DATETIME 
)
returns INT AS
BEGIN
  DECLARE @tempStartDate     DATETIME= @StartDate;
  DECLARE @tempEndDate       DATETIME = @EndDate;

  IF(@tempStartDate IS NULL
  OR
  @tempEndDate IS NULL)
  BEGIN
    RETURN NULL;
  END
  --To avoid negative values reverse the date if StartDate is grater than EndDate
  IF(@StartDate > @EndDate)
  BEGIN
    SET @StartDate = @tempEndDate;
    SET @EndDate = @tempStartDate;
  END

  DECLARE @Counter           INT = Datediff(day,@StartDate ,@EndDate);
  DECLARE @TempCounter       INT = 0;
  DECLARE @TotalBusinessDays INT = 0;

  WHILE @Counter >= 0
  BEGIN
    IF(@TempCounter > 0 OR @Counter = 1) -- To ignore first day's calculation
    Begin
        SET @TotalBusinessDays = @TotalBusinessDays 
                                        + (Iif(Datename(dw, Dateadd(day,@TempCounter,@StartDate)) 
                                            IN('Monday', 'Tuesday','Wednesday','Thursday','Friday'),1,0))
    END

    SET @Counter = @Counter - 1
    SET @TempCounter = @TempCounter +1
  END
  RETURN @TotalBusinessDays;
END

DEV Community: Santhosh N

HttpUtility encode vs WebUtility encode

SQL: Calculate Bussiness Days