public void ChangeRoles(User o)
{
using (var scope = new TransactionScope())
{
DbUtil.ExecuteNonQuerySp("clearRoles", new { o.Id }, Cs);
foreach (var role in o.Roles)
{
DbUtil.ExecuteNonQuerySp("assignRole", new { userId = o.Id, roleId = role.Id }, Cs);
}
scope.Complete();
}
}
public override int Insert(User o)
{
using (var scope = new TransactionScope())
{
var userId = DbUtil.Insert(o, Cs, new[] { "Id", "Roles" });
foreach (var role in o.Roles)
{
DbUtil.ExecuteNonQuerySp("assignRole", new { userId, roleId = role.Id }, Cs);
}
scope.Complete();
return(userId);
}
}
public int Activate(int id)
{
return(DbUtil.ExecuteNonQuerySp("activateMeasureset", new { id }, Cs));
}
public int ChangeState(int id, int stateId)
{
return(DbUtil.ExecuteNonQuerySp("changeMeasuresetState", new { id, stateId }, Cs));
}
public int UnassignField(int fieldId, int fieldsetId)
{
return(DbUtil.ExecuteNonQuerySp("unassignField", new { fieldId, fieldsetId }, Cs));
}
public int Unassign(int measureId, int measuresetId)
{
return(DbUtil.ExecuteNonQuerySp("unassignMeasure", new { measureId, measuresetId }, Cs));
}
public void MoveToFpi(int fpiId)
{
DbUtil.ExecuteNonQuerySp("updateToFpi", new { fpiId }, Cs);
}
public void RollbackToIndicators(int fpiId)
{
DbUtil.ExecuteNonQuerySp("rollbackToIndicators", new { fpiId }, Cs);
}
public int RollbackWinners(int fpiId)
{
return(DbUtil.ExecuteNonQuerySp("rollbackWinners", new { fpiId }, Cs));
}
public int ChangeState(int id, DossierStates stateId)
{
return(DbUtil.ExecuteNonQuerySp("changeDossierState", new { id, stateId }, Cs));
}