public EventFromSeries GetEventFromSeries(int id)
{
using (var db = new CalendarDbContext())
{
return(db.EditedSeriesEvents.First(x => x.Id == id));
}
}
public SingleEvent GetSingleEvent(int id)
{
using (var db = new CalendarDbContext())
{
return(db.SingleEvents.First(x => x.Id == id));
}
}
public EventSeries GetEventSeries(int id)
{
using (var db = new CalendarDbContext())
{
var eventSeries = db.EventSeries.Include(x => x.EditedEvents).First(x => x.Id == id);
return(eventSeries);
}
}
public List <EventFromSeries> GetEventFromSeries(DateTime from, DateTime to)
{
using (var db = new CalendarDbContext())
{
var editedSeries = db.EditedSeriesEvents.Where(x => x.Start > from && x.Start < to);
return(editedSeries.ToList());
}
}
public CalendarQueryService(CalendarDbContext calendarDbContext,
IEnumerable <IRecurringEvent> recurringEventProviders,
IEnumerable <ISecurityGroupProvider> groupProviders)
{
_calendarDbContext = calendarDbContext;
_recurringEventProviders = recurringEventProviders;
_groupProviders = groupProviders;
}
public List <SingleEvent> GetSingleEvents(DateTime from, DateTime to)
{
using (var db = new CalendarDbContext())
{
var singleEvents = db.SingleEvents.Where(x => x.Start > from && x.Start < to);
return(singleEvents.ToList());
}
}
public int AddSingleEvent(SingleEvent singleEvent)
{
using (var db = new CalendarDbContext())
{
var entity = db.SingleEvents.Add(singleEvent);
db.SaveChanges();
return(entity.Entity.Id);
}
}
public EventSeries UpdateEventSeries(EventSeries editedEventSeries)
{
using (var db = new CalendarDbContext())
{
var addedEntity = db.EventSeries.Update(editedEventSeries);
db.SaveChanges();
return(addedEntity.Entity);
}
}
public EventFromSeries UpdateEventFromSeries(EventFromSeries eventFromSeries)
{
using (var db = new CalendarDbContext())
{
var entity = db.EditedSeriesEvents.Update(eventFromSeries);
db.SaveChanges();
return(entity.Entity);
}
}
public bool DeleteEventSeries(int id)
{
using (var db = new CalendarDbContext())
{
var eventToDelete = db.EventSeries.First(x => x.Id == id);
db.EventSeries.Remove(eventToDelete);
return(db.SaveChanges() > 0);
}
}
public int AddEventSeries(EventSeries eventSeries)
{
using (var db = new CalendarDbContext())
{
var entity = db.EventSeries.Add(eventSeries);
db.SaveChanges();
return(entity.Entity.Id);
}
}
public SingleEvent UpdateSingleEvent(SingleEvent editedSingleEvent)
{
using (var db = new CalendarDbContext())
{
var entity = db.SingleEvents.Update(editedSingleEvent);
db.SaveChanges();
return(entity.Entity);
}
}
public List <EventSeries> GetEventSeries(DateTime to)
{
using (var db = new CalendarDbContext())
{
// not getting from because it may be starting before
var eventSeries = db.EventSeries.Where(x => x.Start < to).Include(x => x.EditedEvents)
.ToList();
return(eventSeries);
}
}
public CalendarSecurityService
(
IContextAccessor <SiteContext> siteContextAccessor,
IContextAccessor <UserContext> userContextAccessor,
CalendarDbContext calendarDbContext
)
{
_siteContextAccessor = siteContextAccessor;
_userContextAccessor = userContextAccessor;
_calendarDbContext = calendarDbContext;
}
public int AddEventFromSeries(EventFromSeries eventFromSeries)
{
// TODO: MEDIUM : Why not injected and initialized once in scope of request?
// Is it created multiple times if we use a few repository methods?
using (var db = new CalendarDbContext())
{
var entity = db.EditedSeriesEvents.Add(eventFromSeries);
db.SaveChanges();
return(entity.Entity.Id);
}
}
public int ExcludeEventFromSeries(int seriesId, EventFromSeries eventToExclude)
{
using (var db = new CalendarDbContext())
{
var eventSeries = db.EventSeries.Include(x => x.EditedEvents).First(x => x.Id == seriesId);
eventSeries.EditedEvents.Add(eventToExclude);
db.Update(eventSeries);
db.SaveChanges();
return(eventToExclude.Id);
}
}
public GraphQLTab(CalendarDbContext dbContext)
{
Field(x => x.Id);
Field(x => x.Name);
Field(x => x.Logo, nullable: true);
FieldAsync <NonNullGraphType <ListGraphType <NonNullGraphType <GraphQLEvent> > > >("events",
arguments: new QueryArguments(new QueryArgument <IntGraphType> {
Name = "id"
}),
resolve: async context =>
{
return(await dbContext.Events.Where(x => x.TabId == context.Source.Id).ToListAsync());
});
}
private void SeedDb(CalendarDbContext dbContext)
{
if (dbContext.Users.Any() == false)
{
var email = "*****@*****.**";
var user = new User
{
Email = email,
DateCreated = DateTime.Now.ToUniversalTime(),
LastVisitDate = DateTime.Now.ToUniversalTime(),
Phone = "+7 951 111 11 11"
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
}
}
public UpcomingEventsWidgetGroupForm
(
CategoryManager categoryManager,
CalendarDbContext blogDb,
CalendarQueryService calendarQueryService,
CalendarWidgetService calendarWidgetService,
CalendarSecurityService calendarSecurity,
IContextAccessor <UserContext> userContextAccessor
)
{
_calendarDb = blogDb;
_calendarWidgetService = calendarWidgetService;
_calendarQueryService = calendarQueryService;
_calendarSecurity = calendarSecurity;
_categoryManager = categoryManager;
_userContextAccessor = userContextAccessor;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, CalendarDbContext dbContext)
{
app.UseMiniProfiler();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseCors(x => x.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod());
app.UseGraphiQl("/graphiql", "/graphql");
app.UseMvc();
SeedDb(dbContext);
}
public CalendarController
(
SiteContext siteContext,
ConnectDbContext connectDbContext,
CalendarDbContext calendarDbContext,
CalendarWidgetService calendarWidgetService,
CalendarQueryService calendarQueryService
//BlogDocumentService blogDocumentService,
//IFolderManager<BlogPost> blogFolderManager,
//RawHtmlService rawHtmlService
)
{
_siteContext = siteContext;
_calendarDbContext = calendarDbContext;
_connectDbContext = connectDbContext;
_calendarWidgetService = calendarWidgetService;
_calendarQueryService = calendarQueryService;
//_blogDocumentService = blogDocumentService;
//_blogFolderManager = blogFolderManager;
//_rawHtmlService = rawHtmlService;
}
public EventItemUpdatedConsumer(CalendarDbContext calendarDbContext, IHubContext <CalendarHub> calendarHub, IMapper mapper)
{
_calendarDbContext = calendarDbContext;
_calendarHub = calendarHub;
_mapper = mapper;
}
public MembershipPackagesController(CalendarDbContext context)
{
_context = context;
}
public EventsController(CalendarDbContext context)
{
_context = context;
}
public AppointmentDeletedToProjectionEventHandler(CalendarDbContext context)
{
this.context = context;
}
public AppointmentCreatedToProjectEventHandler(CalendarDbContext context)
{
this.context = context;
}
public DbTransactionManager(CalendarDbContext context, ILogger <DbTransactionManager> logger)
{
_context = context;
_logger = logger;
}
public AttachmentService(CalendarDbContext dbContext, IMapper mapper, IStorageProvider storageProvider)
{
this.dbContext = dbContext;
this.mapper = mapper;
this.storageProvider = storageProvider;
}
public AppointmentController(IMapper mapper, CalendarDbContext context)
{
this.mapper = mapper;
this.context = context;
}
public PackagesController(CalendarDbContext context)
{
_context = context;
}
