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();
}
public SQL(SqlLogic logical, SqlCompare compare, string name, object value)
{
_logical = logical;
_compare = compare;
_name = name;
_value = value;
}
/// <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());
}
