public SqlLiteAddTable(string database)
{
this.TransientFor = MainClass.MainWindow;
this.Build();
this.Title = "New Table";
//this.dbConnection = dbConnection;
this.database = database;
sqlLiteDal = new SqlLiteDal(this.database);
tvFields.Model = fieldsStore;
tvFields.AppendColumn(MainClass.Languages.Translate("name"), new Gtk.CellRendererText(), "text", 0);
tvFields.AppendColumn(MainClass.Languages.Translate("type"), new Gtk.CellRendererText(), "text", 1);
}
public SqlLiteEditTable(string filePath, string tableName)
{
this.TransientFor = MainClass.MainWindow;
this.Build();
this.Title = "Edit Table :" + tableName;
this.tableName = tableName;
this.database = filePath;
sqlLiteDal = new SqlLiteDal(this.database);
tvFields.Model = fieldsStore;
tvFields.AppendColumn(MainClass.Languages.Translate("name"), new Gtk.CellRendererText(), "text", 0);
tvFields.AppendColumn(MainClass.Languages.Translate("type"), new Gtk.CellRendererText(), "text", 1);
tvFields.AppendColumn(MainClass.Languages.Translate("not_null"), new Gtk.CellRendererText(), "text", 2);
tvFields.AppendColumn(MainClass.Languages.Translate("default_value"), new Gtk.CellRendererText(), "text", 3);
entrTableName.Text = tableName;
this.Title = MainClass.Languages.Translate("edit_table_f1", tableName);
GetTableStructure();
}
public DataDatabaseView(string fileName)
{
hbox = new HBox();
sqlLiteDal = new SqlLiteDal(fileName);
lblTable = new Label(MainClass.Languages.Translate("tables"));
hbox.PackStart(lblTable, false, false, 10);
cbTable = new ComboBox();
cbTable.Changed += new EventHandler(OnComboProjectChanged);
CellRendererText textRenderer = new CellRendererText();
cbTable.PackStart(textRenderer, true);
cbTable.AddAttribute(textRenderer, "text", 0);
cbTable.Model = tablesComboModel;
cbTable.WidthRequest = 200;
hbox.PackStart(cbTable, false, false, 2);
hbox.PackEnd(new Label(""), true, true, 2);
this.PackStart(hbox, false, false, 5);
ScrolledWindow sw = new ScrolledWindow();
sw.ShadowType = ShadowType.EtchedIn;
sw.SetPolicy(PolicyType.Automatic, PolicyType.Automatic);
treeView = new TreeView(tableModel);
treeView.RulesHint = true;
//treeView.SearchColumn = (int) Column.Description;
sw.Add(treeView);
this.PackStart(sw, true, true, 5);
this.ShowAll();
GetTables();
}
protected override void OnActivated()
{
MessageDialogs md = new MessageDialogs(MessageDialogs.DialogButtonType.OkCancel, "Are you sure?", "", Gtk.MessageType.Question);
int result = md.ShowDialog();
if (result != (int)Gtk.ResponseType.Ok)
{
return;
}
ProgressDialog progressDialog;
string filename = System.IO.Path.Combine(MainClass.Paths.ConfingDir, "completedcache");
sqlLiteDal = new SqlLiteDal(filename);
string sql = "";
if (sqlLiteDal.CheckExistTable("completed"))
{
sql = "DROP TABLE completed ;";
sqlLiteDal.RunSqlScalar(sql);
}
sql = "CREATE TABLE completed (id INTEGER PRIMARY KEY, name TEXT, signature TEXT, type NUMERIC, parent TEXT,summary TEXT ,returnType TEXT ) ;";
sqlLiteDal.RunSqlScalar(sql);
SyntaxMode mode = new SyntaxMode();
mode = SyntaxModeService.GetSyntaxMode("text/moscrif");
progressDialog = new ProgressDialog("Generated...", ProgressDialog.CancelButtonType.None, mode.Keywords.Count(), MainClass.MainWindow);
foreach (Keywords kw in mode.Keywords)
{
progressDialog.Update(kw.ToString());
foreach (string wrd in kw.Words)
{
insertNewRow(wrd, wrd, (int)CompletionDataTyp.keywords, "", "", "");
}
}
Gtk.FileChooserDialog fc = new Gtk.FileChooserDialog("data.json", null, FileChooserAction.Open, "Cancel", ResponseType.Cancel, "Open", ResponseType.Accept);
fc.TransientFor = MainClass.MainWindow;
fc.SetCurrentFolder(@"d:\Work\docs-api\output\");
if (fc.Run() != (int)ResponseType.Accept)
{
return;
}
string json;
string fileName = fc.Filename;
progressDialog.Destroy();
fc.Destroy();
progressDialog = new ProgressDialog("Generated...", ProgressDialog.CancelButtonType.None, 100, MainClass.MainWindow);
using (StreamReader file = new StreamReader(fileName)) {
json = file.ReadToEnd();
file.Close();
file.Dispose();
}
//XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(json);
//doc.Save(fileName+"xml");
/*JObject jDoc= JObject.Parse(json);
* //classes
* Console.WriteLine("o.Count->"+jDoc.Count);
*
* foreach (JProperty jp in jDoc.Properties()){
* Console.WriteLine(jp.Name);
* }
* Console.WriteLine("------------");
* JObject classes = (JObject)jDoc["classes"];
* foreach (JProperty jp in classes.Properties()){
* Console.WriteLine(jp.Name);
* JObject classDefin = (JObject)classes[jp.Name];
* string name = (string)classDefin["name"];
* string shortname = (string)classDefin["shortname"];
* string description = (string)classDefin["description"];
* //string type = (string)classDefin["type"];
* insertNewRow(name,name,(int)CompletionDataTyp.types,"",description,name);
* }
* Console.WriteLine("------------");
*
* JArray classitems = (JArray)jDoc["classitems"];
* foreach (JObject classitem in classitems){
*
* string name = (string)classitem["name"];
* Console.WriteLine(name);
*
* string description = (string)classitem["description"];
* string itemtype = (string)classitem["itemtype"];
* string classParent = (string)classitem["class"];
* string signature = (string)classitem["name"];
* CompletionDataTyp type = CompletionDataTyp.noting;
* string returnType= classParent;
*
* switch (itemtype){
* case "method":{
* JArray paramsArray = (JArray)classitem["params"];
* signature = signature+ GetParams(paramsArray);
* type = CompletionDataTyp.members;
* JObject returnJO =(JObject)classitem["return"] ;
* if(returnJO!=null){
* returnType = (string)returnJO["type"];
* }
*
* break;
* }
* case "property":{
*
* string tmpType = (string)classitem["type"];
* if(!String.IsNullOrEmpty(tmpType)){
* returnType=tmpType.Replace("{","").Replace("}","");
* }
* type = CompletionDataTyp.properties;
* break;
* }
* case "event":{
* JArray paramsArray = (JArray)classitem["params"];
* signature = signature+ GetParams(paramsArray);
* type = CompletionDataTyp.events;
* break;
* }
* case "attribute":{
* continue;
* break;
* }
* default:{
* type = CompletionDataTyp.noting;
* break;
* }
*
* }
*
* insertNewRow(name,signature,(int)type,classParent,description,returnType);
* }*/
//classitems
// string name = (string)o["project"]["name"];
// Console.WriteLine(name);
progressDialog.Destroy();
md = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Done", "", Gtk.MessageType.Info);
md.ShowDialog();
return;
/*
*
* Gtk.FileChooserDialog fc = new Gtk.FileChooserDialog("Select DOC Directory (with xml)", null, FileChooserAction.SelectFolder, "Cancel", ResponseType.Cancel, "Open", ResponseType.Accept);
* FileInfo[] xmls = new FileInfo[]{};
*
* if (fc.Run() == (int)ResponseType.Accept) {
*
* DirectoryInfo di = new DirectoryInfo(fc.Filename);
* xmls = di.GetFiles("*.xml");
* //List<string> output = new List<string>();
*
* //MainClass.CompletedCache.ListTypes= listSignature.Distinct().ToList();
* //MainClass.CompletedCache.ListMembers= listMemberSignature.Distinct().ToList();
* }
* progressDialog.Destroy();
* fc.Destroy();
* progressDialog = new ProgressDialog("Generated...",ProgressDialog.CancelButtonType.None,xmls.Length ,MainClass.MainWindow);
* foreach (FileInfo xml in xmls)
* {
* try
* {
* progressDialog.Update(xml.Name);
* if(!xml.Name.StartsWith("_"))
* getObject(xml.FullName);
* }
* catch(Exception ex) {
* Console.WriteLine(ex.Message);
* Console.WriteLine(ex.StackTrace);
* return;
* }
* }
* progressDialog.Destroy();
*
* md = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Done", "", Gtk.MessageType.Info);
* md.ShowDialog();*/
}
public void GetCompletedData()
{
ListDataKeywords = new List <CompletionData>();
ListDataTypes = new List <CompletionData>();
ListDataMembers = new List <CompletionData>();
ListDataProperties = new List <CompletionData>();
ListDataEvents = new List <CompletionData>();
AllCompletionRepeat = new CompletionDataList();
AllCompletionOnlyOne = new CompletionDataList();
NewCompletion = new CompletionDataList();
DotCompletion = new CompletionDataList();
if (!System.IO.File.Exists(FilePath))
{
Tool.Logger.Error("CodeCompletion file not exist!", null);
return;
}
SqlLiteDal sqlLiteDal = new SqlLiteDal(FilePath);
SqliteConnection dbcon = (SqliteConnection)sqlLiteDal.GetConnect(); //GetConnect();
if (dbcon == null)
{
return;
}
SqliteCommand dbcmd = dbcon.CreateCommand();
string sql = "SELECT * FROM completed;";
dbcmd.CommandText = sql;
SqliteDataReader reader = null;
try {
reader = dbcmd.ExecuteReader();
int numberCollumns = reader.FieldCount;
if (numberCollumns < 5)
{
return;
}
while (reader.Read())
{
CompletionData cd;
string name = reader.GetValue(1).ToString();
string signature = reader.GetValue(2).ToString();
int type = reader.GetInt32(3);
string parent = reader.GetValue(4).ToString();
string summary = "";
string returnType = "";
if (numberCollumns >= 6)
{
summary = reader.GetValue(5).ToString();
}
if (numberCollumns >= 7)
{
returnType = reader.GetValue(6).ToString();
}
cd = new CompletionData(name, null, signature, name, 1, parent, returnType);
cd.Signature = signature;
if (!string.IsNullOrEmpty(summary))
{
cd.Description = cd.Description + Environment.NewLine + summary; //+Environment.NewLine;
}
if (type == (int)CompletionDataTyp.keywords)
{
ListDataKeywords.Add(cd);
}
else if (type == (int)CompletionDataTyp.members)
{
ListDataMembers.Add(cd);
}
else if (type == (int)CompletionDataTyp.types)
{
ListDataTypes.Add(cd);
}
else if (type == (int)CompletionDataTyp.properties)
{
ListDataProperties.Add(cd);
}
else if (type == (int)CompletionDataTyp.events)
{
ListDataEvents.Add(cd);
}
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
Tool.Logger.Error("ERROR LOADING COMPLETED CACHE");
Tool.Logger.Error(ex.Message);
//MessageDialogs ms = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Error", ex.Message, MessageType.Error);
//ms.ShowDialog();
} finally {
if (reader != null)
{
reader.Close();
}
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
}
AllCompletionRepeat = GetCompletionData(CompletionTyp.allType, false);
AllCompletionOnlyOne = GetCompletionData(CompletionTyp.allType, true);
NewCompletion = GetCompletionData(CompletionTyp.newType, true);
DotCompletion = GetCompletionData(CompletionTyp.dotType, true);
IncludeCompletion = GetCompletionData(CompletionTyp.includeType, true);
}
public StructureDatabaseView(string fileName)
{
this.filename = fileName;
hbox = new HBox();
sqlLiteDal = new SqlLiteDal(fileName);
lblTable = new Label(MainClass.Languages.Translate("tables"));
hbox.PackStart(lblTable, false, false, 10);
cbTable = new ComboBox();
cbTable.Changed += new EventHandler(OnComboProjectChanged);
CellRendererText textRenderer = new CellRendererText();
cbTable.PackStart(textRenderer, true);
cbTable.AddAttribute(textRenderer, "text", 0);
cbTable.Model = tablesComboModel;
cbTable.WidthRequest = 200;
hbox.PackStart(cbTable, false, false, 2);
hbox.PackEnd(new Label(""), true, true, 2);
HButtonBox hbbAction = new HButtonBox();
hbbAction.LayoutStyle = Gtk.ButtonBoxStyle.Start;
hbbAction.Spacing = 6;
Button btnAddTable = new Button(MainClass.Languages.Translate("add_table"));
btnAddTable.Clicked += delegate(object sender, EventArgs e) {
SqlLiteAddTable addtable = new SqlLiteAddTable(filename);
int result = addtable.Run();
if (result == (int)ResponseType.Ok)
{
GetTables();
}
addtable.Destroy();
};
Button btnDeleteTable = new Button(MainClass.Languages.Translate("delete_table"));
btnDeleteTable.Clicked += delegate(object sender, EventArgs e) {
if (!CheckSelectTable())
{
return;
}
MessageDialogs md = new MessageDialogs(MessageDialogs.DialogButtonType.YesNo, MainClass.Languages.Translate("permanently_delete_table", curentTable), "", Gtk.MessageType.Question);
int result = md.ShowDialog();
if (result != (int)Gtk.ResponseType.Yes)
{
return;
}
DropTable();
GetTables();
};
Button btnEditTable = new Button(MainClass.Languages.Translate("edit_table"));
btnEditTable.Clicked += delegate(object sender, EventArgs e) {
if (!CheckSelectTable())
{
return;
}
SqlLiteEditTable editTable = new SqlLiteEditTable(filename, curentTable);
int result = editTable.Run();
if (result == (int)ResponseType.Ok)
{
GetTables();
}
editTable.Destroy();
};
hbbAction.Add(btnAddTable);
hbbAction.Add(btnDeleteTable);
hbbAction.Add(btnEditTable);
hbox.PackEnd(hbbAction, false, false, 10);
this.PackStart(hbox, false, false, 5);
ScrolledWindow sw = new ScrolledWindow();
sw.ShadowType = ShadowType.EtchedIn;
sw.SetPolicy(PolicyType.Automatic, PolicyType.Automatic);
treeView = new TreeView(tableModel);
GenerateColumns();
treeView.RulesHint = true;
//treeView.SearchColumn = (int) Column.Description;
sw.Add(treeView);
this.PackStart(sw, true, true, 5);
ScrolledWindow sw2 = new ScrolledWindow();
sw2.ShadowType = ShadowType.EtchedIn;
sw2.SetPolicy(PolicyType.Automatic, PolicyType.Automatic);
sw2.HeightRequest = 50;
textControl = new TextView();
textControl.Editable = false;
textControl.HeightRequest = 50;
sw2.Add(textControl);
this.PackEnd(sw2, false, false, 5);
this.ShowAll();
GetTables();
//cbTable.Active = 0;
}
