Domain Technical Compatable Platform Knowledge.

1. https://msdn.microsoft.com/en-us/library/aa288468(v=vs.71).aspx

2. https://msdn.microsoft.com/en-us/library/aa288474(v=vs.71).aspx

3. https://msdn.microsoft.com/en-us/library/aa288436(v=vs.71).aspx

4. https://msdn.microsoft.com/en-us/library/ms123401.aspx

5. Symbol Code ID Character
Below link for Symbol barcode reader/
https://www.manualslib.com/manual/167759/Symbol-P370.html?
http://www.csharpteacher.com/2013/01/barcode-reader-for-motorola-mc3000.html
https://wenku.baidu.com/view/aa0fe8d376a20029bd642d95.html

6. How to get the device manufacturer information and for code sample?
http://stackoverflow.com/questions/11317195/determine-mobile-hardware-manufacturer-in-c-sharp
https://msdn.microsoft.com/en-us/library/aa446489.aspx

7. How to detect device information in jQuery
http://stackoverflow.com/questions/3514784/what-is-the-best-way-to-detect-a-mobile-device-in-jquery?rq=1

8. How Hardware communicates with software.
https://www.youtube.com/watch?v=rNl9ol_rPMs
https://www.youtube.com/watch?v=cNN_tTXABUA

9. User Mannual for Symbol Handheld device.
http://automation.bartec.de/DataRoot/mobile/MC9090ex/manuals/motorola/E_Application_for_WM_5.0_and_CE.pdf

10. Windows CE Application Programming book.
http://read.pudn.com/downloads38/ebook/131274/Windows%20CE%20Programming%20[PDA][C%2B%2B].pdf

11. Language packs for Handheld
Korean ->https://forum.xda-developers.com/showthread.php?t=646728
Vietnamse ->https://forum.xda-developers.com/showthread.php?t=1005171

Thai ->https://link-4share.com/download/JfYSjINm/pdamobizthaienabled_v2_2_wm5_cab.html

Japan ->https://link-4share.com/download/8T7VhX3o/2_setup_japan_cab.html
             https://www.codeproject.com/Articles/28234/Survival-guide-to-do-resource-localization-using-C
             https://link-4share.com/download/8T7VhX3o/2_setup_japan_cab.html

12. Cab files description
http://www.cabextract.org.uk/wince_cab_format/
How to add Post Build script for other languages
copy "$(TargetDir)uk-UA\opkb.resources.dll" "$(TargetDir)uk-UA\uk-UA.opkb.resources.dll"

13. Test your web page design for all kind of devices in responsive.
1. http://responsivetest.net/#u=http://www.zootemplate.com|1024|768|1
2. http://www.responsinator.com/

14. Git Kraken Tutorial for Merging Code
https://www.youtube.com/channel/UCp06FAzrFalo3txskS1gCfA

15. Dotnet Zip Library for zip Uploading
https://dotnetzip.codeplex.com/

16. EPPlus Library for Excel dot net library
http://epplus.codeplex.com/
http://stackoverflow.com/questions/41302540/how-do-i-apply-excel-data-validation-for-text-length-to-a-column-with-epplus


17. Excel library for for Excel dot net library
https://code.google.com/archive/p/excellibrary/downloads
https://code.google.com/archive/p/excellibrary/
http://www.c-sharpcorner.com/blogs/create-excelxls-and-xlsx-file-from-c-sharp-using-excellibrary-in-window-application1

18. Mail Client Through Dot net
https://www.codeproject.com/Articles/719490/vmime-NET-Smtp-Pop-Imap-Library-for-Cplusplus-and

19. Newtonsoft json deserializer
http://www.newtonsoft.com/json/help/html/SerializingJSON.htm
https://github.com/JamesNK/Newtonsoft.Json
https://json.codeplex.com/

20. iTextSharp To create PDF through c#
https://www.youtube.com/watch?v=KVA3VWlDzVE&list=PLWmMdHp-BF15T4t_3tJuxzzZFM1lezhVT

https://www.codeproject.com/Articles/686994/Create-Read-Advance-PDF-Report-using-iTextSharp-in

https://www.mikesdotnetting.com/article/89/itextsharp-page-layout-with-columns

21. SAP Connector dlls
https://github.com/ion-sapoval/NSAPConnector/tree/master/Libraries/SAP_DotNetConnector3_x64

