Colors in windows 10 - Graphic settings

 Brightness to -60

Only increase contrast - 53

saturation is the colors

How to copy filtered cells in excel

 

1. Select the cells that you want to copy For more information, see Select cells, ranges, rows, or columns on a worksheet. ...
2. Click Home > Find & Select, and pick Go To Special.
3. Click Visible cells only > OK.
4. Click Copy (or press Ctrl+C).

or we can copy by programmatically

Sub CopyFilteredData()

Dim r As Integer, KIA As String, ws As Worksheet

Set ws = ActiveSheet

ws.Range("A1:K1").AutoFilter

r = 1

Do

    r = r + 1

    KIA = ws.Range("H" & r).Value

    On Error Resume Next

    If Sheets(KIA) Is Nothing Then

        ws.Range("A1:K1").AutoFilter Field:=8, Criteria1:=KIA

        ws.Range("A1").CurrentRegion.SpecialCells(xlCellTypeVisible).Copy

        Sheets.Add.Name = KIA

        Sheets(KIA).Paste

        ws.ShowAllData

    End If

Loop While ws.Range("A" & r + 1).Value <> ""

End Sub

        

How to use youtube API - How to use api in asp.net c#

 https://www.googleapis.com/youtube/v3/search?key=${API_KEY}

    &part=snippet&q=${search}&maxResults=${maxResults}&pageToken=${nextPageToken}&publishedBefore=${beforedate}&publishedAfter=${afterdate}&order=${order}&videoDuration=${duration}&type=video`;

reference:- https://codingshiksha.com/javascript/build-a-youtube-video-search-in-javascript-with-pagination-using-youtube-data-api-v3-full-project/

To get the API key

reference:- https://blog.hubspot.com/website/how-to-get-youtube-api-key

https://www.alphavantage.co/documentation/

Disable infinite scrolling of any website

 >Click on padlock icon on address bar(lock icon)

>Click on site settings

>Clik on javascript to disable

reference:- https://ostipsjournal.com/how-do-i-disable-infinite-scroll-for-certain-website-chrome/

ESDM Error

if invoice is not creating correctly in InvoiceCreate.aspx and InvoicePrint.aspx

View/TrainingPartner/Manageinvoice/InvoiceCreate.aspx

View/TrainingPartner/Manageinvoice/InvoicePrint.aspx

than login with admin

Click on master(menu)>Agency Master(menu)>ESDM Seat Creation>"Effective year from-to" will be in 2022-23 not in the form of 2022-2023 (it will show error if you put 2022-2023)

View/Admin/Master/SeatCreation.aspx

------------

Click on master(menu)>Other master(menu)>Rate master > Give the values

otherwise creating invoice will give error

View/Admin/Ratemaster.aspx

----------------

Click on master(menu)>Other master(menu)>GST master > Give the values

otherwise creating invoice will give error

View/Admin/GSTMaster.aspx

------------------------

Click on master(menu)>Other master(menu)>Statewise target(menu)>Some time you save it, it will not not save first time, second time it will save.

View/Admin/Master/StatewiseTargetMaster.aspx

Creating duplicate copy of database in SQL Server - copy one database to another database

>Open SQL Server Management Studio

 > Right click on Databases

> Click on Restore database

> Select the database from source

>Select Destination database name and click on OK

-------------------

or in option (left side)> Check on overwrite the existing database(with replace)

ESDM seat creation

 > Login with Admin

> Click on Master(menu )>Agency Master>Esdm seat creation (View/Admin/Master/SeatCreation.aspx)

>Click on Master (menu)>Other master>Statewise target(view/Admin/master/statewisetargetmaster.aspx)

>Click on Master(menu)> other master> seat allocation(view/admin/master/seatallocationmaster.aspx)

>Click on Super SIA(menu)>Dashboard and click on State

>Click on super SIA(menu)> seat allocation(view/Admin>SuperSIA>SeatAllocationToTP.aspx)

Creating PDF from div with ASP.NET C#

https://drive.google.com/file/d/19bms0SRkRoQNAYNod7gx308q8KN4rFZV/view?usp=sharing

https://drive.google.com/file/d/1x7J8FV9NsWhDsSWWvCFv8bf2-5RTHAMc/view?usp=sharing

https://drive.google.com/file/d/1ZhbTe8OA4woHEzsUYFcQ2At1l458hlS7/view?usp=sharing

https://drive.google.com/file/d/1ZhbTe8OA4woHEzsUYFcQ2At1l458hlS7/view?usp=sharing

How to disable node.js in Task manager, when Visual studio is running

taskkill /im node.exe

 taskkill /f /im node.exe

reference:- https://stackoverflow.com/questions/14790910/stop-all-instances-of-node-js-server#:~:text=Try%20taskkill%20%2FIM%20node.exe,all%20processes%20named%20node.exe%20.&text=I%20had%20to%20use%20taskkill,to%20make%20it%20work%2C%20thanks!

External IP address and Internal IP address

 ipconfig command in command prompt gives internal ipaddress

----------------

In google, what is my ip address is the external IP address

How to pass dbnull or zero values to Textbox ASP.NET C#

 Txt_Reimburse.Text = dt.Rows[0]["NSQF_Reimburse_Duration_in_Hour"] == DBNull.Value ? "0" : Convert.ToString(dt.Rows[0]["NSQF_Reimburse_duration_in_hour"]);

                TXT_OJTNOS.Text = Txt_Reimburse.Text == "0" ? "0" : (Convert.ToString(int.Parse(Txt_Reimburse.Text) - int.Parse(Txt_CHASN.Text)));

different forms of Response.redirect in ASP.NET C#

Response.Redirect("~/Login.aspx?errormessage=No valid session found", false);

Response.Redirect("InvoiceInbox.aspx");

 Response.Redirect("./InvoicePrint.aspx?Invoice_ID=" + Invoice_ID + "&InvoiceNo=" + Invoice_No + "&InVoiceDate=" + Invoice_Date);

How to change icon size for each folder in windows 10

 >Go to C drive

> Click on view and change it to 'medium icons' or 'large icons'

>Click on options and click on ''change folder and search engines"

> Click on 'view' tab> Click on 'apply to folders'

>Do it twice

reference:- https://superuser.com/questions/1165751/how-to-show-all-windows-folders-in-large-icons

Complete flow of Course batch Result publish and Invoice generation-ESDM

 > First create a course in Admin - with selected KIA(ESSC, TSSC, HSSC, NIELIT)

> Go to TP login and Click on manage Course>Apply for new course

> Click on checkbox(NIELIT, TSSC, ESSCI) and select Course and click on apply

>Go to KIA login in which KIA course is applied

>Click on menu 'Manage training partner'> 'Click on Request list of training partner for approval'

>Select the training partner and click on details and click on approve

Table names in ESDM

 TP_Login -------- Training partner login and password

MST_User -------------  PMU user ID and Password

Flags ESDM

Flags
TP
0-NEW
2-Approved
3-Rejected ---------------
KIA	0	2	3 -reject	1-PDF Created	1-NOT Created
====== SIA	0-Show	3-Reject
------------ PMU	2-Approve	3-reject	0-Show
-------------- Flag_Invoice	1-Uploaded	0-Not Uploaded
------------ I_TP_Status	Null-Not uploaded	0 - may be uploaded
--------------- Batch_status	2-Approved	1-Request Send to KIA	3-Rejected	0-New Request May be

How to restore database in SQL Server - BAK File

 > Right click on database

> Click on restore database

> Click on device

> Click on browse

> Click on add (Select the location)

> Click on .bak file

> Give the destination database name(we can change the database name>Also first create the blank database{Also we can rename the database, after restoring it})

How to download SQL latest version

 > First download SQL server express 

> After that download SMSS (SQL Server management studio)

ESDM Introduction

KIA (Key implementing agency)

1) NIELIT--- Login ID NEL

2) ESSCI --- Login ID ESSC

3) TSSC -- Login ID - TSSC

4) HSSC

 SIA State implementing agency

Login ID=stanzinangmo1992@gmail.com

Login ID = cetuplc@gmail.com

kiran.b@apssdc.in

saleem.rizvi@jk.gov.in

gurnam.singh64@punjab.gov.in

pmgr1_sd_task@telangana.gov.in

suseelaj@asapkerala.gov.in

cetuplc@gmail.com

js.irdt@gmail.com

meghalaya.pmu@gmail.com

manipur.pmu@gmail.com

chandigarh.pmu@gmail.com

assam.pmu@gmail.com

rajasthan.pmu@gmail.com

maharashtra.pmu@gmail.com

tripura.pmu@gmail.com

madhyapradesh.pmu@gmail.com

chhattisgarh.pmu@gmail.com

jharkhand.pmu@gmail.com

dadranagarhaveli.pmu@gmail.com

damandiu.pmu@gmail.com

puducherry.pmu@gmail.com

sikkim.pmu@gmail.com

haryana.pmu@gmail.com

prgheadskills.kits@gmail.com

bihar.pmu@gmail.com

delhi.pmu@gmail.com

gujarat.pmu@gmail.com

himachalpradesh.pmu@gmail.com

odisha.pmu@gmail.com

tamilnadu.pmu@gmail.com

westbengal.pmu@gmail.com

arunachalpradesh.pmu@gmail.com

goa.pmu@gmail.com

mizoram.pmu@gmail.com

nagaland.pmu@gmail.com

andamannicobar.pmu@gmail.com

lakshadweep.pmu@gmail.com

andhrapradesh2.pmu@gmail.com

director_sd_tas@telangana.gov.

kerala2.pmu@gmail.com

uttarakhand2.pmu@gmail.com

stanzinangmo1992@gmail.com

PMU Finance

Login ID = pmufinance (password change error)

password:- Admin@123

PMU NIELIT

Login ID = rahulverma

Default password  $P@1573kk

Login ID = sanjay

database name:- ESDM_NIELIT_NEW

Website name :- https://esdm-skill.deity.gov.in/

ESDM - Electronics system design and manufacturing

PMU- Planning and monitoring Unit

TP - Training Partner

User manual :- esdm-skill.diety.gov.in/notification.aspx

App_code folder>-

>Logic part in BLL folder.

>Business objects or Models are in BO Folder

> SQLhelper class in common folder

View folder is having UI part and some pages are in root folder.

NIELIT  Address :- Plot no. 3, PSP pocket, industrial area, sector -9, dwarka , NEW Delhi - 110077

TP names

ESDM-HR-TP-000379(Gramodya yuva)

esdm-pb-tp-000137(ICEI society for education)

--------------------

Certificate saving to location PDF files

/View/CertificationAgency/KIACertificate/Certificates/

/View/CertificationAgency/KIACertificate/FinalCertificates/

/Files/

-----------

Invoice

View\TrainingPartner\TPDocument\Invoice

cancel cheque and pan cards

View\TrainingPartner\TPDocument

--------------------

View\TrainingPartner\StudentData

View\TrainingPartner\TPDocument

---------------------------

Certification Agency (CA) ID in database

ID            Name

1                NIELIT

2                ESSCI

3                TSSC

4                HSSC

Skill development 

Username:- Admin

Password:- Admin@123

How to download batch file

Login with admin> Click on Portal(Menu)> Click on Certificate view(Menu)> Click on Search Student(Button)> Click on ALL Excel(Button)

ESDM new Course Master revision

revision 23 to 93

revision 98 to 101

When you start Google chrome, open it from last pages or new pages or custom pages

 > Go to settings

> Click on "On startup"

> Select the radio box "open the new tab" etc.

Creating category wise blogs in Blogger- Google

 > First create a new post 

> Click on Page settings

> Click on Labels

> Enter category name, if category is already present, than click on that category

> Otherwise select the category and the post will be go in this category.

TODO ESDM

 SELECT * FROM MST_COURSE where Course_Code='TL/S/L4/C081N'

UPDATE MST_COURSE SET course_tp_Status = 0

select * from MST_TP_REGISTRATION where tp_ID = 'esdm-hr-tp-000018'

-----------------

Also in admin login > Master>Agency master> state level master(view>admin>master>statewiselevel.aspx)

Change

Level L1-L2 --------------- 25 to 0%

Level L3 ----------------- 25 to 20%

Level L4 ------------------ 35 to 70%

Level Level 5 - Level 6 --------------- 15 % to 10%

-----------------------

Level 5 to L5/L6 (Update course level )

Login with Admin>Master>Agency master>Course Level Master

(View>Admin>Master>CourseLevel.aspx)

--------------------

UPDATE MST_List_Master SET LM_Active='Y' WHERE LM_Name='07' 

UPDATE MST_List_Master SET LM_Active='Y' WHERE LM_Name='08'

--------------------

Change files here

/Document/Admin/TP_wise_Data.pdf

/Document/Admin/Updated_List_NSQF_ESDM_Course_150920.pdf

Google chrome high power usage in Task bar Window 10

 https://www.addictivetips.com/windows-tips/fix-chrome-software-reporter-tool-high-power-usage-windows-10/

ASP.NET C# button click Event handler on page load event- two event handler on one button

 <asp:Button ID="btnSave" runat="server" Text="Save" CssClass="btn btn-info" 

                        onclick="btnSave_Click" ValidationGroup="Save1" />

<asp:Button ID="btnSearch" CausesValidation="false" runat="server" Text="Search" CssClass="btn btn-primary" 

              onclick="btnSearch_Click" />

aspx.cs page

protected void Page_Load(object sender, EventArgs e)

    {

btnSave.Click += new EventHandler(btnSearch_Click);

}

 protected void btnSearch_Click(object sender, EventArgs e)

    {

}

protected void btnSave_Click(object sender, EventArgs e)

    {

}

How to validate only characters in Textbox ASP.NET C# (textbox only takes given characters not other characters) - textbox valid characters

  <asp:TextBox ID="txtLevel" Width="80%" CssClass="form-control" runat="server" 

                    MaxLength="6"></asp:TextBox>

                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtLevel" SetFocusOnError="true" Display="None" ErrorMessage="Enter Level Name"></asp:RequiredFieldValidator>

                <cc1:ValidatorCalloutExtender ID="reqVal" runat="server" TargetControlID="RequiredFieldValidator1"></cc1:ValidatorCalloutExtender>

                 <cc1:FilteredTextBoxExtender ID="levelFilter" TargetControlID="txtLevel" runat="server" FilterMode="ValidChars" ValidChars="0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-/"></cc1:FilteredTextBoxExtender>

Drop down list ASP.NET C# DataTextField and DatavalueField both same SQL query

 SELECT DISTINCT YearOF as YearOF1,YearOF as YearOF2 FROM [MST_SEATALLOCMASTER]  

Update Table with date in SQL SERVER Converting DATETIME TO VARCHAR OR Vice-Versa

 UPDATE mst_batch  SET BATCH_START_DATE =convert(varchar,'2022-07-22',103)WHERE Batch_CODE = 'BATCH-HR-20453-DB'

varchar to datetime

convert(datetime,PresentInstitutePostingDate,101)

HTML DIV button like click event ASP.NET C#

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using LuminiousUtility.Util;

using System.Data.SqlClient;

using System.Web.Caching;

using Luminious.DataAcessLayer;

using System.IO;

using System.Text;

public partial class View_TrainingPartner_WelcomeTP : System.Web.UI.Page

{

    bool IsPageRefresh=true;

    protected void Page_Load(object sender, EventArgs e)

    {

 this.BatchTotal.Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(this.BatchTotal, string.Empty));

        if (IsPostBack && Request["__EVENTTARGET"] == BatchTotal.UniqueID)

        {

            Lbl_Batch_Div_Status.Text = "";

            BatchTotal_Click(BatchTotal, EventArgs.Empty);

            Lbl_Batch_Div_Status.Text = "0";

        }

}

}

protected void BatchTotal_Click(object sender, EventArgs e)

    {

        GetBatchDetails(0);

    }

aspx page code

<div class="widget-thumb-wrap" id="BatchTotal" style="cursor:pointer" runat="server">