fernandezja

--------------------------------------------------------------------------------
-- Example JSON_QUERY JSON_VALUE
--------------------------------------------------------------------------------
DECLARE @data VARCHAR(4000)
SET @data=N'[
				{
					"Name": "Yoda",
					"Id": "001"
				},
				{

fernandezja

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <location path="." inheritInChildApplications="false">
    <system.webServer>
		<handlers>
			<add name="aspNetCore" path="*" verb="*" modules="AspNetCoreModuleV2" resourceType="Unspecified" />
		</handlers>
		<aspNetCore processPath=".\WebApp1.exe" 
				  stdoutLogEnabled="false" 
				  stdoutLogFile=".\logs\stdout" 

fernandezja

--Add time to date SQL Server
--------------------------------------------------------------
DECLARE @Hour TIME = '20:00',
		    @Today VARCHAR(10) = CONVERT(VARCHAR(10), GETDATE(), 121)

DECLARE @TodayWithHourString VARCHAR(100) =  CONCAT(@Today, ' ', @Hour)

DECLARE @TodayWithHour DATETIME2(0) = CONVERT(DATETIME2(0), @TodayWithHourString)

SELECT

fernandezja

var inicio = new DateTime(2022, 12, 18);
var fin = new DateTime(2023, 5, 1);


var dias = Enumerable.Range(0, 1 + fin.Subtract(inicio).Days)
                   .Select(offset => inicio.AddDays(offset))
                 .ToArray(); 

var diasSinDomingo = Enumerable.Range(0, 1 + fin.Subtract(inicio).Days)                		 	 	       
                 .Where(offset => (inicio.AddDays(offset)).DayOfWeek != DayOfWeek.Sunday)

fernandezja

Console.WriteLine("Send email with MimeKit + MailKit!");

var from = new MailboxAddress(name: "Demo From", address: "...@outlook.com");
var to = new MailboxAddress(name: "Demo To", address: "...@gmail.com");


var msj = new MimeMessage();
msj.From.Add(from);
msj.To.Add(to);
msj.Subject = "Episode IV";

fernandezja

using System;
using System.Text.RegularExpressions;
using System.Linq;
using System.Numerics;
					
public class Program
{
	public static void Main()
	{
		var longNumberString = "123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789";

fernandezja

public static class TimeSpanExtensions
{
    public static bool IsBetween(this TimeSpan target, TimeSpan start, TimeSpan end)
    {
        if (target == start) return true;
        if (target == end) return true;

        if (start <= end)
            return (target >= start && target <= end);
        else

fernandezja

Web Components Frameworks

Astro

• https://www.astrouxds.com/
• Playground components: https://astro-components.netlify.app/
• https://www.astrouxds.com/components/readme/

OpenUI5

• https://openui5.org/

fernandezja

Nuget list & clean folders

nuget locals all -list
nuget locals all -clear

Reference

• https://docs.microsoft.com/en-us/nuget/reference/nuget-exe-cli-reference

fernandezja

[SQLServer] Convert Float To String/Varchar

-----------------------------------------------------------
-- Convert Float To String/Varchar
-----------------------------------------------------------
DECLARE @FloatValue FLOAT = -58.3921465762225

SELECT