// [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 void SendPackage(Int64 ClientId, Int64 SessionId, PackageData data)
{
if (!data.HasContent)
{
return;
}
if (data.Tables == null)
{
return;
}
using (var cnn = SqlExtension.NewSqlConnection)
{
foreach (var t in data.Tables)
{
ProcessOneTable(cnn, ClientId, SessionId, t);
}
using (var cmd = cnn.CreateCommandSP(String.Format("a2repl.{0}_from_client_written", data.ItemName)))
{
cmd.Parameters.AddWithValue("@clientid", ClientId);
cmd.Parameters.AddWithValue("@sessionid", SessionId);
cmd.Parameters.AddWithValue("@id", data.ItemId);
cmd.ExecuteNonQuery();
}
}
}
// [OperationContract]
public void SendPackageContent(Int64 ClientId, Int64 SessionId, PackageData data)
{
if (!data.HasContent)
{
return;
}
if (data.Tables == null)
{
return;
}
using (var cnn = SqlExtension.NewSqlConnection)
{
foreach (var t in data.Tables)
{
ProcessOneTableContent(cnn, ClientId, SessionId, t);
}
}
}
// [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);
}
