ASP.NET

8-Feb-18 1:53

i am working with 4 fields but i may have to search 100 fields. so to mention 100 fields name in where is very cumbersome.

please suggest best approach when we search a value against all fields or few specific fields.

if (!String.IsNullOrEmpty(SearchText))
    {
        customer = customer.Where(s => s.CompanyName.ToUpper().Contains(SearchText.ToUpper())
        || s.ContactName.ToUpper().Contains(SearchText.ToUpper())
        || s.ContactTitle.ToUpper().Contains(SearchText.ToUpper())
        || s.Address.ToUpper().Contains(SearchText.ToUpper()));
    }

thanks

ASP.NET Core to IIS

Priyanka Kale7-Feb-18 23:25

Priyanka Kale

7-Feb-18 23:25

How To Deploy ASP.NET Core to IIS ?

Re: ASP.NET Core to IIS

User 41802549-Feb-18 12:35

User 4180254

9-Feb-18 12:35

Hope this helps - Host ASP.NET Core on Windows with IIS | Microsoft Docs[^]

modified 20-Sep-20 21:01pm.

Parsing JSON

A_Griffin7-Feb-18 22:40

A_Griffin

7-Feb-18 22:40

So I have this weird (to me) JSON string of "Things":

XML

{
	"0":{"Property1":"P0001","Property2":"Value One"},
	"1":{"Property1":"P0002","Property2":"Value Two"},
	"2":{"Property1":"P0003","Property2":"Value Three"}
}

I can make a simple class

Friend Class clsThings
   <JsonProperty("Property1")>
   Public Property Property1 As String
   <JsonProperty("Property2")>
   Public Property Property2 As String
End Class

and by "manually" (in code) stripping out each individual "Thing" - eg:

{"Property1":"P0001","Property2":"Value One"}
{"Property1":"P0002","Property2":"Value Two"}
{"Property1":"P0003","Property2":"Value Three"}

can loop through them one by one and, using Newtonsoft, read them into a collection of classes.

But I am sure there must be a way to do this without the manual steps of extracting each sub-JSON-string (for want of a better word) .....

Newtonsoft Utils wants to create separate classes for each line, which is just sily ...

Re: Parsing JSON

F-ES Sitecore7-Feb-18 23:57

F-ES Sitecore

7-Feb-18 23:57

You can parse the json using the newtonsoft classes

JObject jo = (JObject)JsonConvert.DeserializeObject(json);

foreach (JProperty p in jo.Properties())
{
    string pname = p.Name; // "0", "1", "2"
    string p1 = p.Value["Property1"].Value<string>();
    string p2 = p.Value["Property2"].Value<string>();
}

or you can map the properties to your own object

JObject jo = (JObject)JsonConvert.DeserializeObject(json);

foreach (JProperty p in jo.Properties())
{
    string pname = p.Name;
    clsThings t = JsonConvert.DeserializeObject<clsThings>(p.Value.ToString());
}

It's csharp but should be fairly easy to convert. "json" contains your json string.

Re: Parsing JSON

A_Griffin8-Feb-18 0:08

A_Griffin

8-Feb-18 0:08

Thank you!

Re: Parsing JSON

Richard Deeming8-Feb-18 1:01

EntityFramework: Can we minimize sorting code

8-Feb-18 1:01

The simplest option would be to deserialize as a Dictionary(Of String, clsThings). If necessary, you can then ignore the keys, and just read the values.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol6-Feb-18 2:46

6-Feb-18 2:46

i am fetching data from db using EF. when i fetching then i am filtering and sorting data too.this way i am sorting by column name. huge line i have to write which looks not good.

switch (SortColumn)
    {
        case "CompanyName":
            ViewBag.OldSort = "CompanyName";
            if (SortColumn.Equals(CurrentSort))
            {
                customer = customer.OrderByDescending(m => m.CompanyName);
                ViewBag.CurrentSort = "";
                ViewBag.SortOrder = "desc";
            }
            else
            {
                customer = customer.OrderBy(m => m.CompanyName);
                ViewBag.SortOrder = "asc";
            }
            break;

        case "ContactName":
            ViewBag.OldSort = "ContactName";
            if (SortColumn.Equals(CurrentSort))
            {
                customer = customer.OrderByDescending(m => m.ContactName);
                ViewBag.CurrentSort = "";
                ViewBag.SortOrder = "desc";
            }
            else
            {
                customer = customer.OrderBy(m => m.ContactName);
                ViewBag.SortOrder = "asc";
            }
            break;

        case "ContactTitle":
            ViewBag.OldSort = "ContactTitle";
            if (SortColumn.Equals(CurrentSort))
            {
                customer = customer.OrderByDescending(m => m.ContactTitle);
                ViewBag.CurrentSort = "";
                ViewBag.SortOrder = "desc";
            }
            else
            {
                customer = customer.OrderBy(m => m.ContactTitle);
                ViewBag.SortOrder = "asc";
            }
            break;

        case "Address":
            ViewBag.OldSort = "Address";
            if (SortColumn.Equals(CurrentSort))
            {
                customer = customer.OrderByDescending(m => m.Address);
                ViewBag.CurrentSort = "";
                ViewBag.SortOrder = "desc";
            }
            else
            {
                customer = customer.OrderBy(m => m.Address);
                ViewBag.SortOrder = "asc";
            }
            break;

        case "Default":
            ViewBag.OldSort = "CompanyName";
            customer = customer.OrderBy(m => m.CompanyName);
            ViewBag.SortOrder = "asc";
            break;
    }

