public int SaveValidationAddress(ValidationAddress address)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
T_ValidationAddressError tError = new T_ValidationAddressError();
if (address.Error != null)
{
tError.erDesc = address.Error.Description;
tError.erLocation = address.Error.Location;
tError.erNumber = address.Error.Number;
dc.T_ValidationAddressErrors.InsertOnSubmit(tError);
dc.SubmitChanges();
}
T_ValidationAddress tAddress = new T_ValidationAddress();
if (!string.IsNullOrEmpty(address.Address))
{
tAddress.vadAddress = address.Address;
}
if (!string.IsNullOrEmpty(address.City))
{
tAddress.vadCity = address.City;
}
if (!string.IsNullOrEmpty(address.Country))
{
tAddress.vadCountry = address.Country;
}
if (!string.IsNullOrEmpty(address.State))
{
tAddress.vadState = address.State;
}
if (!string.IsNullOrEmpty(address.ZipCode))
{
tAddress.vadZipCode = address.ZipCode;
}
if (address.Error != null)
{
tAddress.ErrorID = tError.ErrorID;
}
dc.T_ValidationAddresses.InsertOnSubmit(tAddress);
dc.SubmitChanges();
return tAddress.AddressID;
}
}
public int SaveValidationAddressError(ValidationAddressError error)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
T_ValidationAddressError tError = new T_ValidationAddressError();
tError.erDesc = error.Description;
tError.erLocation = error.Location;
tError.erNumber = error.Number;
dc.T_ValidationAddressErrors.InsertOnSubmit(tError);
dc.SubmitChanges();
return tError.ErrorID;
}
}
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;
}
}
private ValidationAddressError GetValidationAddressErrorEntity(T_ValidationAddressError tError)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
ValidationAddressError vaError = new ValidationAddressError();
vaError.ErrorID = tError.ErrorID;
vaError.Description = tError.erDesc;
vaError.Location = tError.erLocation;
vaError.Number = (int)tError.erNumber;
return vaError;
}
}
partial void DeleteT_ValidationAddressError(T_ValidationAddressError instance);
partial void InsertT_ValidationAddressError(T_ValidationAddressError instance);