Mar 24

Misc Dot Net Stuff #Root #By Sayed Ahmed

By Author-Check- Article-or-Video in FromSitesTree.com

In real life projects in .Net platform, you might need to know and understand the following:

http://stackoverflow.com/questions/10498102/debugging-with-vs-other-than-localhost

http://stackoverflow.com/questions/4653236/unable-to-start-debugging-on-the-web-server-could-not-start-asp-net-debugging-v

http://stackoverflow.com/questions/16922742/what-is-the-entry-point-for-an-asp-net-mvc-4-application

https://msdn.microsoft.com/en-us/library/windows/apps/xaml/hh750287.aspx

https://msdn.microsoft.com/en-ca/library/dd577079.aspx

http://blogs.msdn.com/b/amb/archive/2012/07/31/easiest-way-to-generate-machinekey.aspx

http://stackoverflow.com/questions/8747912/how-to-install-dotnetnuke-so-i-can-migrate-existing-users

http://stackoverflow.com/questions/11930381/log4net-multiple-appenders-writing-to-event-viewer

https://portal.smartertools.com/kb/a2487/where-are-my-iis-log-files-stored.aspx

From: http://sitestree.com/?p=2084
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2015-08-07 18:01:36

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Mar 24

misc #Root #By Sayed Ahmed

By Author-Check- Article-or-Video in FromSitesTree.com

misc From: http://sitestree.com/?p=2062
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2015-07-04 10:06:53

Mar 24

Some C# Stuff (or similar) as I used #Root #By Sayed Ahmed

By Author-Check- Article-or-Video in C# - Misc, FromSitesTree.com

Sayed Ahmed

Some C# Stuff (or similar) as I used

HP var_dump in C# to dump array or objects?

http://stackoverflow.com/questions/23824899/php-var-dump-in-c-sharp-to-dump-array-or-objects

How to pass an object array from javascript to server

http://stackoverflow.com/questions/12229530/how-to-pass-an-object-array-from-javascript-to-server

How to Convert JSON object to Custom C# object?

http://stackoverflow.com/questions/2246694/how-to-convert-json-object-to-custom-c-sharp-object

The following did work for me

        JavaScriptSerializer serializer = new JavaScriptSerializer();
            var jsonObject = serializer.Deserialize<dynamic>(json);
            name = (string)jsonObject["user"]["name"];
            teamname = (string)jsonObject["user"]["teamname"];
            email = (string)jsonObject["user"]["email"];
            players = jsonObject["user"]["players"];
        }

You could use newtonsoft.json or similar.
My case was little more complicated, JSON string representing: arrays of objects of arrays ofobjects. You could also define the class and could do without dynamic and using Newtonsoft's DeSerialize

C# Parsing JSON array of objects

http://stackoverflow.com/questions/19910476/c-sharp-parsing-json-array-of-objects

The following might also work

string json = "{'results':[{'SwiftCode':'','City':'','BankName':'Deutsche    Bank','Bankkey':'10020030','Bankcountry':'DE'},{'SwiftCode':'','City':'10891    Berlin','BankName':'Commerzbank Berlin (West)','Bankkey':'10040000','Bankcountry':'DE'}]}";

        var resultObjects = AllChildren(JObject.Parse(json))
            .First(c => c.Type == JTokenType.Array && c.Path.Contains("results"))
            .Children<JObject>();

        foreach (JObject result in resultObjects) {
            foreach (JProperty property in result.Properties()) {
                // do something with the property belonging to result
            }
        }

From: http://sitestree.com/?p=2052
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2015-06-30 18:13:33

Mar 24

PIVOT Examples – SQL #Root #By Sayed Ahmed

By Author-Check- Article-or-Video in FromSitesTree.com

http://stackoverflow.com/questions/24470/sql-server-pivot-examples

SELECT Action,
       MAX( CASE data WHEN 'View' THEN data ELSE '' END ) ViewCol, 
       MAX( CASE data WHEN 'Edit' THEN data ELSE '' END ) EditCol
 FROM t
 GROUP BY Action

---

SELECT act AS 'Action', [View] as 'View', [Edit] as 'Edit'
FROM (
    SELECT act, cmd FROM data
) AS src
PIVOT (
    MAX(cmd) FOR cmd IN ([View], [Edit])
) AS pvt

--

Table setup:

CREATE TABLE dbo.tbl (
    action VARCHAR(20) NOT NULL,
    view_edit VARCHAR(20) NOT NULL
);

INSERT INTO dbo.tbl (action, view_edit)
VALUES ('Action1', 'VIEW'),
       ('Action1', 'EDIT'),
       ('Action2', 'VIEW'),
       ('Action3', 'VIEW'),
       ('Action3', 'EDIT');

Your table: SELECT action, view_edit FROM dbo.tbl

Your table

Query without using PIVOT:

SELECT Action, 
[View] = (Select view_edit FROM tbl WHERE t.action = action and view_edit = 'VIEW'),
[Edit] = (Select view_edit FROM tbl WHERE t.action = action and view_edit = 'EDIT')
FROM tbl t
GROUP BY Action

Query using PIVOT:

SELECT [Action], [View], [Edit] FROM
(SELECT [Action], view_edit FROM tbl) AS t1 
PIVOT (MAX(view_edit) FOR view_edit IN ([View], [Edit]) ) AS t2

Both queries result:
enter image description here

From: http://sitestree.com/?p=2040
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2015-06-14 21:36:12

Mar 24

Excel and C# #Root #By Sayed Ahmed

By Author-Check- Article-or-Video in C# - Misc, FromSitesTree.com

Adding image at a particular cell in Excel Spreadsheet

https://social.msdn.microsoft.com/Forums/lync/en-US/5c6e7ebd-66e2-40fa-9194-aed5cdc3f0ae/adding-image-at-a-particular-cell-in-excel-spreadsheet?forum=oxmlsdk

How to: Insert text into a cell in a spreadsheet document (Open XML SDK)

https://msdn.microsoft.com/en-us/library/office/cc861607.aspx

You will need reference to OpenXML, Systems.IO.Packaging, System.xml and/or similar.

You may need to copy the related DLLs to your production at deployment (depends on your deploy method)

to insert image located at another site (if any and under your control), you may need to change IIS config for : Allow Access Control

From: http://sitestree.com/?p=2038
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2015-06-14 21:29:23

Mar 24

Random Information on DNN #Root #By Sayed Ahmed

By Author-Check- Article-or-Video in FromSitesTree.com

DotNetNuke.Common.Globals.NavigateURL() does not do a redirect, it simply creates a target URL based on the parameter you’ve provided.

IIS 7 enable 32 bit application mode
appcmd apppool set /apppool.name:MyNukeSite /enable32BitAppOnWin64:true

on IIS 6
cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
aspnet_regiis.exe -i

How to avoid adding multiple references to JQuery Libraries. And how to refer only when JQuery is not loaded. Will help in DNN as well.
// ‘load-jquery.js’
window.onload = function () {
if (window.jQuery === undefined) {
var script = document.createElement(‘script’);
script.src = ‘path/to/jquery.min.js’;
document.getElementsByTagName(‘head’)[0].appendChild(script); // load jQuery
}
};
ASP.NET MVC based CMS

N2 Open Source ASP.NET CMS http://n2cms.com/

Oxite http://www.visitmix.com/Lab/Oxite

Hydrogen CMS http://www.hydrogencms.net/Home.aspx From: http://sitestree.com/?p=2025
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2015-05-17 21:23:12