/// <summary> /// This method gets the data or current status for a request /// </summary> /// <param name="dataRequestLogObj"></param> /// <returns></returns> public static DOBPenaltiesAndViolationsSummaryData ReRun(DataRequestLog dataRequestLogObj) { DOBPenaltiesAndViolationsSummaryData dPenaltiesAndViolations = new DOBPenaltiesAndViolationsSummaryData(); dPenaltiesAndViolations.BBL = dataRequestLogObj.BBL; dPenaltiesAndViolations.requestId = dataRequestLogObj.RequestId; dPenaltiesAndViolations.externalReferenceId = dataRequestLogObj.ExternalReferenceId; dPenaltiesAndViolations.status = ((RequestStatus)dataRequestLogObj.RequestStatusTypeId).ToString();; dPenaltiesAndViolations.civilPenaltyAmount = null; dPenaltiesAndViolations.violationAmount = null; try { Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); using (WebDataEntities webDBEntities = new WebDataEntities()) { if (dataRequestLogObj.RequestStatusTypeId == (int)RequestStatus.Success) { //check if data available WebDataDB.DOBViolation dCivilPenaltiesObj = webDBEntities.DOBViolations.FirstOrDefault(i => i.BBL == parameters.BBL); if (dCivilPenaltiesObj != null && DateTime.UtcNow.Subtract(dCivilPenaltiesObj.LastUpdated).Days <= 30) { dPenaltiesAndViolations.civilPenaltyAmount = dCivilPenaltiesObj.DOBCivilPenalties; dPenaltiesAndViolations.violationAmount = dCivilPenaltiesObj.ECBViolationAmount; } else { dPenaltiesAndViolations.status = RequestStatus.Error.ToString(); } } } return(dPenaltiesAndViolations); } catch (Exception e) { Common.Logs.log().Error(string.Format("Exception encountered processing request log for {0} with externalRefId {1}{2}", dataRequestLogObj.BBL, dataRequestLogObj.ExternalReferenceId, Common.Logs.FormatException(e))); return(null); } }
/// <summary> /// This method gets the data or current status for a request /// </summary> /// <param name="dataRequestLogObj"></param> /// <returns></returns> public static WaterBillDetails ReRun(DataRequestLog dataRequestLogObj) { WaterBillDetails waterBill = new WaterBillDetails(); waterBill.BBL = dataRequestLogObj.BBL; waterBill.requestId = dataRequestLogObj.RequestId; waterBill.externalReferenceId = dataRequestLogObj.ExternalReferenceId; waterBill.status = ((RequestStatus)dataRequestLogObj.RequestStatusTypeId).ToString(); waterBill.billAmount = null; try { using (WebDataEntities webDBEntities = new WebDataEntities()) { if (dataRequestLogObj.RequestStatusTypeId == (int)RequestStatus.Success) { Parameters waterParams = JSONToParameters(dataRequestLogObj.RequestParameters); //check if data available WebDataDB.WaterBill waterBillObj = webDBEntities.WaterBills.FirstOrDefault(i => i.BBL == waterParams.BBL); if (waterBillObj != null && DateTime.UtcNow.Subtract(waterBillObj.LastUpdated).Days <= 30) { waterBill.billAmount = waterBillObj.BillAmount; } else { waterBill.status = RequestStatus.Error.ToString(); } } } return(waterBill); } catch (Exception e) { Common.Logs.log().Error(string.Format("Exception encountered precessing request log for {0} with externalRefId {1}{2}", dataRequestLogObj.BBL, dataRequestLogObj.ExternalReferenceId, Common.Logs.FormatException(e))); return(null); } }
/// <summary> /// This method gets the data or current status for a request /// </summary> /// <param name="dataRequestLogObj"></param> /// <returns></returns> public static FreddieMortgageDetails ReRun(DataRequestLog dataRequestLogObj) { FreddieMortgageDetails mDetails = new FreddieMortgageDetails(); mDetails.BBL = dataRequestLogObj.BBL; mDetails.requestId = dataRequestLogObj.RequestId; mDetails.externalReferenceId = dataRequestLogObj.ExternalReferenceId; mDetails.status = ((RequestStatus)dataRequestLogObj.RequestStatusTypeId).ToString(); try { using (WebDataEntities webDBEntities = new WebDataEntities()) { if (dataRequestLogObj.RequestStatusTypeId == (int)RequestStatus.Success) { Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if data available WebDataDB.FreddieMortgage mortgageObj = webDBEntities.FreddieMortgages.FirstOrDefault(i => i.BBL == parameters.BBL); if (mortgageObj != null && DateTime.UtcNow.Subtract(mortgageObj.LastUpdated).Days <= 30) { mDetails.isFreddieMortgage = mortgageObj.IsFreddie; } else { mDetails.status = RequestStatus.Error.ToString(); } } } return(mDetails); } catch (Exception e) { Common.Logs.log().Error(string.Format("Exception encountered processing request log for {0} with externalRefId {1}{2}", dataRequestLogObj.BBL, dataRequestLogObj.ExternalReferenceId, Common.Logs.FormatException(e))); return(null); } }
/// <summary> /// This method gets the data or current status for a request /// </summary> /// <param name="dataRequestLogObj"></param> /// <returns></returns> public static NoticeOfPropertyValueResult ReRun(DataRequestLog dataRequestLogObj) { NoticeOfPropertyValueResult resultObj = new NoticeOfPropertyValueResult(); resultObj.BBL = dataRequestLogObj.BBL; resultObj.requestId = dataRequestLogObj.RequestId; resultObj.externalReferenceId = dataRequestLogObj.ExternalReferenceId; resultObj.status = ((RequestStatus)dataRequestLogObj.RequestStatusTypeId).ToString(); try { using (WebDataEntities webDBEntities = new WebDataEntities()) { if (dataRequestLogObj.RequestStatusTypeId == (int)RequestStatus.Success) { Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if data available WebDataDB.NoticeOfProperyValue noticeOfPropetyValueObj = webDBEntities.NoticeOfProperyValues.FirstOrDefault(i => i.BBL == parameters.BBL); if (noticeOfPropetyValueObj != null && DateTime.UtcNow.Subtract(noticeOfPropetyValueObj.LastUpdated).Days <= 30) { resultObj.noticeOfPropertyValue = noticeOfPropetyValueObj; } else { resultObj.status = RequestStatus.Error.ToString(); } } } return(resultObj); } catch (Exception e) { Common.Logs.log().Error(string.Format("Exception encountered processing request log for {0} with externalRefId {1}{2}", dataRequestLogObj.BBL, dataRequestLogObj.ExternalReferenceId, Common.Logs.FormatException(e))); return(null); } }
/// <summary> /// This method gets the data or current status for a request /// </summary> /// <param name="dataRequestLogObj"></param> /// <returns></returns> public static ZillowPropertyDetails ReRun(DataRequestLog dataRequestLogObj) { ZillowPropertyDetails zPropertyDetails = new ZillowPropertyDetails(); zPropertyDetails.BBL = dataRequestLogObj.BBL; zPropertyDetails.requestId = dataRequestLogObj.RequestId; zPropertyDetails.externalReferenceId = dataRequestLogObj.ExternalReferenceId; zPropertyDetails.status = ((RequestStatus)dataRequestLogObj.RequestStatusTypeId).ToString();; zPropertyDetails.zEstimate = null; try { using (WebDataEntities webDBEntities = new WebDataEntities()) { if (dataRequestLogObj.RequestStatusTypeId == (int)RequestStatus.Success) { Parameters parameters = JSONToParameters(dataRequestLogObj.RequestParameters); //check if data available WebDataDB.Zillow zillowObj = webDBEntities.Zillows.FirstOrDefault(i => i.BBL == parameters.BBL); if (zillowObj != null && DateTime.UtcNow.Subtract(zillowObj.LastUpdated).Days <= 30) { zPropertyDetails.zEstimate = zillowObj.zEstimate; } else { zPropertyDetails.status = RequestStatus.Error.ToString(); } } } return(zPropertyDetails); } catch (Exception e) { Common.Logs.log().Error(string.Format("Exception encountered processing request log for {0} with externalRefId {1}{2}", dataRequestLogObj.BBL, dataRequestLogObj.ExternalReferenceId, Common.Logs.FormatException(e))); return(null); } }
/// <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 deals with all the details associated with either returning the Mortgage Servicer details or creating the /// request for getting it scrapped from the web /// </summary> public static FreddieMortgageDetails Get(Parameters inParameters, string externalReferenceId, int priority, string jobId) { FreddieMortgageDetails mDetails = new FreddieMortgageDetails(); mDetails.BBL = inParameters.BBL; mDetails.externalReferenceId = externalReferenceId; mDetails.status = RequestStatus.Pending.ToString(); string parameters = ParametersToJSON(inParameters); using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { try { //check if data available WebDataDB.FreddieMortgage mortgageObj = webDBEntities.FreddieMortgages.FirstOrDefault(i => i.BBL == inParameters.BBL); // record in database and data is not stale if (mortgageObj != null && DateTime.UtcNow.Subtract(mortgageObj.LastUpdated).Days <= 30) { mDetails.isFreddieMortgage = mortgageObj.IsFreddie; mDetails.status = RequestStatus.Success.ToString(); DAL.DataRequestLog.InsertForCacheAccess(webDBEntities, inParameters.BBL, RequestTypeId, externalReferenceId, jobId, parameters); } else { //check if pending request in queue DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetPendingRequest(webDBEntities, inParameters.BBL, RequestTypeId, parameters); if (dataRequestLogObj == null) //No Pending Request Create New Request { string requestStr = ""; //RequestData.XXXX(inParameters); Request requestObj = DAL.Request.Insert(webDBEntities, requestStr, RequestTypeId, priority, jobId); dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, inParameters.BBL, RequestTypeId, requestObj.RequestId, externalReferenceId, jobId, parameters); mDetails.status = RequestStatus.Pending.ToString(); mDetails.requestId = requestObj.RequestId; } else //Pending request in queue { mDetails.status = RequestStatus.Pending.ToString(); //Send the RequestId for the pending request back mDetails.requestId = dataRequestLogObj.RequestId; dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, inParameters.BBL, RequestTypeId, dataRequestLogObj.RequestId.GetValueOrDefault(), externalReferenceId, jobId, parameters); } } webDBEntitiestransaction.Commit(); } catch (Exception e) { webDBEntitiestransaction.Rollback(); mDetails.status = RequestStatus.Error.ToString(); DAL.DataRequestLog.InsertForFailure(inParameters.BBL, RequestTypeId, externalReferenceId, jobId, parameters); Common.Logs.log().Error(string.Format("Exception encountered processing {0} with externalRefId {1}{2}", inParameters.BBL, externalReferenceId, Common.Logs.FormatException(e))); } } } return(mDetails); }
/// <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 deals with all the details associated with either returning the water bill details or creating the /// request for getting is scrapped from the web /// </summary> public static WaterBillDetails Get(string propertyBBL, string externalReferenceId, int priority, string jobId) { WaterBillDetails waterBill = new WaterBillDetails(); waterBill.externalReferenceId = externalReferenceId; waterBill.status = RequestStatus.Pending.ToString(); waterBill.BBL = propertyBBL; waterBill.billAmount = null; using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { string parameters = ParametersToJSON(propertyBBL); try { //check if data available WebDataDB.WaterBill waterBillObj = webDBEntities.WaterBills.FirstOrDefault(i => i.BBL == propertyBBL); // record in database and data is not stale if (waterBillObj != null && DateTime.UtcNow.Subtract(waterBillObj.LastUpdated).Days <= 30) { waterBill.billAmount = waterBillObj.BillAmount; waterBill.status = RequestStatus.Success.ToString(); DAL.DataRequestLog.InsertForCacheAccess(webDBEntities, propertyBBL, RequestTypeId, externalReferenceId, jobId, parameters); } else { //check if pending request in queue DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetPendingRequest(webDBEntities, propertyBBL, RequestTypeId, parameters); if (dataRequestLogObj == null) //No Pending Request Create New Request { string requestStr = RequestData.WaterBill(propertyBBL); Request requestObj = DAL.Request.Insert(webDBEntities, requestStr, RequestTypeId, priority, jobId); dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, requestObj.RequestId, externalReferenceId, jobId, parameters); waterBill.status = RequestStatus.Pending.ToString(); waterBill.requestId = requestObj.RequestId; } else //Pending request in queue { waterBill.status = RequestStatus.Pending.ToString(); //Send the RequestId for the pending request back waterBill.requestId = dataRequestLogObj.RequestId; dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, dataRequestLogObj.RequestId.GetValueOrDefault(), externalReferenceId, jobId, parameters); } } webDBEntitiestransaction.Commit(); } catch (Exception e) { webDBEntitiestransaction.Rollback(); waterBill.status = RequestStatus.Error.ToString(); DAL.DataRequestLog.InsertForFailure(propertyBBL, RequestTypeId, externalReferenceId, jobId, parameters); Common.Logs.log().Error(string.Format("Exception encountered processing {0} with externalRefId {1}: {2}", propertyBBL, externalReferenceId, Common.Logs.FormatException(e))); } } } return(waterBill); }
/// <summary> /// This method deals with all the details associated with either returning the details in the Mortgage Document or creating the /// request for getting the data from the web /// </summary> /// <param name="propertyBBL"></param> /// <param name="externalReferenceId"></param> /// <param name="documentURI"></param> /// <param name="jobId"></param> /// <param name="priority"></param> /// <returns></returns> public static MortgageDocumentResult GetDetails(string propertyBBL, string documentURI, string externalReferenceId, int priority, string jobId) { MortgageDocumentResult mortgageDocumentResultObj = new MortgageDocumentResult(); mortgageDocumentResultObj.BBL = propertyBBL; mortgageDocumentResultObj.mortgageDocumentURI = documentURI; mortgageDocumentResultObj.externalReferenceId = externalReferenceId; mortgageDocumentResultObj.status = RequestStatus.Pending.ToString(); string jsonBillParams = ParametersToJSON(propertyBBL, documentURI); using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { try { //check if data available var mortgageDocumentObj = webDBEntities.Mortgages.FirstOrDefault(i => i.BBL == propertyBBL && i.MortgageDocumentURI == documentURI); // record in database and data is not stale if (mortgageDocumentObj != null && DateTime.UtcNow.Subtract(mortgageDocumentObj.LastUpdated).Days <= 30) { mortgageDocumentResultObj.mortgageDetails = mortgageDocumentObj; mortgageDocumentResultObj.status = RequestStatus.Success.ToString(); DAL.DataRequestLog.InsertForCacheAccess(webDBEntities, propertyBBL, RequestTypeId, externalReferenceId, jobId, jsonBillParams); } else { //check if pending request in queue DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetPendingRequest(webDBEntities, propertyBBL, RequestTypeId, jsonBillParams); if (dataRequestLogObj == null) //No Pending Request Create New Request { string requestStr = RequestResponseBuilder.RequestObjects.RequestData.CreateRequestDataForMortgage(documentURI); Request requestObj = DAL.Request.Insert(webDBEntities, requestStr, RequestTypeId, priority, jobId); dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, requestObj.RequestId, externalReferenceId, jobId, jsonBillParams); mortgageDocumentResultObj.status = RequestStatus.Pending.ToString(); mortgageDocumentResultObj.requestId = requestObj.RequestId; } else //Pending request in queue { mortgageDocumentResultObj.status = RequestStatus.Pending.ToString(); //Send the RequestId for the pending request back mortgageDocumentResultObj.requestId = dataRequestLogObj.RequestId; dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, dataRequestLogObj.RequestId.GetValueOrDefault(), externalReferenceId, jobId, jsonBillParams); } } webDBEntitiestransaction.Commit(); } catch (Exception e) { webDBEntitiestransaction.Rollback(); mortgageDocumentResultObj.status = RequestStatus.Error.ToString(); DAL.DataRequestLog.InsertForFailure(propertyBBL, RequestTypeId, externalReferenceId, jobId, jsonBillParams); Common.Logs.log().Error(string.Format("Exception encountered processing {0} with externalRefId {1}{2}", propertyBBL, externalReferenceId, Common.Logs.FormatException(e))); } } } return(mortgageDocumentResultObj); }
/// <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 deals with all the details associated with either returning the Zillow details or creating the /// request for getting it scrapped from the web /// </summary> public static ZillowPropertyDetails Get(string propertyBBL, string address, string externalReferenceId, int priority, string jobId) { ZillowPropertyDetails zPropertyDetails = new ZillowPropertyDetails(); zPropertyDetails.BBL = propertyBBL; zPropertyDetails.externalReferenceId = externalReferenceId; zPropertyDetails.status = RequestStatus.Pending.ToString(); zPropertyDetails.zEstimate = null; string parameters = ParametersToJSON(propertyBBL, address); using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { try { string jsonBillParams = ParametersToJSON(propertyBBL, address); //check if data available WebDataDB.Zillow zillowObj = webDBEntities.Zillows.FirstOrDefault(i => i.BBL == propertyBBL); // record in database and data is not stale if (zillowObj != null && DateTime.UtcNow.Subtract(zillowObj.LastUpdated).Days <= 30) { zPropertyDetails.zEstimate = zillowObj.zEstimate; zPropertyDetails.status = RequestStatus.Success.ToString(); DAL.DataRequestLog.InsertForCacheAccess(webDBEntities, propertyBBL, RequestTypeId, externalReferenceId, jobId, jsonBillParams); } else { //check if pending request in queue DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetPendingRequest(webDBEntities, propertyBBL, RequestTypeId, jsonBillParams); if (dataRequestLogObj == null) //No Pending Request Create New Request { string requestStr = RequestResponseBuilder.RequestObjects.RequestData.ZillowZEstimate(address); Request requestObj = DAL.Request.Insert(webDBEntities, requestStr, RequestTypeId, priority, jobId); dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, requestObj.RequestId, externalReferenceId, jobId, jsonBillParams); zPropertyDetails.status = RequestStatus.Pending.ToString(); zPropertyDetails.requestId = requestObj.RequestId; } else //Pending request in queue { zPropertyDetails.status = RequestStatus.Pending.ToString(); //Send the RequestId for the pending request back zPropertyDetails.requestId = dataRequestLogObj.RequestId; dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, dataRequestLogObj.RequestId.GetValueOrDefault(), externalReferenceId, jobId, jsonBillParams); } } webDBEntitiestransaction.Commit(); } catch (Exception e) { webDBEntitiestransaction.Rollback(); zPropertyDetails.status = RequestStatus.Error.ToString(); DAL.DataRequestLog.InsertForFailure(propertyBBL, RequestTypeId, externalReferenceId, jobId, parameters); Common.Logs.log().Error(string.Format("Exception encountered processing {0} with externalRefId {1}{2}", propertyBBL, externalReferenceId, Common.Logs.FormatException(e))); } } } return(zPropertyDetails); }
/// <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); } } } }
/// <summary> /// This method deals with all the details associated with either returning the DOB Penalties and Violations details or creating the /// request for getting it scrapped from the web /// </summary> public static DOBPenaltiesAndViolationsSummaryData Get(string propertyBBL, string externalReferenceId, int priority, string jobId) { DOBPenaltiesAndViolationsSummaryData dPenaltiesAndViolations = new DOBPenaltiesAndViolationsSummaryData(); dPenaltiesAndViolations.BBL = propertyBBL; dPenaltiesAndViolations.externalReferenceId = externalReferenceId; dPenaltiesAndViolations.status = RequestStatus.Pending.ToString(); dPenaltiesAndViolations.civilPenaltyAmount = null; dPenaltiesAndViolations.violationAmount = null; string parameters = ParametersToJSON(propertyBBL); using (WebDataEntities webDBEntities = new WebDataEntities()) { using (var webDBEntitiestransaction = webDBEntities.Database.BeginTransaction()) { try { //check if data available WebDataDB.DOBViolation dobViolationObj = webDBEntities.DOBViolations.FirstOrDefault(i => i.BBL == propertyBBL); // record in database and data is not stale if (dobViolationObj != null && DateTime.UtcNow.Subtract(dobViolationObj.LastUpdated).Days <= 15) { dPenaltiesAndViolations.civilPenaltyAmount = dobViolationObj.DOBCivilPenalties; dPenaltiesAndViolations.violationAmount = dobViolationObj.ECBViolationAmount; dPenaltiesAndViolations.status = RequestStatus.Success.ToString(); DAL.DataRequestLog.InsertForCacheAccess(webDBEntities, propertyBBL, RequestTypeId, externalReferenceId, jobId, parameters); } else { //check if pending request in queue DataRequestLog dataRequestLogObj = DAL.DataRequestLog.GetPendingRequest(webDBEntities, propertyBBL, RequestTypeId, parameters); if (dataRequestLogObj == null) //No Pending Request Create New Request { string requestStr = RequestResponseBuilder.RequestObjects.RequestData.ECBviolationAndDOBCivilPenalties(propertyBBL); Request requestObj = DAL.Request.Insert(webDBEntities, requestStr, RequestTypeId, priority, jobId); dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, requestObj.RequestId, externalReferenceId, jobId, parameters); dPenaltiesAndViolations.status = RequestStatus.Pending.ToString(); dPenaltiesAndViolations.requestId = requestObj.RequestId; } else //Pending request in queue { dPenaltiesAndViolations.status = RequestStatus.Pending.ToString(); //Send the RequestId for the pending request back dPenaltiesAndViolations.requestId = dataRequestLogObj.RequestId; dataRequestLogObj = DAL.DataRequestLog.InsertForWebDataRequest(webDBEntities, propertyBBL, RequestTypeId, dataRequestLogObj.RequestId.GetValueOrDefault(), externalReferenceId, jobId, parameters); } } webDBEntitiestransaction.Commit(); } catch (Exception e) { webDBEntitiestransaction.Rollback(); dPenaltiesAndViolations.status = RequestStatus.Error.ToString(); DAL.DataRequestLog.InsertForFailure(propertyBBL, RequestTypeId, externalReferenceId, jobId, parameters); Common.Logs.log().Error(string.Format("Exception encountered processing {0} with externalRefId {1}{2}", propertyBBL, externalReferenceId, Common.Logs.FormatException(e))); } } } return(dPenaltiesAndViolations); }