Zbiór zmian 479 dla trunk/TruckExpoCDN/ExportForm.cs

Data:

2009-03-24 12:01:24 (17 years ago)

Autor:

marek

Opis:

re #134

Pliki:

• trunk/TruckExpoCDN/ExportForm.cs (zmodyfikowane) (10 diffs)

trunk/TruckExpoCDN/ExportForm.cs

@@ -1 +1 @@
 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 +21 @@
         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 +35 @@
             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 +52 @@
         private void refresh()
         {
-            this.fAKTURYTableAdapter.FillByNotExported(this.eXPODataSet.FAKTURY);
+            fAKTURYTableAdapter.FillByNotExported(eXPODataSet.FAKTURY);
 
             statusLabel1.Text = "Liczba faktur " + eXPODataSet.FAKTURY.Count;
@@ -120 +117 @@
                             ex.DodajVAT(ex.CDNDataset.TraNag[0], sumaNetto, vat);
 
-                           // kontrahenciAdapter.Update(ex.CDNDataset.Kontrahenci);
                             TraNagAdapter.Update(ex.CDNDataset.TraNag);
                             TraElemAdapter.Update(ex.CDNDataset.TraElem);
@@ -126 +122 @@
 
                             transaction.Commit();
-
                             row.EXPORTED = true;
                             row.EXPORTED_DATA = DateTime.Now;
@@ -134 +129 @@
                             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 +156 @@
             }
 
+            if (bazaReklamConn.State == ConnectionState.Open)
+            {
+                bazaReklamConn.Close();
+            }
             if (conn.State == ConnectionState.Open)
             {
@@ -168 +169 @@
         private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
         {
-            if (!this.Visible || this.WindowState != FormWindowState.Normal)
+            if (!Visible || WindowState != FormWindowState.Normal)
             {
                 return;
@@ -235 +236 @@
         }
 
-        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;
+            }
         }
     }