http://stackoverflow.com/questions/30206689/sap-rfc-command-using-sap-connector-dll

http://sap-abap-info.blogspot.in/2012/08/connect-to-sap-from-net.html

22. How to Set UP Emulator.

http://blogs.technet.com/b/exchange/archive/2007/09/17/3403937.aspx

23. Photo description article.

http://www.rideau-info.com/photos/whatisdpi.html

24. Windows device emulator.

http://ccm.net/download/download-409-windows-mobile-device-center

25. GitHub Tutorials.

https://www.youtube.com/playlist?list=PLDshL1Z581YYxLsjYwM25HkIYrymXb7H_

26. How to Plan or Analyse any flow.

https://www.microsoft.com/en-in/evalcenter/evaluate-visio-professional-2016?i=1

This is Microsoft Visuo for putting all coming ideas from brain to flow.

27. How to Set UP Emulator.

http://www.hivemq.com/blog/mqtt-essentials-part-3-client-broker-connection-establishment

28. How to Set UP Emulator in windows 10.

https://www.swiftbyte.com/articles/windows-mobile/debugging-windows-mobile-6-5-application-on-windows-10

29. For Creating flowcharts, network diagrams, org charts, floor plans, engineering designs, and more using modern shapes and templates

https://www.draw.io

29. For Creating Web Page, Mobile templates for LLD 

https://www.mockplus.com/

30. How a web page is loading to any client browser:
https://friendlybit.com/css/rendering-a-web-page-step-by-step/

31. Rabbit MQ Tutorials
https://www.cloudamqp.com/blog/2015-05-18-part1-rabbitmq-for-beginners-what-is-rabbitmq.html
https://www.youtube.com/watch?v=deG25y_r6OY
https://www.rabbitmq.com/getstarted.html

32. Signal R hot Links
1. http://signalr.net/
2. https://github.com/SignalR/SignalR
3. https://github.com/aspnet/SignalR
4. https://www.asp.net/signalr
5. https://www.nuget.org/packages/Microsoft.AspNet.SignalR.JS/
6. https://docs.microsoft.com/en-us/aspnet/signalr/overview/guide-to-the-api/working-with-groups
7. https://www.codeproject.com/Tips/1100622/SignalR-Difference-Between-Broadcast-To-All-and-Gr
8. https://www.codeproject.com/Articles/1100425/SignalR-with-ASP-NET-One-to-one-and-Group-Chat-wit
9. https://www.codeproject.com/Articles/889257/Chat-Application-using-ASP-NET-SignalR
To improve Signal R Performances
10. http://www.niceonecode.com/Q-A/DotNet/SignalR/How-to-improve-Signalr-performance/20303

33. #Postman [Rest Api Client in chrome browser]
https://chrome.google.com/webstore/detail/restlet-client-rest-api-t/aejoelaoggembcahagimdiliamlcdmfm

https://chrome.google.com/webstore/detail/postman/fhbjgbiflinjbdggehcddcbncdddomop?utm_source=chrome-app-launcher-info-dialog

Cassandra sumit
------------------------------ https://www.youtube.com/channel/UCvP-AXuCr-naAeEccCfKwUA


when does Cassandra node fail?-----------------------------------------------
https://stackoverflow.com/questions/36095890/when-does-cassandra-node-fail

http://docs.datastax.com/en/archived/cassandra/2.0/cassandra/dml/dml_about_hh_c.html
https://www.datastax.com/dev/blog/modern-hinted-handoff
https://www.datastax.com/dev/blog/how-cassandra-deals-with-replica-failure

Syntax for Datastax:
----------------------------
https://stackoverflow.com/questions/38696316/how-to-list-all-cassandra-tables

select * from system_traces.events limit 1;

CREATE TABLE IF NOT EXISTS Employee(
   EmployeeID int PRIMARY KEY,
   EmployeeName  text,
   DepartmentName text
   );
   
drop TABLE Employee;

select * from Employee;
   
insert into Employee(EmployeeID,EmployeeName,DepartmentName) values(1,'OM','Software');

CREATE COLUMNFAMILY songs (
id uuid PRIMARY KEY,
title text,
album text,
artist text,
data blob
);

select * from songs;   
   
SELECT * FROM system_schema.keyspaces ;

SELECT * FROM system_schema.keyspaces;