please see for 4 columns i have to write so many line of code. suppose if i need to work with 40 columns then how many more line i need to write. so tell me best option to minimize the code for sorting when working with EF.

Richard Deeming6-Feb-18 3:03

6-Feb-18 3:03

Assuming all of your sortable columns are strings:

private static readonly IReadOnlyDictionary<string, Expression<Func<Customer, string>>> SortColumns = new Dictionary<string, Expression<Func<Customer, string>>>
{
    ["CompanyName"] = c => c.CompanyName,
    ["ContactName"] = c => c.ContactName,
    ["ContactTitle"] = c => c.ContactTitle,
    ["Address"] = c => c.Address,
};

...

if (SortColumns.TryGetValue(SortColumn, out var sortProperty))
{
    ViewBag.OldSort = SortColumn;
    if (SortColumn.Equals(CurrentSort))
    {
        customer = customer.OrderByDescending(sortProperty);
        ViewBag.CurrentSort = "";
        ViewBag.SortOrder = "desc";
    }
    else
    {
        customer = customer.OrderBy(sortProperty);
        ViewBag.SortOrder = "asc";
    }
}
else
{
    customer = customer.OrderBy(c => c.CompanyName);
    ViewBag.OldSort = "CompanyName";
    ViewBag.SortOrder = "asc";
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol7-Feb-18 20:40

7-Feb-18 20:40

Thank you sir, you said Assuming all of your sortable columns are strings: so if few columns are type of datetime, int or double then your above code will not work?

please suggest what to add in your code if few columns are type of datetime, int or double.

i will test your code let you know the status.

Thanks

Richard Deeming8-Feb-18 1:39

8-Feb-18 1:39

That gets slightly more complicated.

Start by adding the necessary using directives:

using System.Linq;
using System.Linq.Expressions;

Next, you'll need a method to sort based on a LambdaExpression:

private static IOrderedQueryable<TSource> OrderBy<TSource>(IQueryable<TSource> source, LambdaExpression keySelector, bool descending)
{
    string methodName = descending ? "OrderByDescending" : "OrderBy";
    Type[] typeArguments = { typeof(TSource), keySelector.ReturnType };
    var query = Expression.Call(typeof(Queryable), methodName, typeArguments, source.Expression, keySelector);
    return (IOrderedQueryable<TSource>)source.Provider.CreateQuery<TSource>(query);
}

Then you'll need to update the dictionary to store LambdaExpression values. To do that cleanly, you'll need a helper method to convert an anonymous delegate to a LambdaExpression:

private static LambdaExpression Expr<TProperty>(Expression<Func<Customer, TProperty>> fn) => fn;

private static readonly IReadOnlyDictionary<string, LambdaExpression> SortColumns = new Dictionary<string, LambdaExpression>
{
    ["CompanyName"] = Expr(c => c.CompanyName),
    ["ContactName"] = Expr(c => c.ContactName),
    ["ContactTitle"] = Expr(c => c.ContactTitle),
    ["Address"] = Expr(c => c.Address),
};

And finally, update your sorting code to use the new method:

if (SortColumns.TryGetValue(SortColumn, out var keySelector))
{
    ViewBag.OldSort = SortColumn;
    if (SortColumn.Equals(CurrentSort))
    {
        customer = OrderBy(customer, keySelector, true);
        ViewBag.CurrentSort = "";
        ViewBag.SortOrder = "desc";
    }
    else
    {
        customer = OrderBy(customer, keySelector, false);
        ViewBag.SortOrder = "asc";
    }
}
else
{
    customer = customer.OrderBy(c => c.CompanyName);
    ViewBag.OldSort = "CompanyName";
    ViewBag.SortOrder = "asc";
}

Now you can sort by any property type.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol8-Feb-18 1:52

8-Feb-18 1:52

thanks a lot sir Smile | :)

your 2nd posted code will work with any data type ?

Richard Deeming8-Feb-18 1:58

Any free health monitoring dashboard exist

8-Feb-18 1:58

It will work with any type that would work with a manual customers.OrderBy(c => c.SomeProperty) call.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol5-Feb-18 22:00