CodeFlunkie

Localizer in Controller

2022-12-06T09:16:00.006-06:00

Localizer in Controller

Using

using Microsoft.Extensions.Localization;

Includes

private readonly IStringLocalizer<AppAccessController> _localizer;

Resource file must be in a Controller Folder in Resources

Method example

public Dictionary<string,string> GetRoleList(string appName, bool includeX)

{

//Code here

return allItems.ToDictionary<string, string, string>(i => i, i => _localizer[i]);

}

Excel download with Jquery using Table

2022-08-24T14:15:00.003-05:00

I have a tricky dynamic table built from a model that I did not want to fashion in the controller so wanted to just download the table as shown.
This Jquery/Javascript solution allowed me to do just that.

Using a button on the page id='export' and using a table on the page id='tblExport'

We add an event listener for the button - I have declared everything explicitly but could probably have shortened some references to objects.

//For the Csv Export
const toCsv = function (table) {
    // Query all rows
    var data = "";
    var tableData = [];
    var rows = $("table tr");
    rows.each(function (index, row) {
        var rowData = [];
        $(row).find("th, td").each(function (index, column) {
            rowData.push(column.innerText);
        });
        tableData.push(rowData.join(","));
    });
    data += tableData.join("\n");
    return data;
};

const download = function (text, fileName) {
    const link = document.createElement('a');
    link.setAttribute('href', `data:text/csv;charset=utf-8,${encodeURIComponent(text)}`);
    link.setAttribute('download', fileName);

    link.style.display = 'none';
    document.body.appendChild(link);

    link.click();

    document.body.removeChild(link);
};

const table = document.getElementById('tblExport');
const exportBtn = document.getElementById('export');

exportBtn.addEventListener('click', function () {
    // Export to csv
    const csv = toCsv(table);
    var reportName = $("#ReportName").val();
    var repDate = $("#RepTitle").text().replaceAll(" ","_");
    // Download it
    download(csv, `${reportName}_${repDate}.csv`);
});

Linq Remove from list based on other table

2022-08-24T14:10:00.000-05:00

One way to do it when you have two lists (repYearlyData and otherdata)

foreach (var yd in repYearlyData)
{
for(int d=0;d<otherdata.Count;d++)
{
if (yd.AssignedRep == otherdata[d].AssignedRep)
{
otherdata.RemoveAt(d);
}
}
}

var result = peopleList2.Where(p => !peopleList1.Any(p2 => p2.ID == p.ID));

