public RunningQueryViewModel(SqlQuery baseModel) { Id = baseModel.Id; Sql = baseModel.Sql; Databases = baseModel.Databases; UserId = baseModel.UserId; DateStart = baseModel.DateStart; DateEnd = baseModel.DateEnd; SingleTable = baseModel.SingleTable; Done = DateEnd.HasValue && DateEnd > DateStart; var runningTime = Done ? DateEnd.Value - DateStart : DateTime.Now - DateStart; RunningTime = runningTime.ToString(@"dd\.hh\:mm\:ss"); Results = new List<WorkerResult>(); using (var dbContext = new OctopusDbContext()) { var tmpResults = dbContext .QueryResults .Where(qr => qr.QueryId == Id) .ToList(); foreach (var tmpResult in tmpResults) Results.Add(JsonConvert.DeserializeObject<WorkerResult>(tmpResult.Result)); } }
public static bool IsAdmin(IIdentity identity) { if (!identity.IsAuthenticated) return false; else using (var context = new OctopusDbContext()) return context.Accounts.Where(a => a.Name == identity.Name).First().IsAdmin; }
public static int GetUserId(IIdentity identity) { if (!identity.IsAuthenticated) return 0; else using (var context = new OctopusDbContext()) return context.Accounts.Where(a => a.Name == identity.Name).First().Id; }
/// <summary> /// Get script from script repository by id /// </summary> public static PreparedScript Get(int id) { var dbContext = new OctopusDbContext(); return dbContext .PreparedScripts .Where(s => s.Id == id) .FirstOrDefault(); }
// GET: History public ActionResult Index() { var dbContext = new OctopusDbContext(); int userId = UserHelper.GetUserId(User.Identity); return View(dbContext .Queries .Where(q => q.UserId == userId) .OrderByDescending(q => q.DateStart) ); }
/// <summary> /// ctor -- init data sources collection /// </summary> static Worker() { _locker = new object(); _runners = new List <QueryRunner>(); _databases = new List <WorkerDb>(); using (var dbContext = new OctopusDbContext()) { var dataSources = dbContext.DataSources.ToArray(); foreach (var source in dataSources) { _databases.AddRange(InitHelper.LoadDatabases(source)); } } }
/// <summary> /// ctor -- init data sources collection /// </summary> static Worker() { _locker = new object(); _runners = new List<QueryRunner>(); _databases = new List<WorkerDb>(); using (var dbContext = new OctopusDbContext()) { var dataSources = dbContext.DataSources.ToArray(); foreach (var source in dataSources) { _databases.AddRange(InitHelper.LoadDatabases(source)); } } }
public ActionResult Index(UserQueryViewModel model) { var dbContext = new OctopusDbContext(); var script = PreparedScriptHelper.Get(model.PreparedScriptId); ModelState.Remove("Sql"); if (script != null) { model.Sql = script.Sql; model.Params = PreparedScriptHelper.PrepareParams(script.Sql); } else model.Sql = string.Empty; return View(model); }
/// <summary> /// Get prepared script for View /// </summary> /// <returns></returns> public static List<SelectListItem> GetScripts() { var dbContext = new OctopusDbContext(); var result = new List<SelectListItem>(); result.Add(new SelectListItem() { Value = "0", Text = "( none )" }); result.AddRange(dbContext .PreparedScripts .Select(s => new SelectListItem() { Text = s.Name, Value = s.Id.ToString() })); return result; }
public AccountController() { _dbContext = new OctopusDbContext(); }