private string GetAllProgressWorkRequestAssignmentSignalR(long LocationId, long UserId, string SignalRequestType, string Filter) { try { WorkOrderEMS.BusinessLogic.Managers.GlobalAdminManager _GlobalAdminManager = new WorkOrderEMS.BusinessLogic.Managers.GlobalAdminManager(); int? ProjectID = 0, UserID = 0; string textSearch = ""; int? numberOfRows = 100000; int? pageIndex = 1; string sortColumnName = ""; string sortOrderBy = "desc"; string RequestType = SignalRequestType; string filter = Filter; DateTime StartDate = DateTime.UtcNow; DateTime EndDate = DateTime.UtcNow; long iUserID = UserId; long LocationID = LocationId; ObjectParameter paramTotalRecords = new ObjectParameter("TotalRecords", typeof(int)); var WorkRequestList = _GlobalAdminManager.GetAllWorkRequestAssignment(ProjectID, UserID, RequestType, pageIndex, numberOfRows, sortColumnName, sortOrderBy, textSearch, LocationID, iUserID, StartDate, EndDate, filter, "", paramTotalRecords); if (WorkRequestList.Count() > 0) { string result = ""; if (SignalRequestType.Trim() == "GetAllPendingWorkRequest" || SignalRequestType.Trim() == "GetAssignedWorktoEmployee") { result = BuildJQGridResults(WorkRequestList, Convert.ToInt32(numberOfRows), Convert.ToInt32(pageIndex), Convert.ToInt32(paramTotalRecords.Value)); } else { result = BuildJQGridResultsPending(WorkRequestList, Convert.ToInt32(numberOfRows), Convert.ToInt32(pageIndex), Convert.ToInt32(paramTotalRecords.Value)); } return(result); } else { WorkOrderEMS.Helpers.JQGridResults result = new WorkOrderEMS.Helpers.JQGridResults(); List <WorkOrderEMS.Helpers.JQGridRow> rows = new List <WorkOrderEMS.Helpers.JQGridRow>(); result.rows = rows.ToArray(); result.page = 0; result.total = 0; result.records = 0; return(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(result)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public string GetOnlineInterviewer(long getApplicantId) { var _GlobalAdminManager = new WorkOrderEMS.BusinessLogic.Managers.GlobalAdminManager(); try { var _WorkRequestManager = new WorkOrderEMS.BusinessLogic.Managers.WorkRequestManager(); var ObjLoginModel = new eTracLoginModel(); var interviewersList = _GlobalAdminManager.GetInterviewersList(getApplicantId, ObjLoginModel.UserId); return(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(interviewersList)); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public string GetWorkOrderForDashboardSignalR(long LocationId, long UserId, string fromDate, string toDate, long UserType) { try { //Getting client date time. var clientdt = DateTime.UtcNow.GetClientDateTimeNow(); //flag status for if user filter record in time span so to date is till midnight. bool isUTCDay = true; DateTime FromDate = (fromDate == null || string.IsNullOrWhiteSpace(fromDate)) ? clientdt.Date : Convert.ToDateTime(fromDate); DateTime ToDate = (toDate == null || string.IsNullOrWhiteSpace(toDate)) ? clientdt.AddDays(1).Date : Convert.ToDateTime(toDate); ////This condition for if fromdate Todate is same but todate time is upto now. //ToDate = (ToDate.Value.Date == DateTime.UtcNow.Date) ? DateTime.UtcNow : ToDate; //Newly added code if (FromDate != null && ToDate != null) { ////if interval date come then need to fetch record till midnight of todate day if ((FromDate.Date != ToDate.Date) && (ToDate.ToLongTimeString() == "12:00:00 AM") && isUTCDay == false) { ToDate = ToDate.AddDays(1).Date; } if ((FromDate.Date == ToDate.Date) && (ToDate.ToLongTimeString() == "12:00:00 AM")) { ToDate = ToDate.AddDays(1).Date; } } FromDate = FromDate.ConvertClientTZtoUTC(); ToDate = ToDate.ConvertClientTZtoUTC(); //Newly added code end here WorkOrderEMS.BusinessLogic.Managers.GlobalAdminManager _GlobalAdminManager = new WorkOrderEMS.BusinessLogic.Managers.GlobalAdminManager(); var dataJson = _GlobalAdminManager.GetDashboardHeadCount(LocationId, UserId, FromDate, ToDate, UserType); return(dataJson); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }