public static bool GetActiveTenantSubscriptionById(MasterUserSession MasterUserSession, long id, out TenantSubscription tenantsubscription, out Exception exception) { var result = false; tenantsubscription = null; exception = null; try { using (var context = new ContextMaster()) { tenantsubscription = context.TenantSubscriptions.AsNoTracking().Where(x => ((x.TenantId == id) && (x.IsActive == true))).FirstOrDefault(); if (tenantsubscription == null) { tenantsubscription = new TenantSubscription(); } //throw (new RowNotFoundException()); } result = true; } } catch (Exception e) { exception = e; } return(result); }
public static TenantSubscription GetSubscriptionByTenantId(TenantUserSession tenantUserSession, int id) { TenantSubscription subscription = null; using (var context = new ContextTenant(tenantUserSession.Tenant.DatabaseConnectionString)) { subscription = context.TenantSubscriptions.Where(r => r.TenantId == id && r.IsActive == true).FirstOrDefault(); } return(subscription); }
public static bool UpdateTenantSubscription(MasterUserSession MasterUserSession, TenantSubscription tenantsubscription, out TenantSubscription outtenantsubscription, out Exception exception) { var result = false; outtenantsubscription = null; exception = null; try { using (var context = new ContextMaster()) { var temp = new TenantSubscription(); temp = context.TenantSubscriptions.FirstOrDefault(t => t.Id == tenantsubscription.Id); temp.IsDemo = tenantsubscription.IsDemo; temp.IsActive = tenantsubscription.IsActive; temp.DateTimeStart = tenantsubscription.DateTimeStart; temp.DateTimeExpires = tenantsubscription.DateTimeExpires; temp.NumberOfFormsAllowed = tenantsubscription.NumberOfFormsAllowed; temp.NumberOfUsersAllowed = tenantsubscription.NumberOfUsersAllowed; temp.NumberOfPagesAllowed = tenantsubscription.NumberOfPagesAllowed; temp.NumberOfTemplatesAllowed = tenantsubscription.NumberOfTemplatesAllowed; temp.NumberOfFormsUsed = tenantsubscription.NumberOfFormsUsed; temp.NumberOfPagesUsed = tenantsubscription.NumberOfPagesUsed; temp.NumberOfUsersUsed = tenantsubscription.NumberOfUsersUsed; temp.NumberOfTemplatesUsed = tenantsubscription.NumberOfTemplatesUsed; temp.AllowScanning = tenantsubscription.AllowScanning; temp.AllowBranding = tenantsubscription.AllowBranding; temp.AllowTemplateWorkflows = tenantsubscription.AllowTemplateWorkflows; context.TenantSubscriptions.Attach(temp); context.Entry(temp).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); outtenantsubscription = temp; } result = true; } catch (Exception e) { exception = e; } return(result); }
public static int SaveTenantSubscription(TenantUserSession tenantUserSession, TenantSubscription subscribtion) { using (var context = new ContextTenant(tenantUserSession.Tenant.DatabaseConnectionString)) { subscribtion.Subscription = context.Subscriptions.Where(s => s.Id == subscribtion.Subscription.Id).FirstOrDefault(); subscribtion.NumberOfFormsAllowed = subscribtion.Subscription.NumberOfFormsAllowed; subscribtion.NumberOfFormsUsed = subscribtion.Subscription.NumberOfFormsUsed; subscribtion.NumberOfPagesAllowed = subscribtion.Subscription.NumberOfPagesAllowed; subscribtion.NumberOfPagesUsed = subscribtion.Subscription.NumberOfPagesUsed; subscribtion.NumberOfTemplatesAllowed = subscribtion.Subscription.NumberOfTemplatesAllowed; subscribtion.NumberOfUsersAllowed = subscribtion.Subscription.NumberOfUsersAllowed; subscribtion.NumberOfUsersUsed = subscribtion.Subscription.NumberOfUsersUsed; subscribtion = context.TenantSubscriptions.Add(subscribtion); context.SaveChanges(); } return(Convert.ToInt32(subscribtion.TenantId)); }
public static bool CreateTenantSubscriptionAndDeactivateExistingTenantSubscription(MasterUserSession MasterUserSession, long existingtenantsubscriptionid, Subscription subscriptionMaster, TenantSubscription tenantsubscriptionMaster, out Exception exception) { var result = false; exception = null; //System.Data.Common.DbTransaction Tran = null; //ContextMaster context = new ContextMaster(); //context.ObjectContext.Connection.Open(); //Tran = context.ObjectContext.Connection.BeginTransaction(); DbContextTransaction masterTrans = null; DbContextTransaction tenantTrans = null; using (var contextMaster = new ContextMaster()) { try { using (masterTrans = contextMaster.Database.BeginTransaction()) { try { var existingSubscriptions = contextMaster.TenantSubscriptions.Where(x => (x.TenantId == existingtenantsubscriptionid) && (x.IsActive == true)).ToList(); foreach (var existingSubnscription in existingSubscriptions) { existingSubnscription.IsActive = false; contextMaster.SaveChanges(); } contextMaster.TenantSubscriptions.Add(tenantsubscriptionMaster); contextMaster.SaveChanges(); tenantsubscriptionMaster.MasterTenantSubscriptionId = tenantsubscriptionMaster.Id; contextMaster.Entry(tenantsubscriptionMaster).State = EntityState.Modified; contextMaster.SaveChanges(); var tenant = contextMaster.Tenants.SingleOrDefault(x => x.Id == tenantsubscriptionMaster.TenantId); if (tenant == null) { throw (new Exception("Unable to Find Tenant in the Master DB.")); } using (var contextTenant = new ContextTenant(tenant.DatabaseConnectionString)) { try { using (tenantTrans = contextTenant.Database.BeginTransaction()) { var existingtenantsubscriptionstenant = contextTenant.TenantSubscriptions.Where(x => (x.IsActive == true)).ToList(); foreach (var existingSubscriptionTenant in existingtenantsubscriptionstenant) { existingSubscriptionTenant.IsActive = false; contextTenant.SaveChanges(); } var subscriptionTenant = contextTenant.Subscriptions.SingleOrDefault(s => s.MasterSubscriptionId == subscriptionMaster.Id); if (subscriptionTenant == null) { subscriptionTenant = subscriptionMaster.Clone(); subscriptionTenant.Id = 0; subscriptionTenant.MasterSubscriptionId = subscriptionMaster.Id; subscriptionTenant.SubscriptionType = EntityMasterTenantType.Tenant; contextTenant.Subscriptions.Add(subscriptionTenant); contextTenant.SaveChanges(); } else { //subscriptionTenant = subscription.Clone(); //subscriptionTenant.MasterTenantId = subscription.Id;//Yeh Maam Nay kerwaya hai. //contextTenant.Entry(subscriptionTenant).State = EntityState.Modified; //contextTenant.SaveChanges(); } var count = contextTenant.Tenants.Count(); if (count != 1) { throw (new Exception($"The number of tenant entries found in the Tenant database was {count} instead of 1.")); } var tenantTenant = contextTenant.Tenants.Single(); var tenantsubscriptionTenant = tenantsubscriptionMaster; var masterTenantSubscriptionId = contextMaster.TenantSubscriptions.AsNoTracking().Where(x => x.IsActive == true).FirstOrDefault().Id; tenantsubscriptionTenant.MasterTenantSubscriptionId = tenantsubscriptionMaster.Id; tenantsubscriptionTenant.Id = 0; tenantsubscriptionTenant.SubscriptionId = subscriptionTenant.Id; tenantsubscriptionTenant.Tenant = null; tenantsubscriptionTenant.TenantId = tenantTenant.Id; tenantsubscriptionTenant.TenantSubscriptionType = EntityMasterTenantType.Tenant; contextTenant.TenantSubscriptions.Add(tenantsubscriptionTenant); contextTenant.SaveChanges(); try { tenantTrans.Commit(); masterTrans.Commit(); } catch { tenantTrans.Rollback(); masterTrans.Rollback(); } result = true; } } catch (Exception ex) { exception = ex; throw; } } } catch (Exception ex) { exception = ex; throw; //Tran.Rollback(); //Tran.Dispose(); } } } catch (Exception ex) { exception = ex; masterTrans.Rollback(); tenantTrans.Rollback(); masterTrans.Dispose(); tenantTrans.Dispose(); } } return(result); }
public static bool GetTenantSubscriptionById(MasterUserSession MasterUserSession, long id, out TenantSubscription tenantsubscription, out Exception exception) { var result = false; tenantsubscription = null; exception = null; try { using (var context = new ContextMaster()) { tenantsubscription = context.TenantSubscriptions.AsNoTracking().SingleOrDefault(t => t.Id == id); if (tenantsubscription == null) { throw (new RowNotFoundException()); } result = true; } } catch (Exception e) { exception = e; } return(result); }
public static bool CreateTenantSubscription(MasterUserSession MasterUserSession, TenantSubscription tenantsubscription, out TenantSubscription outtenantsubscription, out Exception exception) { var result = false; //tenant = null; outtenantsubscription = null; exception = null; try { using (var context = new ContextMaster()) { DbContextTransaction mastertrans = null; DbContextTransaction tenanttrans = null; try { using (mastertrans = context.Database.BeginTransaction()) { outtenantsubscription = context.TenantSubscriptions.Add(tenantsubscription); context.SaveChanges(); var tenant = context.Tenants.Where(x => x.Id == tenantsubscription.TenantId).FirstOrDefault(); var subscription = context.Subscriptions.Where(x => x.Id == tenantsubscription.SubscriptionId).FirstOrDefault(); using (var contexttenant = new ContextTenant(tenant.DatabaseConnectionString)) { try { using (tenanttrans = contexttenant.Database.BeginTransaction()) { var mastersubscriptionid = subscription.Id; subscription.Id = 0; contexttenant.Subscriptions.Add(subscription); contexttenant.SaveChanges(); tenantsubscription.SubscriptionId = subscription.Id; contexttenant.TenantSubscriptions.Add(tenantsubscription); contexttenant.SaveChanges(); } } catch (Exception ex) { exception = ex; throw ex; } } tenanttrans.Commit(); mastertrans.Commit(); } } catch (Exception ex) { if (mastertrans != null) { mastertrans.Rollback(); mastertrans.Dispose(); } if (tenanttrans != null) { tenanttrans.Rollback(); tenanttrans.Dispose(); } exception = ex; throw ex; } } result = true; } catch (Exception ex) { exception = ex; } return(result); }
public async Task <TenantSubscription> CreateItemAsync(TenantSubscription entity) { var results = await _container.CreateItemAsync <TenantSubscription>(entity, new PartitionKey(entity.Subscription.Name)); return(results); }
public async Task <TenantSubscription> CreateItem(TenantSubscription entity) { var results = await _tenantSubscriptionsManager.CreateItemAsync(entity); return(results); }