Development Experience with sharepoint, MVC, .net: 2018

Tuesday, December 18, 2018

jQgrid with common search textbox maually with Dynamic columns showing with freeze as well.

solution For:

Freeze jqGrid columns
Unload/Unbind grid.
Search by Textbox for all rows and columns

JQ grid version: v5.3.2

HTML

</div>

</td>

<%--jq grid--%>

JavaScript

$scope.bindJqGrid = function (key, p1) {

try {

if (key == 'cnsld') {

$.jgrid.gridUnload("#gvCnsldRcpt");

var colName = Object.keys(p1[0]);

var colMdl = [];

var p2 = [];

if (typeof $scope.srchCnsldRcpt != 'undefined' && $scope.srchCnsldRcpt.trim() != '') {

for (var x = 0; x < p1.length; x++) {

var cnt = 0;

for (var j = 0; j < colName.length; j++) {

var cnm = p1[x][colName[j]] + "";

var fnd = cnm.toLowerCase().search($scope.srchCnsldRcpt.toLowerCase().trim());

if (parseInt(cnt) == 0 && parseInt(fnd) >= 0) {

p2.push(p1[x]); cnt = 1;

}

else

p2 = p1;

for (var i = 0; i < colName.length; i++) {

var jq = {};

jq.name = colName[i];

jq.index = colName[i];

if (i == 0 || i == 1) {

jq.frozen = true;

jq.width = 100;

jq.search = true;

}

else {

jq.width = 60;

}

colMdl.push(jq);

}

$("#gvCnsldRcpt").jqGrid({

datatype: 'local',

data: p2,

gridview: true,

colNames: colName,

colModel: colMdl,

height: "120",

shrinkToFit: false,

width: 620,

loadError: function (xhr, status, error) {

alert('error');

}

});

$("#gvCnsldRcpt").jqGrid("setFrozenColumns");

}

catch (ex) {

alert(ex.message);

}

Wednesday, November 21, 2018

HTML table to convert to XLSX excel file javascript jquery ASP.net

HTML table to convert to XLSX excel file javascript jquery

file link: https://unpkg.com/xlsx@0.14.1/dist/xlsx.full.min.js
https://github.com/sheetjs/js-xlsx
https://freakyjolly.com/demo/jsonToXLS/
https://stackoverflow.com/questions/39475474/how-to-export-or-convert-json-to-excel-in-angularjs

JS file Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="jsontohtml.aspx.cs" Inherits="jsontohtml" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script src="export/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="export/xlsx.full.min.js"></script>
</head>
<body>
<form id="form1" runat="server">
<script>

function expt() {
function tabletoexcel() {
var tbl = document.getElementById('sheetjs');
/* File Name */
var filename = "FreakyJSON_To_XLS.xlsx";

/* Sheet Name */
var ws_name = "FreakySheet";

if (typeof console !== 'undefined') console.log(new Date());
var wb = XLSX.utils.book_new(),
ws = XLSX.utils.table_to_sheet(tbl);

/* Add worksheet to workbook */
XLSX.utils.book_append_sheet(wb, ws, ws_name);

/* Write workbook and Download */
if (typeof console !== 'undefined') console.log(new Date());
XLSX.writeFile(wb, filename);
if (typeof console !== 'undefined') console.log(new Date());

}

</script>

<button onclick="tabletoexcel();return false;">export to table</button><br />
<table id="sheetjs">
<tr><td colspan="2">Ashwini</td><td colspan="4">Sharma</td></tr>
<tr><td>Sai</td><td>Kumar</td><td>ved</td><td>kumar</td><td>t</td><td>J</td><td>S</td></tr>
<tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td></tr>
<tr><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td><td>8</td></tr>

</table>

Saturday, October 27, 2018

Web api practice session C# from scratch : tutorial link

http://www.tutorialsteacher.com/webapi/web-api-tutorials

namespace WebAPI.Configuration

{

public static class HelloWebAPIConfig

{

public static void Register(HttpConfiguration conf)

{

conf.MapHttpAttributeRoutes();

conf.Routes.MapHttpRoute(

name: "DefaultApi",

routeTemplate: "ash/{controller}/{id}",

defaults: new { id = RouteParameter.Optional }

);

}

Global.asax

protected void Application_Start(object sender, EventArgs e)

{

GlobalConfiguration.Configure(HelloWebAPIConfig.Register);

}

Controller code

using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Net.Http;

using System.Web.Http;

namespace WebAPI.Controller

{

//[Authorize()]

public class HelloController : ApiController

{

//// tutorial step 1 ////

//public string Get()

//{

// return "Hello World";

//}

//// tutorial step 2 ////

//[HttpGet]

//public string TestAshwini123()

//{

// return "Hello World";

//}

//// tutorial step 3 //// http://localhost:59736/ash/hello?id=5

//[HttpGet]

//public string TestAshwini123(int id)

//{

// return "Hello World" + id;

//}

//// tutorial step 4 //// http://localhost:59736/ash/hello?id=5&name=Ashwini

//[HttpGet]

//public string TestAshwini123(int id, string name)

//{

// return "Hello " + name + " id:" + id;

//}

//// tutorial step 5 ////

//[HttpPost]

//public string TestAshwini123([FromBody] Student s1)

//{

// return "Hello " + s1.Name + " id:" + s1.Id;

//}

//// tutorial step 6 ////

[HttpPost]

public string TestAshwini123([FromBody] Student s1)

{

s1.Name = User.Identity.Name; //"Hello " + s1.Name;

DataSet ds=DbCon.GetResultFromSqlDatabase("Select * from dbo.AngularEmployee", new List<SqlParameter>());

s1.Id = 1 + s1.Id;

return JsonConvert.SerializeObject(ds.Tables[0]);

}

public class Student

{

public int Id { get; set; }

public string Name { get; set; }

}

public class DbCon

{

public static DataSet GetResultFromSqlDatabase(string cmdText, List<SqlParameter> paramColl)

{

string DBConnectionString = string.Empty;

if (ConfigurationManager.ConnectionStrings["SQLConnectionString"] != null)

DBConnectionString = ConfigurationManager.ConnectionStrings["SQLConnectionString"].ToString();

SqlDataAdapter sqlAdapter = null;

SqlConnection sqlConnection = null;

SqlCommand sqlCommand = null;

DataSet dsResult = new DataSet();

if (!String.IsNullOrEmpty(DBConnectionString))

{

sqlConnection = new SqlConnection(DBConnectionString);

sqlCommand = new SqlCommand(cmdText, sqlConnection);

//sqlCommand.CommandType = CommandType.StoredProcedure;

if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["SqlConnectionTimeout"]))

sqlCommand.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["SqlConnectionTimeout"]);

foreach (SqlParameter p in paramColl)

sqlCommand.Parameters.Add(p);

sqlAdapter = new SqlDataAdapter(sqlCommand);

sqlAdapter.Fill(dsResult);

}

sqlAdapter.Dispose();

sqlConnection.Dispose();

sqlCommand.Dispose();

DBConnectionString = string.Empty;

return dsResult;

}