private void doGetDailySumProduction() { using (ProviderMsAccess prov = new ProviderMsAccess(@"C:\Users\Szymon\Documents\baza.accdb")) { FroniusSymoLog log = new FroniusSymoLog(); DateTime beginDate = prov.GetFroniusProductionBeginDate(); progressBar1.Invoke((MethodInvoker) delegate { progressBar1.Maximum = (DateTime.Now.Date - beginDate.AddDays(1)).Days; }); for (beginDate = beginDate.AddDays(1); beginDate < DateTime.Now.Date; beginDate = beginDate.AddDays(1)) { double dailyProduction = log.DailySumProduction(beginDate); prov.DailySumProduction(beginDate, dailyProduction); progressBar1.Invoke((MethodInvoker) delegate { progressBar1.Increment(1); }); } } }
private void button3_Click(object sender, EventArgs e) { string sDirectoryPath = @"D:\Falownik\Inputs\"; //string sDirectoryPath = @"G:\Fotowoltaika\"; using (ProviderMsAccess prov = new ProviderMsAccess(@"C:\Users\Szymon\Documents\baza.accdb")) { FroniusSymoLog log = new FroniusSymoLog(); var temp = log.GetProduction(sDirectoryPath); prov.InsertProduction(temp); } }
private void button7_Click(object sender, EventArgs e) { using (OpenFileDialog open = new OpenFileDialog()) { if (open.ShowDialog(this) == DialogResult.OK) { string sTauronLogFilePath = open.FileName; //@"D:\Falownik\Tauron\Dane.xls" using (ProviderMsAccess prov = new ProviderMsAccess(@"C:\Users\Szymon\Documents\baza.accdb")) { Tauron.TauronLog log = new Tauron.TauronLog(); //var lista = log.GetTauronLogData(sTauronLogFilePath); var lista = log.GetTauronLogDataCSV(sTauronLogFilePath); prov.InsertTauronLog(lista); } } } MessageBox.Show(this, "Import zakończone!!", "Import Tauron", MessageBoxButtons.OK, MessageBoxIcon.Information); }