private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
RodoDbContext db = new RodoDbContext();
var q = db.Logi.ToList();
var s = JsonConvert.SerializeObject(q);
try
{
if (home.CzyStop(ref aktywny))
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show(ex.Source);
MessageBox.Show(ex.HelpLink);
}
Application.SheetSelectionChange += new Excel.AppEvents_SheetSelectionChangeEventHandler(OnSelection);
Application.SheetChange += new Excel.AppEvents_SheetChangeEventHandler(OnChange);
Application.SheetActivate += new Excel.AppEvents_SheetActivateEventHandler(OnSheetActivate);
Application.WorkbookBeforeClose += new Excel.AppEvents_WorkbookBeforeCloseEventHandler(BeforeCloese);
Application.WorkbookOpen += new Excel.AppEvents_WorkbookOpenEventHandler(OnOpen);
Application.WorkbookAfterSave += new Excel.AppEvents_WorkbookAfterSaveEventHandler(AfterSave);
}
internal void SprawdzZbieranieDanych(Excel.Workbook wb)
{
RodoDbContext db = new RodoDbContext();
foreach (Excel.Worksheet sht in wb.Worksheets)
{
string klucz = Nazwy.ZnajdzNazwe(sht);
Arkusz arkusz = db.Arkusze.Where(x => x.Klucz == klucz).FirstOrDefault();
if (arkusz != null)
{
if (DaneOsobowe.CzyZbieramyDane(sht) != arkusz.ZbieramyDane)
{
DaneOsobowe.Zmien(arkusz.ZbieramyDane, sht, arkusz.ZbieramyDane);
}
}
}
}
public static bool CzyJestPolaczenie()
{
RodoDbContext db = new RodoDbContext();
return(!db.Database.Exists());
}
