private void btnBrowse_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.DefaultExt = ".accdb";
fileDialog.Filter = "Microsoft Access Database (.accdb) | *.accdb*";
if (fileDialog.ShowDialog() == true)
{
txtFileName.Text = fileDialog.FileName;
fileName = txtFileName.Text.ToString();
EnvironmentConfig.DataSourceValue = Convert.ToString(fileName.Trim());
DataSet dd = AccessDbLoader.LoadFromFile();
var lll = (from lead in dd.Tables["[tbl_Lead]"].AsEnumerable()
join member in dd.Tables["[tbl_Member]"].AsEnumerable()
on lead.Field <int>("ID") equals member.Field <int>("LeadId")
select new
{
AadhaarNumber = member.Field <string>("AadharNumber"),
Name = member.Field <string>("Member_Name"),
Village = lead.Field <string>("Village"),
Mandal = lead.Field <string>("Mandal"),
BranchName = lead.Field <string>("BranchName")
}).ToList();
grdView.ItemsSource = lll;
}
}
static void Main(string[] args)
{
ExportAccessTabletoExcel.ExportQuery(@"C:\Projects\CHIA\Cerner\Cerner_Multum_en-US_249_180601.accdb", "drc_gestational_age_non_continuous_infusion", @"C:\Projects\CHIA\drc_gestational_age_non_continuous_infusion.xlsx");
ReadExcelFileReturnList GetGetExcel = new ReadExcelFileReturnList();
GetGetExcel.getExcelFile(@"C:\Projects\CHIA\drc_gestational_age_non_continuous_infusion.xlsx", 1);
//List<string> ExcelList = new List<string>();
//ReadExcelFile GetExcel = new ReadExcelFile(@"C:\Projects\CHIA\Copyof20180513_drc_age2_updates_US_CA_v249.xlsx");
ReadExcelFile GetExcel = new ReadExcelFile();
//ReadExcelFile GetExcel = new ReadExcelFile();
//GetExcel.ExcelList = ReadExcelFile.getExcelFile();
List <string> ExcelList = GetExcel.getExcelFile(@"C:\Projects\CHIA\Copyof20180513_drc_age2_updates_US_CA_v251.xlsx", 3); //Pass in Excel path and string
//List<string> ExcelList2 = GetExcel2.getExcelFile(@"C:\Projects\CHIA\Copyof20180513_drc_age2_updates_US_CA_v251.xlsx", 3);
List <string> ExcelList2 = GetExcel.getExcelFile(@"C:\Projects\CHIA\drc_gestational_age_non_continuous_infusion.xlsx", 1);
CompareList CompareTwoExcelLists = new CompareList();
//List<string> ReturnLists = CompareTwoLists.Contains(ExcelList, DataList);
IEnumerable <string> ReturnDiffLists = CompareTwoExcelLists.Contains(ExcelList, ExcelList2);
PrintToFile.Print(ExcelList);
PrintToFile.Print(ExcelList2);
PrintToFile.Print(ReturnDiffLists);
//ConsoleWriteLineList.DumpExcelSet(ExcelList);
// Load an Access ACCDB file
DataSet ds1 = AccessDbLoader.LoadFromFile(@"C:\Projects\CHIA\Cerner\Cerner_Multum_en-US_249_180601.accdb");
//DataSet ds1 = AccessDbLoader.LoadFromFile(@"C:\Projects\CHIA\Cerner\Cerner_Multum_en-CA_249_180601.accdb");
//DataSet ds1 = AccessDbLoader.LoadFromFile(@"C:\Projects\CHIA\Lexi\Cerner_LexiComp_en-US_249_180601.accdb");
List <string> DataList = DataSetToList.DumpDataSet(ds1);
//DumpDataSetToConsole.DumpDataSet(ds1);
//var firstNotSecond = ExcelList.Except(DataList).ToList();
//var secondNotFirst = DataList.Except(ExcelList).ToList();
CompareList CompareTwoLists = new CompareList();
//List<string> ReturnLists = CompareTwoLists.Contains(ExcelList, DataList);
IEnumerable <string> ReturnLists = CompareTwoLists.Contains(ExcelList, DataList);
PrintToFile.Print(ExcelList);
PrintToFile.Print(DataList);
PrintToFile.Print(ReturnLists);
//ConsoleWriteLineList.DumpExcelSet(ReturnLists);
Console.ReadLine();
}
