public int SaveValidationLead(ValidationLead validation) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Validation tValidation = new T_Validation(); tValidation.LeadID = (int)validation.Lead.LeadID; tValidation.Login = validation.User.Login; tValidation.vldDate = DateTime.Now; dc.T_Validations.InsertOnSubmit(tValidation); dc.SubmitChanges(); List<ValidationResult> results = validation.Results; int ofac = 0; int exList = 0; int addVal = 0; int noInfoStatus = dc.T_ValidationStatus .Where(s => s.vsDescription == ValidationConstants.StatusNoInformation) .Select(f => f.StatusID).First(); foreach (var result in results) { switch (result.Type.Type) { case ValidationConstants.OFAC: ofac = SaveOFAC(tValidation.ValidationID, validation.Lead, result.Status.Status); break; case ValidationConstants.FreddieList: exList = SaveExcList(tValidation.ValidationID, validation.Lead, result.Status.Status); break; case ValidationConstants.Address: addVal = SaveAddrValidation(tValidation.ValidationID, validation.Lead, result.Status.Status); break; default: break; } } var tLead = dc.T_Leads.Where(l => l.LeadID == (int)validation.Lead.LeadID).First(); tLead.ldOFAC = ofac; tLead.ldAddrVal = addVal; tLead.ldExlList = exList; dc.SubmitChanges(); return tValidation.ValidationID; } }
public ValidationFail GetValidationsResultsByValidationID(int validationID) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ValidationFail tFail; T_ValidationResult tResults; T_Validation tValidation = new T_Validation(); ValidationFail result = new ValidationFail(); tResults = dc.T_ValidationResults .Where(r => r.ValidationID == validationID && r.T_ValidationType.vtDescription == ValidationConstants.OFAC) .FirstOrDefault(); if (tResults == null) return null; tFail = dc.T_ValidationFails.Where(f => f.FailID == tResults.FailID).FirstOrDefault(); if (tFail == null) return null; var table = GetValidationFailEntity(tFail); return table; //tResults = dc.T_ValidationResults.Where(r => r.ValidationID == validationID && r.FailID == r.T_ValidationFail.FailID).First(); //tFail = dc.T_ValidationFails.Where(f => f.FailID == tResults.FailID).First(); //var table = GetValidationFailEntity(tFail); } }
private void detach_T_Validations(T_Validation entity) { this.SendPropertyChanging(); entity.T_UserInformation = null; }
private void detach_T_Validations(T_Validation entity) { this.SendPropertyChanging(); entity.T_Lead = null; }
partial void DeleteT_Validation(T_Validation instance);
partial void UpdateT_Validation(T_Validation instance);
partial void InsertT_Validation(T_Validation instance);