public int Create(RoleEntity role)
{
CatchMeContext.Roles.Add(role);
CatchMeContext.SaveChanges();
return role.Id;
}
public void Delete(RoleEntity role)
{
var parameters = new[]
{
new SqlParameter(SpParams.RoleCommon.RoleId, role.Name) { Direction = ParameterDirection.Input, DbType = DbType.Int32 }
};
ExecuteNonQueryProc(SpNames.DeleteRoleById, parameters);
}
public void Update(RoleEntity role)
{
var roleToUpdate = CatchMeContext.Roles.Find(role.Id);
if (roleToUpdate != null)
{
roleToUpdate.Name = role.Name;
CatchMeContext.SaveChanges();
}
}
public int Create(RoleEntity role)
{
var parameters = new[]
{
new SqlParameter(SpParams.RoleCommon.RoleName, role.Name) { Direction = ParameterDirection.Input, DbType = DbType.String }
};
var roleId = ExecuteScalar(SpNames.AddRole, parameters);
return roleId;
}
public void Delete(RoleEntity role)
{
CatchMeContext.Roles.Remove(role);
CatchMeContext.SaveChanges();
}
public RoleEntity PopulateRoleEntity(SqlDataReader reader)
{
var role = new RoleEntity()
{
Id = reader["RoleId"].FromDb<int>(),
Name = reader["RoleName"].FromDb<string>(),
};
return role;
}