public int SaveExcList(int validationID, Lead lead, string status)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
//int statusPassed = dc.T_ValidationStatus
// .Where(s => s.vsDescription == ValidationConstants.StatusPassed)
// .Select(st => st.StatusID)
// .First();
//int statusFailed = dc.T_ValidationStatus
// .Where(s => s.vsDescription == ValidationConstants.StatusFailed)
// .Select(st => st.StatusID)
// .First();
//int statusNoInfo = dc.T_ValidationStatus
// .Where(s => s.vsDescription == ValidationConstants.StatusNoInformation)
// .Select(st => st.StatusID)
// .First();
int exRes = 0;
T_ValidationResult tResult = new T_ValidationResult();
T_ValidationFail tExcListValidation = new T_ValidationFail();
LeadValidationManager tLeadVM = new LeadValidationManager();
tResult.ValidationID = validationID;
tResult.TypeID = dc.T_ValidationTypes
.Where(t => t.vtDescription == ValidationConstants.FreddieList)
.Select(tp => tp.TypeID)
.First();
if (status != ValidationConstants.StatusNoInformation)
{
var validResult = LeadValidationManager.SearchInExclusionaryList(lead);
if (validResult != null)
{
exRes = (int)StatusValidation.Failed;
tExcListValidation.vfExcList = tLeadVM.GetXmlExcListEntry(validResult);
dc.T_ValidationFails.InsertOnSubmit(tExcListValidation);
dc.SubmitChanges();
tResult.StatusID = (int)StatusValidation.Failed;
tResult.FailID = tExcListValidation.FailID;
//---------------
}
else
{
exRes = (int)StatusValidation.Passed;
tResult.StatusID = (int)StatusValidation.Passed;
tResult.FailID = null;
}
}
else
{
exRes = (int)StatusValidation.NoInformation;
tResult.StatusID = (int)StatusValidation.NoInformation;
tResult.FailID = null;
}
dc.T_ValidationResults.InsertOnSubmit(tResult);
dc.SubmitChanges();
return exRes;
}
}
public ExcListValidation GetExcListResultsByValidationID(int validationID)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
T_ValidationFail tExcList = new T_ValidationFail();
T_ValidationResult tResult = new T_ValidationResult();
//int excType = dc.T_ValidationTypes
// .Where(t => t.vtDescription == ValidationConstants.FreddieList)
// .Select(i => i.TypeID)
// .First();
int excType = (int)TypeValidation.ExclusionaryList;
var res = dc.T_ValidationResults
.Where(r => r.ValidationID == validationID && r.TypeID == excType)
.FirstOrDefault();
if (res == null)
return null;
tExcList = dc.T_ValidationFails.Where(l => l.FailID == res.FailID).FirstOrDefault();
if (tExcList == null)
return null;
var table = GetExcListValidationEntity(tExcList);
return table;
}
}
public int SaveOFAC(int validationID, Lead lead, string status)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
//int statusPassed = dc.T_ValidationStatus
// .Where(s => s.vsDescription == ValidationConstants.StatusPassed)
// .Select(st => st.StatusID)
// .First();
//int statusFailed = dc.T_ValidationStatus
// .Where(s => s.vsDescription == ValidationConstants.StatusFailed)
// .Select(st => st.StatusID)
// .First();
//int statusNoInfo = dc.T_ValidationStatus
// .Where(s => s.vsDescription == ValidationConstants.StatusNoInformation)
// .Select(st => st.StatusID)
// .First();
T_ValidationResult tResult = new T_ValidationResult();
LeadValidationManager tLeadVM = new LeadValidationManager();
T_ValidationFail tFail = new T_ValidationFail();
//T_Lead tLead = new T_Lead();
tResult.ValidationID = validationID;
tResult.TypeID = dc.T_ValidationTypes
.Where(t => t.vtDescription == ValidationConstants.OFAC).Select(tp => tp.TypeID).First();
int validStat = 0;
if (status != ValidationConstants.StatusNoInformation)
{
var resultSearchInPLC = LeadValidationManager.SearchInPLC(lead);
var resultSearchInSDN = LeadValidationManager.SearchInSDN(lead);
if (resultSearchInPLC == null && resultSearchInSDN == null)
{
validStat = (int)StatusValidation.Passed;
tResult.FailID = null;
}
else
{
if (resultSearchInPLC != null)
{
tFail.vfPLC = tLeadVM.GetXmlPLC(resultSearchInPLC);
}
if (resultSearchInSDN != null)
{
tFail.vfSDN = tLeadVM.GetXmlSDN(resultSearchInSDN);
}
dc.T_ValidationFails.InsertOnSubmit(tFail);
dc.SubmitChanges();
tResult.FailID = tFail.FailID;
validStat = (int)StatusValidation.Failed;
}
}
else
{
validStat = (int)StatusValidation.NoInformation;
tResult.FailID = null;
}
// if (resultSearchInPLC != null || resultSearchInSDN != null)
// {
// if (resultSearchInPLC != null)
// {
// tFail.vfPLC = tLeadVM.GetXmlPLC(resultSearchInPLC);
// }
// if (resultSearchInSDN != null)
// {
// tFail.vfSDN = tLeadVM.GetXmlSDN(resultSearchInSDN);
// }
// dc.T_ValidationFails.InsertOnSubmit(tFail);
// dc.SubmitChanges();
// tResult.FailID = tFail.FailID;
// }
// if (resultSearchInPLC == null && resultSearchInSDN == null)
// {
// validStat = (int)StatusValidation.Passed;
// tResult.FailID = null;
// //
// }
// else
// {
// validStat = (int)StatusValidation.Failed;
// }
//}
//else
//{
// validStat = (int)StatusValidation.NoInformation;
// tResult.FailID = null;
//}
tResult.StatusID = validStat;
dc.T_ValidationResults.InsertOnSubmit(tResult);
dc.SubmitChanges();
return validStat;
}
}
public int SaveAddrValidation(int validationID, Lead lead, string status)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
int addrValStatus = 0;
int addressID;
T_ValidationResult tResult = new T_ValidationResult();
T_ValidationAddress tAddress = new T_ValidationAddress();
T_ValidationAddressError tError = new T_ValidationAddressError();
tResult.ValidationID = validationID;
tResult.TypeID = (int)TypeValidation.AddressValidation;
if (status != ValidationConstants.StatusNoInformation)
{
var validAddress = LeadValidationManager.GetValidAddress(lead.SubjectPropertyAddress);
if (validAddress.Error != null)
{
int errorID;
ValidationAddressError error = new ValidationAddressError();
error.Description = validAddress.Error.Description;
error.Location = validAddress.Error.Location;
error.Number = validAddress.Error.Number;
errorID = SaveValidationAddressError(error);
addrValStatus = (int)StatusValidation.Failed;
tAddress.ErrorID = errorID;
}
else
{
// SaveValidationAddress(validAddress);
bool isCorrect = LeadValidationManager.CompareAddresses(lead.SubjectPropertyAddress, validAddress);
if (isCorrect)
{
addrValStatus = (int)StatusValidation.Passed;
}
else
{
addrValStatus = (int)StatusValidation.Error;
}
}
addressID = SaveValidationAddress(validAddress);
tResult.AddressID = addressID;
tResult.StatusID = addrValStatus;
}
else
{
addrValStatus = (int)StatusValidation.NoInformation;
tResult.StatusID = addrValStatus;
}
dc.T_ValidationResults.InsertOnSubmit(tResult);
dc.SubmitChanges();
return addrValStatus;
}
}
public bool ChangeStatus(int validationID, int typeID, int status)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
T_ValidationResult tResult = new T_ValidationResult();
tResult = dc.T_ValidationResults.Where(r => r.ValidationID == validationID && r.TypeID == typeID).SingleOrDefault();
if (tResult != null)
{
var tLead = dc.T_Validations.Where(w => w.ValidationID == validationID).Select(s => s.T_Lead).FirstOrDefault();
if (tLead != null)
{
tLead.ldAddrVal = status;
}
tResult.StatusID = status;
dc.SubmitChanges();
return true;
}
return false;
}
}
//public List<Validation> GetValidationInfo()
//{
// using (var dc = new EngageCCTDataClassesDataContext())
// {
// var list = new List<Validation>();
// var tValidation = dc.T_Validations.AsQueryable();
// foreach (var item in tValidation)
// {
// Validation validation = new Validation();
// List<ValidationType> types = new List<ValidationType>();
// List<ValidationStatus> statuses = new List<ValidationStatus>();
// CCTValidationProvider validationProvider = new CCTValidationProvider();
// CCTLeadProvider leadProvider = new CCTLeadProvider();
// validation.ValidationID = item.ValidationID;
// var tValidationResult = dc.T_ValidationResults.Where(v => v.ValidationID == item.ValidationID);
// foreach (var valResult in tValidationResult)
// {
// types.Add(validationProvider.GetValidationType(valResult.T_ValidationType));
// statuses.Add(validationProvider.GetValidationStatus(valResult.T_ValidationStatus));
// }
// validation.Statuses = statuses;
// validation.Types = types;
// validation.Lead = leadProvider.GetLeadEntity(item.T_Lead);
// validation.User = leadProvider.GetUserInformationEntity(item.T_UserInformation);
// validation.ValidationError = null;
// list.Add(validation);
// }
// return list;
// }
//}
internal ValidationResult GetValidationResultEntity(T_ValidationResult tResult)
{
ValidationResult vr = new ValidationResult();
vr.Status = GetValidationStatusEntity(tResult.T_ValidationStatus);
vr.Type = GetValidationTypeEntity(tResult.T_ValidationType);
if (tResult.FailID.HasValue)
{
vr.FailID = (int)tResult.FailID;
}
return vr;
}
private void detach_T_ValidationResults(T_ValidationResult entity)
{
this.SendPropertyChanging();
entity.T_ValidationType = null;
}
private void attach_T_ValidationResults(T_ValidationResult entity)
{
this.SendPropertyChanging();
entity.T_ValidationFail = this;
}
partial void DeleteT_ValidationResult(T_ValidationResult instance);
partial void UpdateT_ValidationResult(T_ValidationResult instance);
partial void InsertT_ValidationResult(T_ValidationResult instance);
