//------------------------------
public List<ExclusionaryListEntry> GetExcListValidationDetails(int validationID)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
var list = new List<ExclusionaryListEntry>();
LeadValidationManager manager = new LeadValidationManager();
var exList = manager.GetExcListEntryByXML(validationID);
if (exList == null)
return list;
foreach (var item in exList)
{
list.Add(item);
}
return list;
}
}
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 List<ValidationResultSDNPLC> GetOFACValidationDetails(int validationID)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
var list = new List<ValidationResultSDNPLC>();
LeadValidationManager manager = new LeadValidationManager();
var plcBase = manager.GetPLCEntityByXML(validationID);
if (plcBase != null)
{
foreach (var entity in plcBase)
list.Add(new ValidationResultSDNPLC(entity));
}
var sdnBase = manager.GetSDNEntityByXML(validationID);
if (sdnBase != null)
{
foreach (var entity in sdnBase)
list.Add(new ValidationResultSDNPLC(entity));
}
return list;
}
}
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;
}
}
