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();
}
//Main functional part
public ActionResult CompareProduct(int[] IdList)
{
IdList = (int[])TempData["testList"];
CompareList list = new CompareList();
List <ProductModel> productModels = new List <ProductModel>();
foreach (int id in IdList)
{
ProductModel item = GetModelByID(id);
productModels.Add(item);
}
list.ProductModels = productModels;
//ViewBag.Message = product;
return(View("CompareTest", list));
}
public ActionResult AddToCompareList(int productid, int size = 0, string attributes = "")
{
var currentUserId = Convert.ToInt32(GlobalUser.getGlobalUser().UserId);
var productSize = _productSizeBusiness.GetListWT(c => c.ProductId == productid).FirstOrDefault();
var defaultSize = productSize == null ? 0 : productSize.Id;
if (size == 0)
{
size = defaultSize;
}
if (currentUserId > 0)
{
var count = _CompareListBusiness.GetListWT(c => c.UserId == currentUserId && c.ProductId == productid).Count();
if (count <= 0)
{
CompareList compareList = new CompareList();
compareList.ProductId = productid;
compareList.UserId = currentUserId;
_CompareListBusiness.Insert(compareList);
_unitOfWork.SaveChanges();
}
}
else
{
CookieStore mycookie = new CookieStore();
var products = mycookie.GetCookie(Enumerator.CustomerAction.CompareList.ToString());
var value = string.Empty;
if (string.IsNullOrEmpty(products))
{
value = productid.ToString() + "~" + size.ToString() + "~" + attributes.ToString();
}
else
{
if (!products.Split(',').Select(c => c.Split('~')[0]).Contains(productid.ToString()))
{
value = products + "," + productid.ToString() + "~" + size.ToString() + "~" + attributes.ToString();
}
}
var expireCookieTimeHr = Convert.ToInt32(ReadConfigData.GetAppSettingsValue("ExpireCookieTimeHr"));
mycookie.SetCookie(Enumerator.CustomerAction.CompareList.ToString(), value, expireCookieTimeHr);
}
return(new EmptyResult());
}
public void Delete(CompareList CompareList)
{
_CompareListRepository.Delete(CompareList);
}
public CompareList Update(CompareList CompareList)
{
_CompareListRepository.Update(CompareList);
return(CompareList);
}
public CompareList Insert(CompareList CompareList)
{
_CompareListRepository.Insert(CompareList);
return(CompareList);
}
