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();
}
}