public void UpdateAddr(ShippingAddr addr)
{
if (addr.IsDefault)
{
context.Database.ExecuteSqlRaw($"UPDATE `ShippingAddrs` SET IsDefault=0 WHERE UserID='{addr.UserID}';");
}
}
public void DeleteAddr(ShippingAddr addr)
{
if (addr == null)
{
throw new ArgumentNullException(nameof(addr));
}
context.ShippingAddrs.Remove(addr);
}
public void AddAddr(Guid userid, ShippingAddr addr)
{
if (addr == null)
{
throw new ArgumentNullException(nameof(addr));
}
addr.UserID = userid;
if (addr.IsDefault)
{
context.Database.ExecuteSqlRaw($"UPDATE `ShippingAddrs` SET IsDefault=0 WHERE UserID='{userid}';");
}
context.ShippingAddrs.Add(addr);
}
