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