// [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 SetDataForGetSent(Int64 ClientId, Int64 SessionId, DataForGet DataForGet)
{
using (var cnn = SqlExtension.NewSqlConnection)
{
using (var cmd = cnn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = String.Format("a2repl.set_{0}_sent_for_client", DataForGet.TableName);
cmd.Parameters.AddWithValue("@clientid", ClientId); // 0
cmd.Parameters.AddWithValue("@sessionid", SessionId); // 1
cmd.Parameters.AddWithValue("@id", DataForGet.Id); // 2
cmd.ExecuteNonQuery();
}
}
}
// [OperationContract]
public DataForGet GetItemForGet(Int64 ClientId, Int64 SessionId)
{
using (var cnn = SqlExtension.NewSqlConnection)
{
using (var cmd = cnn.CreateCommandSP("a2repl.get_element_for_client"))
{
cmd.Parameters.AddWithValue("@clientid", ClientId); // 0
cmd.Parameters.AddWithValue("@sessionid", SessionId); // 1
using (var rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
var d = new DataForGet();
d.Id = rdr.GetInt64(0);
d.TableName = rdr.GetString(1);
return(d);
}
}
}
}
return(null);
}
