//helper.cs

    public sealed class DataStorageHelper
    {
        #region Ядро Singelton
        private DataStorageHelper() { }
        public static readonly DataStorageHelper Instance = new DataStorageHelper() ;
        #endregion

        private SqlCommand cmd = new SqlCommand();
        private SqlConnection conn = new SqlConnection(Properties.Settings.Default.dbMainConnection);
        
        public void InsertVolume(Object [] param)
        {
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.CommandText = @"INSERT dbo.Volume (NUMBER, CUSTOMER, TITLE, REF_BUILDING, REF_TYP)
                                    SELECT @NUMBER, @CUSTOMER, @TITLE, b.ID_BUILDING, @REF_TYP
                                        FROM Building b WHERE b.KKS = @BUILDING";
            cmd.Connection = conn;
            cmd.Parameters.AddWithValue("@ID_VOLUME", param[0]).SqlDbType = SqlDbType.Int;
            cmd.Parameters.AddWithValue("@NUMBER", param[1]).SqlDbType = SqlDbType.NVarChar;
            cmd.Parameters.AddWithValue("@CUSTOMER", param[2]).SqlDbType = SqlDbType.NVarChar;
            cmd.Parameters.AddWithValue("@TITLE", param[3]).SqlDbType = SqlDbType.NVarChar;
            cmd.Parameters.AddWithValue("@REF_TYP", param[4]).SqlDbType = SqlDbType.Int;
            string s = ExtractBuilding((string)param[1]);
            cmd.Parameters.AddWithValue("@BUILDING", s).SqlDbType = SqlDbType.NVarChar;
            cmd.Parameters["@NUMBER"].Size = 37;
            cmd.Parameters["@CUSTOMER"].Size = 255;
            cmd.Parameters["@TITLE"].Size = 4000;
            cmd.Parameters["@BUILDING"].Size = 5;

            try
            {
                if (conn.State == ConnectionState.Closed)
                  cmd.Connection.Open();
                cmd.Prepare();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }    
        }

        private string ExtractBuilding(string s)
        {
            return s.Substring(11, 1) + s.Substring(13, 4);
        }


//fmNew.cs
private void fmNew_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (this.DialogResult == DialogResult.OK)
            {
                
                Object[] arrayParam = new Object[5];

                arrayParam[0] = DBNull.Value;
                arrayParam[1] = teNumber.Text;
                arrayParam[2] = teProject.Text;
                arrayParam[3] = meNamePackage.Text;
                arrayParam[4] = cbTypeDocument.EditValue;

                DataStorageHelper.Instance.InsertVolume(arrayParam);

                e.Cancel = false;
            }