Index: trunk/BazaReklam/OrderDetails.cs
===================================================================
--- trunk/BazaReklam/OrderDetails.cs (revision 556)
+++ trunk/BazaReklam/OrderDetails.cs (revision 557)
@@ -238,5 +238,5 @@
             reklama_Info_DodTableAdapter.Update(rEKLAMADataSet.Reklama_Info_Dod);
             zmianyEmisjiTableAdapter.Update(rEKLAMADataSet.zmianyEmisji);
-            MessageBox.Show("Zmiany zapisane");
+            
 
             zmiany();
@@ -249,5 +249,5 @@
                 ZamowienieHelper.MakeZamowienieZafakturowane(reklama.idZamowienia);
 
-
+            MessageBox.Show("Zmiany zapisane");
             Cursor = Cursors.Default;
         }
Index: trunk/BazaReklam/Baza Reklam.csproj
===================================================================
--- trunk/BazaReklam/Baza Reklam.csproj (revision 554)
+++ trunk/BazaReklam/Baza Reklam.csproj (revision 557)
@@ -125,4 +125,5 @@
     <Compile Include="Classes\WordHandler.cs" />
     <Compile Include="Classes\XTGFile.cs" />
+    <Compile Include="Classes\ZamowienieHelper.cs" />
     <Compile Include="ClientsForm.cs">
       <SubType>Form</SubType>
Index: trunk/BazaReklam/ProjectForm.cs
===================================================================
--- trunk/BazaReklam/ProjectForm.cs (revision 554)
+++ trunk/BazaReklam/ProjectForm.cs (revision 557)
@@ -97,6 +97,4 @@
             REKLAMADataSet.REKLAMARow row = rEKLAMADataSet.REKLAMA.FindByReklamaID(reklamaID);
 
-            int emisja = piewrszaEmisja(reklamaID);
-       
             DataView datatable = (DataView)pRODUKCJABindingSource.List;
             
@@ -111,5 +109,5 @@
             row2["kolor"] = row["KOLOR"];
             row2["lokalizacja"] = row["strona"];
-            row2["dataemisji"] = emisja;
+            row2["dataemisji"] = piewrszaEmisja(reklamaID);
             row2["AGENT"] = User.getUser().Login;
             row2["DATA_AGENT"] = DateTime.Now;
@@ -196,22 +194,22 @@
         /// Wyszukuje nr pierwszej emisji...
         /// </summary>
-        private int piewrszaEmisja(int reklamaId) {
-
-            SqlConnection conn = new SqlConnection(
-                ConnString.getConnString().Value);
-
+        private static int piewrszaEmisja(int reklamaId) {
+
+            SqlConnection conn = new SqlConnection(ConnString.getConnString().Value);
 
             SqlCommand command = new SqlCommand();
             command.CommandType = CommandType.Text;
-            command.CommandText = "select min([Nr Wydania]) from dbo.[UKA¯E SIÊ W NR] where ReklamaId = @param ";
-            command.Parameters.AddWithValue("@param",reklamaID);
+            command.CommandText = "SELECT MIN([Nr Wydania]) FROM dbo.[UKA¯E SIÊ W NR] WHERE ReklamaId=@param";
+            command.Parameters.AddWithValue("@param", reklamaId);
             command.Connection = conn;
-
-            int emisja;
 
             conn.Open();
             try
             {
-                emisja = Convert.ToInt16(command.ExecuteScalar());
+                object nrWydania = command.ExecuteScalar();
+                
+                if (nrWydania is DBNull) return 0;
+                
+                return Convert.ToInt32(nrWydania);
             }
             finally
@@ -219,7 +217,5 @@
                 conn.Close();    
             }
-            
-
-            return emisja;
+            return 0;
         }
               
@@ -237,5 +233,5 @@
         /// Przerysowuje kontrolkê na wydruk.
         /// </summary>
-        private void Renderuj2(object sender, System.Drawing.Printing.PrintPageEventArgs ev)
+        private void Renderuj2(object sender, PrintPageEventArgs ev)
         {            
             int leftMargin = ev.MarginBounds.Left;
Index: trunk/BazaReklam/Classes/ZamowienieHelper.cs
===================================================================
--- trunk/BazaReklam/Classes/ZamowienieHelper.cs (revision 557)
+++ trunk/BazaReklam/Classes/ZamowienieHelper.cs (revision 557)
@@ -0,0 +1,36 @@
+using System.Data;
+using System.Data.SqlClient;
+
+namespace Baza_Reklam.Classes
+{
+    public class ZamowienieHelper
+    {
+        public static void MakeZamowienieZafakturowane(int zamowienieId)
+        {
+            SqlConnection conn = null;
+            SqlCommand cmd = null;
+
+            try
+            {
+                conn = new SqlConnection(ConnString.getConnString().Value);
+                conn.Open();
+                cmd = new SqlCommand("sp_MakeZamowienieZafakturowane", conn);
+                cmd.CommandType = CommandType.StoredProcedure;
+                cmd.Parameters.AddWithValue("@zamowienieId", zamowienieId);
+                cmd.ExecuteNonQuery();
+            }
+            finally
+            {
+                if (cmd != null)
+                    cmd.Dispose();
+
+                if (conn != null && conn.State == ConnectionState.Open)
+                {
+                    conn.Close();
+                    conn.Dispose();
+                }
+            }
+
+        }
+    }
+}