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 QuartzViewController(CreateView creator, string nib, string title, string info) : this(nib, null)
{
this.create = creator;
DemoTitle = title;
DemoInfo = info;
}
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)
{
}
};
}
