public LastConnectionProtocolRow GetLastConnection(
string machineName,
string protocolType
)
{
string clause = string.Join(" AND ", Lists.Of(
DbTypeFn.AsSqlClausePair(),
MachineNameFn.AsSqlClausePair()
));
List <SQLiteParameter> parameters = Lists.Of(
new SQLiteParameter(DbTypeFn, protocolType),
new SQLiteParameter(MachineNameFn, machineName)
);
LastConnectionProtocolRow row =
GetRows(
clause,
parameters
)
.Select(RowConverter.Convert <LastConnectionProtocolRow>)
.FirstOrDefault();
return(row);
}
private void SaveLastConnection(
long groupId,
long templateId
)
{
ConnectionType cnnType = SelectedConnectionType;
if (cnnType != null)
{
string machineName = Environment.MachineName;
LastConnectionProtocolRow lastConnectionProt = new LastConnectionProtocolRow
{
GroupId = groupId,
TemplateId = templateId,
MachineName = machineName,
DbType = cnnType.Id
};
long? lastConnectionId = this._storage.LastConnectionProtocolTable
.SaveLastConnection(lastConnectionProt);
if (lastConnectionId != null)
{
LastConnectionRow lastConnectionRow = new LastConnectionRow
{
MachineName = machineName,
LastConnectionProtocolId = lastConnectionId.Value
};
this._storage.LastConnectionTable
.SaveLastConnection(lastConnectionRow);
}
}
}
public long? SaveLastConnection(LastConnectionProtocolRow row)
{
return this.InsertOrUpdateRow(row);
}
public long?SaveLastConnection(LastConnectionProtocolRow row)
{
return(this.InsertOrUpdateRow(row));
}
