private ValidationFail GetValidationFailEntity(T_ValidationFail tFail) { ValidationFail fail = new ValidationFail(); fail.ID = tFail.FailID; fail.PLC = tFail.vfPLC; fail.SDN = tFail.vfSDN; return fail; }
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; } }
private ExcListValidation GetExcListValidationEntity(T_ValidationFail tExc) { ExcListValidation excValidation = new ExcListValidation(); excValidation.ID = tExc.FailID; excValidation.Result = tExc.vfExcList; return excValidation; }
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 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; } }
partial void DeleteT_ValidationFail(T_ValidationFail instance);
partial void UpdateT_ValidationFail(T_ValidationFail instance);
partial void InsertT_ValidationFail(T_ValidationFail instance);