public List<TeamAverages> GetRepMonthlyAverages()
{
int tday = DateTime.Now.Day;
int mnth = DateTime.Now.Month;
int yr = DateTime.Now.Year;

var otherdata = (from c in db.calldetail_viw
join w in db.UserWorkgroups on c.LocalUserId equals w.UserId into workGroups
from ug in workGroups.Where(w => !w.WorkGroup.Contains("Team")).Where(w => !w.WorkGroup.Contains("Email"))
.Where(w => !w.WorkGroup.Contains("Dummy")).DefaultIfEmpty()
where c.ConnectedDate.Value.Year == yr

&& c.InteractionType == 5

group c by new { c.LocalUserId } into grouped
select new {

AssignedRep = grouped.Key.LocalUserId,
YearlyAverageResponse = grouped.Average(x => x.CallDurationSeconds.Value),
YearlyEmailCount = grouped.Count(),
FullName = "Other"
}).ToList();

var repDailyData = db.calldetail_viw
.Where(d => d.ConnectedDate.Value.Year == yr)
.Where(d => d.ConnectedDate.Value.Month == mnth)
.Where(d => d.ConnectedDate.Value.Day == tday)
.Where(d => d.InteractionType == 5)
.Join(db.UserWorkgroups, d => d.LocalUserId, w => w.UserId, (d, w) => new { calldetail_viw = d, UserWorkgroup = w }).Where(o => o.UserWorkgroup.WorkGroup.Contains("Team")).Where(o => !o.UserWorkgroup.WorkGroup.Contains("Dummy")).Where(o => !o.UserWorkgroup.WorkGroup.Contains("Email"))
.Join(db.Individuals, w => w.UserWorkgroup.UserId, i => i.ICUserID, (d, i) => new { calldetail_viw = d, Individual = i }).Where(p => !p.Individual.JobTitle.Contains("Supervisor"))
.GroupBy(x => new { x.calldetail_viw.calldetail_viw.LocalUserId, x.Individual.FirstName, x.Individual.LastName, x.calldetail_viw.UserWorkgroup.WorkGroup })
.Select(y => new
{
AssignedRep = y.Key.LocalUserId,
TodaysAverageResponse = y.Average(x => x.calldetail_viw.calldetail_viw.CallDurationSeconds.Value),
TodaysEmailCount = y.Count(),
// FullName = y.Key.FirstName + " " + y.Key.LastName
}).OrderBy(d => d.AssignedRep).ToList();

//(from z in otherdata where z.AssignedRep !=repDailyData.Any(p=>p.AssignedRep));
// var filteredList = otherdata.Where(a => repDailyData.All(b => b.AssignedRep != a.AssignedRep)).Dump();
var repMonthlyData = db.calldetail_viw
.Where(d => d.ConnectedDate.Value.Year == yr)
.Where(d => d.ConnectedDate.Value.Month == mnth)
.Where(d => d.InteractionType == 5)
.Join(db.UserWorkgroups, d => d.LocalUserId, w => w.UserId, (d, w) => new { calldetail_viw = d, UserWorkgroup = w }).Where(o => o.UserWorkgroup.WorkGroup.Contains("Team")).Where(o => !o.UserWorkgroup.WorkGroup.Contains("Dummy")).Where(o => !o.UserWorkgroup.WorkGroup.Contains("Email"))
.Join(db.Individuals, w => w.UserWorkgroup.UserId, i => i.ICUserID, (d, i) => new { calldetail_viw = d, Individual = i }).Where(p => !p.Individual.JobTitle.Contains("Supervisor"))

.GroupBy(x => new { x.calldetail_viw.calldetail_viw.LocalUserId, x.Individual.FirstName, x.Individual.LastName, x.calldetail_viw.UserWorkgroup.WorkGroup })
.Select(y => new
{
AssignedRep = y.Key.LocalUserId,
MonthlyAverageResponse = y.Average(x => x.calldetail_viw.calldetail_viw.CallDurationSeconds.Value),
MonthlyEmailCount = y.Count(),
// FullName = y.Key.FirstName + " " + y.Key.LastName
}).Where(d => d.MonthlyEmailCount > 0).OrderBy(d => d.AssignedRep).ToList();

var repYearlyData = db.calldetail_viw
.Where(d => d.ConnectedDate.Value.Year == yr)
.Where(d => d.InteractionType == 5)
.Join(db.UserWorkgroups, d => d.LocalUserId, w => w.UserId, (d, w) => new { calldetail_viw = d, UserWorkgroup = w }).Where(o => o.UserWorkgroup.WorkGroup.Contains("Team")).Where(o => !o.UserWorkgroup.WorkGroup.Contains("Dummy")).Where(o => !o.UserWorkgroup.WorkGroup.Contains("Email"))
.Join(db.Individuals, w => w.UserWorkgroup.UserId, i => i.ICUserID, (d, i) => new { calldetail_viw = d, Individual = i }).Where(p => !p.Individual.JobTitle.Contains("Supervisor"))

.GroupBy(x => new { x.calldetail_viw.calldetail_viw.LocalUserId, x.Individual.FirstName, x.Individual.LastName, x.calldetail_viw.UserWorkgroup.WorkGroup })
.Select(y => new
{
AssignedRep = y.Key.LocalUserId,
YearlyAverageResponse = y.Average(x => x.calldetail_viw.calldetail_viw.CallDurationSeconds.Value),
YearlyEmailCount = y.Count(),
FullName = y.Key.FirstName + " " + y.Key.LastName
}).OrderBy(d => d.AssignedRep).ToList();

foreach (var yd in repYearlyData)
{
for(int d=0;d<otherdata.Count;d++)
{
if (yd.AssignedRep == otherdata[d].AssignedRep)
{
otherdata.RemoveAt(d);
}
}
}

var finalData = (from co in otherdata

group co by new { co.FullName } into othGroup
select new
{

AssignedRep = "" ,
YearlyAverageResponse = othGroup.Average(x => x.YearlyAverageResponse),
YearlyEmailCount = othGroup.Sum(x=>x.YearlyEmailCount),
FullName = othGroup.Key.FullName
}).ToList();

var totalYearlyData = repYearlyData.Concat(finalData);
var returnList = new List<TeamAverages>();
foreach (var row in totalYearlyData)
{
var t = new TeamAverages();
t.FullName = row.FullName;
t.AssignedRep = row.AssignedRep;
t.bestrep = 0;
t.YearlyEmailCount = row.YearlyEmailCount;
t.YearlyAverageResponse = row.YearlyAverageResponse;
foreach (var d in repDailyData.Where(p => p.AssignedRep == row.AssignedRep))
if (row.AssignedRep == d.AssignedRep)
{

t.TodaysEmailCount = d.TodaysEmailCount;
t.TodaysAverageResponse = d.TodaysAverageResponse;
}
foreach (var d in repMonthlyData.Where(p => p.AssignedRep == row.AssignedRep))
if (row.AssignedRep == d.AssignedRep)
{

t.MonthlyEmailCount = d.MonthlyEmailCount;
t.MonthlyAverageResponse = d.MonthlyAverageResponse;
}
returnList.Add(t);
}

return returnList.ToList();
}

Disable Button based on checked items in CheckboxList

2022-08-24T14:09:00.000-05:00

Windows Forms using the ClientID

$("#<%=chkMinCedProgramManagers.ClientID %>").find('input[type="checkbox"]').click(function () {

$("#<%=btnSaveSubGroup.ClientID %>").removeAttr("disabled");

//Identify How many checkboxes are checked so that we can toggle the button
var prgchecked = $('#<%=chkMinCedProgramManagers.ClientID%>').find('input[type="checkbox"]:checked').length;

//Disable button if we have zero checked

if (prgchecked===0)
{

$("#<%=btnSaveSubGroup.ClientID %>").attr("disabled", "disabled");
};

});

Sparkline Chart

2022-08-24T14:04:00.000-05:00

VIEW

CONTROLLER

