public bool DeleteUser(Guid userId, bool isSeller)
{
using (var db = new SqlConnection(_connectionString))
{
_addressRepo.DeleteUserAddresses(userId);
_paymentTypeRepo.DeleteAllPaymentTypesByUserId(userId);
if (isSeller)
{
var productsToDelete = _productRepo.GetProductsByUid(userId);
foreach (Product product in productsToDelete)
{
_productRepo.DeleteProduct(product.Id);
}
}
var sql = @"UPDATE [User]
SET [FirstName] = 'DELETED',
[LastName] = 'DELETED'
WHERE Id = @userId";
var parameters = new { userId };
return(db.Execute(sql, parameters) == 1);
}
}