/// <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);
}
}
}
}