create keyspace OMDB1 WITH replication = {
  'class' : 'org.apache.cassandra.locator.SimpleStrategy',
  'replication_factor' : '2'
};

drop keyspace OMDB1;

creating a table script in cassandra db
-------------------------------------------------------
http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTable.html#tabProp
http://docs.datastax.com/en/cql/3.3/cql/cqlIntro.html
http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cql_data_types_c.html

How To Uninstall Oracle Database 11g From Windows
-----------------------------------------------------------------------
http://www.rebellionrider.com/oracle-sql-concepts/how-to-uninstall-oracle-database-11g-from-windows-10-by-manish-sharma.htm#.Wjn_tGHTTIU
https://superuser.com/questions/256762/how-do-i-completely-remove-oracle-11g
https://techjourney.net/manual-and-clean-uninstall-oracle-for-windows/

Lesson on URI
------------------
https://www.dotnetperls.com/uri

JScript Editor Extensions
--------------------------------------------------------------------
https://marketplace.visualstudio.com/items?itemName=VisualStudioProductTeam.JScriptEditorExtensions

Understanding XSS (Cross Site Scripting)
------------------------------------------------------------------------------
https://www.owasp.org/index.php/XSS_(Cross_Site_Scripting)_Prevention_Cheat_Sheet

Why dll refereed from outside not working for current project:
Because this is the rule that if the copy of dll is available anywhere inside the project then if we are referring outside same dll it wont consider the outside dll. It is always take from local copy only.
Check all folder.


How to apply knockout js into asp.net pages:
https://www.codeproject.com/Articles/153735/Using-KnockoutJS-in-your-ASP-NET-applications

How to apply jQuery mobile into asp.net pages:
https://msdn.microsoft.com/en-us/magazine/jj650891.aspx https://www.dotnettricks.com/learn/jquerymobile/what-is-jquery-mobile-and-how-is-it-different-from-jquery-and-jqueryui

How to apply Angular js:
https://www.w3schools.com/angular/angular_databinding.asp

Interesting IIS and Web configurations:
=================================
1. Add below element in main iPAS web.config file ( FrontEnd/web.config) to prevent the information from webservice

 <system.web>
  <webServices>
      <protocols>
        <remove name="Documentation" />
      </protocols>
    </webServices>

  </system.web>

2.Disabled WCF service metadata from browser (eg: method name , parameter information)

