DEV Community: bikashgosai

Update bulk data in second table's one column based upon first table's another column's data which has multiple condition MSSQL

bikashgosai — Tue, 04 Apr 2023 09:54:19 +0000

UPDATE table2
SET column2 = 
  CASE 
    WHEN table1.column1 = 'condition 1' THEN 'new value 1'
    WHEN table1.column1 = 'condition 2' THEN 'new value 2'
    WHEN table1.column1 = 'condition 3' THEN 'new value 3'
    ELSE table2.column2
  END
FROM table2 
JOIN table1 ON table2.some_column = table1.some_column

Remove Invalid File uploaded to input type=file in JavaScript

bikashgosai — Mon, 19 Dec 2022 05:50:30 +0000

Here input parameter is the html element, span is label for filenames.

var readURL = function (input, span) {
    var text = "";
    let fileName = "";
    let isValid = false;
    var files = $(input)[0].files;
    var fileArray = Array.from(files);

    for (var i in files) {
        if ($(files)[i] && typeof $(files)[i]['name'] != "undefined") {

            fileName = $(files)[i].name;
            isValid = checkFileValidation(fileName);

            response.fileName.push(fileName);
            response.valid.push(isValid);

            if (isValid) {
                text += " " + $(files)[i]['name'];
            }
            else {
                fileArray.splice(i, 1);
            }
        }
    }
    $(input)[0].files = new FileListItems(fileArray);

    if (text == "") {
        text = "Upload";
    }
    $('#' + span).text(text);
};

var validFileExtensions = "^.*\.(pdf|jpg|jpeg|gif|png|bmp|doc|docx|ppsx|ppt|pptx|xls|xlsx|7z|zip|rar|csv|txt|rtf|m4a|mp3|mpeg|avi|mpeg4|real|wav|swf|wma|msg)$"
var checkFileValidation = function (fileOrFileName) {
    //Check whether the file is valid file.
    var regex = new RegExp(validFileExtensions);
    if (regex.test(fileOrFileName.toLowerCase())) {
        return true;
    } else {
        return false;
    }
}

Regex that starts with letter, contains 1 uppercase/lowercase letter, one number and no special characters & min 8 characters

bikashgosai — Wed, 23 Mar 2022 10:38:15 +0000

You need to put the lookaheads after ^ and put [a-zA-Z] right after them and quantify the rest with {8,}:

^(?=.*?[a-z])(?=.*?[A-Z])(?=.*?[0-9])[a-zA-Z][a-zA-Z0-9]{8,}$

Regex that starts with letter, contains 1 uppercase/lowercase letter, one number and special characters & min 8 characters

