public long Add(StateEditData data)
{
using(var scope = new TransactionScope())
{
var id = _executor.Query<long>("[dbo].[State_Add]",
new
{
data.Name,
data.Position,
IsSystem = false,
});
_executor.Execute("[dbo].[StateLocalization_Merge]",
new
{
Name = data.LocalizedName,
TwoLetterISOLanguageName = data.Language,
StateId = id
});
scope.Complete();
return id;
}
}
public void Update(long id, StateEditData data)
{
using(var scope = new TransactionScope())
{
_executor.Execute("[dbo].[State_Update]",
new
{
data.Name,
data.Position,
Id = id
});
_executor.Execute("[dbo].[StateLocalization_Merge]",
new
{
Name = data.LocalizedName,
TwoLetterISOLanguageName = data.Language,
StateId = id
});
scope.Complete();
}
}