Add below elements in the WCF side web config file ( already this element present. Need to modify the value for httpGetEnabled = false 

   <serviceBehaviors>
        <behavior >
          <!-- To avoid disclosing metadata information, 
          set the value below to false and remove the metadata endpoint above before deployment -->
          <serviceMetadata httpGetEnabled="false"/>
   </behavior>
</serviceBehaviors>

3.Disabled F12 feature and right click option in browser to prevent developer tool feature 

4. Add below code (under document.ready event)  under master page Vegam-Responsive.Master 

        jQuery(document).ready(function () {//right click

          $(document).bind("contextmenu", function (e) {
          e.preventDefault();
       });

      $(document).keydown(function (e) {//f-12
       if (e.which === 123) {
            return false;
       }
      });     

5. Disabled Directory Browsing feature in IIS 
     Below are the steps to disable Browsing History in IIS

     1. Open IIS Manager
     2. In Features View, double-click Directory Browsing.
     3. In the Actions pane,  click Disable to disable Directory Browsing  

6. Disabling WCF accessing from outside world. Only configured IP can access WCF application
       * Select WCF application from IIS and select “IP Address and Domain Restrictions” feature
       * Click on ‘Add Allow Entry’ from action pane block
       * Select ‘Specific IP address’ radio button and then enter the host machine address (server IP where WCF is  accessible) and click on 'OK' button
       * Right click on 'Confgiured IP address' and select 'Edit Feature Settings' and select ‘Deny’ – Access for unspecified clients 


Remote IIS debugging in local visual studio:

Step-1:
Download Remote Tools for Visual Studio 2017 64 bit(as per the OS)
https://visualstudio.microsoft.com/downloads/#remote-tools-for-visual-studio-2017

Step-2: 
Install it to IIS Server.

Type in search box MSVSMON to open remote debugger
Set PORT number and allow connection for this port from firewall.

Step-3:
Take the debug dll's and put it on the IIS Server.

Step-4:
Now press CTRL+ALT+P to open attach process and then set connection type as remote in dialog box. Then in connection target put ipaddress of the server and find w3wp processes and attach it to your visual studio.

Thats all if anybody made request to the IIS by any client ways like browser it will hit to our visual studio.

Site Map default db is mysql so if mysql is installed in system than site will try to connect to mysql: 
<!--Site Map default db is mysql so if mysql is installed in system than site will try to connect to mysql
    So while using oracle db it goes to error page-->
    <siteMap>
      <providers>
        <remove name="MySqlSiteMapProvider" />
      </providers>

    </siteMap>

Interop library from microsoft for word printing:
https://www.microsoft.com/en-in/download/details.aspx?id=3508

https://stackoverflow.com/questions/10837437/interop-word-documents-open-is-null/24671664#24671664

MS Office 2010 should be installed to work for word printing.

https://stackoverflow.com/questions/31133505/does-primary-interop-assemblies-pia-require-microsoft-office-to-be-installed

https://stackoverflow.com/questions/854693/printing-excel-using-interop

https://www.wfonts.com/font/idautomationhc39m-free-version

How to display Assembly version number to aspx page:
labelControl.InnerText = Assembly.GetExecutingAssembly().GetName().Version.ToString();
Rules to Release:

1 Before merge keep back up with different dates
2 After each TR and PR Release keep back up of released codes.



filename Identifier
TR_LOCAL Local Test Server
TR Test Server
PR Production Server



Release Subject Format
filename Identifier + _ + V + version number + - + CURRENT 3 CHARACTER OF MONTH + _ + CURRENT YEAR
ex:- TR_V5-NOV_2018


There will be a relation mentained between PR,TR and TR_LOCAL versions. Any change must get link to lowest level of tracker i.e TR_LOCAL then it will be pushed to TR and further it should be pushed to PR.
First a tracker will generate and associated with TR_LOCAL_V5-NOV_2018
Second this tracker will get associated with TR_V5-NOV_2018
Third this tracker will get associated with PR_V5-NOV_2018

There must be no direct release to production or test environment. It must follow the ladder.

We must maintain 3 version's of code anytime
1. Local Test Server.
2. Client Test Server.
3. Client Production Server.


Folder Structure For Review
Review Folder Loc Working_Progress\Working_Final_Code\Review\Jan_2019
Inside Folder Loc Name OF Developer\Tracker ID\ Mulitple Dates


Don't delete reviewed changes which are not moved to production.

Don't accept direct files tell them to send with project folder structure.

Keep a back of pre-change and post-change Projects for each received changes for the same date. To analyze the required changes.

Always ask developers to send changed files each tracker at a time.

There should be an order to release trackers this is because one tracker changes may depend on another tracker changes.

There should be Local Release Halt till it goes to test server and production server. Otherwise we have to keep merging our changes into test server and production server project. Which is not good it's like double work. 

Only Immediate bug fixes or urgent release things should be merged into direct test server and production server project and later into local project also.

There should a scheduled release
For test server like 2 times in a month
1. 2nd week Monday.
2. Last week Monday.

For production server like 1 time in a month
1. 1st week Monday.

For local test release weekly once or maximum twice.

If for the same tracker there is different files change comes multiple times then release with different version names.

Excel Structure to maintain the tracker and to track it till where it is released.

Date

Tracker ID

Tracker Details Released to local server

File Versions

Released CR to Test System

Released CR to Production System

Keep a folder in Local Test Server folder with name as "Moved to Client Test Server".
Keep a folder in Client Test Server folder with name as "Moved to Client Production Server".

Once it goes out of local test server then for same tracker even it contains same file changes it has to release with different version number.

Note:
If we have to maintain same project in multiple servers then we must avoid keeping multiple copies of the same project otherwise in future merging will be difficult. So Keep one local server backup and then whenever you release to one client test server. Same copy must be released to other test servers.

How to include files to deliver to client browser through web config mime type:
<staticContent>
<remove fileExtension=".woff" />
<mimeMap fileExtension=".woff" mimeType="application/font-woff" />
<remove fileExtension=".woff2" />
<mimeMap fileExtension=".woff2" mimeType="font/woff2" />
</staticContent>
We should do these changes on web config level instead of iis level because if we change the server then we may forget to enable these files from IIS.