public void createClass(String XmlPath, string ClassComment)
{
MysqlClass classModellator = new MysqlClass();
//classModellator.PathToSave = this.txtPath.Text;
classModellator.Description = ClassComment;
classModellator.DriverUsed = (TypeOfDriver)this.comboBoxTypeDrivedr.SelectedItem;
classModellator.AccessModifier = this.comboBoxModifiers.SelectedItem.ToString();
classModellator.NameSpace = this.textBoxProjectName.Text + (this.textBoxProjectName.Text.Length > 0 ? "." : "") + this.textBoxNamespace.Text;
classModellator.Name = this.textBoxClassName.Text;
XmlTextReader reader = new XmlTextReader(XmlPath);
String Name = "";
String Type = "";
bool isColumnName = false;
bool isDataType = false;
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element:
if (reader.Name == "ColumnName")
{
isColumnName = true;
}
else if (reader.Name == "DataType")
{
isDataType = true;
}
//DataType
break;
case XmlNodeType.Text:
if (isColumnName)
{
Name = reader.Value;
isColumnName = false;
}
else if (isDataType)
{
Type = reader.Value;
String[] vetStr = Type.Split(',');
PropertyModellator tmpPM = new PropertyModellator();
tmpPM.Name = Name;
tmpPM.Type = vetStr[0];
classModellator.ListProperties.Add(tmpPM);
//classTable.addProperty(Name, vetStr[0]);
isColumnName = false;
isDataType = false;
Name = "";
Type = "";
}
//tmp=reader.Value;
break;
case XmlNodeType.EndElement:
//tmp = reader.Name;
break;
}
}
StreamWriter sw = File.CreateText(this.txtPath.Text + "\\" + classModellator.FileName);
sw.Write(classModellator.getClassModellated());
//classModellator.writeClass();
if (this.checkBoxOpenFile.Checked)
{
System.Diagnostics.Process.Start(this.txtPath.Text + "\\" + classModellator.FileName);
}
}
public void setClass()
{
_tableInformations = _mysqlInf.getTableInformations(tables.SelectedItem.ToString());
_tableInformations.Schema = this.databaseList.SelectedItem.ToString();
_tableInformations.PrimaryKey = _mysqlInf.getPrimaryKeyConstraints(_tableInformations.Schema, tables.SelectedItem.ToString());
_tableInformations.ForeignConstraints = _mysqlInf.getForeignConstraints(_tableInformations.Schema, tables.SelectedItem.ToString());
_tableInformations.UniqueConstraints = _mysqlInf.getUniqueConstraints(_tableInformations.Schema, tables.SelectedItem.ToString());
_mysqlClassModellator = new MysqlClass();
//creazione della classe
_mysqlClassModellator.TableInformation = _tableInformations;
String summary = this.textBoxClassSummary.Text;
summary += Environment.NewLine + "Full Class Information";
summary += Environment.NewLine + "Table Name : " + _tableInformations.Name;
summary += Environment.NewLine + "Table Comment : " + _tableInformations.Comment;
summary += Environment.NewLine + "Table Collation : " + _tableInformations.Collation;
summary += Environment.NewLine + "Table Create_time : " + _tableInformations.Create_time;
summary += Environment.NewLine + "Table Engine : " + _tableInformations.Engine;
summary += Environment.NewLine + "Table Version : " + _tableInformations.Version;
summary += Environment.NewLine + "Table Row_format : " + _tableInformations.Row_format;
summary += Environment.NewLine + "Table Rows : " + _tableInformations.Rows;
summary += Environment.NewLine + "Table Avg_row_length : " + _tableInformations.Avg_row_length;
summary += Environment.NewLine + "Table Data_length : " + _tableInformations.Data_length;
summary += Environment.NewLine + "Table Max_data_length : " + _tableInformations.Max_data_length;
summary += Environment.NewLine + "Table Index_length : " + _tableInformations.Index_length;
summary += Environment.NewLine + "Table Data_free : " + _tableInformations.Data_free;
summary += Environment.NewLine + "Table Auto_increment : " + _tableInformations.Auto_increment;
summary += Environment.NewLine + "Table Update_time : " + _tableInformations.Update_time;
summary += Environment.NewLine + "Table Check_time : " + _tableInformations.Check_time;
summary += Environment.NewLine + "Table Checksum : " + _tableInformations.Checksum;
summary += Environment.NewLine + "Table Create_options : " + _tableInformations.Create_options;
if (checkBoxInsertCreateTable.Checked)
{
summary += Environment.NewLine + Environment.NewLine + Environment.NewLine + "Create Table Statment:";
summary += "" + Environment.NewLine + _mysqlInf.getCreateTableString(tables.SelectedItem.ToString());
}
//classModellator.PathToSave = this.txtPath.Text;
_mysqlClassModellator.Description = summary;
_mysqlClassModellator.DriverUsed = (TypeOfDriver)this.comboBoxTypeDrivedr.SelectedItem;
if (this.checkBoxPersonalCodeClass.Checked)
{
_mysqlClassModellator.AccessModifier = ListAccessModifiers.PUBLIC_PARTIAL.Value;
}
else
{
_mysqlClassModellator.AccessModifier = this.comboBoxModifiers.SelectedItem.ToString();
}
_mysqlClassModellator.NameSpace = this.textBoxProjectName.Text+(this.textBoxProjectName.Text.Length>0 ? ".":"") + this.textBoxNamespace.Text;
_mysqlClassModellator.Name = this.textBoxClassName.Text;
_mysqlClassModellator.ListCouloumbInformations = _mysqlInf.getFullColumnsList(tables.SelectedItem.ToString());
summary = "";
foreach (CoulomnInformations tmp in _mysqlClassModellator.ListCouloumbInformations)
{
PropertyModellator tmpPM = new PropertyModellator();
tmpPM.Name = tmp.Field;
summary = Environment.NewLine + "Complete informations";
summary += Environment.NewLine + "Field: " + tmp.Field;
summary += Environment.NewLine + "Comment: " + tmp.Comment;
summary += Environment.NewLine + "Type: " + tmp.Type;
summary += Environment.NewLine + "Collation: " + tmp.Collation;
summary += Environment.NewLine + "Null: " + tmp.Null;
summary += Environment.NewLine + "Key: " + tmp.Key;
summary += Environment.NewLine + "Default: " + tmp.Default;
summary += Environment.NewLine + "Extra: " + tmp.Extra;
summary += Environment.NewLine + "Privileges: " + tmp.Privileges;
tmpPM.Description = summary;
tmpPM.Type = MysqlTypeMapping.getCsharpType(tmp.Type);
_mysqlClassModellator.ListProperties.Add(tmpPM);
//this.groupBoxFunction.Enabled = true;
}
}
