public static void CreateFile(string newFile, string content)
{
string dir = System.IO.Path.GetDirectoryName(newFile);
string nameExtens = System.IO.Path.GetExtension(newFile);
string nameClear = System.IO.Path.GetFileNameWithoutExtension(newFile);
if (System.IO.File.Exists(newFile))
{
newFile = System.IO.Path.Combine(dir, nameClear + "_1" + nameExtens);
}
string ext = System.IO.Path.GetExtension(newFile);
if (ext == ".db")
{
using (FileStream fs = System.IO.File.Create(newFile))
fs.Close();
SqlLiteDal sqlld = new SqlLiteDal(newFile);
//Console.WriteLine(content);
sqlld.RunSqlScalar(content);
}
else
{
using (StreamWriter file = new StreamWriter(newFile)) {
file.Write(content);
file.Close();
file.Dispose();
}
}
}
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 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();
}
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;
}
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 static void CreateFile(string newFile, string content)
{
string dir = System.IO.Path.GetDirectoryName(newFile);
string nameExtens = System.IO.Path.GetExtension(newFile);
string nameClear = System.IO.Path.GetFileNameWithoutExtension(newFile);
if (System.IO.File.Exists(newFile))
newFile = System.IO.Path.Combine(dir, nameClear+"_1"+nameExtens);
string ext = System.IO.Path.GetExtension(newFile);
if (ext == ".db"){
using (FileStream fs = System.IO.File.Create(newFile))
fs.Close();
SqlLiteDal sqlld = new SqlLiteDal(newFile);
//Console.WriteLine(content);
sqlld.RunSqlScalar(content);
} else {
using (StreamWriter file = new StreamWriter(newFile)) {
file.Write(content);
file.Close();
file.Dispose();
}
}
}
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 );
}