^(?=.*[0-9])(?=.*[!@#$%^&*])[0-9a-zA-Z!@#$%^&*0-9]{8,}$

See the regex demo.
https://regex101.com/r/fGk1AC/1

> Pattern details:

^ - start of a string
(?=.*?[a-z]) - at least 1 lowercase ASCII letter
(?=.*?[A-Z]) - at least 1 uppercase ASCII letter
(?=.*?[0-9]) - at least 1 ASCII digit 5.[a-zA-Z] - an ASCII letter
[a-zA-Z0-9]{7,} - 7 or more ASCII letters or digits (\w also allows _)
$ - end of string.

Get Id of recently added record in Linq.

bikashgosai — Thu, 13 Jan 2022 05:14:22 +0000

After you commit your object into the db the object receives a value in its ID field.
So:

myObject.Field1 = "value";

// Db is the datacontext
db.MyObjects.InsertOnSubmit(myObject);
db.SubmitChanges();
//in case of Repository pattern
db.InsertorUpdate(myObject);
db.commit();

// You can retrieve the id from the object
int id = myObject.ID;

jQuery Validation [Number]

bikashgosai — Thu, 23 Dec 2021 11:18:38 +0000

Here is simple jQuery validation.

HTML code:

<form id="formId" method="post">
<div class="body">
<input class="form-control text-right" type="number" name="fieldName" min="0" max="1000" />
</div>
<div class="footer">
<button type="button" onclick="clearValidation()" class="btn btn-sm" >Cancel</button>
<button id="btnSubmit" type="button or submit" class="btn btn-sm">Submit</button>
</div>
</form>

Put this code on document ready.

$("#formId").validate({
        rules: {
            fieldName: {
                required: true,
                number: true,
                min: 1
            }
        },
        messages: {
            fieldName: {
//Custom messages
                required: "Required",
                min: "Value must be greater than 0"
            }
        }
    });

Check if fields are valid according to rules defined above:

var form = $("#formId");
    if (form.valid()) {
        //do something...
    }
else
{
return;
}

This is code for removing validation on form.


function clearValidation() {
    var form = $("#formId").validate();
    form.resetForm();
}

How to get current time zone in JavaScript

bikashgosai — Tue, 07 Dec 2021 07:07:57 +0000

To get the current browser's time zone, you can use the getTimezoneOffset() method from the JavaScript Date object.

The getTimezoneOffset() returns the time difference, in minutes, between UTC time and local time. The returned value is positive if the local time zone is behind UTC and negative if the local time zone is ahead of UTC.

For example, if your time zone is UTC+5:45, the getTimezoneOffset() method will return -345 minutes:


const date = new Date();
const offset = date.getTimezoneOffset();
console.log(offset);    // -345

The getTimezoneOffset() works in all modern browsers, Internet Explorer 5 and higher.

Select the first value of DropDown List using jQuery.

bikashgosai — Mon, 06 Dec 2021 06:26:38 +0000

There are mostly 3 ways:

$("#target").val("thevalue");
Just make sure the value in the options tags matches the value in the val method.
$("#target").val($("#target option:first").val());
$("#target").prop("selectedIndex", 0);

Reflection

bikashgosai — Thu, 08 Apr 2021 14:52:40 +0000

Reflection objects are used for obtaining type information at runtime. The classes that give access to the metadata of a running program are in the System.Reflection namespace.

The System.Reflection namespace contains classes that allow you to obtain information about the application and to dynamically add types, values, and objects to the application.

Applications of Reflection
Reflection has the following applications −

It allows view attribute information at runtime.
It allows examining various types in an assembly and instantiate these types.
It allows late binding to methods and properties
It allows creating new types at runtime and then performs some tasks using those types.

// C# program to illustrate
// the use of Reflection
using System;
using System.Reflection;

namespace Reflection_Metadata {

// Define a class Student
class Student {

    // Properties definition
    public int RollNo
    {
        get;
        set;
    }

    public string Name
    {
        get;
        set;
    }

    // No Argument Constructor
    public Student()
    {
        RollNo = 0;
        Name = string.Empty;
    }

    // Parameterised Constructor
    public Student(int rno, string n)
    {
        RollNo = rno;
        Name = n;
    }

    // Method to Display Student Data
    public void displayData()
    {
        Console.WriteLine("Roll Number : {0}", RollNo);
        Console.WriteLine("Name : {0}", Name);
    }
}

class Reflect {

    // Main Method
    static void Main(string[] args)
    {
        // Declare Instance of class Assembly
        // Call the GetExecutingAssembly method
        // to load the current assembly
        Assembly executing = Assembly.GetExecutingAssembly();

        // Array to store types of the assembly
        Type[] types = executing.GetTypes();
        foreach(var item in types)
        {
            // Display each type
            Console.WriteLine("Class : {0}", item.Name);

            // Array to store methods
            MethodInfo[] methods = item.GetMethods();
            foreach(var method in methods)
            {
                // Display each method
                Console.WriteLine("--> Method : {0}", method.Name);

                // Array to store parameters
                ParameterInfo[] parameters = method.GetParameters();
                foreach(var arg in parameters)
                {
                    // Display each parameter
                    Console.WriteLine("----> Parameter : {0} Type : {1}",
                                            arg.Name, arg.ParameterType);
                }
            }
        }
    }
}
}

Output:

Class : Student
--> Method : get_RollNo
--> Method : set_RollNo
----> Parameter : value Type : System.Int32
--> Method : get_Name
--> Method : set_Name
----> Parameter : value Type : System.String
--> Method : displayData
--> Method : ToString
--> Method : Equals
----> Parameter : obj Type : System.Object
--> Method : GetHashCode
--> Method : GetType

Class : Program
--> Method : ToString
--> Method : Equals
----> Parameter : obj Type : System.Object
--> Method : GetHashCode
--> Method : GetType

Search Text in stored procedure in SQL Server

bikashgosai — Wed, 27 May 2020 11:36:06 +0000

SELECT DISTINCT
o.name AS Object_Name,
o.type_desc
FROM sys.sql_modules m
INNER JOIN
sys.objects o
ON m.object_id = o.object_id
WHERE m.definition Like '%[ABD]%' ESCAPE '\'

===============================================================================
Escape the square brackets:
...
WHERE m.definition Like '%[ABD]%' ESCAPE '\'

Then the square brackets will be treated as a string literals not as wild cards.

MS-SQL, LIST FROM TABLE WHOSE VALUE IS REPEATED MORE THAN ONCE.

bikashgosai — Wed, 31 Jul 2019 09:24:43 +0000

SELECT 
NAME, EMAIL, COUNT(*) 
FROM 
USERS 
GROUP BY
 NAME, EMAIL
HAVING COUNT(*) > 1