private void SaveIndividualsToDB(string fileName)
{
string connectionString = string.Format(_excelConStr, fileName);
using (var adapter = new OleDbDataAdapter("SELECT * FROM [INDIVIDUALS$]", connectionString))
{
using (var ds = new DataSet())
{
adapter.Fill(ds, "AnyName");
var data = ds.Tables["AnyName"].AsEnumerable();
var query = data.Where(x => x.Field<string>("Last Name") != string.Empty).AsQueryable();
List<Individual> individuals = new List<Individual>();
foreach (var item in query)
{
Individual individual = new Individual();
individual.AddressLine1 = item["Address Line 1"].ToString();
individual.AddressLine2 = item["Address Line 2"].ToString();
individual.AddressLine3 = item["Address Line 3"].ToString();
individual.Aka = item["aka/dba"].ToString();
individual.City = item["City"].ToString();
individual.Comments = item["Comments"].ToString();
individual.FirstName = item["First Name"].ToString();
individual.IssuingState = item["Issuing State"].ToString();
individual.LastName = item["Last Name"].ToString();
individual.LicenseNumber = item["License Number"].ToString();
individual.LicenseType = item["License Type"].ToString();
individual.State = item["State"].ToString();
individual.Zip = item["Zip"].ToString();
individuals.Add(individual);
}
CCTValidationProvider validationProvider = new CCTValidationProvider();
validationProvider.SaveExcludedIndividuals(individuals);
}
}
}
public List<Individual> GetExcludedIndividuals(int? id)
{
using (var dc = new EngageCCTDataClassesDataContext())
{
var query = dc.T_ExcListIndividuals.AsQueryable();
if (id.HasValue)
{
query = query.Where(i => i.ExcListIndividualID == id);
}
List<Individual> result = new List<Individual>();
foreach (var tIndividual in query.ToArray())
{
Individual individual = new Individual();
individual.ID = tIndividual.ExcListIndividualID;
individual.AddressLine1 = tIndividual.eliAddressLine1;
individual.AddressLine2 = tIndividual.eliAddressLine2;
individual.AddressLine3 = tIndividual.eliAddressLine3;
individual.Aka = tIndividual.eliAkaDba;
individual.City = tIndividual.eliCity;
individual.Comments = tIndividual.eliComments;
individual.FirstName = tIndividual.eliFirstName;
individual.IssuingState = tIndividual.eliIssuingState;
individual.LastName = tIndividual.eliLastName;
individual.LicenseNumber = tIndividual.eliLicenseNumber;
individual.LicenseType = tIndividual.eliLicenseType;
individual.State = tIndividual.eliState;
individual.Zip = tIndividual.eliZip;
result.Add(individual);
}
return result;
}
}