Index: trunk/TruckExpoCDN/ExportForm.cs
===================================================================
--- trunk/TruckExpoCDN/ExportForm.cs (revision 415)
+++ trunk/TruckExpoCDN/ExportForm.cs (revision 479)
@@ -1,9 +1,6 @@
 using System;
-using System.Collections.Generic;
 using System.ComponentModel;
 using System.Data;
 using System.Data.SqlClient;
-using System.Drawing;
-using System.Text;
 using System.Windows.Forms;
 using ExportFaktur.EXPODataSetTableAdapters;
@@ -24,6 +21,6 @@
         TraVatTableAdapter TraVatAdapter = new TraVatTableAdapter();
 
-        SqlConnection conn = new SqlConnection(ConnString.getConnString().CdnExpoConnStr);
-        SqlConnection truck_expo_conn = new SqlConnection(ConnString.getConnString().TruckExpoConnStr);
+        SqlConnection conn = new SqlConnection(ConnString.CDNConnection);
+        SqlConnection bazaReklamConn = new SqlConnection(ConnString.BazaReklamConnection);
 
         int nMaxProgress;
@@ -38,7 +35,7 @@
             fakturyDetailsAdapter.ClearBeforeFill = true;
 
-            fAKTURYTableAdapter.Connection = truck_expo_conn;
-            klientAdapter.Connection = truck_expo_conn;
-            fakturyDetailsAdapter.Connection = truck_expo_conn;
+            fAKTURYTableAdapter.Connection = bazaReklamConn;
+            klientAdapter.Connection = bazaReklamConn;
+            fakturyDetailsAdapter.Connection = bazaReklamConn;
 
             kontrahenciAdapter.Connection = conn;
@@ -55,5 +52,5 @@
         private void refresh()
         {
-            this.fAKTURYTableAdapter.FillByNotExported(this.eXPODataSet.FAKTURY);
+            fAKTURYTableAdapter.FillByNotExported(eXPODataSet.FAKTURY);
 
             statusLabel1.Text = "Liczba faktur " + eXPODataSet.FAKTURY.Count;
@@ -120,5 +117,4 @@
                             ex.DodajVAT(ex.CDNDataset.TraNag[0], sumaNetto, vat);
 
-                           // kontrahenciAdapter.Update(ex.CDNDataset.Kontrahenci);
                             TraNagAdapter.Update(ex.CDNDataset.TraNag);
                             TraElemAdapter.Update(ex.CDNDataset.TraElem);
@@ -126,5 +122,4 @@
 
                             transaction.Commit();
-
                             row.EXPORTED = true;
                             row.EXPORTED_DATA = DateTime.Now;
@@ -134,8 +129,10 @@
                             backgroundWorker1.ReportProgress(n);
                         }
-                        catch (Exception)
+                        catch (Exception exception)
                         {
                             transaction.Rollback();
                             conn.Close();
+                            //TODO: Send Email
+                            MessageBox.Show("Faktura ID: " + row.ID_FAKTURY + "\n" + exception);
                             throw;
                         }
@@ -159,4 +156,8 @@
             }
 
+            if (bazaReklamConn.State == ConnectionState.Open)
+            {
+                bazaReklamConn.Close();
+            }
             if (conn.State == ConnectionState.Open)
             {
@@ -168,5 +169,5 @@
         private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
         {
-            if (!this.Visible || this.WindowState != FormWindowState.Normal)
+            if (!Visible || WindowState != FormWindowState.Normal)
             {
                 return;
@@ -235,7 +236,12 @@
         }
 
-        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
-        {
-            //dataGridView1.EndEdit();
+        private void cbSelectAll_CheckedChanged(object sender, EventArgs e)
+        {
+            cbSelectAll.Text = cbSelectAll.Checked ? "Odznacz wszystko" : "Zaznacz wszystko";
+
+            foreach (EXPODataSet.FAKTURYRow row in eXPODataSet.FAKTURY.Rows)
+            {
+                row.Exportuj = cbSelectAll.Checked;
+            }
         }
     }