Guriddo » All Posts

Reply To: Filter Toolbar not passing the search parameters to MVC controller

guriddo.support — Fri, 27 Nov 2020 09:13:42 +0000

Hello,

The searchField, searchOper, and searchString field values are not present in filterToolbar method. These are valid only in certain cases in form searching (this is a old behaviour)

Instead of this use the filters property and accept it in the server. I recommend you to read this docs Here we describe what is posted to the server when searching

Kind Regards

Will

Guriddo Support Team

Filter Toolbar not passing the search parameters to MVC controller

Whiterainbow — Thu, 26 Nov 2020 14:06:06 +0000

Hi,

Here goes my grid code:

$(“#mailGrid”).navButtonAdd(‘#mailGridControls’, {
position: “left”,
caption: “Expand/Collapse All”,
title: “Expand/Collapse All”,
cursor: “pointer”,
buttonicon: “ui-icon-triangle-2-n-s”,
onClickButton: function () {
$(“#mailGrid”).find(“.treeclick”).trigger(‘click’);
}
});

if ($.session.get(‘IsInitial_load’) === “true”)
$(‘#mailGrid’).navButtonAdd(‘#mailGridControls’,
{
buttonicon: “ui-icon-plus”,
title: “More”,
caption: “More”,
position: “right”,
onClickButton: moreClicked
});
});
imgFormatter = function (cellvalue, options, rowObject) {
if (rowObject[“HasAttachments”] === “TRUE”)
return ““;
else
return “”;
};
boundFormatter = function (cellvalue, options, rowObject) {
if (cellvalue !== null && cellvalue !== undefined && cellvalue !== ‘null’ && cellvalue !== ‘undefined’) {
if (cellvalue.toUpperCase() === “SENT”)
return ““;
else
return ““;
}
else
return ““;
};
urlFormatter = function (cellvalue, options, rowObject) {
var sub = cellvalue;
var oId = rowObject[“ItemId”];
var uId = rowObject[“ID”];
var webaccesssiteURL = $(“#webaccessURL”).val().toString().replace(“[ItemID]”, oId.replace(‘+’, ‘%2B’));
var retString = “” + sub + ““;

return retString;
};

if ($.session.get(‘CurrentPage’) !== ‘undefined’ || $.session.get(‘CurrentPage’) !== undefined)
$(“#mailGrid”).trigger(“reloadGrid”, [{ page: $.session.get(‘CurrentPage’) }]);
}

And my search code in the controller:

public JsonResult GetAllTaggedMails(string sord, string sidx, int page, int rows, bool _search, string searchField, string searchOper, string searchString)
{
try
{
int pageIndex = Convert.ToInt32(page) – 1;
int pageSize = rows;

#region Get the e-mail details with client matter code from the mailbox of the user

var topMails = Session[“AllTaggedMails”] == null ? GetTopMails() : Session[“AllTaggedMails”] as List;

//if (Session[“AllTaggedMails”] == null)
Session[“AllTaggedMails”] = topMails as List;

var allTaggedMails = topMails.OrderByDescending(y => y.SentDate).Select(
c => new
{
c.RowID,
ID = c.UniqueID.ToString(),
c.Subject,
SentDate = Convert.ToDateTime(c.SentDate),
c.Recipient,
HasAttachments = c.HasAttachments == true ? “TRUE” : “FALSE”,
GroupCode = c.GroupCode == null ? “” : c.GroupCode,
GroupName = c.GroupName == null ? “” : c.GroupName,
c.ItemId,
c.Direction
});

#endregion

#region Search

if (_search)
{
switch (searchField == null ? searchField : searchField.ToUpper())
{
case “SUBJECT”:
if (searchOper == “eq”)
allTaggedMails = allTaggedMails.Where(s => s.Subject.Equals(searchString));
else
allTaggedMails = allTaggedMails.Where(s => s.Subject.ToLower().Contains(searchString.ToLower()));
break;
case “RECIPIENT”:
if (searchOper == “eq”)
allTaggedMails = allTaggedMails.Where(s => s.Recipient.Equals(searchString));
else
allTaggedMails = allTaggedMails.Where(s => s.Recipient.ToLower().Contains(searchString.ToLower()));
break;
case “GROUPCODE”:
if (searchOper == “eq”)
allTaggedMails = allTaggedMails.Where(s => s.GroupCode.Equals(searchString));
else
allTaggedMails = allTaggedMails.Where(s => s.GroupCode.ToLower().Contains(searchString.ToLower()));
break;
case “GroupNAME”:
if (searchOper == “eq”)
allTaggedMails = allTaggedMails.Where(s => s.GroupName.Equals(searchString));
else
allTaggedMails = allTaggedMails.Where(s => s.GroupName.ToLower().Contains(searchString.ToLower()));
break;
}
}

#endregion

int totalRecords = allTaggedMails.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);

#region Sort

string sortIndex = string.Empty;
if (sidx != null)
{
if (sidx.IndexOf(‘,’) >= 0)
{
sortIndex = sidx.Split(new char[] { ‘,’ }, StringSplitOptions.RemoveEmptyEntries)[1].ToString().Trim();
}
}
else
sortIndex = “SENTDATE”;

//switch (sidx == null ? sidx : sidx.ToUpper())
switch (sortIndex.ToUpper())
{
case “SENTDATE”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.SentDate);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.SentDate);

break;
case “SUBJECT”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.Subject);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.Subject);

