public OSTicketInstance(string connectionString, IOSTicketOfficalApi osTicketOfficalApi)
{
var optionsBuilder = new DbContextOptionsBuilder <OSTicketContext>();
optionsBuilder.UseMySQL(connectionString);
var osticketContext = new OSTicketContext(optionsBuilder.Options);
OSTicketOfficalApi = osTicketOfficalApi;
Tickets = new TicketRepository(osticketContext);
Users = new UserRepository(osticketContext);
HelpTopics = new HelpTopicsRepository(osticketContext);
}
public OSTicketInstance(string databaseServer, string databaseUsername, string databasePassword, string databaseName, IOSTicketOfficalApi osTicketOfficalApi, int portNumber = 3306)
{
var optionsBuilder = new DbContextOptionsBuilder <OSTicketContext>();
optionsBuilder.UseMySQL($"server={databaseServer};uid={databaseUsername};pwd={databasePassword};database={databaseName};port={portNumber};Convert Zero Datetime=True;");
var osticketContext = new OSTicketContext(new DbContextOptions <OSTicketContext>());
OSTicketOfficalApi = osTicketOfficalApi;
Tickets = new TicketRepository(osticketContext);
Users = new UserRepository(osticketContext);
HelpTopics = new HelpTopicsRepository(osticketContext);
}
public TicketThread(OSTicketContext context, int ticketId)
{
Thread = context.OstThread.FirstOrDefault(o => o.ObjectType == "T" && o.ObjectId == ticketId);
Entries = context.OstThreadEntry.Where(o => o.ThreadId == Thread.Id).OrderBy(o => o.Created).ToList();
Events = context.OstThreadEvent.Where(o => o.ThreadId == Thread.Id).OrderBy(o => o.Timestamp).ToList();
}
public UserRepository(OSTicketContext osticketContext)
{
_osticketContext = osticketContext;
}
public HelpTopicsRepository(OSTicketContext osticketContext)
{
_osticketContext = osticketContext;
}
