public static User Update(User user)
{
bool isNew = user.IsNew;
UserMapper.Instance.Update(user);
if (user.BrandsLoaded)
{
if (!isNew)
{
UserBrandMapper.Instance.DeleteUserBrands(user.UserId);
}
if (user.UserRole != Shared.UserRole.SuperAdministrator)
{
foreach (Brand brand in user.Brands)
{
UserBrand ub = UserBrand.New();
ub.UserId = user.UserId.GetValueOrDefault();
ub.BrandId = brand.BrandId.GetValueOrDefault();
UserBrand.Update(ub);
}
}
}
return(user);
}
protected override object ReadRow(IRowReader reader)
{
UserBrand userBrand = UserBrand.New();
// Table Fields
userBrand.UserBrandId = reader.GetInt32("UserBrandId");
userBrand.UserId = reader.GetInt32("UserId");
userBrand.BrandId = reader.GetInt32("BrandId");
userBrand.IsDirty = false;
userBrand.ChangedProperties.Clear();
return(userBrand);
}
public virtual UserBrand Update(UserBrand userBrand)
{
if (!userBrand.IsDirty || userBrand.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(userBrand);
}
IDbCommand command = CreateCommand();
if (userBrand.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [UserBrand] ([UserId], [BrandId]) VALUES (@userId, @brandId) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [UserBrand] SET [UserId] = @userId, [BrandId] = @brandId WHERE UserBrandId = @userBrandId";
}
command.Parameters.Add(CreateParameter("@userId", userBrand.UserId));
command.Parameters.Add(CreateParameter("@brandId", userBrand.BrandId));
if (userBrand.IsNew)
{
userBrand.UserBrandId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@userBrandId", userBrand.UserBrandId));
ExecuteCommand(command);
}
userBrand.IsDirty = false;
userBrand.ChangedProperties.Clear();
return(userBrand);
}
public static UserBrand FindOne(UserBrandFinder finder)
{
UserBrand UserBrand = UserBrandMapper.Instance.FindOne(finder);
return(UserBrand ?? Empty);
}
public static UserBrand Update(UserBrand userBrand)
{
return(UserBrandMapper.Instance.Update(userBrand));
}
public static UserBrand Get(Nullable <Int32> UserBrandId)
{
UserBrand UserBrand = UserBrandMapper.Instance.Get(UserBrandId);
return(UserBrand ?? Empty);
}
