public void createControl(string projectName) { DataTable dat = new Connectoperations().showDatabaseTables(); foreach (DataRow row in dat.Rows) { string tableName = row[0].ToString(); //string namespc = new general.ClassGeneral().getNameSpaces(".control", tableName + "Control", projectName); //string str = ""; //str += "\n"; //str += namespc; //str += generatethem(projectName, tableName, "Before", "Update"); //str += generatethem(projectName, tableName, "Before", "Insert"); //str += generatethem(projectName, tableName, "Before", "Delete"); //str += generatethem(projectName, tableName, "Before", "Select"); //str += generatethem(projectName, tableName, "After", "Update"); //str += generatethem(projectName, tableName, "After", "Insert"); //str += generatethem(projectName, tableName, "After", "Delete"); //str += generatethem(projectName, tableName, "After", "Select"); //str += new general.ClassGeneral().closeClassBrace(); //string path = ""; //path = Directory.GetCurrentDirectory() + "\\" + projectName + "\\" + projectName + "\\control\\Class" + tableName + "Control.cs"; //File.WriteAllText(path, str); createControlTable(projectName, tableName); } }
public void createControlResume(string projectName,int numCompletedTables) { DataTable dat = new Connectoperations().showDatabaseTables(); for (int i=numCompletedTables;i<dat.Rows.Count;i++) { string tableName = dat.Rows[i][0].ToString(); createControlTable(projectName, tableName); } }
public List<ClassRelations> loadRelations(string SProject, string SPlatform, string SType, string SLanguage, string STable) { //intialise project myproject.language = SLanguage; myproject.platform = SPlatform; myproject.selectedProject = SProject; myproject.type = SType; myproject.selectedTable = STable; relations.Clear(); switch (myproject.platform) { case ".NET": if (myproject.language == "" || myproject.selectedProject == "" || myproject.type == "") { MessageBox.Show("For .NET,please select Type as well as langauge"); } else { } break; case "PHP": break; } //counter to keep the names of the database tables int tableCounter = 0; //get all database table DataTable dat = new Connectoperations().showDatabaseTables(); //loop for counter for (int y = 0; y < dat.Rows.Count; y++) { // create relation class ClassRelations cr = new ClassRelations(); cr.belongsTo = new List<string>(); cr.has = new List<string>(); cr.name = dat.Rows[tableCounter][0].ToString(); //loop through each table for (int i = 0; i < dat.Rows.Count; i++) { //prevent double deal if (dat.Rows[i][0].ToString() != cr.name) { //get attributes of the table string tabname = dat.Rows[i][0].ToString(); DataTable tab = new Connectoperations().describeTable(tabname); string hasrel = tabname + "_id"; string relationshipField = cr.name + "_id"; DataTable tabb = new Connectoperations().describeTable(cr.name); //go throuh each table check if the current table has 'has' relations with others foreach (DataRow drow in tab.Rows) { //field from other table string comp = drow[0].ToString(); //adding has relationship if (relationshipField == comp) { cr.has.Add(dat.Rows[i][0].ToString() + "#" + comp); } }//end for each //belongs to foreach (DataRow myrow in tabb.Rows) { string c = myrow[0].ToString(); //add belongs to if (c == hasrel) { // if(cr.belongsTo.Contains(row[0].ToString().Split('_')[0] + "#" + hasrel )==false ) cr.belongsTo.Add(c.Split('_')[0] + "#" + hasrel); } }//end foreach }//end double deal }//end for loop tableCounter++; //add list or relations relations.Add(cr); }//end counter for loop return relations; }
private void generateCustomcontrolListviewDesigner(string tableName, string projectName, List<string> mycontrols) { string customeFormDesigner = ""; customeFormDesigner += "\n"; customeFormDesigner += " namespace " + projectName + "\n"; customeFormDesigner += "{\n"; customeFormDesigner += "partial class UserControl" + tableName + "view\n"; customeFormDesigner += "{\n"; customeFormDesigner += " private System.ComponentModel.IContainer components = null;\n"; customeFormDesigner += " protected override void Dispose(bool disposing)\n"; customeFormDesigner += " {\n"; customeFormDesigner += " if (disposing && (components != null))\n"; customeFormDesigner += " {\n"; customeFormDesigner += " components.Dispose();\n"; customeFormDesigner += " }\n"; customeFormDesigner += " base.Dispose(disposing);\n"; customeFormDesigner += " }\n"; customeFormDesigner += " #region Component Designer generated code\n"; customeFormDesigner += " private void InitializeComponent()\n"; customeFormDesigner += " {\n"; customeFormDesigner += " this.components = new System.ComponentModel.Container();\n"; customeFormDesigner += " this.groupBox1 = new System.Windows.Forms.GroupBox();\n"; customeFormDesigner += " this.listView1 = new System.Windows.Forms.ListView();\n"; customeFormDesigner += " this.contextMenuStrip1 = new System.Windows.Forms.ContextMenuStrip(this.components);\n"; customeFormDesigner += " this.toolStripMenuItemView = new System.Windows.Forms.ToolStripMenuItem();\n"; //view toolstripmenuitem go here customeFormDesigner += " this.editToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; //edit toolstripmenuitem go here customeFormDesigner += " this.updateToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; customeFormDesigner += " this.newToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; customeFormDesigner += " this.deleteToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; customeFormDesigner += " this.menuStrip1 = new System.Windows.Forms.MenuStrip();\n"; customeFormDesigner += " this.toolStripComboBox1 = new System.Windows.Forms.ToolStripComboBox();\n"; customeFormDesigner += " this.toolStripTextBox1 = new System.Windows.Forms.ToolStripTextBox();\n"; customeFormDesigner += " this.toolStripMenuItemSearch = new System.Windows.Forms.ToolStripMenuItem();\n"; //association //create associations List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods //create field name for the hastables for (int y = 0; y < lcr[x].has.Count; y++) { string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; customeFormDesigner += " this."+tableName+hasTableName+"ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; } //create field name for the belongstables //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // string belongsToField = belongsToString[1]; // customeFormDesigner += " this." + tableName + belongsToTableName + "ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; //} } } customeFormDesigner += " this." + tableName+ "ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();\n"; customeFormDesigner += " this.groupBox1.SuspendLayout();\n"; customeFormDesigner += " this.contextMenuStrip1.SuspendLayout();\n"; customeFormDesigner += " this.menuStrip1.SuspendLayout();\n"; customeFormDesigner += " this.SuspendLayout();\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // groupBox1\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)\n"; customeFormDesigner += " | System.Windows.Forms.AnchorStyles.Left)\n"; customeFormDesigner += " | System.Windows.Forms.AnchorStyles.Right)));\n"; customeFormDesigner += " this.groupBox1.Controls.Add(this.listView1);\n"; customeFormDesigner += " this.groupBox1.Location = new System.Drawing.Point(3, 28);\n"; customeFormDesigner += " this.groupBox1.Name = \"groupBox1\";\n"; customeFormDesigner += " this.groupBox1.Size = new System.Drawing.Size(694, 348);\n"; customeFormDesigner += " this.groupBox1.TabIndex = 0;\n"; customeFormDesigner += " this.groupBox1.TabStop = false;\n"; customeFormDesigner += " this.groupBox1.Text = \"\";\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // listView1\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.listView1.ContextMenuStrip = this.contextMenuStrip1;\n"; customeFormDesigner += " this.listView1.Dock = System.Windows.Forms.DockStyle.Fill;\n"; customeFormDesigner += " this.listView1.FullRowSelect = true;\n"; customeFormDesigner += " this.listView1.GridLines = true;\n"; customeFormDesigner += " this.listView1.Location = new System.Drawing.Point(3, 16);\n"; customeFormDesigner += " this.listView1.Name = \"listView1\";\n"; customeFormDesigner += " this.listView1.Size = new System.Drawing.Size(688, 329);\n"; customeFormDesigner += " this.listView1.TabIndex = 0;\n"; customeFormDesigner += " this.listView1.UseCompatibleStateImageBehavior = false;\n"; customeFormDesigner += " this.listView1.View = System.Windows.Forms.View.Details;\n"; customeFormDesigner += " this.listView1.ItemSelectionChanged += new System.Windows.Forms.ListViewItemSelectionChangedEventHandler(this.listView1_ItemSelectionChanged);\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // contextMenuStrip1\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.contextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {\n"; customeFormDesigner += " this.toolStripMenuItemView,\n"; customeFormDesigner += " this.editToolStripMenuItem});\n"; customeFormDesigner += " this.contextMenuStrip1.Name = \"contextMenuStrip1\";\n"; customeFormDesigner += " this.contextMenuStrip1.RenderMode = System.Windows.Forms.ToolStripRenderMode.System;\n"; customeFormDesigner += " this.contextMenuStrip1.Size = new System.Drawing.Size(100, 26);\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // toolStripMenuItemView\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.toolStripMenuItemView.Name = \"toolStripMenuItemView\";\n"; customeFormDesigner += " this.toolStripMenuItemView.Size = new System.Drawing.Size(99, 22);\n"; customeFormDesigner += " this.toolStripMenuItemView.Text = \"View\";\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // menuStrip1\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {\n"; customeFormDesigner += " this.toolStripComboBox1,\n"; customeFormDesigner += " this.toolStripTextBox1,\n"; customeFormDesigner += " this.toolStripMenuItemSearch});\n"; customeFormDesigner += " this.menuStrip1.Location = new System.Drawing.Point(0, 0);\n"; customeFormDesigner += " this.menuStrip1.Name = \"menuStrip1\";\n"; customeFormDesigner += " this.menuStrip1.Size = new System.Drawing.Size(700, 27);\n"; customeFormDesigner += " this.menuStrip1.TabIndex = 1;\n"; customeFormDesigner += " this.menuStrip1.Text = \"menuStrip1\";\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // toolStripComboBox1\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.toolStripComboBox1.Items.AddRange(new object[] {\n"; DataTable dat = new Connectoperations().describeTable(tableName); string delimeter = ","; string str = ""; int i = 0; foreach (DataRow row in dat.Rows) { if (i++ > dat.Rows.Count - 2) delimeter = ""; str += "\"" + row[0].ToString() + "\"" + delimeter; } customeFormDesigner += str; //hasmany search fields //List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods //create field name for the hastables for (int y = 0; y < lcr[x].has.Count; y++) { string mydelim = ",\n"; string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; dat = new Connectoperations().describeTable(hasTableName); customeFormDesigner += ","; string hasField = hasString[1]; for(int a=1;a<dat.Rows.Count;a++) { if (a > dat.Rows.Count - 2) { mydelim = ""; } customeFormDesigner +="\""+dat.Rows[a][0].ToString()+"\""+mydelim+"\n"; } } //create field name for the hastables //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string mydelim = ",\n"; // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // dat = new Connectoperations().describeTable(belongsToTableName); // customeFormDesigner += ","; // string belongsToField = belongsToString[1]; // for (int a = 1; a < dat.Rows.Count; a++) // { // if (a > dat.Rows.Count - 2) // { // mydelim = ""; // } // customeFormDesigner += "\"" + dat.Rows[a][0].ToString() + "\"" + mydelim + "\n"; // } //} } } customeFormDesigner += " });\n"; customeFormDesigner += " this.toolStripComboBox1.Name = \"toolStripComboBox1\";\n"; customeFormDesigner += " this.toolStripComboBox1.Size = new System.Drawing.Size(121, 23);\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // toolStripTextBox1\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.toolStripTextBox1.Name = \"toolStripTextBox1\";\n"; customeFormDesigner += " this.toolStripTextBox1.Size = new System.Drawing.Size(200, 23);\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // toolStripMenuItemSearch\n"; customeFormDesigner += " // \n"; //create associations //List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); //create field name for the hastables customeFormDesigner += " this.toolStripMenuItemSearch.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {\n"; customeFormDesigner += "this." + tableName + "ToolStripMenuItem\n"; for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods if (lcr[x].has.Count> 0) { customeFormDesigner += ","; } for (int y = 0; y < lcr[x].has.Count; y++) { string mydelim = ","; string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; if (y > lcr[x].has.Count - 2) { mydelim = ""; } customeFormDesigner += "this."+tableName+hasTableName+"ToolStripMenuItem" + mydelim +"\n"; } //create has class methods //if (lcr[x].belongsTo.Count > 0) //{ // customeFormDesigner += ","; //} //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string mydelim = ","; // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // string belongsToField = belongsToString[1]; // if (y > lcr[x].has.Count - 2) // { // mydelim = ""; // } // customeFormDesigner += "this." + tableName + belongsToTableName + "ToolStripMenuItem" + mydelim + "\n"; //} } } customeFormDesigner += "});\n"; customeFormDesigner += " this.toolStripMenuItemSearch.Name = \"toolStripMenuItemSearch\";\n"; customeFormDesigner += " this.toolStripMenuItemSearch.Size = new System.Drawing.Size(54, 23);\n"; customeFormDesigner += " this.toolStripMenuItemSearch.Text = \"View&Search\";\n"; customeFormDesigner += " // \n"; //assoc //create associations // List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods //create field name for the hastables for (int y = 0; y < lcr[x].has.Count; y++) { string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; customeFormDesigner += " this."+tableName+hasTableName+"ToolStripMenuItem.Name = \"studentToolStripMenuItem\";\n"; customeFormDesigner += " this."+tableName+hasTableName+"ToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; customeFormDesigner += " this."+tableName+hasTableName+"ToolStripMenuItem.Text = \""+tableName+"->"+hasTableName+"\";\n"; customeFormDesigner += " this." + tableName + hasTableName + "ToolStripMenuItem.Click += new System.EventHandler(this." + tableName + hasTableName + "ToolStripMenuItem_Click);\n"; } //create field name for the hastables //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // string belongsToField = belongsToString[1]; // customeFormDesigner += " this." + tableName + belongsToTableName + "ToolStripMenuItem.Name = \"studentToolStripMenuItem\";\n"; // customeFormDesigner += " this." + tableName + belongsToTableName + "ToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; // customeFormDesigner += " this." + tableName + belongsToTableName + "ToolStripMenuItem.Text = \"" + tableName + "->" + belongsToTableName + "\";\n"; // customeFormDesigner += " this." + tableName + belongsToTableName + "ToolStripMenuItem.Click += new System.EventHandler(this." + tableName + belongsToTableName + "ToolStripMenuItem_Click);\n"; //} } } //default table customeFormDesigner += " this." + tableName + "ToolStripMenuItem.Name = \"studentToolStripMenuItem\";\n"; customeFormDesigner += " this." + tableName + "ToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; customeFormDesigner += " this." + tableName + "ToolStripMenuItem.Text = \"" + tableName + "->" + "\";\n"; customeFormDesigner += " this." + tableName + "ToolStripMenuItem.Click += new System.EventHandler(this." + tableName+"ToolStripMenuItem_Click);\n"; //view items go here customeFormDesigner += " // \n"; customeFormDesigner += " // editToolStripMenuItem\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.editToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {\n"; customeFormDesigner += " this.updateToolStripMenuItem,\n"; customeFormDesigner += " this.newToolStripMenuItem,\n"; customeFormDesigner += " this.deleteToolStripMenuItem});\n"; customeFormDesigner += " this.editToolStripMenuItem.Name = \"editToolStripMenuItem\";\n"; customeFormDesigner += " this.editToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; customeFormDesigner += " this.editToolStripMenuItem.Text = \"Edit\";\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // updateToolStripMenuItem\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.updateToolStripMenuItem.Name = \"updateToolStripMenuItem\";\n"; customeFormDesigner += " this.updateToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; customeFormDesigner += " this.updateToolStripMenuItem.Text = \"Update\";\n"; customeFormDesigner += " this.updateToolStripMenuItem.Click += new System.EventHandler(this.updateToolStripMenuItem_Click);\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // newToolStripMenuItem\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.newToolStripMenuItem.Name = \"newToolStripMenuItem\";\n"; customeFormDesigner += " this.newToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; customeFormDesigner += " this.newToolStripMenuItem.Text = \"New\";\n"; customeFormDesigner += " this.newToolStripMenuItem.Click += new System.EventHandler(this.newToolStripMenuItem_Click);\n"; customeFormDesigner += " // \n"; customeFormDesigner += " // deleteToolStripMenuItem\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.deleteToolStripMenuItem.Name = \"deleteToolStripMenuItem\";\n"; customeFormDesigner += " this.deleteToolStripMenuItem.Size = new System.Drawing.Size(152, 22);\n"; customeFormDesigner += " this.deleteToolStripMenuItem.Text = \"Delete\";\n"; customeFormDesigner += " this.deleteToolStripMenuItem.Click += new System.EventHandler(this.deleteToolStripMenuItem_Click);\n"; customeFormDesigner += " // UserControlgreenapple\n"; customeFormDesigner += " // \n"; customeFormDesigner += " this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);\n"; customeFormDesigner += " this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;\n"; customeFormDesigner += " this.Controls.Add(this.groupBox1);\n"; customeFormDesigner += " this.Controls.Add(this.menuStrip1);\n"; customeFormDesigner += " this.Name = \"UserControl" + tableName + "view\";\n"; customeFormDesigner += " this.Size = new System.Drawing.Size(700, 379);\n"; customeFormDesigner += " this.Load += new System.EventHandler(this.UserControl" + tableName + "view_Load);\n"; customeFormDesigner += " this.groupBox1.ResumeLayout(false);\n"; customeFormDesigner += " this.contextMenuStrip1.ResumeLayout(false);\n"; customeFormDesigner += " this.menuStrip1.ResumeLayout(false);\n"; customeFormDesigner += " this.menuStrip1.PerformLayout();\n"; customeFormDesigner += " this.ResumeLayout(false);\n"; customeFormDesigner += " this.PerformLayout();\n"; customeFormDesigner += " }\n"; customeFormDesigner += " #endregion\n"; customeFormDesigner += " private System.Windows.Forms.GroupBox groupBox1;\n"; customeFormDesigner += " private System.Windows.Forms.MenuStrip menuStrip1;\n"; customeFormDesigner += " private System.Windows.Forms.ToolStripComboBox toolStripComboBox1;\n"; customeFormDesigner += " private System.Windows.Forms.ToolStripTextBox toolStripTextBox1;\n"; customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem toolStripMenuItemSearch;\n"; customeFormDesigner += " private System.Windows.Forms.ListView listView1;\n"; customeFormDesigner += " private System.Windows.Forms.ContextMenuStrip contextMenuStrip1;\n"; customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem toolStripMenuItemView;\n"; //view toolstripmenuitem go here customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem editToolStripMenuItem;\n"; //edit toolstripmenuitem go here customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem updateToolStripMenuItem;\n"; customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem newToolStripMenuItem;\n"; customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem deleteToolStripMenuItem;\n"; //add table association menus //create associations //List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods //create field name for the hastables for (int y = 0; y < lcr[x].has.Count; y++) { string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem "+tableName+hasTableName+"ToolStripMenuItem;\n"; } //create field name for the belong to //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // string belongsToField = belongsToString[1]; // customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem " + tableName + belongsToTableName + "ToolStripMenuItem;\n"; //} } } //create for current table customeFormDesigner += " private System.Windows.Forms.ToolStripMenuItem " + tableName + "ToolStripMenuItem;\n"; customeFormDesigner += " }\n"; customeFormDesigner += "}\n"; string path = ""; path = Directory.GetCurrentDirectory() + "\\" + projectName + "\\" + projectName + "\\view\\UserControl" + tableName + "view.Designer.cs"; File.WriteAllText(path, customeFormDesigner); }
//create listview on user control private void generateCustomcontrolListviewClass(string tableName, string projectName) { string customeFormClass = ""; customeFormClass += "\n"; customeFormClass += "using System;\n"; customeFormClass += "using System.Collections.Generic;\n"; customeFormClass += "using System.ComponentModel;\n"; customeFormClass += "using System.Drawing;\n"; customeFormClass += "using System.Data;\n"; customeFormClass += "using System.Linq;\n"; customeFormClass += "using System.Text;\n"; customeFormClass += "using System.Windows.Forms;\n"; customeFormClass += "using " + projectName + ".model;\n"; customeFormClass += "namespace " + projectName; customeFormClass += "{\n"; customeFormClass += " public partial class UserControl" + tableName + "view : UserControl\n"; customeFormClass += " {\n"; customeFormClass += " public UserControl" + tableName + "view()\n"; customeFormClass += " {\n"; customeFormClass += " InitializeComponent();\n"; customeFormClass += " }\n"; customeFormClass += " int selectedIndex = 0;\n"; customeFormClass += " private void UserControl" + tableName + "view_Load(object sender, EventArgs e)\n"; customeFormClass += " {\n"; customeFormClass += " loaddata" + tableName + "(\"\");\n"; customeFormClass += " }\n"; customeFormClass += "//this function is used for search\n"; customeFormClass += " public void loaddata" + tableName + "(string whereclause)\n"; customeFormClass += " {\n"; customeFormClass += " listView1.Columns.Clear();\n"; DataTable dat = new Connectoperations().describeTable(tableName); customeFormClass += " listView1.Columns.Add(\"No\", 50, HorizontalAlignment.Left);\n"; bool setidwith = true; int columnWidth=100; foreach (DataRow row in dat.Rows) { //set id column width to 0 id if (setidwith) { columnWidth = 0; setidwith = false; } else { columnWidth = 100; } string attribute = row[0].ToString(); customeFormClass += " listView1.Columns.Add(\"" + attribute + "\", "+columnWidth+", HorizontalAlignment.Left);\n"; } customeFormClass += " DataTable dat = new " + tableName + "muid().selecttable" + tableName + "(\"*\", whereclause);\n"; customeFormClass += " listView1.Items.Clear();\n"; customeFormClass += " int counter = 1;\n"; customeFormClass += " foreach (DataRow row in dat.Rows)\n"; customeFormClass += " {\n"; customeFormClass += " ListViewItem lv = new ListViewItem(counter.ToString());\n"; for (int i = 0; i < dat.Rows.Count; i++) { customeFormClass += " lv.SubItems.Add(row[" + i + "].ToString());\n"; } customeFormClass += " counter++;\n"; customeFormClass += " listView1.Items.Add(lv);\n"; customeFormClass += " }\n"; customeFormClass += "}\n"; //hasMany functions customeFormClass += "//has many functions\n"; //create associations List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods //create field name for the hastables for (int y = 0; y < lcr[x].has.Count; y++) { string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; //create fieldname for the current table customeFormClass += " private void loaddata" + tableName + hasTableName + "hasMany(string andorclause)\n"; customeFormClass += " {\n"; customeFormClass += "listView1.Columns.Clear();\n"; DataTable datparent = new Connectoperations().describeTable(tableName); customeFormClass += " listView1.Columns.Add(\"No\", 50, HorizontalAlignment.Left);\n"; foreach (DataRow row in datparent.Rows) { string attribute =tableName+ row[0].ToString(); attribute = tableName +":"+ row[0].ToString(); customeFormClass += " listView1.Columns.Add(\"" + attribute + "\", 100, HorizontalAlignment.Left);\n"; } DataTable datchild = new Connectoperations().describeTable(hasTableName); foreach (DataRow row in datchild.Rows) { string attribute = row[0].ToString(); attribute = hasTableName +":"+ row[0].ToString(); customeFormClass += " listView1.Columns.Add(\"" + attribute + "\", 100, HorizontalAlignment.Left);\n"; } customeFormClass += " DataTable dat = new " + tableName + "muid()." + tableName + hasTableName + "hasMany(andorclause);\n"; customeFormClass += " listView1.Items.Clear();\n"; customeFormClass += " int counter = 1;\n"; customeFormClass += " foreach (DataRow row in dat.Rows)\n"; customeFormClass += " {\n"; customeFormClass += " ListViewItem lv = new ListViewItem(counter.ToString());\n"; //get the fields for (int i = 0; i < (datparent.Rows.Count+datchild.Rows.Count); i++) { customeFormClass += " lv.SubItems.Add(row[" + i + "].ToString());\n"; } customeFormClass += " counter++;\n"; customeFormClass += " listView1.Items.Add(lv);\n"; customeFormClass += " }\n"; customeFormClass += "}\n"; }//end has to //create field name for the belongs //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // string belongsToField = belongsToString[1]; // //create fieldname for the current table // customeFormClass += " private void loaddata" + tableName + belongsToTableName + "(string andorclause)\n"; // customeFormClass += " {\n"; // customeFormClass += "listView1.Columns.Clear();\n"; // DataTable datparent = new Connectoperations().describeTable(tableName); // customeFormClass += " listView1.Columns.Add(\"No\", 50, HorizontalAlignment.Left);\n"; // foreach (DataRow row in datparent.Rows) // { // string attribute = tableName + row[0].ToString(); // attribute = tableName + ":" + row[0].ToString(); // customeFormClass += " listView1.Columns.Add(\"" + attribute + "\", 100, HorizontalAlignment.Left);\n"; // } // DataTable datchild = new Connectoperations().describeTable(belongsToTableName); // foreach (DataRow row in datchild.Rows) // { // string attribute = row[0].ToString(); // attribute = belongsToTableName + ":" + row[0].ToString(); // customeFormClass += " listView1.Columns.Add(\"" + attribute + "\", 100, HorizontalAlignment.Left);\n"; // } // customeFormClass += " DataTable dat = new " + tableName + "muid()." + tableName + belongsToTableName + "(andorclause);\n"; // customeFormClass += " listView1.Items.Clear();\n"; // customeFormClass += " int counter = 1;\n"; // customeFormClass += " foreach (DataRow row in dat.Rows)\n"; // customeFormClass += " {\n"; // customeFormClass += " ListViewItem lv = new ListViewItem(counter.ToString());\n"; // //get the fields // for (int i = 0; i < (datparent.Rows.Count + datchild.Rows.Count); i++) // { // customeFormClass += " lv.SubItems.Add(row[" + i + "].ToString());\n"; // } // customeFormClass += " counter++;\n"; // customeFormClass += " listView1.Items.Add(lv);\n"; // customeFormClass += " }\n"; // customeFormClass += "}\n"; //}//end belongs to } } //events for assoc // List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods //create field name for the hastables for (int y = 0; y < lcr[x].has.Count; y++) { string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; customeFormClass += " private void "+tableName+hasTableName+"ToolStripMenuItem_Click(object sender, EventArgs e)\n"; customeFormClass += " {\n"; customeFormClass += " loaddata" + tableName + hasTableName + "hasMany(\" and \" + toolStripComboBox1.Text + \" like '%\" + toolStripTextBox1.Text + \"%'\"); \n"; customeFormClass += " }\n"; }//end has //create field name for the hastables //for (int y = 0; y < lcr[x].belongsTo.Count; y++) //{ // string[] belongsToString = lcr[x].belongsTo[y].Split('#'); // string belongsToTableName = belongsToString[0]; // string belongsToField = belongsToString[1]; // customeFormClass += " private void " + tableName + belongsToTableName + "ToolStripMenuItem_Click(object sender, EventArgs e)\n"; // customeFormClass += " {\n"; // customeFormClass += " loaddata" + tableName + belongsToTableName + "(\" and \" + toolStripComboBox1.Text + \" like '%\" + toolStripTextBox1.Text + \"%'\"); \n"; // customeFormClass += " }\n"; //} } } customeFormClass += " private void " + tableName + "ToolStripMenuItem_Click(object sender, EventArgs e)\n"; customeFormClass += " {\n"; customeFormClass += " loaddata" + tableName + "(\"where \" + toolStripComboBox1.Text + \" like '%\" + toolStripTextBox1.Text + \"%'\"); \n"; customeFormClass += " }\n"; customeFormClass += "//search any record in the listview\n"; customeFormClass += " private void toolStripMenuItemSearch_Click(object sender, EventArgs e)\n"; customeFormClass += "{\n"; customeFormClass += " loaddata"+tableName+"(\"where \" + toolStripComboBox1.Text + \" like '%\" + toolStripTextBox1.Text + \"%'\");\n"; customeFormClass += "}\n"; customeFormClass += " private void updateToolStripMenuItem_Click(object sender, EventArgs e)\n"; customeFormClass += "{\n"; //customeFormClass += " new Form" + tableName + "muid().Show();\n"; customeFormClass += ("Form" + tableName + "muid " + tableName + "muid = new Form" + tableName + "muid();\n"); //link to the MUID Form/user control customeFormClass += (tableName + "muid.userControl" + tableName + "insert1.loaddata(listView1, selectedIndex, 1);\n"); customeFormClass += (tableName + "muid.Show();\n"); customeFormClass += "}\n"; //TODO implement Clearing of input fields customeFormClass += " private void newToolStripMenuItem_Click(object sender, EventArgs e)\n"; customeFormClass += "{\n"; //customeFormClass += " new Form" + tableName + "muid().Show();\n"; customeFormClass += ("Form" + tableName + "muid " + tableName + "muid = new Form" + tableName + "muid();\n"); //link to the MUID Form/user control customeFormClass += (tableName + "muid.userControl" + tableName + "insert1.loaddata(listView1, selectedIndex, 0);\n"); customeFormClass += (tableName + "muid.Show();\n"); customeFormClass += "}\n"; customeFormClass += "private void deleteToolStripMenuItem_Click(object sender, EventArgs e)\n"; customeFormClass += "{\n"; customeFormClass += "}\n"; customeFormClass += "private void listView1_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)\n"; customeFormClass += "{\n"; customeFormClass += "selectedIndex = e.ItemIndex;\n"; customeFormClass += "}\n"; customeFormClass += " }\n"; customeFormClass += "}\n"; string path = ""; path = Directory.GetCurrentDirectory() + "\\" + projectName + "\\" + projectName + "\\view\\UserControl" + tableName + "view.cs"; File.WriteAllText(path, customeFormClass); }
private void generateCustomConrolDesigner(string projectName, string tableName, List<ClassTableControls> lctc) { controls.Clear(); defaultInsertattribute = "\""; defaultInservalues = ""; string customeControlDesigner = ""; string initiallizer = ""; string privateString = ""; //string groupBox = ""; initiallizer += "\n"; privateString += "\n"; //get table attributes DataTable dtab = new Connectoperations().describeTable(tableName); int i = 0; int heightControls = 13; int heightlabels = 16; string insertvalues = ""; string insertattributes = ""; string delimiter = "+\",\"+"; string delimiter1 = ","; foreach (DataRow row in dtab.Rows) { string attribute = row[0].ToString(); string dataType = row[1].ToString(); //label privateString += " private System.Windows.Forms.Label label" + attribute + ";\n"; initiallizer += " this.label" + attribute + " = new System.Windows.Forms.Label();\n"; initiallizer += " this.groupBox1.Controls.Add(this.label" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // label" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.label" + attribute + ".AutoSize = true;\n"; initiallizer += " this.label" + attribute + ".Location = new System.Drawing.Point(6, " + heightlabels + ");\n"; initiallizer += " this.label" + attribute + ".Name = \"label" + attribute + "\";\n"; initiallizer += " this.label" + attribute + ".Size = new System.Drawing.Size(35, 13);\n"; initiallizer += " this.label" + attribute + ".TabIndex = 8;\n"; initiallizer += " this.label" + attribute + ".Text =\"" + attribute + "\";\n"; foreach (ClassTableControls ctc in lctc) { if (ctc.tablename == tableName) { if (ctc.controls.Count - 1 == i) { delimiter1 = ""; delimiter = ""; } insertattributes += attribute + delimiter1; switch (ctc.controls[i]) { case "TextBox": //textbox privateString += " private System.Windows.Forms.TextBox textBox" + attribute + ";\n"; initiallizer += " this.textBox" + attribute + " = new System.Windows.Forms.TextBox();\n"; initiallizer += " this.groupBox1.Controls.Add(this.textBox" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // textBox" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.textBox" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.textBox" + attribute + ".Name = \"textBox" + attribute + "\";\n"; initiallizer += " this.textBox" + attribute + ".Size = new System.Drawing.Size(273, 20);\n"; initiallizer += " this.textBox" + attribute + ".TabIndex = 1;\n"; insertvalues += create_i_attribute("textBox" + attribute + ".Text", dataType) + delimiter; controls.Add("textBox" + attribute + ".Text"); break; case "ComboBox": //combobox privateString += " private System.Windows.Forms.ComboBox comboBox" + attribute + ";\n"; initiallizer += " this.comboBox" + attribute + " = new System.Windows.Forms.ComboBox();\n"; initiallizer += " this.groupBox1.Controls.Add(this.comboBox" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // comboBox" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.comboBox" + attribute + ".FormattingEnabled = true;\n"; initiallizer += " this.comboBox" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.comboBox" + attribute + ".Name = \"comboBox" + attribute + "\";\n"; initiallizer += " this.comboBox" + attribute + ".Size = new System.Drawing.Size(273, 21);\n"; initiallizer += " this.comboBox" + attribute + ".TabIndex = 4;\n"; insertvalues += create_i_attribute("comboBox" + attribute + ".Text", dataType) + delimiter; controls.Add("comboBox" + attribute + ".Text"); break; case "DateTimePicker": //datetimepicker privateString += " private System.Windows.Forms.DateTimePicker dateTimePicker" + attribute + ";\n"; initiallizer += " this.dateTimePicker" + attribute + " = new System.Windows.Forms.DateTimePicker();\n"; initiallizer += " this.groupBox1.Controls.Add(this.dateTimePicker" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // dateTimePicker" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.dateTimePicker" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.dateTimePicker" + attribute + ".Name = \"dateTimePicker" + attribute + "\";\n"; initiallizer += " this.dateTimePicker" + attribute + ".Size = new System.Drawing.Size(273, 20);\n"; initiallizer += " this.dateTimePicker" + attribute + ".TabIndex = 7;\n"; //take care of mysql date //insertvalues += create_i_attribute("dateTimePicker" + attribute + ".Value", dataType) + delimiter; insertvalues += "\"'\"+mymodel.getmysqldate(dateTimePicker" + attribute + ")+\"'\"" + delimiter; controls.Add("dateTimePicker" + attribute + ".Value"); break; case "CheckBox": //checkbox privateString += " private System.Windows.Forms.CheckBox checkBox" + attribute + ";\n"; initiallizer += " this.checkBox" + attribute + " = new System.Windows.Forms.CheckBox();\n"; initiallizer += " this.groupBox1.Controls.Add(this.checkBox" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // checkBox" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.checkBox" + attribute + ".AutoSize = true;\n"; initiallizer += " this.checkBox" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.checkBox" + attribute + ".Name = \"checkBox1\";\n"; initiallizer += " this.checkBox" + attribute + ".Size = new System.Drawing.Size(80, 17);\n"; initiallizer += " this.checkBox" + attribute + ".TabIndex = 6;\n"; initiallizer += " this.checkBox" + attribute + ".Text = \"checkBox1\";\n"; initiallizer += " this.checkBox" + attribute + ".UseVisualStyleBackColor = true;\n"; insertvalues += create_i_attribute("checkBox" + attribute + ".Text", dataType) + delimiter; controls.Add("checkBox" + attribute + ".Text"); break; case "RadioButton": //radiobutton privateString += " private System.Windows.Forms.RadioButton radioButton" + attribute + ";\n"; initiallizer += " this.radioButton" + attribute + " = new System.Windows.Forms.RadioButton();\n"; initiallizer += " this.groupBox1.Controls.Add(this.radioButton" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // radioButton" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.radioButton" + attribute + ".AutoSize = true;\n"; initiallizer += " this.radioButton" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.radioButton" + attribute + ".Name = \"radioButton" + attribute + "\";\n"; initiallizer += " this.radioButton" + attribute + ".Size = new System.Drawing.Size(85, 17);\n"; initiallizer += " this.radioButton" + attribute + ".TabIndex = 11;\n"; initiallizer += " this.radioButton" + attribute + ".TabStop = true;\n"; initiallizer += " this.radioButton" + attribute + ".Text = \"radioButton" + attribute + "\";\n"; initiallizer += " this.radioButton" + attribute + ".UseVisualStyleBackColor = true;\n"; insertvalues += create_i_attribute("radioButton" + attribute + ".Text", dataType) + delimiter; controls.Add("radioButton" + attribute + ".Text"); break; case "PictureBox": //picturebox privateString += " private System.Windows.Forms.PictureBox pictureBox" + attribute + ";\n"; initiallizer += " this.pictureBox" + attribute + " = new System.Windows.Forms.PictureBox();\n"; initiallizer += " this.groupBox1.Controls.Add(this.pictureBox" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // pictureBox" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.pictureBox" + attribute + ".Location = new System.Drawing.Point(493, " + heightControls + ");\n"; initiallizer += " this.pictureBox" + attribute + ".Name = \"pictureBox1\";\n"; initiallizer += " this.pictureBox" + attribute + ".Size = new System.Drawing.Size(101, 89);\n"; initiallizer += " this.pictureBox" + attribute + ".TabIndex = 12;\n"; initiallizer += " this.pictureBox" + attribute + ".TabStop = false;\n"; initiallizer += " ((System.ComponentModel.ISupportInitialize)(this.pictureBox" + attribute + ")).BeginInit();\n"; insertvalues += create_i_attribute("pictureBox" + attribute + ".Image", dataType) + delimiter; controls.Add("pictureBox" + attribute + ".Image"); break; case "NumericUp": //numeric updown privateString += " private System.Windows.Forms.NumericUpDown numericUpDown" + attribute + ";\n"; initiallizer += " this.numericUpDown" + attribute + " = new System.Windows.Forms.NumericUpDown();\n"; initiallizer += " this.groupBox1.Controls.Add(this.numericUpDown" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // numericUpDown" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.numericUpDown" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.numericUpDown" + attribute + ".Name = \"numericUpDown1\";\n"; initiallizer += " this.numericUpDown" + attribute + ".Size = new System.Drawing.Size(273, 20);\n"; initiallizer += " this.numericUpDown" + attribute + ".TabIndex = 5;\n"; initiallizer += " ((System.ComponentModel.ISupportInitialize)(this.numericUpDown" + attribute + ")).BeginInit();\n"; insertvalues += create_i_attribute("numericUpDown" + attribute + ".Value", dataType) + delimiter; controls.Add("numericUpDown" + attribute + ".Value"); break; case "CheckedLisBox": //richtextbox // initiallizer += " private System.Windows.Forms.RichTextBox richTextBox1;\n"; break; case "RichTextBox": //richtextbox privateString += " private System.Windows.Forms.RichTextBox richTextBox" + attribute + ";\n"; initiallizer += " this.richTextBox" + attribute + " = new System.Windows.Forms.RichTextBox();\n"; initiallizer += " this.groupBox1.Controls.Add(this.richTextBox" + attribute + ");\n"; initiallizer += " // \n"; initiallizer += " // richTextBox" + attribute + "\n"; initiallizer += " // \n"; initiallizer += " this.richTextBox" + attribute + ".Location = new System.Drawing.Point(187, " + heightControls + ");\n"; initiallizer += " this.richTextBox" + attribute + ".Name = \"richTextBox1\";\n"; initiallizer += " this.richTextBox" + attribute + ".Size = new System.Drawing.Size(273, 31);\n"; initiallizer += " this.richTextBox" + attribute + ".TabIndex = 13;\n"; initiallizer += " this.richTextBox" + attribute + ".Text = \"\";\n"; insertvalues += create_i_attribute("richTextBox" + attribute + ".Text", dataType) + delimiter; controls.Add("richTextBox" + attribute + ".Text"); break; } }//end if check }//end lctc i++; heightControls = heightControls + 26; heightlabels = heightlabels + 26; } defaultInsertattribute += insertattributes + "\""; defaultInservalues += insertvalues; customeControlDesigner += "\n"; customeControlDesigner += "namespace " + projectName + ".view\n"; customeControlDesigner += "{\n"; customeControlDesigner += " partial class UserControl" + tableName + "insert\n"; customeControlDesigner += " {\n"; customeControlDesigner += " private System.ComponentModel.IContainer components = null;\n"; customeControlDesigner += " protected override void Dispose(bool disposing)\n"; customeControlDesigner += " {\n"; customeControlDesigner += " if (disposing && (components != null))\n"; customeControlDesigner += " {\n"; customeControlDesigner += " components.Dispose();\n"; customeControlDesigner += " }\n"; customeControlDesigner += " base.Dispose(disposing);\n"; customeControlDesigner += " }\n"; customeControlDesigner += " #region Component Designer generated code\n"; customeControlDesigner += " private void InitializeComponent()\n"; customeControlDesigner += " {\n"; customeControlDesigner += " this.groupBox1 = new System.Windows.Forms.GroupBox();\n"; //all controls come here customeControlDesigner += initiallizer + "\n"; // customeControlDesigner += " this.progressBar1 = new System.Windows.Forms.ProgressBar();\n"; customeControlDesigner += " this.groupBox2 = new System.Windows.Forms.GroupBox();\n"; customeControlDesigner += " this.buttonDelete = new System.Windows.Forms.Button();\n"; customeControlDesigner += " this.buttonSave = new System.Windows.Forms.Button();\n"; customeControlDesigner += " this.buttonNew = new System.Windows.Forms.Button();\n"; customeControlDesigner += " this.labelNext = new System.Windows.Forms.Label();\n"; customeControlDesigner += " this.labelprev = new System.Windows.Forms.Label();\n"; customeControlDesigner += " this.groupBox1.SuspendLayout();\n"; customeControlDesigner += " this.groupBox2.SuspendLayout();\n"; customeControlDesigner += " this.SuspendLayout();\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // groupBox1\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)\n"; customeControlDesigner += " | System.Windows.Forms.AnchorStyles.Left)\n"; customeControlDesigner += " | System.Windows.Forms.AnchorStyles.Right)));\n"; //customeControlDesigner += " this.groupBox1.Controls.Add(this.progressBar1);\n"; customeControlDesigner += " this.groupBox1.Controls.Add(this.labelprev);\n"; customeControlDesigner += " this.groupBox1.Controls.Add(this.labelNext);\n"; customeControlDesigner += " this.groupBox1.Controls.Add(this.groupBox2);\n"; customeControlDesigner += " this.groupBox1.Location = new System.Drawing.Point(3, 3);\n"; customeControlDesigner += " this.groupBox1.Name = \"groupBox1\";\n"; customeControlDesigner += " this.groupBox1.Size = new System.Drawing.Size(697, 332);\n"; customeControlDesigner += " this.groupBox1.TabIndex = 0;\n"; customeControlDesigner += " this.groupBox1.TabStop = false;\n"; customeControlDesigner += " this.groupBox1.Text =\"\";\n"; customeControlDesigner += " // \n"; // customeControlDesigner += " // progressBar1\n"; // customeControlDesigner += " // \n"; // customeControlDesigner += " this.progressBar1.Location = new System.Drawing.Point(187, 311);\n"; // customeControlDesigner += " this.progressBar1.Name = \"progressBar1\";\n"; // customeControlDesigner += " this.progressBar1.Size = new System.Drawing.Size(273, 13);\n"; // customeControlDesigner += " this.progressBar1.TabIndex = 10;\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // groupBox2\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.groupBox2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)\n"; customeControlDesigner += " | System.Windows.Forms.AnchorStyles.Right)));\n"; customeControlDesigner += " this.groupBox2.Controls.Add(this.buttonDelete);\n"; customeControlDesigner += " this.groupBox2.Controls.Add(this.buttonSave);\n"; customeControlDesigner += " this.groupBox2.Controls.Add(this.buttonNew);\n"; customeControlDesigner += " this.groupBox2.Location = new System.Drawing.Point(6, 267);\n"; customeControlDesigner += " this.groupBox2.Name = \"groupBox2\";\n"; customeControlDesigner += " this.groupBox2.Size = new System.Drawing.Size(685, 43);\n"; customeControlDesigner += " this.groupBox2.TabIndex = 0;\n"; customeControlDesigner += " this.groupBox2.TabStop = false;\n"; customeControlDesigner += " this.groupBox2.Text = \"\";\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // buttonDelete\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.buttonDelete.FlatAppearance.BorderColor = System.Drawing.Color.Blue;\n"; customeControlDesigner += " this.buttonDelete.FlatAppearance.MouseDownBackColor = System.Drawing.Color.Red;\n"; customeControlDesigner += " this.buttonDelete.FlatAppearance.MouseOverBackColor = System.Drawing.Color.Lime;\n"; customeControlDesigner += " this.buttonDelete.FlatStyle = System.Windows.Forms.FlatStyle.Popup;\n"; customeControlDesigner += " this.buttonDelete.Location = new System.Drawing.Point(181, 10);\n"; customeControlDesigner += " this.buttonDelete.Name = \"buttonDelete\";\n"; customeControlDesigner += " this.buttonDelete.Size = new System.Drawing.Size(87, 28);\n"; customeControlDesigner += " this.buttonDelete.TabIndex = 2;\n"; customeControlDesigner += " this.buttonDelete.Text = \"Delete\";\n"; customeControlDesigner += " this.buttonDelete.UseVisualStyleBackColor = true;\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // buttonSave\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.buttonSave.FlatAppearance.BorderColor = System.Drawing.Color.Blue;\n"; customeControlDesigner += " this.buttonSave.FlatAppearance.MouseDownBackColor = System.Drawing.Color.Red;\n"; customeControlDesigner += " this.buttonSave.FlatAppearance.MouseOverBackColor = System.Drawing.Color.Lime;\n"; customeControlDesigner += " this.buttonSave.FlatStyle = System.Windows.Forms.FlatStyle.Popup;\n"; customeControlDesigner += " this.buttonSave.Location = new System.Drawing.Point(367, 10);\n"; customeControlDesigner += " this.buttonSave.Name = \"buttonSave\";\n"; customeControlDesigner += " this.buttonSave.Size = new System.Drawing.Size(87, 28);\n"; customeControlDesigner += " this.buttonSave.TabIndex = 1;\n"; customeControlDesigner += " this.buttonSave.Text = \"Save\";\n"; customeControlDesigner += " this.buttonSave.UseVisualStyleBackColor = true;\n"; customeControlDesigner += " this.buttonSave.Click += new System.EventHandler(this.buttonSave_Click);\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // buttonNew\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.buttonNew.FlatAppearance.BorderColor = System.Drawing.Color.Blue;\n"; customeControlDesigner += " this.buttonNew.FlatAppearance.MouseDownBackColor = System.Drawing.Color.Red;\n"; customeControlDesigner += " this.buttonNew.FlatAppearance.MouseOverBackColor = System.Drawing.Color.Lime;\n"; customeControlDesigner += " this.buttonNew.FlatStyle = System.Windows.Forms.FlatStyle.Popup;\n"; customeControlDesigner += " this.buttonNew.Location = new System.Drawing.Point(274, 10);\n"; customeControlDesigner += " this.buttonNew.Name = \"buttonNew\";\n"; customeControlDesigner += " this.buttonNew.Size = new System.Drawing.Size(87, 28);\n"; customeControlDesigner += " this.buttonNew.TabIndex = 0;\n"; customeControlDesigner += " this.buttonNew.Text = \"New*\";\n"; customeControlDesigner += " this.buttonNew.UseVisualStyleBackColor = true;\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // labelNext\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.labelNext.AutoSize = true;\n"; customeControlDesigner += " this.labelNext.Location = new System.Drawing.Point(566, 0);\n"; customeControlDesigner += " this.labelNext.Name = \"labelNext\";\n"; customeControlDesigner += " this.labelNext.Size = new System.Drawing.Size(25, 13);\n"; customeControlDesigner += " this.labelNext.TabIndex = 11;\n"; customeControlDesigner += " this.labelNext.Text = \">>+\";\n"; customeControlDesigner += " this.labelNext.Click += new System.EventHandler(this.labelNext_Click);\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // labelprev\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.labelprev.AutoSize = true;\n"; customeControlDesigner += " this.labelprev.Location = new System.Drawing.Point(523, 0);\n"; customeControlDesigner += " this.labelprev.Name = \"labelprev\";\n"; customeControlDesigner += " this.labelprev.Size = new System.Drawing.Size(22, 13);\n"; customeControlDesigner += " this.labelprev.TabIndex = 12;\n"; customeControlDesigner += " this.labelprev.Text = \"-<<\";\n"; customeControlDesigner += " this.labelprev.Click += new System.EventHandler(this.labelprev_Click);\n"; customeControlDesigner += " // \n"; customeControlDesigner += " // UserControlinsert\n"; customeControlDesigner += " // \n"; customeControlDesigner += " this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);\n"; customeControlDesigner += " this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;\n"; customeControlDesigner += " this.AutoScroll = true;\n"; customeControlDesigner += " this.Controls.Add(this.groupBox1);\n"; customeControlDesigner += " this.Name = \"UserControl" + tableName + "insert\";\n"; customeControlDesigner += " this.Size = new System.Drawing.Size(700, 338);\n"; customeControlDesigner += " this.groupBox1.ResumeLayout(false);\n"; customeControlDesigner += " this.groupBox1.PerformLayout();\n"; //customeControlDesigner += " ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();\n"; //customeControlDesigner += " ((System.ComponentModel.ISupportInitialize)(this.numericUpDown1)).EndInit();\n"; customeControlDesigner += " this.groupBox2.ResumeLayout(false);\n"; customeControlDesigner += " this.ResumeLayout(false);\n"; customeControlDesigner += " }\n"; customeControlDesigner += " #endregion\n"; customeControlDesigner += " private System.Windows.Forms.GroupBox groupBox1;\n"; customeControlDesigner += " private System.Windows.Forms.GroupBox groupBox2;\n"; customeControlDesigner += " private System.Windows.Forms.Button buttonNew;\n"; customeControlDesigner += " private System.Windows.Forms.Button buttonDelete;\n"; customeControlDesigner += " private System.Windows.Forms.Button buttonSave;\n"; //customeControlDesigner += " private System.Windows.Forms.ProgressBar progressBar1;\n"; customeControlDesigner += " private System.Windows.Forms.Label labelNext;\n"; customeControlDesigner += " private System.Windows.Forms.Label labelprev;\n"; customeControlDesigner += privateString + "\n"; customeControlDesigner += " }\n"; customeControlDesigner += " }\n"; string path = ""; path = Directory.GetCurrentDirectory() + "\\" + projectName + "\\" + projectName + "\\view\\UserControl" + tableName + "insert.Designer.cs"; File.WriteAllText(path, customeControlDesigner); }
//this class should build the class for the custome control designer muidinsert private void generateCustomeControlClass(string tableName, string projectName) { validationString.Clear(); string customeControlClass = ""; customeControlClass += "\n"; customeControlClass += "using System;\n"; customeControlClass += "using System.Collections.Generic;\n"; customeControlClass += "using System.ComponentModel;\n"; customeControlClass += "using System.Drawing;\n"; customeControlClass += "using System.Data;\n"; customeControlClass += "using System.Linq;\n"; customeControlClass += "using System.Text;\n"; customeControlClass += "using " + projectName + ".model;\n"; customeControlClass += "using System.Windows.Forms;\nusing " + projectName + ".control;\n"; customeControlClass += "namespace " + projectName + ".view\n"; customeControlClass += "{\n"; customeControlClass += " public partial class UserControl" + tableName + "insert : UserControl\n"; customeControlClass += " {\n"; customeControlClass += " public UserControl" + tableName + "insert()\n"; customeControlClass += " {\n"; customeControlClass += " InitializeComponent();\n"; customeControlClass += " }\n"; customeControlClass += " ListView mylv = new ListView();\n"; customeControlClass += " int selectedInd = 0;\n"; customeControlClass += " int myflag = 0;\n"; customeControlClass += " private void buttonSave_Click(object sender, EventArgs e)\n"; customeControlClass += " {\n"; customeControlClass += " " + tableName + "muid mymodel= new " + tableName + "muid();" + "\n"; DataTable table = new Connectoperations().describeTable(tableName); int i = 0; foreach (DataRow drow in table.Rows) { string dataType = drow[1].ToString();//.Substring(0, 3); string attributeName = drow[0].ToString(); int count = 0; count = dataType.IndexOf('('); try { dataType = dataType.Substring(0, count); } catch { dataType = drow[1].ToString(); } switch (dataType) { case "int": case "tinyint": case "smallint": case "bigint": case "mediumint": validationString.Add("mymodel.validate_int(" + controls[i] + ")"); break; case "varchar": case "text": case "time": case "timestamp": case "bit": case "bool": case "enum": case "set": case "serial": case "tinytext": case "mediumtext": case "longtext": break; case "char": break; case "float": case "double": case "decimal": case "real": validationString.Add("mymodel.validate_floatpoints(" + controls[i] + ")"); break; case "date": case "datetime": case "year": validationString.Add("mymodel.validate_date(" + controls[i] + ".ToString())"); break; case "longblob": case "blob": case "mediumblob": case "tinyblob": break; }//end switch i++; }//end attributes if (validationString.Count > 0) { customeControlClass += " if (myflag < 1)\n"; customeControlClass += "{\n"; customeControlClass += " if("; int j = 0; string greenapple = "&&"; foreach (string str in validationString) { if (j < validationString.Count - 1) { } else { greenapple = ""; } customeControlClass += str + "==true" + greenapple; j++; } customeControlClass += "){\n"; customeControlClass += " mymodel.insert" + tableName + "(" + defaultInsertattribute + "," + defaultInservalues + ");\n"; customeControlClass += " }\n"; customeControlClass += " else{\n"; customeControlClass += " MessageBox.Show(\"Validation Failed!\");\n"; customeControlClass += " }\n"; customeControlClass += "}\n"; customeControlClass += " else\n"; customeControlClass += "{\n"; //update data customeControlClass += " if("; j = 0; greenapple = "&&"; foreach (string str in validationString) { if (j < validationString.Count - 1) { } else { greenapple = ""; } customeControlClass += str + "==true" + greenapple; j++; } customeControlClass += "){\n"; customeControlClass += " mymodel.update" + tableName + "(" + defaultInsertattribute + "," + defaultInservalues + ",\"where id=\"+textBoxid.Text);\n"; customeControlClass += " }\n"; customeControlClass += " else{\n"; customeControlClass += " MessageBox.Show(\"Validation Failed!\");\n"; customeControlClass += " }\n"; customeControlClass += "}\n"; } else { customeControlClass += " mymodel.insert" + tableName + "(" + defaultInsertattribute + "," + defaultInservalues + ");\n"; } customeControlClass += " }\n"; customeControlClass += "public void loaddata(ListView lv,int selectedIndex,int flag)\n"; customeControlClass += "{\n"; customeControlClass += "try{"; customeControlClass += "mylv = lv;\n"; customeControlClass += "selectedInd = selectedIndex;\n"; customeControlClass += "myflag = flag;\n"; //all textboxes go here i = 0; foreach (DataRow drow in table.Rows) { string dataType = drow[1].ToString();//.Substring(0, 3); string attributeName = drow[0].ToString(); int count = 0; count = dataType.IndexOf('('); try { dataType = dataType.Substring(0, count); } catch { dataType = drow[1].ToString(); } switch (dataType) { case "int": case "tinyint": case "smallint": case "bigint": case "mediumint": customeControlClass += controls[i] + "=lv.Items[selectedIndex].SubItems[" + (i + 1) + "].Text;\n"; break; case "varchar": case "text": case "time": case "timestamp": case "bit": case "bool": case "enum": case "set": case "serial": case "tinytext": case "mediumtext": case "longtext": customeControlClass += controls[i] + "=lv.Items[selectedIndex].SubItems[" + (i + 1) + "].Text;\n"; break; case "char": customeControlClass += controls[i] + "=lv.Items[selectedIndex].SubItems[" + (i + 1) + "].Text;\n"; break; case "float": case "double": case "decimal": case "real": customeControlClass += controls[i] + "=lv.Items[selectedIndex].SubItems[" + (i + 1) + "].Text;\n"; break; case "date": case "datetime": case "year": customeControlClass += controls[i] + "=Convert.ToDateTime(lv.Items[selectedIndex].SubItems[" + (i + 1) + "].Text);\n"; break; case "longblob": case "blob": case "mediumblob": case "tinyblob": break; }//end switch i++; }//end attributes ////////////////// customeControlClass += "}\n"; customeControlClass += "catch{}\n"; customeControlClass += "}\n"; customeControlClass += "private void labelprev_Click(object sender, EventArgs e)\n"; customeControlClass += "{\n"; customeControlClass += " if (selectedInd > 0)\n"; customeControlClass += " {\n"; customeControlClass += " loaddata(mylv, --selectedInd, 3);\n"; customeControlClass += " }\n"; customeControlClass += "}\n"; customeControlClass += "private void labelNext_Click(object sender, EventArgs e)\n"; customeControlClass += "{\n"; customeControlClass += " if (mylv.Items.Count-1 != selectedInd)\n"; customeControlClass += " {\n"; customeControlClass += " loaddata(mylv, ++selectedInd, 3);\n"; customeControlClass += " }\n"; customeControlClass += "}\n"; customeControlClass += " }\n"; customeControlClass += "}\n"; string path = ""; path = Directory.GetCurrentDirectory() + "\\" + projectName + "\\" + projectName + "\\view\\UserControl" + tableName + "insert.cs"; File.WriteAllText(path, customeControlClass); }
/// <summary> /// genereates muid ie merge,update,insert and delete methods /// </summary> /// <param name="tableName">the name of the table for which muid is being generated</param> /// <returns>string</returns> public string generateMUID(string tableName,string projectName) { string muidString = ""; try { muidString += "\n"; //create insert muidString += "public bool insert" + tableName + " (string attributes,string values){\n"; muidString += "if(new " + tableName + "Control().BeforeInsert()==true){\n"; muidString += "if(new Connectoperations().insert(\"" + tableName + "\",attributes,values)>0){\n"; muidString += "MessageBox.Show(\"captured!\");\n"; muidString += "if(new " + tableName + "Control().AfterInsert()==true){\n"; muidString += "return true;\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "MessageBox.Show(\"Failed!\");\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "MessageBox.Show(\"Failed!\");\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; //create update muidString += "public bool update" + tableName + " (string attributes,string values,string where){\n"; muidString += "if(new " + tableName + "Control().BeforeUpdate()==true){\n"; muidString += "if(new Connectoperations().update(\"" + tableName + "\",attributes,values,where)>0){\n"; muidString += "MessageBox.Show(\"updated!\");\n"; muidString += "if(new " + tableName + "Control().AfterUpdate()==true){\n"; muidString += "return true;\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "MessageBox.Show(\"Failed!\");\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "MessageBox.Show(\"Failed!\");\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; //create select muidString += "public DataTable selecttable" + tableName + "(string attributes,string where){\n"; muidString += "DataTable dt= new DataTable();\n"; muidString += "if(new " + tableName + "Control().BeforeSelect()==true){\n"; muidString += "dt=new Connectoperations().selectdatable(\"" + tableName + "\",attributes,where);\n"; muidString += "if(new " + tableName + "Control().AfterSelect()==true){\n"; muidString += "return dt;\n"; muidString += "}\n"; muidString += "else\n"; muidString += "{\n"; muidString += "return new DataTable();\n"; muidString += "}\n"; muidString += "}\n"; muidString += "return dt;\n"; muidString += "}\n"; //create select single muidString += "public string selectsinglevalue" + tableName + "(string attribute,string where){\n"; muidString += "string str= \"\";\n"; muidString += "if(new " + tableName + "Control().BeforeSelect()==true){\n"; muidString += "str=new Connectoperations().singleval(\"" + tableName + "\",attribute,where);\n"; muidString += "if(new " + tableName + "Control().AfterSelect()==true){\n"; muidString += "return str;\n"; muidString += "}\n"; muidString += "else\n"; muidString += "{\n"; muidString += "return \"\";\n"; muidString += "}\n"; muidString += "}\n"; muidString += "return str;\n"; muidString += "}\n"; //create delete muidString += "public bool delete" + tableName + " (string where){\n"; muidString += "if(new " + tableName + "Control().BeforeDelete()==true){\n"; muidString += "if(new Connectoperations().delete(\"" + tableName + "\",where)>0){\n"; muidString += "MessageBox.Show(\"deleted!\");\n"; muidString += "if(new " + tableName + "Control().AfterDelete()==true){\n"; muidString += "return true;\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "MessageBox.Show(\"Failed!\");\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; muidString += "else{\n"; muidString += "MessageBox.Show(\"Failed!\");\n"; muidString += "return false;\n"; muidString += "}\n"; muidString += "}\n"; //generateProjectProperty list of property muidString += "public List<" + tableName + "Property> listOf" + tableName + "(){\n"; muidString += "List<" + tableName + "Property> mylistOf" + tableName + "=new List<" + tableName + "Property>();\n"; muidString += "if(new " + tableName + "Control().BeforeSelect()==true){\n"; muidString += "DataTable dat= selecttable" + tableName + "(\"*\",\"\");\n"; //loop for attributes int i = 0; DataTable table = new Connectoperations().describeTable(tableName); muidString += "foreach(DataRow row in dat.Rows){\n"; muidString += tableName + "Property mylist= new " + tableName + "Property();\n"; foreach (DataRow drow in table.Rows) { string dataType = drow[1].ToString();//.Substring(0, 3); string attributeName = drow[0].ToString(); int count = 0; count = dataType.IndexOf('('); try { dataType = dataType.Substring(0, count); } catch { dataType = drow[1].ToString(); } switch (dataType) { case "int": case "tinyint": case "smallint": case "bigint": case "mediumint": muidString += ("mylist." + attributeName + "=Convert.ToInt32(row[" + (i++) + "].ToString());\n"); break; case "varchar": case "text": case "time": case "timestamp": case "bit": case "bool": case "enum": case "set": case "serial": case "tinytext": case "mediumtext": case "longtext": muidString += ("mylist." + attributeName + "=Convert.ToString(row[" + (i++) + "].ToString());\n"); break; case "char": muidString += ("mylist." + attributeName + "=Convert.ToChar(row[" + (i++) + "].ToString());\n"); break; case "float": muidString += ("mylist." + attributeName + "= Convert.ToSingle(row[" + (i++) + "].ToString());\n"); break; case "double": case "decimal": case "real": muidString += ("mylist." + attributeName + "= Convert.ToDouble(row[" + (i++) + "].ToString());\n"); break; case "date": case "datetime": case "year": muidString += ("mylist." + attributeName + "=Convert.ToDateTime(row[" + (i++) + "].ToString());\n"); break; case "longblob": case "blob": case "mediumblob": case "tinyblob": muidString += ("mylist." + attributeName + "=(byte[])row[" + (i++) + "];\n"); break; }//end switch }//end attributes muidString += "mylistOf" + tableName + ".Add(mylist);\n"; muidString += "if(new " + tableName + "Control().AfterSelect()==true){\n"; muidString += "return mylistOf" + tableName + ";\n"; muidString += "}\n"; muidString += "else\n"; muidString += "{\n"; muidString += "return new List<" + tableName + "Property>();\n"; muidString += "}\n"; muidString += "}\n"; muidString += "}\n"; muidString += "return mylistOf" + tableName + ";\n"; muidString += "}\n"; muidString += " public string getmysqldate(DateTimePicker dt)\n"; muidString += "{\n"; muidString += "dt.Format = DateTimePickerFormat.Long;\n"; muidString += "return new Connectoperations().mysqldate(Convert.ToDateTime(dt.Value));\n"; muidString += "}\n"; muidString += "//Validation methods\n"; muidString += "public bool validate_int(string val){\n"; muidString += "return Regex.IsMatch(val, @\"[0-9]+\");\n"; muidString += "}\n"; muidString += "public bool validate_floatpoints(string val){\n"; muidString += "return Regex.IsMatch(val, @\"[0-9]+\\.\\[0-9]+\");\n"; muidString += "}\n"; muidString += "public bool validate_date(string val){\n"; muidString += "// Return true if val is valid mysql date format.\n"; muidString += "return true;\n"; muidString += "}\n"; muidString += "public bool validate_email(string val){\n"; muidString += "// Return true if val is in valid e-mail format.\n"; muidString += "return Regex.IsMatch(val, @\"\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*([,;]\\s*\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*)*\");\n"; muidString += "}\n"; //create associations List<ClassRelations> lcr = new List<ClassRelations>(); lcr = new ClassGenerateRelation().loadRelations(projectName, ".NET", "Forms", "C#", tableName); for (int x = 0; x < lcr.Count; x++) { if (lcr[x].name == tableName) { //create has class methods for (int y = 0; y < lcr[x].has.Count; y++) { string[] hasString = lcr[x].has[y].Split('#'); string hasTableName = hasString[0]; string hasField = hasString[1]; //create a specific method muidString += "public DataTable " + tableName +hasTableName+ "hasMany(string andorclause){\n"; muidString += "DataTable dt= new DataTable();\n"; muidString += "if(new " + tableName + "Control().BeforeSelect()==true){\n"; muidString += "dt=new Connectoperations().selectdatable(\"" + tableName+","+hasTableName + "\",\"*\",\"where "+tableName+".id="+hasTableName+"."+hasField+" \"+ andorclause);\n"; muidString += "if(new " + tableName + "Control().AfterSelect()==true){\n"; muidString += "return dt;\n"; muidString += "}\n"; muidString += "else\n"; muidString += "{\n"; muidString += "return new DataTable();\n"; muidString += "}\n"; muidString += "}\n"; muidString += "return dt;\n"; muidString += "}\n"; }//end for //create has class methods for (int y = 0; y < lcr[x].belongsTo.Count; y++) { string[] belongToString = lcr[x].belongsTo[y].Split('#'); string belongsToTableName = belongToString[0]; string belongsToField = belongToString[1]; //create a specific method muidString += "public DataTable " + tableName + belongsToTableName + "belongsTo(string andorclause){\n"; muidString += "DataTable dt= new DataTable();\n"; muidString += "if(new " + tableName + "Control().BeforeSelect()==true){\n"; muidString += "dt=new Connectoperations().selectdatable(\"" + tableName + "," + belongsToTableName + "\",\"*\",\"where " + tableName + ".id=" + tableName + "." + belongsToField + " \"+ andorclause);\n"; muidString += "if(new " + tableName + "Control().AfterSelect()==true){\n"; muidString += "return dt;\n"; muidString += "}\n"; muidString += "else\n"; muidString += "{\n"; muidString += "return new DataTable();\n"; muidString += "}\n"; muidString += "}\n"; muidString += "return dt;\n"; muidString += "}\n"; }//end for } } return muidString; } catch (Exception ex) { MessageBox.Show(ex.Message); return muidString; } }