public SQL(SqlLogic logical, SqlCompare compare, string name, object value) { _logical = logical; _compare = compare; _name = name; _value = value; }
public void Execute() { Console.WriteLine("Executing plugin"); var sqlLogic = new SqlLogic(); sqlLogic.CreateConnection(); }
/// <summary> /// Initializes a new instance with the given table and AND/OR logic. /// </summary> /// <param name="root"></param> /// <param name="logic"></param> public DbQueryWhereClause(ISqlTable root, SqlLogic logic) { _root = root; this.Filters = new SqlFilterCollection() { Logic = logic }; }
public ActionResult DeleteConfirmed(int id) { Bug bug = SqlLogic.FindBug(id); string currentProject = bug.Project.ProjectName; SqlLogic.DeleteBugConfirmation(bug); return(RedirectToAction("Index", "Bugs", new { id = currentProject })); }
public ActionResult Edit(Bug bug, int id) { if (ModelState.IsValid) { Bug currentBug = SqlLogic.GetCurrentBug(bug); SqlLogic.EditBug(bug, id); return(RedirectToAction("Index", "Bugs", new { id = currentBug.Project.ProjectName })); } return(View(bug)); }
public ActionResult Create([Bind(Include = "ID,ProjectName,ProjectDescription,ProfileID")] Project project) { if (ModelState.IsValid) { SqlLogic.CreateProject(project); return(RedirectToAction("Index")); } return(View(project)); }
public ActionResult Edit(Project project) { if (ModelState.IsValid) { SqlLogic.EditProject(project); return(RedirectToAction("Index")); } return(View(project)); }
public ActionResult Create([Bind(Include = "BugName,Priority,BugDescription,Status,ProjectID")] Bug bug, string id) { if (ModelState.IsValid) { SqlLogic.CreateBug(bug, id); return(RedirectToAction("Index", "Bugs", new { id = id })); } return(View(bug)); }
public void RunImmediateBatchCreationTest() { using (var logic = new MessagesModuleLogic(new MessageContext(Settings.MessageContextConnectionString))) { using (var sqlLogic = new SqlLogic(new SqlConnectionFactory(Settings.SqlConnectionString))) { using (var Bcm = BatchCreationManager.NewInstance(new DateTime(2016, 9, 3), new DateTime(2016, 9, 5), sqlLogic, logic)) { //TASK_PROTOTYPE.RunImmediateBatchCreation(logic.Get<tblMessageSchedule>(1), 1, sqlLogic, logic); } } } }
// GET: Projects/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Project project = SqlLogic.FindProject(id); if (project == null) { return(HttpNotFound()); } return(View(project)); }
// GET: Bugs/Delete public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Bug bug = SqlLogic.FindBug(id); if (bug == null) { return(HttpNotFound()); } return(View(bug)); }
public void CollectTest() { using (var logic = new MessagesModuleLogic(new MessageContext(Settings.MessageContextConnectionString))) { using (var sqlLogic = new SqlLogic(new SqlConnectionFactory(Settings.SqlConnectionString))) { using (var Bcm = BatchCreationManager.NewInstance(new DateTime(2016, 9, 3), new DateTime(2016, 9, 5), sqlLogic, logic)) { Bcm.DontMakeTimeStamp(); var sced = logic.Get <tblMessageSchedule>(1); var Collector = new MessageDataCollector(Bcm); var result = Collector.Collect(sced); } } } }
public void BigTask_Example() { using (var logic = new MessagesModuleLogic(new MessageContext(Settings.MessageContextConnectionString))) { using (var sqlLogic = new SqlLogic(new SqlConnectionFactory(Settings.SqlConnectionString))) { using (var manager = NewInstance(new DateTime(2015, 9, 3), new DateTime(2017, 9, 5), sqlLogic, logic)) { var shedules = manager.GetActualMessageSchedules(); var creator = new BatchCreator(manager); var results = new List <BatchCreationResult>(); foreach (var sched in shedules) { results.Add(creator.CreateBatch(sched, 0)); } //manager.SaveResultsToDB(results); } } } }
public void RenderWhere(IEnumerable <ISqlFilter> filters, SqlLogic logic, SqlBuildArguments args) { if (filters == null) { throw new ArgumentNullException("filters"); } if (args == null) { throw new ArgumentNullException("args"); } var items = filters.ToArray(); if (items.Length > 0) { this.WriteWhere(); this.RenderAll(items, args, string.Concat(SqlConstants.SPACE, ConvertSqlLogicToString(logic), SqlConstants.SPACE)); } }
// GET: Bugs public ActionResult Index(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } // If project does not exist, throw 404 error var project = db.Projects.Where(p => p.ProjectName == id).ToList(); if (project.Count == 0) { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } List <Bug> allBugs = SqlLogic.GetBugsForCurrentProject(id).OrderBy(x => x.Status).ToList(); return(View(allBugs)); }
public virtual string ConvertLogicToString(SqlLogic logic) { return(ConvertSqlLogicToString(logic)); }
public virtual void WriteLogic(SqlLogic logic) { this.Write(logic.ToString().ToUpper()); }
// Returns only normal priority bugs for current project public ActionResult NormalPriority(string id) { List <Bug> normalBugs = SqlLogic.GetPriorityBugs("Normal", id).OrderBy(x => x.Status).ToList(); return(View("Index", normalBugs)); }
// Returns only low priority bugs for current project public ActionResult LowPriority(string id) { List <Bug> lowBugs = SqlLogic.GetPriorityBugs("Low", id).OrderBy(x => x.Status).ToList(); return(View("Index", lowBugs)); }
// Returns only low priority bugs for current project public ActionResult ImmediatePriority(string id) { List <Bug> immediateBugs = SqlLogic.GetPriorityBugs("Immediate", id).OrderBy(x => x.Status).ToList(); return(View("Index", immediateBugs)); }
// Returns only high priority bugs for current project public ActionResult HighPriority(string id) { List <Bug> highBugs = SqlLogic.GetPriorityBugs("High", id).OrderBy(x => x.Status).ToList(); return(View("Index", highBugs)); }
// GET: Projects public ActionResult Index() { List <Project> userProjects = SqlLogic.GetUserProjects(); return(View(userProjects)); }
public ActionResult DeleteConfirmed(int id) { SqlLogic.DeleteProjectConfirmation(id); return(RedirectToAction("Index")); }
// Sorts bug list where most recent bugs are before older ones public ActionResult SortByRecent(string id) { List <Bug> allBugs = SqlLogic.SortBugsByRecent(id).OrderBy(x => x.Status).ToList(); return(View("Index", allBugs)); }
// Sorts bug list by priority. Order is low, normal, high, then immediate public ActionResult SortByPriority(string id) { IOrderedEnumerable <Bug> sortedByPriority = SqlLogic.SortBugsByPriority(id); return(View("Index", sortedByPriority)); }
public static string ConvertSqlLogicToString(SqlLogic logic) { return(logic.ToString().ToUpper()); }