// [OperationContract]
        public PackageData GetDataForGet(Int64 ClientId, Int64 SessionId, DataForGet DataForGet)
        {
            PackageData pd = new PackageData();

            using (var cnn = SqlExtension.NewSqlConnection)
            {
                using (var cmd = cnn.CreateCommand())
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = String.Format("a2repl.get_{0}_for_client", DataForGet.TableName);
                    cmd.Parameters.AddWithValue("@clientid", ClientId);   // 0
                    cmd.Parameters.AddWithValue("@sessionid", SessionId); // 1
                    cmd.Parameters.AddWithValue("@id", DataForGet.Id);    // 2
                    using (var rdr = cmd.ExecuteReader())
                    {
                        do
                        {
                            var di = new DataTable(rdr);
                            while (rdr.Read())
                            {
                                ReadData(di, rdr);
                            }
                            if (pd.Tables == null)
                            {
                                pd.Tables = new List <DataTable>();
                            }
                            pd.Tables.Add(di);
                        } while (rdr.NextResult());
                    }
                }
            }
            pd.SetHasContent();
            return(pd);
        }
        // [OperationContract]
        public PackageData LoadPackage(Int64 ClientId, Int64 SessionId, Int64 PackageId)
        {
            var pd = new PackageData();

            using (var cnn = SqlExtension.NewSqlConnection)
            {
                using (var cmd = cnn.CreateCommandSP("a2repl.package_content_load"))
                {
                    cmd.Parameters.AddWithValue(String.Empty, (Int32)0).Direction = ParameterDirection.ReturnValue;
                    cmd.Parameters.AddWithValue("@clientid", ClientId);
                    cmd.Parameters.AddWithValue("@sessionid", SessionId);
                    cmd.Parameters.AddWithValue("@pkgid", PackageId);
                    cmd.Parameters.AddWithValue("@nextpkg", (Int64)0).Direction = ParameterDirection.Output;
                    using (var rdr = cmd.ExecuteReader())
                    {
                        do
                        {
                            var di = new DataTable(rdr);
                            while (rdr.Read())
                            {
                                di.Read(rdr);
                            }
                            if (di.HasContent)
                            {
                                if (pd.Tables == null)
                                {
                                    pd.Tables = new List <DataTable>();
                                }
                                pd.Tables.Add(di);
                            }
                        } while (rdr.NextResult());
                    }
                    pd.HasMoreData = (Int32)cmd.Parameters[0].Value != 0;
                    if (pd.HasMoreData)
                    {
                        pd.NextPackageId = (Int64)cmd.Parameters[4].Value;
                    }
                    pd.SetHasContent();
                }
            }
            return(pd);
        }