/// <summary> /// Inserts a DataRequestLog object(row) for a given BBL and type of request when data (not stale) is found in WebData DB /// </summary> public static WebDataDB.DataRequestLog InsertForFailure(string propertyBBL, int requestTypeId, string externalReferenceId, string jobId, string requestParameters) { WebDataDB.DataRequestLog dataRequestLogObj = new WebDataDB.DataRequestLog(); using (WebDataEntities webDBEntities = new WebDataEntities()) { try { dataRequestLogObj.BBL = propertyBBL; dataRequestLogObj.RequestStatusTypeId = (int)RequestStatus.Error; dataRequestLogObj.RequestTypeId = requestTypeId; dataRequestLogObj.RequestDateTime = DateTime.UtcNow; dataRequestLogObj.ExternalReferenceId = externalReferenceId; dataRequestLogObj.JobId = jobId; dataRequestLogObj.ServedFromCache = false; dataRequestLogObj.WebDataRequestMade = false; dataRequestLogObj.RequestParameters = requestParameters; dataRequestLogObj = webDBEntities.DataRequestLogs.Add(dataRequestLogObj); webDBEntities.SaveChanges(); return(dataRequestLogObj); } catch (Exception e) { Common.Logs.log().Error(string.Format("Exception encountered request for BBL {0} for Request Type {1} with externalRefId {2}{3}", propertyBBL, ((RequestStatus)requestTypeId).ToString(), externalReferenceId, Common.Logs.FormatException(e))); return(null); } } }
/// <summary> /// Gets all DataRequestLog objects(rows) from the DataRequestLog table for a given RequestId and sets their status to Error /// </summary> /// <param name="webDBEntities"></param> /// <param name="requestId"></param> /// <returns></returns> public static List <WebDataDB.DataRequestLog> SetAsSuccess(WebDataEntities webDBEntities, long requestId) { List <WebDataDB.DataRequestLog> requestDataLogList = webDBEntities.DataRequestLogs.Where(i => i.RequestId == requestId).ToList(); requestDataLogList.ForEach(a => a.RequestStatusTypeId = (int)RequestStatus.Success); webDBEntities.SaveChanges(); return(requestDataLogList); }
/// <summary> /// Inserts a Request object(row) for a given BBL and type of request when data (not stale) is found in WebData DB /// </summary> /// <param name="webDBEntities"></param> /// <param name="requestStr"> /// Depending on the Request Type a helper class will be provided to convert business level variables into a string (in a specific format) /// such that it is readable by the web scarping service. /// </param> /// <param name="requestTypeId"></param> /// <param name="priority"></param> /// <param name="jobId"></param> /// <returns></returns> public static WebDataDB.Request Insert(WebDataEntities webDBEntities, string requestStr, int requestTypeId, int priority, string jobId) { WebDataDB.Request requestObj = new WebDataDB.Request(); requestObj.JobId = jobId; requestObj.Priorty = priority; requestObj.RequestTypeId = requestTypeId; requestObj.RequestStatusTypeId = (int)RequestStatus.Pending; requestObj.DateTimeSubmitted = DateTime.UtcNow; requestObj.AttemptNumber = 0; requestObj.RequestData = requestStr; requestObj = webDBEntities.Requests.Add(requestObj); webDBEntities.SaveChanges(); return(requestObj); }
/// <summary> /// Inserts a DataRequestLog object(row) for a given BBL and type of request when data (not stale) is found in WebData DB /// </summary> public static WebDataDB.DataRequestLog InsertForCacheAccess(WebDataEntities webDBEntities, string propertyBBL, int requestTypeId, string externalReferenceId, string jobId, string requestParameters) { WebDataDB.DataRequestLog dataRequestLogObj = new WebDataDB.DataRequestLog(); dataRequestLogObj.BBL = propertyBBL; dataRequestLogObj.RequestStatusTypeId = (int)RequestStatus.Success; dataRequestLogObj.RequestTypeId = requestTypeId; dataRequestLogObj.RequestDateTime = DateTime.UtcNow; dataRequestLogObj.ExternalReferenceId = externalReferenceId; dataRequestLogObj.JobId = jobId; dataRequestLogObj.ServedFromCache = true; dataRequestLogObj.WebDataRequestMade = false; dataRequestLogObj.RequestParameters = requestParameters; dataRequestLogObj = webDBEntities.DataRequestLogs.Add(dataRequestLogObj); webDBEntities.SaveChanges(); return(dataRequestLogObj); }
/// <summary> /// This function returns a list of unsatisfied mortgages and deletes any mortgage data stored for a mortgaged that is satisfied /// </summary> public static List <tfnGetUnsatisfiedMortgages_Result> GetSynchronizedData(string propertyBBL) { List <tfnGetUnsatisfiedMortgages_Result> uMortgagesList = null; //get all unsatisfied mortgage document records using (ACRISEntities acrisDBEntities = new ACRISEntities()) { uMortgagesList = acrisDBEntities.tfnGetUnsatisfiedMortgages(propertyBBL).ToList(); } //get all mortgage document records stored in webdata locally using (WebDataEntities wDBEntities = new WebDataEntities()) { if (uMortgagesList == null || uMortgagesList.Count <= 0) { wDBEntities.Mortgages.RemoveRange(wDBEntities.Mortgages.Where(x => x.BBL == propertyBBL)); } else { List <WebDataDB.Mortgage> webDataMortgageList = wDBEntities.Mortgages.Where(x => x.BBL == propertyBBL).ToList(); foreach (var wDBMortgage in webDataMortgageList) { bool found = false; foreach (var uMortgage in uMortgagesList) { if (uMortgage.URL == wDBMortgage.MortgageDocumentURI) { found = true; break; } } if (!found) { wDBEntities.Mortgages.Remove(wDBMortgage); } } } wDBEntities.SaveChanges(); } return(uMortgagesList); }
/// <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 WaterBill table based on the information received from the Request Object /// </summary> 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; Decimal?billAmount = null; switch (requestObj.RequestStatusTypeId) { case (int)RequestStatus.Error: 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.ParseWaterBill(requestObj.ResponseData); billAmount = resultObj.Amount; Parameters waterBillParams = JSONToParameters(dataRequestLogObj.RequestParameters); //check if data available WebDataDB.WaterBill waterBillObj = webDBEntities.WaterBills.FirstOrDefault(i => i.BBL == waterBillParams.BBL); if (waterBillObj != null) { waterBillObj.BillAmount = resultObj.Amount; waterBillObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); } else { waterBillObj = new WebDataDB.WaterBill(); waterBillObj.BBL = waterBillParams.BBL; waterBillObj.BillAmount = resultObj.Amount; waterBillObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.WaterBills.Add(waterBillObj); } 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 Id {0} with incorrect Status Id {2}", requestObj.RequestId, requestObj.RequestStatusTypeId)); break; } webDBEntitiestransaction.Commit(); if (logs != null) { MakeCallBacks(appContext, logs, billAmount); } 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); } } } }
/// <summary> /// This method updates the Zillow table based on the information received from the Request Object /// </summary> 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; decimal?zEstimate = 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) { RequestResponseBuilder.ResponseObjects.ZillowZEstimate resultObj = null; try { resultObj = (ResponseData.ParseZillowZEstimate(requestObj.ResponseData))[0]; zEstimate = resultObj.Zestimate; } catch (Exception e) { Common.Logs.log().Error(string.Format("Cannot parse the response data {0}{1}", requestObj.RequestId, Common.Logs.FormatException(e))); } Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if old data in the DB WebDataDB.Zillow zillowObj = webDBEntities.Zillows.FirstOrDefault(i => i.BBL == parameters.BBL); if (zillowObj != null) { //Update data with new results zillowObj.zEstimate = zEstimate; zillowObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); } else { // add an entry into cache or DB zillowObj = new WebDataDB.Zillow(); zillowObj.BBL = parameters.BBL; zillowObj.zEstimate = zEstimate; zillowObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.Zillows.Add(zillowObj); } 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, zEstimate); } 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); } } } }
/// <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); } } } }
/// <summary> /// This method updates the dCivilPenalties table based on the information received from the Request Object /// </summary> 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; decimal?penaltyAmount = null, violationAmount = 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) { decimal dobTotalPenaltyAmount = 0; decimal dobTotalViolationAmount = 0; foreach (var row in ResponseData.ParseECBviolationAndDOBCivilPenalty(requestObj.ResponseData).DOBCivilPenalties) { dobTotalPenaltyAmount += row.DOBCivilPenaltyAmount.GetValueOrDefault(); } foreach (var row in ResponseData.ParseECBviolationAndDOBCivilPenalty(requestObj.ResponseData).ECBViolations) { dobTotalViolationAmount += row.ECBPenaltyDue.GetValueOrDefault(); } penaltyAmount = dobTotalPenaltyAmount; violationAmount = dobTotalViolationAmount; Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if data available WebDataDB.DOBViolation dobPenaltiesAndViolationsObj = webDBEntities.DOBViolations.FirstOrDefault(i => i.BBL == parameters.BBL); if (dobPenaltiesAndViolationsObj != null) { dobPenaltiesAndViolationsObj.DOBCivilPenalties = dobTotalPenaltyAmount; dobPenaltiesAndViolationsObj.ECBViolationAmount = dobTotalViolationAmount; dobPenaltiesAndViolationsObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); } else { dobPenaltiesAndViolationsObj = new WebDataDB.DOBViolation(); dobPenaltiesAndViolationsObj.BBL = parameters.BBL; dobPenaltiesAndViolationsObj.DOBCivilPenalties = dobTotalPenaltyAmount; dobPenaltiesAndViolationsObj.ECBViolationAmount = dobTotalViolationAmount; dobPenaltiesAndViolationsObj.LastUpdated = requestObj.DateTimeEnded.GetValueOrDefault(); webDBEntities.DOBViolations.Add(dobPenaltiesAndViolationsObj); } 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, penaltyAmount, violationAmount); } 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); } } } }