public static void CreateSubscription(BitcornContext dbContext, Subscription sub, params SubscriptionTier[] tiers)
{
dbContext.Subscription.Add(sub);
dbContext.SaveChanges();
foreach (var tier in tiers)
{
tier.SubscriptionId = sub.SubscriptionId;
dbContext.SubscriptionTier.Add(tier);
}
dbContext.SaveChanges();
}
public static void AddUser(this BitcornContext context, UserIdentity identity, UserWallet wallet)
{
var user = new User();
user.UserWallet = wallet;
user.UserIdentity = identity;
user.UserStat = new UserStat();
context.User.Add(user);
context.SaveChanges();
}
public static void RemoveUserIfExists(BitcornContext dbContext, User user)
{
if (user != null)
{
dbContext.Database.ExecuteSqlRaw("delete socialidentity");
dbContext.Database.ExecuteSqlRaw("delete subtx");
dbContext.Database.ExecuteSqlRaw("delete corndeposit");
dbContext.Database.ExecuteSqlRaw("delete walletdownload ");
var referral = dbContext.UserReferral.FirstOrDefault(u => u.UserId == user.UserId);
if (referral != null)
{
dbContext.UserReferral.Remove(referral);
}
dbContext.UserSubscription.RemoveRange(dbContext.UserSubscription.Where(u => u.UserId == user.UserId).ToArray());
dbContext.WalletDownload.RemoveRange(dbContext.WalletDownload.Where(w => w.UserId == user.UserId).ToArray());
dbContext.Remove(user.UserWallet);
dbContext.Remove(user.UserIdentity);
dbContext.Remove(user.UserStat);
dbContext.Remove(user);
dbContext.SaveChanges();
}
}
