public HttpResponseMessage GetRouteUsers([FromBody] GetRouteUserRequest GetRouteUserRequest) { Logger.Debug("Inside UM Controller- GetRouteUsers "); Logger.Debug("Request: " + new JavaScriptSerializer().Serialize(GetRouteUserRequest)); GetRouteUserResponse lResponse = new GetRouteUserResponse(); ErrorResponse error = new ErrorResponse(); var response = new Dictionary <string, object>(); try { string SessionID = Guid.Empty.ToString(); if (Request.Headers != null) { SessionID = Request.Headers.LastOrDefault().Value.First(); Logger.Debug("SessionID: " + SessionID.ToString()); if (_IUMServer.ValidateUser(SessionID)) { lResponse = _IUMServer.GetRouteUsers(GetRouteUserRequest); if (lResponse != null) { Logger.Debug("Response: " + new JavaScriptSerializer().Serialize(lResponse)); return(Request.CreateResponse(HttpStatusCode.OK, lResponse)); } else { error.ErrorCode = HttpStatusCode.InternalServerError; error.ErrorMessage = "Failure"; response.Add("ErrorResponse", error); return(Request.CreateResponse(HttpStatusCode.InternalServerError, response)); } } else { error.ErrorCode = HttpStatusCode.Forbidden; error.ErrorMessage = "Session has expired, please login again"; response.Add("ErrorResponse", error); return(Request.CreateResponse(HttpStatusCode.Forbidden, response)); } } else { error.ErrorCode = HttpStatusCode.BadRequest; error.ErrorMessage = "Failure"; response.Add("ErrorResponse", error); return(Request.CreateResponse(HttpStatusCode.BadRequest, response)); } } catch (Exception ex) { Logger.Error(ex.Message); error.ErrorCode = HttpStatusCode.InternalServerError; error.ErrorMessage = "Failure"; response.Add("ErrorResponse", error); return(Request.CreateResponse(HttpStatusCode.InternalServerError, response)); } }
public GetRouteUserResponse GetRouteUsers(GetRouteUserRequest GetRouteUserRequest) { GetRouteUserResponse lresponse = new GetRouteUserResponse(); IJobRepository _IJobRepository; _IJobRepository = new JobRepository(new WorkersInMotionDB()); //lresponse = _IJobRepository.GetRouteUsers(GetRouteUserRequest); //return lresponse; try { GetRouteUserResponse lResponse = new GetRouteUserResponse(); SqlParameter[] Param = new SqlParameter[12]; Param[11] = new SqlParameter("@pOrganizationGUID", SqlDbType.UniqueIdentifier); Param[11].Value = DBNull.Value; Param[0] = new SqlParameter("@pDate", SqlDbType.Date); Param[0].Value = DateTime.UtcNow; Param[1] = new SqlParameter("@pStartTime", SqlDbType.Time); Param[1].Value = DateTime.UtcNow.TimeOfDay; Param[2] = new SqlParameter("@pEndTime", SqlDbType.Time); Param[2].Value = DateTime.UtcNow.TimeOfDay; Param[3] = new SqlParameter("@pDuration", SqlDbType.Float); Param[3].Value = 230; Param[4] = new SqlParameter("@pRegionGUID", SqlDbType.UniqueIdentifier); Param[4].Value = DBNull.Value; Param[5] = new SqlParameter("@pTerritoryGUID", SqlDbType.UniqueIdentifier); Param[5].Value = DBNull.Value; Param[6] = new SqlParameter("@pLatitude", SqlDbType.Float); Param[6].Value = 0; Param[7] = new SqlParameter("@pLongitude", SqlDbType.Float); Param[7].Value = 0; Param[8] = new SqlParameter("@pSearchWithinZoneArea", SqlDbType.Bit); Param[8].Value = 0; Param[9] = new SqlParameter("@pSearch", SqlDbType.Bit); Param[9].Value = 0; Param[10] = new SqlParameter("@pErrorCode", SqlDbType.NVarChar, 200); Param[10].Value = ""; Param[10].Direction = ParameterDirection.Output; // var result1 = contextWIM.Database.SqlQuery<dynamic>("p_GetUsersLocationForADate @pOrganizationGUID,@pDate,@pStartTime, @pEndTime, @pDuration,@pRegionGUID,@pTerritoryGUID,@pLatitude,@pLongitude,@pSearchWithinZoneArea,@pSearch,@pErrorCode", Param).ToList(); SqlParameter[] sqlParam = new SqlParameter[12]; sqlParam[0] = new SqlParameter("@pSkill", SqlDbType.NVarChar); sqlParam[0].Value = ""; sqlParam[1] = new SqlParameter("@pDate", SqlDbType.Date); sqlParam[1].Value = DateTime.UtcNow; sqlParam[2] = new SqlParameter("@pStartTime", SqlDbType.Time); sqlParam[2].Value = DateTime.UtcNow.TimeOfDay; sqlParam[3] = new SqlParameter("@pEndTime", SqlDbType.Time); sqlParam[3].Value = DateTime.UtcNow.TimeOfDay; sqlParam[4] = new SqlParameter("@pDuration", SqlDbType.Float); sqlParam[4].Value = 230; sqlParam[5] = new SqlParameter("@pRegionGUID", SqlDbType.UniqueIdentifier); sqlParam[5].Value = DBNull.Value; sqlParam[6] = new SqlParameter("@pTerritoryGUID", SqlDbType.UniqueIdentifier); sqlParam[6].Value = DBNull.Value; sqlParam[7] = new SqlParameter("@pLatitude", SqlDbType.Float); sqlParam[7].Value = 0; sqlParam[8] = new SqlParameter("@pLongitude", SqlDbType.Float); sqlParam[8].Value = 0; sqlParam[9] = new SqlParameter("@pSearchWithinZoneArea", SqlDbType.Bit); sqlParam[9].Value = 0; sqlParam[10] = new SqlParameter("@pSearch", SqlDbType.Bit); sqlParam[10].Value = 0; sqlParam[11] = new SqlParameter("@pErrorCode", SqlDbType.NVarChar, 200); sqlParam[11].Value = ""; sqlParam[11].Direction = ParameterDirection.Output; // var result = contextWIM.Database.SqlQuery<dynamic>("p_GetUsersAvailability @pSkill,@pDate,@pStartTime, @pEndTime, @pDuration,@pRegionGUID,@pTerritoryGUID,@pLatitude,@pLongitude,@pSearchWithinZoneArea,@pSearch,@pErrorCode", sqlParam).ToList(); lresponse = _IJobRepository.GetRouteUsers(sqlParam, Param); return(lResponse); } catch (Exception exception) { return(null); } }
public GetRouteUserResponse GetRouteUsers(GetRouteUserRequest GetRouteUserRequest) { GetRouteUserResponse lresponse = new GetRouteUserResponse(); IJobRepository _IJobRepository; _IJobRepository = new JobRepository(new WorkersInMotionDB()); //lresponse = _IJobRepository.GetRouteUsers(GetRouteUserRequest); //return lresponse; try { GetRouteUserResponse lResponse = new GetRouteUserResponse(); SqlParameter[] Param = new SqlParameter[12]; Param[11] = new SqlParameter("@pOrganizationGUID", SqlDbType.UniqueIdentifier); Param[11].Value = DBNull.Value; Param[0] = new SqlParameter("@pDate", SqlDbType.Date); Param[0].Value = DateTime.UtcNow; Param[1] = new SqlParameter("@pStartTime", SqlDbType.Time); Param[1].Value = DateTime.UtcNow.TimeOfDay; Param[2] = new SqlParameter("@pEndTime", SqlDbType.Time); Param[2].Value = DateTime.UtcNow.TimeOfDay; Param[3] = new SqlParameter("@pDuration", SqlDbType.Float); Param[3].Value = 230; Param[4] = new SqlParameter("@pRegionGUID", SqlDbType.UniqueIdentifier); Param[4].Value = DBNull.Value; Param[5] = new SqlParameter("@pTerritoryGUID", SqlDbType.UniqueIdentifier); Param[5].Value = DBNull.Value; Param[6] = new SqlParameter("@pLatitude", SqlDbType.Float); Param[6].Value = 0; Param[7] = new SqlParameter("@pLongitude", SqlDbType.Float); Param[7].Value = 0; Param[8] = new SqlParameter("@pSearchWithinZoneArea", SqlDbType.Bit); Param[8].Value = 0; Param[9] = new SqlParameter("@pSearch", SqlDbType.Bit); Param[9].Value = 0; Param[10] = new SqlParameter("@pErrorCode", SqlDbType.NVarChar, 200); Param[10].Value = ""; Param[10].Direction = ParameterDirection.Output; // var result1 = contextWIM.Database.SqlQuery<dynamic>("p_GetUsersLocationForADate @pOrganizationGUID,@pDate,@pStartTime, @pEndTime, @pDuration,@pRegionGUID,@pTerritoryGUID,@pLatitude,@pLongitude,@pSearchWithinZoneArea,@pSearch,@pErrorCode", Param).ToList(); SqlParameter[] sqlParam = new SqlParameter[12]; sqlParam[0] = new SqlParameter("@pSkill", SqlDbType.NVarChar); sqlParam[0].Value = ""; sqlParam[1] = new SqlParameter("@pDate", SqlDbType.Date); sqlParam[1].Value = DateTime.UtcNow; sqlParam[2] = new SqlParameter("@pStartTime", SqlDbType.Time); sqlParam[2].Value = DateTime.UtcNow.TimeOfDay; sqlParam[3] = new SqlParameter("@pEndTime", SqlDbType.Time); sqlParam[3].Value = DateTime.UtcNow.TimeOfDay; sqlParam[4] = new SqlParameter("@pDuration", SqlDbType.Float); sqlParam[4].Value = 230; sqlParam[5] = new SqlParameter("@pRegionGUID", SqlDbType.UniqueIdentifier); sqlParam[5].Value = DBNull.Value; sqlParam[6] = new SqlParameter("@pTerritoryGUID", SqlDbType.UniqueIdentifier); sqlParam[6].Value = DBNull.Value; sqlParam[7] = new SqlParameter("@pLatitude", SqlDbType.Float); sqlParam[7].Value = 0; sqlParam[8] = new SqlParameter("@pLongitude", SqlDbType.Float); sqlParam[8].Value = 0; sqlParam[9] = new SqlParameter("@pSearchWithinZoneArea", SqlDbType.Bit); sqlParam[9].Value = 0; sqlParam[10] = new SqlParameter("@pSearch", SqlDbType.Bit); sqlParam[10].Value = 0; sqlParam[11] = new SqlParameter("@pErrorCode", SqlDbType.NVarChar, 200); sqlParam[11].Value = ""; sqlParam[11].Direction = ParameterDirection.Output; // var result = contextWIM.Database.SqlQuery<dynamic>("p_GetUsersAvailability @pSkill,@pDate,@pStartTime, @pEndTime, @pDuration,@pRegionGUID,@pTerritoryGUID,@pLatitude,@pLongitude,@pSearchWithinZoneArea,@pSearch,@pErrorCode", sqlParam).ToList(); lresponse = _IJobRepository.GetRouteUsers(sqlParam, Param); return lResponse; } catch (Exception exception) { return null; } }