For multiple criteria conditions

Photo from: https://www.newworldai.com/sql-tutorial/
create procedure [dbo].[Usp_Read_Country_Code_Mapping]
@Codes varchar(max) = null…

Preprocessing in the earlier stage

public class TestResultInBound {
[JsonProperty ("supplier_code")]
public string SupplierCode { get; set; }
[JsonProperty ("supplier_name")]
public string SupplierName { get; set; }
[JsonProperty ("commodity_name")]
public string CommodityName { get; set; }
[JsonProperty ("site")]
public string Site { get; set; }
[JsonProperty("unit")]
public string Unit { get; set; }
[JsonProperty ("test_value")]
public string TestValue { get; set; }
[JsonProperty ("test_result")]
public string TestResult { get; set; }
}

Not just compared equality but the difference parts

// SomeClass.cs
public class SomeClass{
public string PropertyName1 {get; set;}
// ...

public override bool Equals(object obj){
var other = obj as SomeClass;
if (other == null){
return false;
}
if(PropertyName1 != other.PropertyName1){
return false;
}
return true;
}
}// in some function or block
var class1 = new SomeClass {PropertyName1 = "Name1"};
var class2 = new SomeClass {PropertyName1 = "Name2"};
// should return false
var requal = class1.Equals(class2)…

Introduction


Photo from: https://www.functionize.com/blog/importance-upstream-unit-testing/


BizTalk — take EDI 850 (X12_00401) N1 looing section as example

Photo from: https://safe-software.gitbooks.io/fme-desktop-basic-training-2017/content/DesktopBasic2Transformation/2.04.SchemaMapping.html
1. Receiving EDI850 (source in)
2. BizTalk mapping and processing
3. Store into database table (target)
4. ERP processing
5. Others...


Photo from: https://www.rina.org/en/business/transport-infrastructure/resilience-engineering

Take ASP.NET Core 3.1 as an example

Photo from: https://wateroxconsulting.com/archives/whitelist/
using Microsoft.AspNetCore.Http.Features;public class EventHub : Hub<IEventHub> {
public override Task OnConnectedAsync () {
var feature = Context.Features.Get<IHttpConnectionFeature>(); // here you could get your…


Using EPPlus package for exporting excel document(s)

Photo from: https://www.syncfusion.com/blogs/post/6-easy-ways-to-export-data-to-excel-in-c-sharp.aspx

Background

public class Customer
{
public string ID{ get; set; }
public string Sex { get; set; }
public string Phone { get; set; }
public string Address { get; set; }
public DateTime CreateDate { get; set; }
}

.NET CORE Console Application

Photo from: https://dailydotnettips.com/how-to-pass-command-line-arguments-using-visual-studio/
public static class Program
{
public static void Main(string[] args)
{
}
}
{Path_Of_Your_App}\AppName arg1 arg2
public static class Program
{
public static void Main(string[] args)
{
Console.WriteLine($"arg1 = {args[0]}");
Console.WriteLine($"arg2 …

LAI TOCA

Coding for fun

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store