public JsonResult GetWorkOrderList(long LocationId, long workRequestProjectId, string filterwrtype, string filterqrc, string filter) { eTracLoginModel ObjLoginModel = null; var details = new List <WorkRequestAssignmentModelList>(); long UserId = 0, RequestedBy = 0; int? rows = 20; int?page = 1; int? TotalRecords = 10; string sord = null; String sidx = null; string txtSearch = ""; GlobalAdminManager _GlobalAdminManager = new GlobalAdminManager(); if (Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(Session["eTrac"]); UserId = ObjLoginModel.UserId; if (LocationId == 0) { LocationId = Convert.ToInt32(ObjLoginModel.LocationID); } } sord = string.IsNullOrEmpty(sord) ? "desc" : sord; sidx = string.IsNullOrEmpty(sidx) ? "CreatedDate" : sidx; DateTime StartDate = DateTime.UtcNow; DateTime EndDate = DateTime.UtcNow; var obj_Common_B = new Common_B(); ObjectParameter paramTotalRecords = new ObjectParameter("TotalRecords", typeof(int)); var data = _GlobalAdminManager.GetAllWorkRequestAssignmentList(workRequestProjectId, RequestedBy, "GetAllWorkRequestAssignment", page, rows, sidx, sord, txtSearch, LocationId, UserId, StartDate, EndDate, (filter == "All" ? "" : filter), (filterqrc == "All" ? "" : filterqrc), (filterwrtype == "All" ? "" : filterwrtype), paramTotalRecords); if (data.Count() > 0) { foreach (var item in data) { item.id = Cryptography.GetEncryptedData(item.WorkRequestAssignmentID.ToString(), true); item.QRCType = String.IsNullOrEmpty(item.QRCType) ? ((item.eFleetVehicleID != null && item.eFleetVehicleID != "" ? "Shuttle Bus" : "N/A")) : item.QRCType + " (" + item.QRCodeID + ")"; item.FacilityRequestType = (item.FacilityRequestType == null || item.FacilityRequestType.TrimWhiteSpace() == "" || item.FacilityRequestType.Trim() == "") ? "N/A" : item.FacilityRequestType; item.ProfileImage = item.ProfileImage == null ? HostingPrefix + ConstantImages.Replace("~", "") + "no-profile-pic.jpg" : HostingPrefix + ProfilePicPath.Replace("~", "") + item.ProfileImage; item.AssignedWorkOrderImage = item.AssignedWorkOrderImage == null ? HostingPrefix + ConstantImages.Replace("~", "") + "no-asset-pic.png" : HostingPrefix + WorkRequestImagepath.Replace("~", "") + item.AssignedWorkOrderImage; details.Add(item); } return(Json(details, JsonRequestBehavior.AllowGet)); } else { return(Json(details, JsonRequestBehavior.AllowGet)); } }
public void ProcessRequest(HttpContext context) { int?ProjectID = 0, UserID = 0; GlobalAdminManager _GlobalAdminManager = new GlobalAdminManager(); System.Collections.Specialized.NameValueCollection forms = context.Request.Form; HttpRequest request = context.Request; HttpResponse response = context.Response; string strOperation = forms.Get("oper"); string _search = request["_search"]; string textSearch = request["txtSearch"] ?? ""; int? numberOfRows = Convert.ToInt32(request["rows"]); int? pageIndex = Convert.ToInt32(request["page"]); string sortColumnName = request["sidx"]; string sortOrderBy = request["sord"]; string Location = request["LocationId"]; string filter = (request["filter"] == null || request["filter"] == "Select All") ? "" : request["filter"]; string filterqrc = (request["filterqrc"] == null || request["filterqrc"] == "Select All") ? "" : request["filterqrc"]; string filterwrtype = (request["filterwrtype"] == null || request["filterwrtype"] == "Select All") ? "" : request["filterwrtype"]; if (request["UserID"] != "") { UserID = Convert.ToInt32(request["UserID"]); //obj_StaffUserBusiness.Deleteuser(id); } DateTime StartDate = DateTime.UtcNow; DateTime EndDate = DateTime.UtcNow; eTracLoginModel ObjLoginModel = null; long iUserID = 0; long LocationID = 0; if (context.Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(context.Session["eTrac"]); if (!string.IsNullOrEmpty(Location)) { LocationID = Convert.ToInt64(Location); //LocationID = 0; iUserID = ObjLoginModel.UserId; } else { iUserID = ObjLoginModel.UserId; LocationID = ObjLoginModel.LocationID; } } else { return; } //long LocationID = Convert.ToInt64(context.Session["eTrac_SelectedDasboardLocationID"]); ObjectParameter paramTotalRecords = new ObjectParameter("TotalRecords", typeof(int)); //var WorkRequestList = _GlobalAdminManager.GetAllWorkRequestAssignment(ProjectID, UserID, "GetAllWorkRequestAssignment", pageIndex, numberOfRows, sortColumnName, sortOrderBy, textSearch, LocationID, iUserID, StartDate, EndDate, (filter == "All" ? "" : filter), (filterqrc == "All" ? "" : filterqrc), paramTotalRecords); var WorkRequestList = _GlobalAdminManager.GetAllWorkRequestAssignmentList(ProjectID, UserID, "GetAllWorkRequestAssignment", pageIndex, numberOfRows, sortColumnName, sortOrderBy, textSearch, LocationID, iUserID, StartDate, EndDate, (filter == "All" ? "" : filter), (filterqrc == "All" ? "" : filterqrc), (filterwrtype == "All" ? "" : filterwrtype), paramTotalRecords); if (WorkRequestList.Count() > 0) { string output = BuildJQGridResults(WorkRequestList, Convert.ToInt32(numberOfRows), Convert.ToInt32(pageIndex), Convert.ToInt32(paramTotalRecords.Value)); response.Write(output); } else { JQGridResults result = new JQGridResults(); List <JQGridRow> rows = new List <JQGridRow>(); result.rows = rows.ToArray(); result.page = 0; result.total = 0; result.records = 0; response.Write(new JavaScriptSerializer().Serialize(result)); } }