public ActionResult Index(int? id, int? reportType)
{
ViewBag.Expire = getExpiringMonths();
..............................

public string getExpiringMonths()
{
List<int> listofRecords = new List<int>();
string mylist = string.Empty;
List<AgreementExpiration> exp = new List<AgreementExpiration>();
exp = prog.getExpiringChart();
foreach(var a in exp)
{
listofRecords.Add(a.ExpireCount);
mylist = mylist + a.ExpireCount + ",";
}
return mylist;

}

Multiple Filters

2022-08-24T14:02:00.000-05:00

$(document).ready(function () {

ManageRadioButtons();

numerizeRows();

$('[data-toggle="tooltip"]').tooltip();

});

jQuery.expr[':'].icontains = function (a, i, m) {

return jQuery(a).text().toUpperCase()

.indexOf(m[3].toUpperCase()) >= 0;

};

$("#searchInputResponsibility").keyup(function () {

if (checkMultiple() == true) {

filterMultiple();

return true;

}

var data = this.value.split(" ");

var currentRow = $("#fbody").find("tr").not('.H').not('.thead');

if (this.value == "") {

currentRow.show();

return;

}

//hide all the rows

currentRow.hide();

currentRow.filter(function (i, v) {

var $t = $(this).find("td:eq(0)");

for (var d = 0; d < data.length; ++d) {

if ($t.is(":icontains('" + data[d] + "')")) {

return true;

}

return false;

})

.show();

}).focus(function () {

this.value = "";

$(this).css({

"color": "black"

});

$(this).unbind('focus');

});

function numerizeRows() {

var eachRow = $("#fbody").find("tr").not('.H').not('.thead');

var start = 1;

eachRow.each(function () {

$(this).children('td:eq(1)').html(start);

start = start + 1;

});

};

$("#searchInputTask").keyup(function () {

if (checkMultiple() == true) {

filterMultiple();

return true;

}

var data = this.value.split(" ");

var currentRow = $("#fbody").find("tr").not('.H').not('.thead');

if (this.value == "") {

currentRow.show();

return;

}

//hide all the rows

currentRow.hide();

currentRow.filter(function (i, v) {

var $t = $(this).find("td:eq(2)");

for (var d = 0; d < data.length; ++d) {

if ($t.is(":icontains('" + data[d] + "')")) {

return true;

}

return false;

})

//show the rows that match.

.show();

}).focus(function () {

this.value = "";

$(this).css({

"color": "black"

});

$(this).unbind('focus');

});

$("#searchInputNotes").keyup(function () {

if (checkMultiple() == true) {

filterMultiple();

return true;

// return;

}

var data = this.value.split(" ");

var currentRow = $("#fbody").find("tr").not('.H').not('.thead');

if (this.value == "") {

currentRow.show();

return;

}

//hide all the rows

currentRow.hide();

currentRow.filter(function (i, v) {

var $t = $(this).find("td:eq(3)");

for (var d = 0; d < data.length; ++d) {

if ($t.is(":icontains('" + data[d] + "')")) {

return true;

}

return false;

})

//show the rows that match.

.show();

}).focus(function () {

this.value = "";

$(this).css({

"color": "black"

});

$(this).unbind('focus');

});

function checkMultiple() {

var dataP = $("#searchInputResponsibility").val().split(" ");

var dataR = $("#searchInputTask").val().split(" ");

var dataI = $("#searchInputNotes").val();

if (dataI != "" && dataR != "") return true;

if (dataI != "" && dataP != "") return true;

if (dataP != "" && dataR != "") return true;

return false;

};

function filterMultiple () {

var dataI = $("#searchInputNotes").val().split(" ");

var dataR = $("#searchInputTask").val().split(" ");

var dataP = $("#searchInputResponsibility").val().split(" ");

var allRows = $("#fbody").find("tr").not('.H').not('.thead');

if (dataI == "" && dataR == "" && dataP == "") {

allRows.show();

return;

}

//hide all the rows

allRows.hide();

allRows.filter(function (i, v) {

var $v = $(this).find("td:eq(0)");

var $u = $(this).find("td:eq(1)");

var $t = $(this).find("td:eq(2)");

if (dataI != "" && dataR != "" && dataP != "") {

for (var p = 0; p < 2; ++p) {

if ($v.is(":icontains('" + dataP[p] + "')") && ($u.is(":icontains('" + dataR[p] + "')")) && $t.is(":icontains('" + dataI[p] + "')") ) {

return true;

}

if (dataI != "" && dataR != "" && dataP == "") {

for (var p = 0; p < 2; ++p) {

if (($u.is(":icontains('" + dataR[p] + "')")) && $t.is(":icontains('" + dataI[p] + "')")) {

return true;

}

if (dataI == "" && dataR != "" && dataP != "") {

for (var p = 0; p < 2; ++p) {

if (($u.is(":icontains('" + dataR[p] + "')")) && $v.is(":icontains('" + dataP[p] + "')")) {

return true;

}

if (dataI != "" && dataR == "" && dataP != "") {

for (var p = 0; p < 2; ++p) {

if (($t.is(":icontains('" + dataI[p] + "')")) && $v.is(":icontains('" + dataP[p] + "')")) {

return true;

}

if (dataI != "" && dataR != "" && dataP == "") {

for (var p = 0; p < 2; ++p) {

if (($u.is(":icontains('" + dataR[p] + "')")) && $t.is(":icontains('" + dataI[p] + "')")) {

return true;

}

return false;

})

.show();

};

$("input[type='radio']").change(function () {

ManageRadioButtons();

});

function ManageRadioButtons() {

$("#searchInputResponsibility").val('');;

$("#searchInputTask").val('');;

$("#searchInputNotes").val('');;

var selection = $('input[name=env]:checked').val();

var currentRow = $("#fbody").find("tr").not('.H');

currentRow.hide();

if (selection == "QA") {

var QARows = $("#fbody").find("tr.Q");

QARows.show();

} else {

var PRows = $("#fbody").find("tr.P");

PRows.show();

}

};

Jquery add dynamic numeric column

2022-08-24T14:01:00.000-05:00

Jquery adding column options

function numerizeRows() {

var eachRow = $("#fbody").find("tr").not('.H').not('.thead');

var start = 1;

$(".id").each(function() {

this.text(start);

start = start + 1;

});

//eachRow.each(function () {

$(this).children('td:eq(0)').html(start);

// var myNumber = '<td>' + start + '</td>';

// this.prepend(start);

// start = start + 1;

//});

};

Linq list filtered on list

2021-10-29T10:19:00.004-05:00

modelItems is a list of Model
intList is a list of Integers

I am looking for modelItems where the id is in my Int List

var myFilteredList= modelItems.Where(item => intList.Contains(item.Id))

.Select(a => a).ToList();

Dynamic Dropdowns NetCore and Json

2021-09-29T09:33:00.002-05:00

Html for placeholder

Controller returns a Model - Add records to the Model and then return as JsonResult

public async Task<JsonResult> GetApplications(int id)
{ var selectAppList = new List<ModelName>();
var apps = _applicationService.GetApplicationModels();
var modelVariable = (await GetModelRecords);

if (modelVariable is object )
{
selectAppList.Add(modelVariable);
}

return Json(selectAppList);

}

Jquery
Add something like this to document.ready

$("#brandId").change(function () {

var id = $("#brandId").val();

BuildAppList(id);

});

Then add the function

function BuildAppList(id) {

$.ajax({

type: 'GET',

url:'ConfigureKey/GetApplications/' + id,

data: { id: id },

success: function (result) {

$('#AppList').empty();

$.each(result, function (i, item) {

$('#AppList').append('<option value="' + item.modelid + '"> ' + item.name + ' </option>');

});

error: function (xhr, status, err) {

// error handling

}

});

}

Ajax Loop Photos

2021-02-26T08:56:00.000-06:00

function GetPhotos() {

var row = "<div class='w3-container w3-row-padding'>";

var itemcount = 0;

$.ajax({

url: '/Photos/PhotoList',

type: 'GET',

contentType: 'application/json',

data: "{}",

dataType: "json",

success: function (data) {

var count = Object.keys(data).length;

// var row = "";

$.each(data, function (item) {

if (itemcount % 6 != 0) {

row += "<div class='w3-left w3-padding-16'><div class='w3-container w3-center' style='width: 150px;'><img class='w3-round-xlarge' alt='"+ itemcount +"' onclick=" + "if(event.shiftKey){document.getElementById('dispImage')" + ".src='" + data[item].photoSrc + "';" + "document.getElementById('id01')" + ".style.display='block';}else{if(event.ctrlKey||event.metaKey){$(this).toggleClass('csam');}else{$(this).toggleClass('rev');}}" + " id='" + data[item].photoId + "' src=" + data[item].photoSrc + " data-src=" + data[item].photoSrc + " style='width: 100px;' /></div></div>";

}

if (itemcount % 6 == 0) {

row += "</div>";

row += "<div class='w3-container w3-row-padding'>";

row += "<div class='w3-left w3-padding-16'><div class='w3-container w3-center' style='width: 150px;'><img class='w3-round-xlarge' alt='" + itemcount + "' onclick=" + "if(event.shiftKey){document.getElementById('dispImage')" + ".src='" + data[item].photoSrc + "';" + "document.getElementById('id01')" + ".style.display='block';}else{if(event.ctrlKey||event.metaKey){$(this).toggleClass('csam');}else{$(this).toggleClass('rev');}}" + " id='" + data[item].photoId + "' src=" + data[item].photoSrc + " data-src=" + data[item].photoSrc + " style='width: 100px;' /></div></div>";

}

itemcount++;

});

row += "</div>";

$("#photos").html(row + " itemcount=" + itemcount);

error: function (result) {

alert("Error");

}

MVC Changed State with no query string

2021-01-27T10:10:00.001-06:00

I needed to take action if i was in the edit state of my page. So in the controller I set a ViewBag object then from my jquery I checked the value

I needed to check a NO value in a checkbox if there was no textarea value in the model set

var number = parseInt(@ViewBag.Edit);

if (number == 1) {

if ($("#TextAreaEngagement").val().length == 0) {

$("#chkEngagedNo").prop("checked", true);

}

Linq Query Syntax vs Method Syntax

2020-05-19T09:52:00.001-05:00

Referenced from MSDN:
https://msdn.microsoft.com/en-us/library/bb397947.aspx

Query syntax:

IEnumerable<int> numQuery1 = 
            from num in numbers
            where num % 2 == 0
            orderby num
            select num;

Method syntax:

        IEnumerable<int> numQuery2 = numbers.Where(num => num % 2 == 0).OrderBy(n => n)

Sticky Footer made simple

2020-05-19T09:40:00.004-05:00

CSS Footers are simple but people tend to overthink them. Here is how it works

You have two pieces

A container that all your other stuff is in
A footer that you want to always stay at the bottom of the page

In Blazor I put this container on my content pages and not my host page because I didn't want my left hand nav to be involved

<div class="container">

All my content

</div>
<footer>
Centered footer content
</footer>

And the CSS

.container {
width:100%;
padding: 0 15px;
}
footer {
font-size: 12px; (you could also use a vw value here)
padding-top:20px;
background-color: #xxx;
color: #fff;
margin: auto;
height: 60px;
width: 100%;
position: sticky; //absolute;
bottom: 0;
text-align: center;
}

Ah Blazor - Now refresh the page!

2020-05-15T17:08:00.001-05:00

Started my first Blazor project today. New to NetCore as well so it was a fun challenge. I like that is is similar to MVC and I appreciate the ability to add code into my page while building without moving to a controller - it was a real challenge to accommodate some JQuery but I got everything to work. After looking a little closer I realized a large chunk of my JQuery and even javascript could be moved to the @code section and written differently - made for a cleaner, more readable page.

I spent over an hour trying to figure out how to do a simple page refresh! Part of the challenge is that Blazor is a moving target - different libraries and ways of doing simple tasks from version to version - I am confident that most of that will stop as they more clearly define what it is they want to do with this tool.

Refresh a page (NetCore 3.1)

First set up an alias for the uriHelper - you will now find it in NavigationManager
@inject NavigationManager uriHelper

Attach a method to your button:

<button type="submit" @onclick="Reload">Start Over </button>

In your @code section add this oh so simple method - you will want to include the true as it initiates a real reload otherwise you will just navigate to the same location with no StateChange. There are most likely many ways to do this - this was the easiest.

private async void Reload()
{
uriHelper.NavigateTo("/MyPage", true);

}

From Checkbox to Linq list

2020-02-12T07:58:00.005-06:00

Just the Values of the Selected Items

List<string> selectedValues = chkMyList.Items.Cast<ListItem>()
   .Where(li => li.Selected)
   .Select(li => li.Value)
   .ToList();

Both Text and Value of Selected item into a listItem object

List<ListItem> selected = chkMyList.Items.Cast<ListItem>()
    .Where(li => li.Selected)
    .ToList();

Linq Compare to a list

2019-11-21T14:13:00.001-06:00

Establish your list

var idList = new [] {5, 7};

Compare against the List

var jobs = originaljobs.Where(t => t.StatusId != null).Where(t => idList.Contains((int)t.StatusId));

Conversion Classes

2019-09-23T08:00:00.003-05:00

Convert from Model to Dataset

public static DataSet ToDataSet(this IList list)
{
Type elementType = typeof(T);
DataSet ds = new DataSet();
DataTable t = new DataTable();
ds.Tables.Add(t);

//add a column to table for each public property on T
foreach (var propInfo in elementType.GetProperties())
{
Type ColType = Nullable.GetUnderlyingType(propInfo.PropertyType) ?? propInfo.PropertyType;

t.Columns.Add(propInfo.Name, ColType);
}

//go through each property on T and add each value to the table
foreach (T item in list)
{
DataRow row = t.NewRow();

foreach (var propInfo in elementType.GetProperties())
{
row[propInfo.Name] = propInfo.GetValue(item, null) ?? DBNull.Value;
}

t.Rows.Add(row);
}

return ds;
}

Convert from Array to Dataset

public static DataSet ToDataSetFromArrayOfObject(this object[] arrCollection)
{
DataSet ds = new DataSet();
try
{
XmlSerializer serializer = new XmlSerializer(arrCollection.GetType);
System.IO.StringWriter sw = new System.IO.StringWriter();
serializer.Serialize(sw, dsCollection);
System.IO.StringReader reader = new System.IO.StringReader(sw.ToString());
ds.ReadXml(reader);
}
catch (Exception ex)
{
throw (new Exception("Error While Converting Array of Object to Dataset."));
}
return ds;
}

Jquery ... little things

2019-09-20T14:25:00.001-05:00

Code Snippets

Remove duplicate IDs on a page - but not the first one

$('[id]').each(function () {
$('[id="' + this.id + '"]:gt(0)').remove();

});

Open XML and Word Doc creation

2019-09-20T14:24:00.001-05:00

https://github.com/OfficeDev/office-content/blob/master/en-us/OpenXMLCon/articles/360318b5-9d17-42a1-b707-c3ccd1a89c97.md

While at Lockheed I created an interface that modified and created contracts on the fly - wish I had kept some code references - but I started here

To generate Word documents with Office Automation within .NET, specifically in C# or VB.NET:

Add the Microsoft.Office.Interop.Word assembly reference to your project. The path is \Visual Studio Tools for Office\PIA\Office11\Microsoft.Office.Interop.Word.dll.
Follow the Microsoft code example you can find here: http://support.microsoft.com/kb/316384/en-us.

API Examples Returning various ...

2019-09-20T14:22:00.000-05:00

API Examples

public IQueryable<Customer> GetCustomers()
{
return db.Customers;

[ResponseType(typeof(Customer))]
public IHttpActionResult GetCustomer(string email)
{
Customer customer = db.Customers.Where(c=>c.Email== email).FirstOrDefault();
if (customer == null)
{
return NotFound();
}

return Ok(customer);
} }

// PUT: api/Customers/5
[ResponseType(typeof(void))]
public IHttpActionResult PutCustomer(int id, Customer customer)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}

if (id != customer.Id)
{
return BadRequest();
}

db.Entry(customer).State = EntityState.Modified;

try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(id))
{
return NotFound();
}
else
{
throw;
}
}

return StatusCode(HttpStatusCode.NoContent);
}

----
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
----
private bool CustomerExists(int id)
{
return db.Customers.Count(e => e.Id == id) > 0;
}
---
private readonly MemoryStream _Stream = new MemoryStream();
public JsonContent(object value)
{

Headers.ContentType = new MediaTypeHeaderValue("application/json");
var jw = new JsonTextWriter(new StreamWriter(_Stream));
jw.Formatting = Formatting.Indented;
var serializer = new JsonSerializer();
serializer.Serialize(jw, value);
jw.Flush();
_Stream.Position = 0;

}

protected override Task SerializeToStreamAsync(Stream stream, TransportContext context)
{
return _Stream.CopyToAsync(stream);
}

protected override bool TryComputeLength(out long length)
{
length = _Stream.Length;
return true;
}

public IHttpActionResult PostTaskStart(OrderManfTask orderManfTask)
{

List<OrderManfTask> items = new List<OrderManfTask>();
items = (from a in db.OrderManfTasks where a.OrderId == orderManfTask.OrderId && a.TaskId == orderManfTask.TaskId select a).ToList();

foreach (var i in items)
{
i.EmployeeName = orderManfTask.EmployeeName;
i.TaskId = orderManfTask.TaskId;
i.TaskEnd = orderManfTask.TaskEnd;
db.SaveChanges();
}
string tasktext = string.Empty;
switch (orderManfTask.TaskId)
{
case 1:
tasktext = "Cut";
break;
case 2:
tasktext = "Sewn";
break;
case 3:
tasktext = "Filled";
break;
}
//Add Note
OrderNote orderNote = new OrderNote();
orderNote.DownloadId = 0;
orderNote.OrderId = orderManfTask.OrderId;
orderNote.CreatedOnUtc = DateTime.Now;
orderNote.Note = "Production " + tasktext + " Task Completed by: " + orderManfTask.EmployeeName + " on " + DateTime.Now;
db.OrderNotes.Add(orderNote);
db.SaveChanges();
return Ok(new { success = true });

}
}

-----

public int PostTaskStart(OrderManfTask orderManfTask)
{

int items = 0;
int taskstarted = 0;
int taskEnded = 0;
items = (from a in db.OrderManfTasks where a.OrderId == orderManfTask.OrderId && a.TaskId == orderManfTask.TaskId select a.id).Count();
taskstarted = (from a in db.OrderManfTasks where a.OrderId == orderManfTask.OrderId && a.TaskId == orderManfTask.TaskId && a.TaskStart != null select a.id).Count();
taskEnded = (from a in db.OrderManfTasks where a.OrderId == orderManfTask.OrderId && a.TaskId == orderManfTask.TaskId && a.TaskEnd != null select a.id).Count();

//Task has an End Date
if (taskEnded > 0) { return 4; }
//Task has started
if (taskstarted > 0) { return 2; }
//task is not started but is valid
if (items > 0) { return 1; }
//task is invalid for this order
return 0;

}

----
Called in Javascript
summaryByTech.DataSource = app.DataSource("SummaryByTech", summaryByTech.Model, urlFilter, salesPerformanceTech.objGroup, salesPerformanceTech.objAggregate);
dsSummaryByTech = summaryByTech.DataSource;

Within WEBSERVICES PROJECT
[Authorize(Roles = "Franchisee,HomeOffice")]
public class SummaryByTechController : ApiController
{
// 1. Group By Tech over a date range
// 2. Group By Tech by Week for single column

[HttpGet]
public List<Model_BigBoard.DTO.DTOSummaryByTech> FetchSummaryByTech(string bNumber, DateTime startDate, DateTime endDate)
{
BusinessLogic.BLSummaryByTech bl = new BusinessLogic.BLSummaryByTech();
string bNumberConvert = Dwyer.BIMS.BigBoard.Base.Util.Tools.BusinessSupport.HexToASCIICharString(bNumber);
return bl.LoadSummaryByTech(bNumberConvert, startDate, endDate);
}
}
}

https://nordicapis.com/3-common-methods-api-authentication-explained/

CALLING THE API

From Javascript

<script>
$("#Create").click(function () {

var source = {
'OrderId': $("#OrderId").val(),
'TrackingNumber': $('#TrackingNumber').val(),
'TotalWeight': $('#TotalWeight').val(),
'ShippedDateUtc': $('#ShippedDateUtc').val(),
'AdminComment': $('#AdminComment').val(),
'CreatedOnUtc': new Date().toISOString(),
}
$.ajax({
type: "POST",
data: source,
url: "/api/Shipments",
})
.done(function (data, status, jqXHR) {
if (data.Success)
{
$("#OrderId").val("");
$('#TrackingNumber').val("");
$('#TotalWeight').val("");
$('#ShippedDateUtc').val("");
$('#AdminComment').val("");

}
else
{
alert(data.Message) //display exception
}

//alert("Success");
})
.fail(function (jqXHR, textStatus, err) {
//alert("Failed");
})

event.preventDefault();
});
</script>

<script type="text/javascript">
function getcustomer() {
$("#stateID").empty();
$("#stateID").append("<option value='0'>--Select State--</option>");
var email = $('#Email').val();
var Url="@Url.Content("~/api/customers/getcustomer")";
$.ajax({
url:Url,
dataType: 'json',
data: { email: countryID },
success: function (data) {

$.each(data, function (index, optiondata) {
$("#FirstName").val(optiondata.firstName);
});
}
});
}
</script>

<script>
$('#ppTable').on('click', '.btnSelect', function () {
// var tds = $(this).addClass('row-highlight').find('td');

var currentRow = $(this).closest("tr");

var OrderId = currentRow.find("td:eq(0)").text(); // get current row 1st TD value
var OrderItemId = currentRow.find("td:eq(1)").text();
var tracking = currentRow.find(".tracking").val(); // get current row 2nd TD
var weight = currentRow.find(".totalweight").val(); // get current row 3rd TD
var shipdate = currentRow.find(".shipdate").val(); // get current row 4rd TD
// var data = OrderId + "-" + tracking + "-" + weight + "-" + shipdate;
//alert(data);

var source = {

'OrderId':OrderId,
'TrackingNumber': tracking,
'TotalWeight': weight,
'ShippedDateUtc': shipdate,
'AdminComment': OrderItemId,
'CreatedOnUtc': new Date().toISOString(),
}
$.ajax({
type: "POST",
data: source,
url: "/api/PPShipments",
})
.done(function (data, status, jqXHR) {
if (data.Success)
{
// $("#OrderId").val("");
// $('#TrackingNumber').val("");
// $('#TotalWeight').val("");
//$('#ShippedDateUtc').val("");
// $('#AdminComment').val("");
currentRow.remove();
}
else
{
alert(data.Message) //display exception
}

//alert("Success");
})
.fail(function (jqXHR, textStatus, err) {
//alert("Failed");
})

event.preventDefault();
});

Security

2019-09-20T14:21:00.000-05:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Web;

namespace LM_API
{
public static class SiteMethods
{
public static string ComputeHash(string plainText,
string hashAlgorithm,
byte[] saltBytes)
{ // If salt is not specified, generate it on the fly.
if (saltBytes == null)
{
// Define min and max salt sizes.
int minSaltSize = 4;
int maxSaltSize = 8;

// Generate a random number for the size of the salt.
Random random = new Random();
int saltSize = random.Next(minSaltSize, maxSaltSize);
//Hardcoded the salt size
// int saltSize = 3;
// Allocate a byte array, which will hold the salt.
saltBytes = new byte[saltSize];

// Initialize a random number generator.
RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();

// Fill the salt with cryptographically strong byte values.
rng.GetNonZeroBytes(saltBytes);
}

// Convert plain text into a byte array.
byte[] plainTextBytes = Encoding.UTF8.GetBytes(plainText);

// Allocate array, which will hold plain text and salt.
byte[] plainTextWithSaltBytes =
new byte[plainTextBytes.Length + saltBytes.Length];

// Copy plain text bytes into resulting array.
for (int i = 0; i < plainTextBytes.Length; i++)
plainTextWithSaltBytes[i] = plainTextBytes[i];

// Append salt bytes to the resulting array.
for (int i = 0; i < saltBytes.Length; i++)
plainTextWithSaltBytes[plainTextBytes.Length + i] = saltBytes[i];

// Because we support multiple hashing algorithms, we must define
// hash object as a common (abstract) base class. We will specify the
// actual hashing algorithm class later during object creation.
HashAlgorithm hash;

// Make sure hashing algorithm name is specified.
if (hashAlgorithm == null)
hashAlgorithm = "";

// Initialize appropriate hashing algorithm class.
switch (hashAlgorithm.ToUpper())
{
case "SHA1":
hash = new SHA1Managed();
break;

case "SHA256":
hash = new SHA256Managed();
break;

case "SHA384":
hash = new SHA384Managed();
break;

case "SHA512":
hash = new SHA512Managed();
break;

default:
hash = new MD5CryptoServiceProvider();
break;
}

// Compute hash value of our plain text with appended salt.
byte[] hashBytes = hash.ComputeHash(plainTextWithSaltBytes);

// Create array which will hold hash and original salt bytes.
byte[] hashWithSaltBytes = new byte[hashBytes.Length +
saltBytes.Length];

// Copy hash bytes into resulting array.
for (int i = 0; i < hashBytes.Length; i++)
hashWithSaltBytes[i] = hashBytes[i];

// Append salt bytes to the result.
for (int i = 0; i < saltBytes.Length; i++)
hashWithSaltBytes[hashBytes.Length + i] = saltBytes[i];

// Convert result into a base64-encoded string.
string hashValue = Convert.ToBase64String(hashWithSaltBytes);

// Return the result.
return hashValue;
}

public static bool VerifyHash(string plainText,
string hashAlgorithm,
string hashValue)
{
// Convert base64-encoded hash value into a byte array.
byte[] hashWithSaltBytes = Convert.FromBase64String(hashValue);

// We must know size of hash (without salt).
int hashSizeInBits, hashSizeInBytes;

// Make sure that hashing algorithm name is specified.
if (hashAlgorithm == null)
hashAlgorithm = "";

// Size of hash is based on the specified algorithm.
switch (hashAlgorithm.ToUpper())
{
case "SHA1":
hashSizeInBits = 160;
break;

case "SHA256":
hashSizeInBits = 256;
break;

case "SHA384":
hashSizeInBits = 384;
break;

case "SHA512":
hashSizeInBits = 512;
break;

default: // Must be MD5
hashSizeInBits = 128;
break;
}

// Convert size of hash from bits to bytes.
hashSizeInBytes = hashSizeInBits / 8;

// Make sure that the specified hash value is long enough.
if (hashWithSaltBytes.Length < hashSizeInBytes)
return false;

// Allocate array to hold original salt bytes retrieved from hash.
byte[] saltBytes = new byte[hashWithSaltBytes.Length -
hashSizeInBytes];

// Copy salt from the end of the hash to the new array.
for (int i = 0; i < saltBytes.Length; i++)
saltBytes[i] = hashWithSaltBytes[hashSizeInBytes + i];

// Compute a new hash string.
string expectedHashString =
ComputeHash(plainText, hashAlgorithm, saltBytes);

// If the computed hash matches the specified hash,
// the plain text value must be correct.
return (hashValue == expectedHashString);
}
public static string Base64Encode(string plainText)
{
var plainTextBytes = System.Text.Encoding.UTF8.GetBytes(plainText);
return System.Convert.ToBase64String(plainTextBytes);
}
public static string Base64Decode(string base64EncodedData)
{
var base64EncodedBytes = System.Convert.FromBase64String(base64EncodedData);
return System.Text.Encoding.UTF8.GetString(base64EncodedBytes);
}
}
}

Return View of a model or an HttpStatusCode

2019-09-20T14:20:00.001-05:00

public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}

OrderNote orderNote = mymethodtoretriverecord(id);

if (orderNote == null)
{
return HttpNotFound();
}
return View(orderNote);
}

Pseudo Class when you need a generic object

2019-09-20T14:20:00.000-05:00

public class PseudoProduct : calldetail_viw
{
};

public List<calldetail_viw> GetTeamMonthlySummary()
{

int currentmonth = DateTime.Today.Month;
int lastmonth = DateTime.Today.AddMonths(-3).Month;

var calldata = (from c in db.calldetail_viw
where c.ConnectedDate.Value.Month >= lastmonth
&& c.ConnectedDate.Value.Month <= currentmonth
&& c.LocalName == "myaccountrep"
&& c.CallDirection=="Inbound"
group c by new {c.AssignedWorkGroup, month = c.ConnectedDate.Value.Month}
into g
select new PseudoProduct
{
AssignedWorkGroup = g.Key.AssignedWorkGroup,
CustomNum1 = g.Key.month,
CustomNum2 = g.Count()
});

var cl = new List<calldetail_viw>();
foreach (var item in calldata)
{
cl.Add(new calldetail_viw {
AssignedWorkGroup = item.AssignedWorkGroup,
CustomNum1 = item.CustomNum1,
CustomNum2 = item.CustomNum2,
});
}
return cl;
}

HTML Helper Methods

2019-09-20T14:16:00.002-05:00

public static class CoverageAuthorization
{
public static MvcHtmlString ShowHideLink( this HtmlHelper helper,string linkSupplied, string username)
{

var approvalHierarchy = ConfigurationManager.AppSettings["ApprovalHierarchy"];
approvalHierarchy = approvalHierarchy.Substring(approvalHierarchy.IndexOf("Supervisor"));
var claimManager = new ClaimManager();
var currentUser = claimManager.GetClaimUserByLogin(username);
if (approvalHierarchy.IndexOf(currentUser.Role.ToString()) >= 0)
{

return MvcHtmlString.Create("<br />" + linkSupplied);
}
else
{
return MvcHtmlString.Empty; ;
}
}
}

To use it

@Html.ShowHideLink("<a href='/CaseLoadTransition/Index'>Case Load Transition</a> ", HttpContext.Current.User.Identity.Name.ToString())

Export Grid to Excel with JQuery

2019-09-20T14:16:00.001-05:00

Using Table2Excel

Grab the Javascript Table2Excel and make sure you have a reference to a recent Jquery library

https://rawgit.com/unconditional/jquery-table2excel/master/src/jquery.table2excel.js

Create a button click or other event

$("#myButton").click(function(){

$("#myGridorTable").table2excel({
exclude: ".noExl",
name: "MyExcel.xls"
});
};

There you go - button click - excel returned as a file to the browser.

CodeFlunkie

Localizer in Controller

Excel download with Jquery using Table

Linq Remove from list based on other table

Disable Button based on checked items in CheckboxList

//Disable button if we have zero checked

if (prgchecked===0){

$("#<%=btnSaveSubGroup.ClientID %>").attr("disabled", "disabled"); };

});

Sparkline Chart

VIEW

CONTROLLER

Multiple Filters

Jquery add dynamic numeric column

Linq list filtered on list

Dynamic Dropdowns NetCore and Json

Ajax Loop Photos

MVC Changed State with no query string

Linq Query Syntax vs Method Syntax

Sticky Footer made simple

Ah Blazor - Now refresh the page!

Refresh a page (NetCore 3.1)

From Checkbox to Linq list

Just the Values of the Selected Items

Both Text and Value of Selected item into a listItem object

Linq Compare to a list

Conversion Classes

Convert from Model to Dataset

Convert from Array to Dataset

Jquery ... little things

Code Snippets

Open XML and Word Doc creation

API Examples Returning various ...

API Examples

Security

Return View of a model or an HttpStatusCode

Pseudo Class when you need a generic object

HTML Helper Methods

Export Grid to Excel with JQuery

Using Table2Excel

if (prgchecked===0)
{

$("#<%=btnSaveSubGroup.ClientID %>").attr("disabled", "disabled");
};