private void FunctionSwitcher(string SelectedFunctionName) { UserControl usc; switch (SelectedFunctionName) { case "Create": usc = new CreateView(); break; case "Update": usc = new UpdateView(); usc.DataContext = new CategoryViewModel { SelectedCategoryId = this.SelectedCategoryId }; break; case "Delete": DeleteCategory(); usc = new CategoryView(); break; default: usc = new CategoryView(); break; } ; Session.Instance.SetNextView(usc); }
internal void SendCreateView(string schema, string name, string definer, ViewAlgorithm algorithm, ViewSqlSecurity security, ViewCheckOption check, string[] columns, bool replace, QueryStatement queryStatement) { var builder = new CreateView(); builder.Collection = ExprUtil.BuildCollection(schema, name); builder.Definer = definer; builder.Algorithm = algorithm; builder.Security = security; builder.Check = check; if (columns != null && columns.Length > 0) { foreach (string column in columns) { builder.Column.Add(column); } } if (queryStatement != null) { builder.Stmt = CreateFindMessage(queryStatement.schema, queryStatement.collection, queryStatement.isRelational, queryStatement.filter, queryStatement.findParams); } builder.ReplaceExisting = replace; _writer.Write((int)ClientMessages.Types.Type.CrudCreateView, builder); }
public T GetView <T>(ViewTypes type) where T : Control { T result = default(T); switch (type) { case ViewTypes.Clone: result = new CloneView(_messenger, _shell, _storage, _web) as T; break; case ViewTypes.Create: result = new CreateView(_git, _messenger, _shell, _storage, _web) as T; break; case ViewTypes.Login: result = new LoginView(_messenger, _shell, _storage, _web) as T; break; case ViewTypes.CreateSnippet: result = new CreateSnippet(_messenger, _shell, _storage, _web) as T; break; default: break; } return(result); }
public CreateView GenerateCreateViewStatement(View v) { CreateView cv = new CreateView(); cv.View = v; return(cv); }
public QuartzViewController(CreateView creator, string nib, string title, string info) : this(nib, null) { this.create = creator; DemoTitle = title; DemoInfo = info; }
public async Task <ActionResult> UserCreate(CreateView ViewMessage) { UserDb UserSession = (UserDb)Session["User"]; if (ViewMessage.UserDbId == UserSession.Id) { var user = await db.Users.FirstOrDefaultAsync(f => f.Id == UserSession.Id); MessageDb Message = new MessageDb(); Message.UserDbId = ViewMessage.UserDbId; Message.Company = ViewMessage.Company; Message.Subject = ViewMessage.Subject; Message.Message = ViewMessage.Message; Message.FullName = user.FirstName + " " + user.LastName; Message.Phone = user.PhoneNumber; Message.CreateDate = DateTime.Now; Message.FromMail = user.Mail; Message.ToMail = "kenanbagirov14gmail.com"; Message.Read = true; db.Messages.Add(Message); await db.SaveChangesAsync(); return(RedirectToAction("UserIndexMsg", new { id = UserSession.Id })); } else { return(RedirectToAction("Index", "MyAccount")); } }
public void SetController(PackageController controller) { IndexView.SetController(controller); CreateView.SetController(controller); EditView.SetController(controller); DetailView.SetController(controller); DeleteView.SetController(controller); }
public string GenerateCreateViewScript(CreateView CreateViewStatement) { string Tmp = "drop view dbo." + CreateViewStatement.View.Name + Environment.NewLine; Tmp += CreateViewStatement.View.Body; return(Tmp); }
public override void EnterState() { MaterialColorController.Instance.SetUp(); createView = stateController.AppViews.CreateView; createView.OnNextButton += SetNextCannonPart; createView.OnPreviousButton += SetPreviousCannonPart; createView.OnSaveButton += SaveButtonClicked; createView.OnMenuButton += MenuButtonClicked; createView.SubscribeToViewActions(); createView.DisplayView(true); }
public void OpenCreateView(MapData data = null) { if (createView != null) { createView.OpenPanel(data); } else { createView = new CreateView(canvas.transform, data); } mainViewGameObject.SetActive(false); }
protected override void OnInit(EventArgs e) { string culture = Request.QueryString["culture"]; if (!string.IsNullOrEmpty(culture)) { Thread.CurrentThread.CurrentCulture = new CultureInfo(culture); } string uiCulture = Request.QueryString["uiculture"]; if (!string.IsNullOrEmpty(uiCulture)) { Thread.CurrentThread.CurrentUICulture = new CultureInfo(uiCulture); } base.OnInit(e); if (!IsPostBack) { List <int> invalidRowIds; if (UrlTrackerRepository.HasInvalidEntries(out invalidRowIds)) { ltlError.Text = string.Format(UrlTrackerResources.ErrorMessageOldUrlAndOldRegexEmpty, string.Join(", ", invalidRowIds)); lbDeleteErrorRows.Text = UrlTrackerResources.ErrorMessageOldUrlAndOldRegexEmptyButton; mvUrlTrackerError.SetActiveView(vwUrlTrackerErrorMessage); odsUrlTrackerEntries.Selecting += odsUrlTrackerEntries_Selecting; } gvUrlTracker.Sort("Inserted", SortDirection.Descending); gvNotFound.Sort("NotFoundCount", SortDirection.Descending); } if (!_earlyErrorDetected) { pnlBreadcrumb.Visible = false; if (icAutoView == null) { icAutoView = (AutoView)LoadControl("~/Umbraco/UrlTracker/InfoCaster.Umbraco.UrlTracker.UI.UserControls.AutoView.ascx"); icCustomView = (CustomView)LoadControl("~/Umbraco/UrlTracker/InfoCaster.Umbraco.UrlTracker.UI.UserControls.CustomView.ascx"); icNotFoundView = (NotFoundView)LoadControl("~/Umbraco/UrlTracker/InfoCaster.Umbraco.UrlTracker.UI.UserControls.NotFoundView.ascx"); icAdvancedView = (AdvancedView)LoadControl("~/Umbraco/UrlTracker/InfoCaster.Umbraco.UrlTracker.UI.UserControls.AdvancedView.ascx"); icCreateView = (CreateView)LoadControl("~/Umbraco/UrlTracker/InfoCaster.Umbraco.UrlTracker.UI.UserControls.CreateView.ascx"); pnlEditValidationGroup.Controls.AddAt(0, icAutoView); pnlEditValidationGroup.Controls.AddAt(1, icCustomView); pnlEditValidationGroup.Controls.AddAt(2, icNotFoundView); pnlEditValidationGroup.Controls.AddAt(3, icAdvancedView); pnlCreateValidationGroup.Controls.AddAt(0, icCreateView); } } }
public RectanglesAndInputs(int n) { this.n = n; input_list = new List <TextBox>(); output_list = new List <TextBox>(); rectangles_list = new List <List <Rectangles> >(); floors = Convert.ToInt32(2 * Math.Log((double)n, 2) - 1); rtag = new int[floors - 1, n]; inports = new int[floors, n]; outports = new int[floors, n]; swtichs = new int[floors, n / 2]; benes = new Benes(); view = new CreateView(n, input_list, output_list, rectangles_list); }
public RectanglesAndInputs(int n) { this.n = n; input_list = new List<TextBox>(); output_list = new List<TextBox>(); rectangles_list = new List<List<Rectangles>>(); floors = Convert.ToInt32(2 * Math.Log((double)n, 2) - 1); rtag = new int[floors - 1, n]; inports = new int[floors, n]; outports = new int[floors, n]; swtichs = new int[floors, n / 2]; benes = new Benes(); view = new CreateView(n, input_list, output_list, rectangles_list); }
public ActionResult Create(CreateView reservation, int?id) { if (ModelState.IsValid) { var misafir = new guest(); Random rnd = new Random(); int num = rnd.Next(1, 10000); misafir.id = num; misafir.e_mail = reservation.e_mail; misafir.first_name = reservation.first_name; misafir.last_name = reservation.last_name; misafir.phone_number = reservation.phone_number; db.guest.Add(misafir); db.SaveChanges(); var rezervasyon = new reservation(); int generated = rezervasyon.GetHashCode(); rezervasyon.id = generated; rezervasyon.guest_id = num; rezervasyon.date_in = DateTime.Now; rezervasyon.date_out = DateTime.Now.AddDays(10); rezervasyon.status = "true"; rezervasyon.made_by = reservation.first_name + " " + reservation.last_name; db.reservation.Add(rezervasyon); db.SaveChanges(); //Database kayıt işlemi //db.Entry(reservation).State = EntityState.Modified; //oda durumunun değiştiği yer var room = db.room.Find(id); room.status = "false"; db.SaveChanges(); return(RedirectToAction("Create", "CreditCards", new { id = id })); } return(View()); }
public override View GetView(int position, View convertView, ViewGroup parent) { T item = this[position]; if (convertView == null) { convertView = CreateView.Invoke(parent); } var dataContextProperty = convertView.GetType().GetProperties().FirstOrDefault(i => i.Name.Equals("DataContext")); if (dataContextProperty != null) { dataContextProperty.SetValue(convertView, item); } return(convertView); }
public override View GetView(int position, View convertView, ViewGroup parent) { // The convertView is the previous View at that position (if there is one). // So that means if something was inserted at the top, the convertView would be off by one index. // We could theoretically assign the new data context on each one, but that means there would // be O(N) changes to the data context of each. // Alternatively, we can cache mappings between the item and its convertView, and return the corresponding // view if it exists, and otherwise create and map it. That should be O(1). // However, the convertView is also used for recycling views when scrolling through long lists... // So theoretically, as we scroll down, the item's view at the top would end up appearing for an item further down, // which we wouldn't return, and instead we would create a new one, and the top item's view would lose its reference. // Best design would probably have a ViewWithDataContext, and then assign DataContext on them. // We could also support options for keeping all views loaded. if (CreateView == null) { throw new NullReferenceException("CreateView function cannot be null."); } var dataItem = this[position]; var cachedView = GetCachedView(dataItem); if (cachedView != null) { return(cachedView); } var newView = CreateView.Invoke(parent, dataItem); CacheCreatedView(dataItem, newView); return(newView); }
public ActionResult Create(CreateView reservation, int?id) { if (ModelState.IsValid) { var misafir = new guest(); misafir.id = 45; misafir.e_mail = reservation.e_mail; misafir.first_name = reservation.first_name; misafir.last_name = reservation.last_name; misafir.phone_number = reservation.phone_number; db.guests.Add(misafir); db.SaveChanges(); var rezervasyon = new reservation(); rezervasyon.date_in = DateTime.Now; rezervasyon.date_out = DateTime.Now.AddDays(10); rezervasyon.guest_id = misafir.id; rezervasyon.status = "true"; rezervasyon.made_by = reservation.first_name + " " + reservation.last_name; db.reservations.Add(rezervasyon); db.SaveChanges(); //Database kayıt işlemi //db.Entry(reservation).State = EntityState.Modified; //oda durumunun değiştiği yer var room = db.rooms.Find(id); room.status = "false"; db.SaveChanges(); return(RedirectToAction("Index", "Home")); } return(View()); }
public CreateTodoListCommand(CreateView toCreate) { _toCreate = toCreate; }
public Expression GetNode(ExpressionParser parser) { Lexem lex = parser.Collection.CurrentLexem(); Expression res = null; if (lex.LexemType == LexType.Command) { string lowerLexem = lex.LexemText.ToLower(); if (ParserUtils.ParseCommandPhrase(parser.Collection, "create view", false, false)) { res = new CreateView(); } if (ParserUtils.ParseCommandPhrase(parser.Collection, "create table", false, false)) { res = new CreateTable(); } if (res == null && ParserUtils.ParseCommandPhrase(parser.Collection, "alter table", false, false)) { res = new AlterTable(); } if (res == null && ParserUtils.ParseCommandPhrase(parser.Collection, "drop table", false, false)) { res = new DropTable(); } if (res == null && ParserUtils.ParseCommandPhrase(parser.Collection, "drop index", false, false)) { res = new DropIndex(); } if (res == null && (ParserUtils.ParseCommandPhrase(parser.Collection, "create unique index", false, false) || ParserUtils.ParseCommandPhrase(parser.Collection, "create index", false, false))) { res = new CreateIndex(); } if (res == null) { if (parser.Collection.GetNext() != null && parser.Collection.GetNext().IsSkobraOpen()) { switch (lowerLexem) { case "count": res = new CountExpr(); break; case "sum": res = new SumExpr(); break; case "min": res = new MinExpr(); break; case "max": res = new MaxExpr(); break; case "avg": res = new AvgExpr(); break; case "lastinsertrowid": res = new LastInsertRowidExpr(); break; case "exists": res = new ExistsExpr(); break; case "any": res = new AnyExpr(); break; } } switch (lowerLexem) { case "between": //не функция res = new Between(); break; case "select": res = new SelectExpresion(); break; case "update": res = new UpdateStatement(); break; case "insert": res = new InsertStatement(); break; case "delete": res = new DeleteStatement(); break; } } } if (res != null) { return(res); } return(res); }
public QuartzViewController(CreateView creator, string title, string info) : this(creator, "DemoView", title, info) { }
public QuartzViewController(CreateView creator, string title, string info) : this(creator, "QuartzViewController", title, info) { }
//打开操作 public void OpenProject(string filename) { try { FileStream openfile = new FileStream(filename, FileMode.Open); StreamReader sr = new StreamReader(openfile); string line = sr.ReadLine(); int num = Convert.ToInt32(line); this.n = num; this.input_list = new List<TextBox>(); this.output_list = new List<TextBox>(); this.rectangles_list = new List<List<Rectangles>>(); this.floors = Convert.ToInt32(2 * Math.Log((double)n, 2) - 1); this.rtag = new int[floors - 1, n]; this.inports = new int[floors, n]; this.outports = new int[floors, n]; this.swtichs = new int[floors, n / 2]; for (int i = 0; i < n; i++) { input_list.Add(new TextBox()); output_list.Add(new TextBox()); } for (int i = 0; i < n / 2; i++) { List<Rectangles> rect_list = new List<Rectangles>(); for (int j = 0; j < floors; j++) { rect_list.Add(new Rectangles()); } rectangles_list.Add(rect_list); } line = sr.ReadLine(); for (int i = 0; i < n; i++) { line = sr.ReadLine(); input_list[i].Text = line; } line = sr.ReadLine(); for (int i = 0; i < floors - 1; i++) { for (int j = 0; j < n ; j++) { line = sr.ReadLine(); rtag[i, j] = Convert.ToInt32(line); } } line = sr.ReadLine(); for (int i = 0; i < n; i++) { line = sr.ReadLine(); output_list[i].Text = line; } line = sr.ReadLine(); for (int i = 0; i < floors; i++) { for (int j = 0; j < n / 2; j++) { line = sr.ReadLine(); swtichs[i, j] = Convert.ToInt32(line); } } sr.Close(); this.benes = new Benes(); ShowSave(n, rtag); this.view = new CreateView(n, input_list, output_list, rectangles_list); } catch (Exception) { throw; } }
public QuartzBlendingViewController(CreateView creator, string title, string info) : base(creator, "QuartzBlendingViewController", title, info) { Array.Sort(Colors, ColorSortByLuminance); }
private void CreateClick(object sender, MouseButtonEventArgs e) { DataContext = new CreateView(); }
public CreateCtrl(CreateView view) { this.view = view; mapConst = new MapConst(); //Tool.SaveJsonToFile(JsonMapper.ToJson(mapConst.itemConfigs), "mapConst"); }
public CreatePresenter(CreateView createView, int width, int height) { GridHeight = height; GridWidth = width; _createView = createView; var grid = new GridControlView(); var gridPresenter = new GridPresenter(grid, false, true, GridWidth, GridHeight); var columnsLabels = new CountColumnView(); var columnPresenter = new CountColumnPresenter(columnsLabels, gridPresenter.TilesGrid, true); var rowsLabels = new CountRowView(); var rowPresenter = new CountRowPresenter(rowsLabels, gridPresenter.TilesGrid, true); gridPresenter.RowPresenter = rowPresenter; gridPresenter.ColumnPresenter = columnPresenter; List <int>[] rows = new List <int> [GridHeight]; List <int>[] columns = new List <int> [GridWidth]; for (int i = 0; i < GridHeight; i++) { rows[i] = new List <int>(); rows[i].Add(0); } for (int i = 0; i < GridWidth; i++) { columns[i] = new List <int>(); columns[i].Add(0); } columnPresenter.Counts = columns; rowPresenter.Counts = rows; gridPresenter.RowsCounts = rows; gridPresenter.ColumnsCounts = columns; var location = grid.Location; grid.Location = new System.Drawing.Point(location.X + 100, location.Y + 100); location = grid.Location; columnsLabels.Location = new System.Drawing.Point(location.X, location.Y - 100); rowsLabels.Location = new System.Drawing.Point(location.X - 100, location.Y); _createView.GridPanel.Width = GridWidth * Tile.Width + 100; _createView.GridPanel.Height = GridHeight * Tile.Height + 100; _createView.GridPanel.Controls.Add(grid); _createView.GridPanel.Controls.Add(columnsLabels); _createView.GridPanel.Controls.Add(rowsLabels); _createView.Save.Click += (s, e) => { Game newGame = new Game() { ColumnsLabels = gridPresenter.ColumnPresenter.Counts, RowsLabels = gridPresenter.RowPresenter.Counts, Difficulty = _createView.Difficulty.Text, Height = GridHeight, Width = GridWidth, Title = _createView.Title.Text }; using (System.Windows.Forms.SaveFileDialog dialog = new SaveFileDialog()) { dialog.Filter = "Json files (*.json)|*.json"; dialog.FilterIndex = 2; dialog.RestoreDirectory = true; if (dialog.ShowDialog() == DialogResult.OK) { System.IO.StreamWriter file = new System.IO.StreamWriter(dialog.FileName.ToString()); var stringJson = JsonConvert.SerializeObject(newGame); file.WriteLine(stringJson); file.Close(); } } }; }
static void Main(string[] args) { var service = new CovidDbService(CovidDatabaseSettings.DatabaseSettings); StatisticsView statView = new StatisticsView(); CreateView createView = new CreateView(); //var service = new CitizenService(CovidDatabaseSettings.DatabaseSettings); //var citizens=service.GetCitizens(); //int id=citizens.First().ID; //service.AddTest(new Test { Date = DateTime.Now, Res = "pos", Status = "Fine" },id); //citizens = service.GetCitizens(); //foreach(var cit in citizens) //{ // Console.WriteLine($"Citizen:\n Name: {cit.FirstName}, Muni: {cit.Muni}"); // Console.WriteLine("Tests:"); // foreach(var test in cit.Tests) // { // Console.WriteLine($"Test result: {test.Res}, Test date: {test.Date}"); // } //} bool finish = false; do { Console.Clear(); Console.WriteLine("***** Velkommen til Covid19 tracking app ***** \n" + "\n Følgende muligheder er tilgængelige: \n - Exit \n - Vis antal aktive Covid19 patienter per kommune" + "\n - Se deataljeret statistik over smittede baseret på aldersgruppe og køn \n - Udregn mulige smittede ved nyeste smittetilfælde" + "\n - Tilføj nyt smittetilfælde, testcenter, testsag eller ny lokation" + "\n "); Console.WriteLine(" Indtast et af de følgende bogstaver for at åbne en mulighed: \n E = exit " + "\n A = Aktive pr. kommune \n S = Åben statistik \n U = Mulige nye smittede \n N = Tilføj data "); string input = Console.ReadLine(); if (string.IsNullOrEmpty(input)) { continue; } switch (input[0]) { case 'E': finish = true; // exit break; case 'A': //Calculate the number of active Covid19 cases - a person is infected 14 days after a positive //test. Results should be shown per Municipality. var totalInfected = service.GetAllCurrentlyInfected(); Console.WriteLine("Total antal smittede: {0}", totalInfected.Count); // udskriv per municipality Dictionary <int, int> muniDictionary = new Dictionary <int, int>(); foreach (var cit in totalInfected) { bool added = muniDictionary.TryAdd(cit.Muni, 1); if (!added) { muniDictionary.TryGetValue(cit.Muni, out var currentCount); muniDictionary[cit.Muni] = currentCount + 1; } } Console.WriteLine("\n Kommune: Antal smittede:"); foreach (KeyValuePair <int, int> kvp in muniDictionary) { Console.WriteLine(" {0}, {1} ", kvp.Key, kvp.Value); } Console.WriteLine("Tryk på en knap for at vælge en ny mulighed"); Console.ReadKey(); break; case 'S': // åben stat menu statView.OpenStatMenu(); break; case 'U': //Given a new infected citizen, “calculate” which other citizen may be infected . Console.WriteLine("Indtast id på smittet person."); string citId = Console.ReadLine(); if (string.IsNullOrEmpty(citId)) { continue; } var possibleInfectedList = service.GetPossibleInfected(int.Parse(citId)); Console.WriteLine("\n Muligt smittede borgere: "); foreach (var cit in possibleInfectedList) { Console.WriteLine($"Test result: {cit.FirstName}, Test date: {cit.LastName}"); } Console.WriteLine("Tryk på en knap for at vælge en ny mulighed"); Console.ReadKey(); break; case 'N': //åben create menu createView.OpenCreateMenu(); break; default: break; } } while (!finish); }
//打开操作 public void OpenProject(string filename) { try { FileStream openfile = new FileStream(filename, FileMode.Open); StreamReader sr = new StreamReader(openfile); string line = sr.ReadLine(); int num = Convert.ToInt32(line); this.n = num; this.input_list = new List <TextBox>(); this.output_list = new List <TextBox>(); this.rectangles_list = new List <List <Rectangles> >(); this.floors = Convert.ToInt32(2 * Math.Log((double)n, 2) - 1); this.rtag = new int[floors - 1, n]; this.inports = new int[floors, n]; this.outports = new int[floors, n]; this.swtichs = new int[floors, n / 2]; for (int i = 0; i < n; i++) { input_list.Add(new TextBox()); output_list.Add(new TextBox()); } for (int i = 0; i < n / 2; i++) { List <Rectangles> rect_list = new List <Rectangles>(); for (int j = 0; j < floors; j++) { rect_list.Add(new Rectangles()); } rectangles_list.Add(rect_list); } line = sr.ReadLine(); for (int i = 0; i < n; i++) { line = sr.ReadLine(); input_list[i].Text = line; } line = sr.ReadLine(); for (int i = 0; i < floors - 1; i++) { for (int j = 0; j < n; j++) { line = sr.ReadLine(); rtag[i, j] = Convert.ToInt32(line); } } line = sr.ReadLine(); for (int i = 0; i < n; i++) { line = sr.ReadLine(); output_list[i].Text = line; } line = sr.ReadLine(); for (int i = 0; i < floors; i++) { for (int j = 0; j < n / 2; j++) { line = sr.ReadLine(); swtichs[i, j] = Convert.ToInt32(line); } } sr.Close(); this.benes = new Benes(); ShowSave(n, rtag); this.view = new CreateView(n, input_list, output_list, rectangles_list); } catch (Exception) { throw; } }
private async void toolStripMenuItem2_Click(object sender, EventArgs e) { var node = (TreeNode)this.menuMenus.Tag; if (node == null) { return; } if (node.Text.Equals("TABLES")) { this.TableCreate = new TableCreate(true, string.Empty); if (TableCreate.ShowDialog() == DialogResult.OK) { try { var result = await this.controller.ExecuteConsult(TableCreate.Query); if (result == 0) { this.treeViewDataConecction.Nodes.Clear(); var nodes = (await this.controller.GethTreeNodes()).ToArray(); this.treeViewDataConecction.Nodes.AddRange(nodes); MessageBox.Show("The table was crate suscefully"); } else { MessageBox.Show("Not was create the table"); } } catch (Exception exc) { MessageBox.Show("Internal error:" + exc.Message); } } } else if (node.Text.Equals("VIEWS")) { this.CreateView = new CreateView(true, string.Empty); if (this.CreateView.ShowDialog() == DialogResult.OK) { try { var query = this.CreateView.Sql; var result = await this.controller.ExecuteConsult(query); if (result == 0) { this.treeViewDataConecction.Nodes.Clear(); var nodes = (await this.controller.GethTreeNodes()).ToArray(); this.treeViewDataConecction.Nodes.AddRange(nodes); MessageBox.Show("The view was crate suscefully"); } else { MessageBox.Show("Not was create the view"); } } catch (Exception) { MessageBox.Show("Internal error"); } } } else if (node.Text.Equals("TRIGGERS")) { this.CreateTrigger = new CreateTrigger(true, string.Empty, this.controller.datab); if (this.CreateTrigger.ShowDialog() == DialogResult.OK) { try { var query = this.CreateTrigger.Sql; var result = await this.controller.ExecuteConsult(query); if (result == 0) { this.treeViewDataConecction.Nodes.Clear(); var nodes = (await this.controller.GethTreeNodes()).ToArray(); this.treeViewDataConecction.Nodes.AddRange(nodes); MessageBox.Show("The trigger was crate suscefully"); } else { MessageBox.Show("Not was create the trigger"); } } catch (Exception exc) { MessageBox.Show("Internal error:" + exc.Message); } } } else if (node.Text.Equals("INDEXS")) { var nodeP = node.Parent; if (nodeP == null) { return; } this.CreateIndex = new CreateIndex(true, "", this.controller.datab, nodeP.Text); if (this.CreateIndex.ShowDialog() == DialogResult.OK) { try { var query = this.CreateIndex.Sql; var result = await this.controller.ExecuteConsult(query); if (result == 0) { this.treeViewDataConecction.Nodes.Clear(); var nodes = (await this.controller.GethTreeNodes()).ToArray(); this.treeViewDataConecction.Nodes.AddRange(nodes); MessageBox.Show("The index was crate suscefully"); } else { MessageBox.Show("Not was create the index"); } } catch (Exception esx) { MessageBox.Show("Internal error:" + esx.Message); } } } }
private async void testToolStripMenuItem_Click(object sender, EventArgs e) { var node = (TreeNode)this.menuElements.Tag; if (node == null) { return; } var parent = (TreeNode)node.Parent; if (parent == null) { return; } if (parent.Text.Equals("TABLES")) { var table = this.controller.datab.Tables.Find(x => x.TableName.Equals(node.Text)); if (table == null) { return; } this.AlterTable = new AlterTable(table, await this.controller.GetSQliteConecction()); this.AlterTable.ShowDialog(); } else if (parent.Text.Equals("VIEWS")) { string querys = $"select * from sqlite_master where name = '{node.Text}' and type = 'view'"; var results = await this.controller.Consulta(querys); var c = $"drop view {node.Text} ; \n \n"; while (results.Read()) { c += results["sql"].ToString(); } this.CreateView = new CreateView(false, c); if (this.CreateView.ShowDialog() == DialogResult.OK) { try { var query = this.CreateView.Sql; var result = await this.controller.ExecuteConsult(query); if (result == 0) { this.treeViewDataConecction.Nodes.Clear(); var nodes = (await this.controller.GethTreeNodes()).ToArray(); this.treeViewDataConecction.Nodes.AddRange(nodes); MessageBox.Show("The view was edited suscefully"); } else { MessageBox.Show("Not was edited the view"); } } catch (Exception ews) { MessageBox.Show("Internal error: \n" + ews.Message); } } } else if (parent.Text.Equals("TRIGGERS")) { string querys = $"select * from sqlite_master where name = '{node.Text}' and type = 'trigger'"; var results = await this.controller.Consulta(querys); var c = ""; var drop = $"drop trigger {node.Text} ; \n \n"; while (results.Read()) { c += results["sql"].ToString(); } this.manualQuerys.Text = c; this.AlterTrigger = new AlterTrigger(c); if (this.AlterTrigger.ShowDialog() == DialogResult.OK) { try { var query = this.AlterTrigger.Sql; await this.controller.ExecuteConsult(drop); var result = await this.controller.ExecuteConsult(query); if (result == 0) { this.treeViewDataConecction.Nodes.Clear(); var nodes = (await this.controller.GethTreeNodes()).ToArray(); this.treeViewDataConecction.Nodes.AddRange(nodes); MessageBox.Show("The trigger was edited suscefully"); } else { MessageBox.Show("Not was edited the view"); } } catch (Exception ews) { MessageBox.Show("Internal error: \n" + ews.Message); } } } else { } }
protected void InvokeCreateViewEvent(object derivedSender, ViewModelEventArgs e) { CreateView?.Invoke(derivedSender, e); }
public void Create() { var view = new CreateView(); Render(view); }
public QuartzBlendingViewController (CreateView creator, string title, string info) : base (creator, "QuartzBlendingViewController", title, info) { Array.Sort (Colors, ColorSortByLuminance); }
public ShellPresenter(ShellFormView view) { _view = view; var gridControlView = new GridControlView(); var countColumnView = new CountColumnView(); var countRowView = new CountRowView(); var gridPresenter = new GridPresenter(gridControlView, true, false, 10, 10); var columnPresenter = new CountColumnPresenter(countColumnView, gridPresenter.TilesGrid, false); var rowPresenter = new CountRowPresenter(countRowView, gridPresenter.TilesGrid, false); gridPresenter.RowsCounts = rowPresenter.Counts; gridPresenter.ColumnsCounts = columnPresenter.Counts; var grid = gridPresenter.TilesGrid; for (int i = 0; i < grid.Height; i++) { for (int j = 0; j < grid.Width; j++) { grid.Tiles[i, j].Selected = false; } } int meshWidth = gridControlView.Width; int meshHeight = gridControlView.Height; int X = (_view.GridWrapper.Width - meshWidth) / 2; int Y = (_view.GridWrapper.Height - meshHeight) / 2; gridControlView.Location = new Point(X, Y); countColumnView.Location = new Point(X, Y - 100); countRowView.Location = new Point(X - 100, Y); _view.GridWrapper.Controls.Add(gridControlView); _view.GridWrapper.Controls.Add(countRowView); _view.GridWrapper.Controls.Add(countColumnView); _view.CreatePuzzleSubMenuItem.Click += (s, e) => { var sizeDialog = new SizeDialogBoxView(); int height = 0, width = 0; if (sizeDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { _view.GridWrapper.Controls.Clear(); height = sizeDialog.GridHeight; width = sizeDialog.GridWidth; var createView = new CreateView(); var presenter = new CreatePresenter(createView, width, height); presenter.GridWidth = width; presenter.GridHeight = height; createView.Enabled = true; createView.Location = new Point(0, 0); _view.GridWrapper.Controls.Add(createView); } }; _view.LoadSubMenuItem.Click += (s, e) => { Stream myStream = null; OpenFileDialog theDialog = new OpenFileDialog(); theDialog.Title = "Open Puzzle JSON File"; theDialog.Filter = "Json files (*.json)|*.json"; theDialog.InitialDirectory = @"C:\"; if (theDialog.ShowDialog() == DialogResult.OK) { try { if ((myStream = theDialog.OpenFile()) != null) { StreamReader sr = new StreamReader(myStream); string text = sr.ReadToEnd(); Game newGame;// = new Game(); using (myStream) { newGame = (Game)JsonConvert.DeserializeObject <Game>(text); } _view.GridWrapper.Controls.Clear(); gridControlView = new GridControlView(); countColumnView = new CountColumnView(); countRowView = new CountRowView(); gridPresenter = new GridPresenter(gridControlView, false, false, newGame.Width, newGame.Height, newGame.RowsLabels, newGame.ColumnsLabels); columnPresenter = new CountColumnPresenter(countColumnView, gridPresenter.TilesGrid, false); rowPresenter = new CountRowPresenter(countRowView, gridPresenter.TilesGrid, false); gridPresenter.ColumnPresenter = columnPresenter; gridPresenter.ColumnPresenter.Counts = newGame.ColumnsLabels; gridPresenter.RowPresenter = rowPresenter; gridPresenter.RowPresenter.Counts = newGame.RowsLabels; gridPresenter.RowsCounts = newGame.RowsLabels; gridPresenter.ColumnsCounts = newGame.ColumnsLabels; gridPresenter.ColumnPresenter.Draw(); gridPresenter.RowPresenter.Draw(); grid = gridPresenter.TilesGrid; for (int i = 0; i < grid.Height; i++) { for (int j = 0; j < grid.Width; j++) { grid.Tiles[i, j].Selected = false; } } int meshWidth = gridControlView.Width; int meshHeight = gridControlView.Height; int X = (_view.GridWrapper.Width - meshWidth) / 2; int Y = (_view.GridWrapper.Height - meshHeight) / 2; gridControlView.Location = new Point(X, Y); countColumnView.Location = new Point(X, Y - 100); countRowView.Location = new Point(X - 100, Y); _view.GridWrapper.Controls.Add(gridControlView); _view.GridWrapper.Controls.Add(countRowView); _view.GridWrapper.Controls.Add(countColumnView); } } catch (Exception ex) { MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message); } } }; _view.RandomSubMenuItem.Click += (s, e) => { var sizeDialog = new SizeDialogBoxView(); int height = 0, width = 0; if (sizeDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { _view.GridWrapper.Controls.Remove(gridControlView); _view.GridWrapper.Controls.Remove(countColumnView); _view.GridWrapper.Controls.Remove(countRowView); height = sizeDialog.GridHeight; width = sizeDialog.GridWidth; _view.GridWrapper.Controls.Clear(); gridControlView = new GridControlView(); countColumnView = new CountColumnView(); countRowView = new CountRowView(); gridPresenter = new GridPresenter(gridControlView, true, false, width, height); columnPresenter = new CountColumnPresenter(countColumnView, gridPresenter.TilesGrid, false); rowPresenter = new CountRowPresenter(countRowView, gridPresenter.TilesGrid, false); gridPresenter.ColumnPresenter = columnPresenter; gridPresenter.RowPresenter = rowPresenter; gridPresenter.RowsCounts = rowPresenter.Counts; gridPresenter.ColumnsCounts = columnPresenter.Counts; gridPresenter.ColumnPresenter.Draw(); gridPresenter.RowPresenter.Draw(); grid = gridPresenter.TilesGrid; for (int i = 0; i < grid.Height; i++) { for (int j = 0; j < grid.Width; j++) { grid.Tiles[i, j].Selected = false; } } int meshWidth = gridControlView.Width; int meshHeight = gridControlView.Height; int X = (_view.GridWrapper.Width - meshWidth) / 2; int Y = (_view.GridWrapper.Height - meshHeight) / 2; gridControlView.Location = new Point(X, Y); countColumnView.Location = new Point(X, Y - 100); countRowView.Location = new Point(X - 100, Y); _view.GridWrapper.Controls.Add(gridControlView); _view.GridWrapper.Controls.Add(countRowView); _view.GridWrapper.Controls.Add(countColumnView); } }; _view.ChooseSubMenuItem.Click += (s, e) => { var listDialog = new ChooseView(); if (listDialog.ShowDialog() == DialogResult.OK) { } }; }