/// <summary> /// Update Request object with higher priority and Job Id /// </summary> public static WebDataDB.Request Update(WebDataEntities webDBEntities, long requestId, int priority, string jobId) { var requestObj = webDBEntities.Requests.Where(x => x.RequestId == requestId).FirstOrDefault(); if (requestObj == null) { return(null); } requestObj.JobId = jobId; if (requestObj.Priorty > priority) { requestObj.Priorty = priority; } webDBEntities.Requests.Attach(requestObj); webDBEntities.Entry(requestObj).State = EntityState.Modified; webDBEntities.SaveChanges(); return(requestObj); }
/// <summary> /// This method updates the Mortgage Servicer table based on the information received from the Request Object /// </summary> /// <param name="appContext"></param> /// <param name="requestObj"></param> /// <returns>True if successful else false</returns> public static bool UpdateData(Common.Context appContext, Request requestObj) { using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { try { List <DataRequestLog> logs = null; bool?isFreddie = null; switch (requestObj.RequestStatusTypeId) { case (int)RequestStatus.Error: logs = DAL.DataRequestLog.SetAsError(webDBEntities, requestObj.RequestId); break; case (int)RequestStatus.Success: { DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetFirst(webDBEntities, requestObj.RequestId); if (dataRequestLogObj == null) { throw (new Exception("Cannot locate Request Log Record(s)")); } //var resultObj = // need to modify isFreddie = false; // resultObj.ServicerName; if (isFreddie == null) { logs = DAL.DataRequestLog.SetAsError(webDBEntities, requestObj.RequestId); } else { Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if old data in the DB WebDataDB.FreddieMortgage mortgageObj = webDBEntities.FreddieMortgages.FirstOrDefault(i => i.BBL == parameters.BBL); if (mortgageObj != null) { //Update data with new results mortgageObj.IsFreddie = isFreddie.GetValueOrDefault(); mortgageObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.Entry(mortgageObj).State = EntityState.Modified; } else { // add an entry into cache or DB mortgageObj = new WebDataDB.FreddieMortgage(); mortgageObj.BBL = parameters.BBL; mortgageObj.IsFreddie = isFreddie.GetValueOrDefault(); mortgageObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.FreddieMortgages.Add(mortgageObj); } webDBEntities.SaveChanges(); logs = DAL.DataRequestLog.SetAsSuccess(webDBEntities, requestObj.RequestId); } break; } default: Common.Logs.log().Warn(string.Format("Update called for a Request Object Id {0} with incorrect Status Id {1}", requestObj.RequestId, requestObj.RequestStatusTypeId)); break; } webDBEntitiestransaction.Commit(); if (logs != null) { MakeCallBacks(appContext, logs, isFreddie); } return(true); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Common.Logs.log().Error(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage)); } } return(false); } catch (Exception e) { webDBEntitiestransaction.Rollback(); Common.Logs.log().Error(string.Format("Exception encountered updating request with id {0}{1}", requestObj.RequestId, Common.Logs.FormatException(e))); return(false); } } } }
/// <summary> /// This method updates the Mortgage Servicer table based on the information received from the Request Object /// </summary> /// <param name="requestObj"></param> /// <param name="appContext"></param> /// <returns>True if successful else false</returns> public static bool UpdateData(Common.Context appContext, Request requestObj) { using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { try { List <DataRequestLog> logs = null; NoticeOfProperyValue noticeOfPropertyValueObj = null; switch (requestObj.RequestStatusTypeId) { case (int)RequestStatus.Error: logs = DAL.DataRequestLog.SetAsError(webDBEntities, requestObj.RequestId); break; case (int)RequestStatus.Success: { DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetFirst(webDBEntities, requestObj.RequestId); if (dataRequestLogObj != null) { var resultObj = ResponseData.ParseNoticeOfPropertyValue(requestObj.ResponseData); Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if old data in the DB noticeOfPropertyValueObj = webDBEntities.NoticeOfProperyValues.FirstOrDefault(i => i.BBL == parameters.BBL); if (noticeOfPropertyValueObj != null) { //Update data with new results noticeOfPropertyValueObj = CopyData(noticeOfPropertyValueObj, resultObj); noticeOfPropertyValueObj.BBL = parameters.BBL; noticeOfPropertyValueObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.Entry(noticeOfPropertyValueObj).State = EntityState.Modified; } else { // add an entry into cache or DB noticeOfPropertyValueObj = CopyData(null, resultObj); noticeOfPropertyValueObj.BBL = parameters.BBL; noticeOfPropertyValueObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.NoticeOfProperyValues.Add(noticeOfPropertyValueObj); } webDBEntities.SaveChanges(); logs = DAL.DataRequestLog.SetAsSuccess(webDBEntities, requestObj.RequestId); } else { throw (new Exception("Cannot locate Request Log Record(s)")); } break; } default: Common.Logs.log().Warn(string.Format("Update called for a Request Object Id {0} with incorrect Status Id {1}", requestObj.RequestId, requestObj.RequestStatusTypeId)); break; } webDBEntitiestransaction.Commit(); if (logs != null) { MakeCallBacks(appContext, logs, noticeOfPropertyValueObj); } return(true); } catch (Exception e) { webDBEntitiestransaction.Rollback(); Common.Logs.log().Error(string.Format("Exception encountered updating request with id {0}{1}", requestObj.RequestId, Common.Logs.FormatException(e))); return(false); } } } }