break;
case “GroupCODE”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.GroupCode);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.GroupCode);

break;
case “GroupNAME”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.GroupName);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.GroupName);

break;
case “ROWID”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.HasAttachments);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.HasAttachments);

break;
case “RECIPIENT”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.Recipient);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.Recipient);

break;
case “DIRECTION”:
if (sord.ToUpper() == “DESC”)
allTaggedMails = allTaggedMails.OrderByDescending(s => s.Direction);
else
allTaggedMails = allTaggedMails.OrderBy(s => s.Direction);

break;
default:
allTaggedMails = allTaggedMails.OrderByDescending(s => s.SentDate);
break;
}

#endregion

allTaggedMails = allTaggedMails.Skip(pageIndex * pageSize).Take(pageSize);

if (Session[“IsLastPage”] != null)
isLastPage = Convert.ToBoolean(Session[“IsLastPage”].ToString().ToLower());

var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = allTaggedMails.ToList(),
IsLastPage = isLastPage
};
return Json(jsonData, JsonRequestBehavior.AllowGet);

}
catch (Exception ex)
{
ExReporter.Report(ex, MethodInfo.GetCurrentMethod().Name.ToString(), MethodInfo.GetCurrentMethod().DeclaringType.ToString(), Session[“User”].ToString());
return null;
}
}

When I type the text in the filter columns, the controller method receives, the searchField, searchOper, and searchString field values as null but the _search is passed as true.

Please let me know where in the code I am making the mistake?

Thanks in advance.

Senthil Kumar M.

Reply To: Using Chosen plugin with select elements in add/edit form

igor83 — Thu, 13 Jul 2017 02:23:26 +0000

Hello.

Thank you. At your suggestion, I used the plugin select2.

Reply To: Using Chosen plugin with select elements in add/edit form

tony — Tue, 11 Jul 2017 08:39:49 +0000

Hello,

Look t my answer here: http://guriddo.net/?topic=using-chosen-plugin-with-select-elements-in-addedit-form/#post-126261

Kind Regards,

Reply To: Using Chosen plugin with select elements in add/edit form

igor83 — Tue, 11 Jul 2017 04:10:33 +0000

tony wrote:

Hello,

Which search is used – dialog search or toolbar search?

Kind Regards

toolbar search

Reply To: Using Chosen plugin with select elements in add/edit form

tony — Mon, 10 Jul 2017 13:10:38 +0000

Hello,

Use setTimeout within the dataInit and it will work, but there is a problem wit position and visibility (z-index).

Some possible resolution is here

If possible use another plugin like maybe select2.

Kind Regards,

Reply To: Using Chosen plugin with select elements in add/edit form

tony — Mon, 10 Jul 2017 11:28:25 +0000

Hello,

Which search is used – dialog search or toolbar search?

Kind Regards

Reply To: Using Chosen plugin with select elements in add/edit form

igor83 — Mon, 10 Jul 2017 03:17:38 +0000

Hello.
Also there was a question on this plugin.
I do so

{ label: 'Student', name: 'student_name', width: '30%', filtering: true, viewable: false, stype: 'select',
   searchoptions: {
      value:':;1:student_1;2:student_2;3:student_3',
      dataInit : function (element, options) {
         $(element).chosen();
      }
   }
},

{ label: 'Student', name: 'student_name', width: '30%', filtering: true, viewable: false, stype: 'select',

searchoptions: {

value:':;1:student_1;2:student_2;3:student_3',

dataInit : function (element, options) {

$(element).chosen();

}

but the plugin does not work. The search string does not even appear. Tell me what I’m doing wrong?

Reply To: Roadmap update

tony — Wed, 10 May 2017 08:28:41 +0000

Hello,

We have updated our Roadmap.

Kind Regards,

Reply To: Roadmap update

tony — Thu, 03 Nov 2016 08:16:53 +0000

Hell Kris,

Thank you for remaind us about this.
I have updated the Roadmap for 2016.
The Roadmap for 2017 will be available after publishing the new release (expected 10 November, 2016)

Kind Regards,