public OutputObject GenerateWebServiceControllerClass(SqlTable sqlTable, List <string> namespaceIncludes, IDictionary <string, bool> options) { if (sqlTable == null) { throw new ArgumentException("Sql table cannot be null"); } string class_name = NameFormatter.ToCSharpClassName(sqlTable.Name); var output = new OutputObject { Name = $"{class_name}Controller.cs", Type = OutputObject.eObjectType.CSharp }; var sb = new StringBuilder(); sb.AppendLine("using System;"); sb.AppendLine("using System.Collections.Generic;"); sb.AppendLine("using System.Reflection;"); sb.AppendLine(); sb.AppendLine("using Microsoft.AspNetCore.Mvc;"); sb.AppendLine(); if (namespaceIncludes != null && namespaceIncludes.Count > 1) { sb.AppendLine(GenerateNamespaceIncludes(namespaceIncludes)); } sb.AppendLine($"namespace {CONTROLLER_NAMESPACE}.{NameFormatter.ToCSharpPropertyName(sqlTable.Database.Name)}"); sb.AppendLine("{"); sb.AppendLine(AddTabs(1) + "[ApiController]"); if (options[GENERATE_BASE_CONTROLLER]) { sb.AppendLine(AddTabs(1) + $"public class {sqlTable.Name}Controller : ControllerBase"); } else { sb.AppendLine(AddTabs(1) + $"public class {sqlTable.Name}Controller : ApiController"); } sb.AppendLine(AddTabs(1) + "{"); sb.AppendLine(AddTabs(2) + $"public {sqlTable.Name}Controller() {{ }}"); sb.AppendLine(); // controllers sb.AppendLine(GenerateGetById(sqlTable.Name)); sb.AppendLine(); sb.AppendLine(GenerateGetAll(sqlTable.Name)); sb.AppendLine(); sb.AppendLine("}"); output.Body = sb.ToString(); return(output); }
public OutputObject GenerateWebServiceControllerClass(SqlTable sqlTable, List <string> namespaceIncludes, IDictionary <string, bool> options) { if (sqlTable == null) { throw new ArgumentException("Sql table cannot be null"); } string controllerName = NameFormatter.ToCSharpClassName(sqlTable.Name); var output = new OutputObject { Name = $"{controllerName}Controller.cs", Type = OutputObject.eObjectType.CSharp }; var sb = new StringBuilder(); sb.AppendLine(); sb.AppendLine("using Microsoft.AspNetCore.Mvc;"); sb.AppendLine("using System;"); sb.AppendLine("using TelemetryManager;"); sb.AppendLine(); if (namespaceIncludes != null && namespaceIncludes.Count > 1) { sb.AppendLine(GenerateNamespaceIncludes(namespaceIncludes)); } sb.AppendLine($"namespace {CONTROLLER_NAMESPACE}"); sb.AppendLine("{"); sb.AppendLine(AddTabs(1) + "[ApiController]"); if (options[GENERATE_BASE_CONTROLLER]) { sb.AppendLine(AddTabs(1) + $"public class {controllerName}Controller : ApiControllerBase"); } else { sb.AppendLine(AddTabs(1) + $"public class {controllerName}Controller : ControllerBase"); } sb.AppendLine(AddTabs(1) + "{"); sb.AppendLine(AddTabs(2) + $"public {controllerName}Controller(IConfigProvider config, ILogger log, IMetrics metrics, IDataProvider datasource, ISecurityProvider security)"); sb.AppendLine(AddTabs(3) + $": base(config, log, metrics, datasource, security) {{ }}"); sb.AppendLine(); // controllers sb.AppendLine(GenerateGetById(controllerName, options)); sb.AppendLine(); sb.AppendLine(GenerateGetAll(controllerName, options)); sb.AppendLine(); //sb.AppendLine(GenerateGetAllPaged(sqlTable.Name)); //sb.AppendLine(); //sb.AppendLine(GenerateInsert(sqlTable.Name)); //sb.AppendLine(); //sb.AppendLine(GenerateUpdate(sqlTable.Name)); //sb.AppendLine(); //sb.AppendLine(GenerateDelete(sqlTable.Name)); //sb.AppendLine(); sb.AppendLine("}"); output.Body = sb.ToString(); return(output); }
public OutputObject GenerateWinformEditCode(SqlTable sqlTable) { #region Sample Output //using System; //using System.Collections.Generic; //using System.ComponentModel; //using System.Data; //using System.Drawing; //using System.Linq; //using System.Text; //using System.Windows.Forms; //namespace MarvelSuperheroesEditor //{ // public partial class Form1 : Form // { // public Form1() // { // InitializeComponent(); // } // } //} #endregion if (sqlTable == null) { return(null); } string class_name = "frmEdit" + NameFormatter.ToCSharpPropertyName(sqlTable.Name); string dal_name = NameFormatter.ToCSharpClassName("Dal" + sqlTable.Name); var output = new OutputObject { Name = class_name + ".cs", Type = OutputObject.eObjectType.CSharp }; var sb = new StringBuilder(); sb.AppendLine("using System;"); sb.AppendLine("using System.Collections.Generic;"); sb.AppendLine("using System.Configuration;"); sb.AppendLine("using System.ComponentModel;"); sb.AppendLine("using System.Data;"); //sb.AppendLine("using System.Drawing;"); //sb.AppendLine("using System.Linq;"); //sb.AppendLine("using System.Text;"); sb.AppendLine("using System.Windows.Forms;"); sb.AppendLine(); sb.AppendLine("using DAL;"); sb.AppendLine("using " + NameFormatter.ToCSharpPropertyName(sqlTable.Database.Name) + ";"); sb.AppendLine(); sb.AppendLine("namespace " + NameFormatter.ToCSharpPropertyName(sqlTable.Database.Name) + "Editor"); sb.AppendLine("{"); sb.AppendLine(AddTabs(1) + "public partial class " + class_name + " : Form"); sb.AppendLine(AddTabs(1) + "{"); #region Fields sb.AppendLine(AddTabs(2) + "#region Fields"); sb.AppendLine(); sb.AppendLine(AddTabs(3) + "protected string _SQLConnection = ConfigurationManager.ConnectionStrings[\"SQLConnection\"].ConnectionString;"); sb.AppendLine(); sb.AppendLine(AddTabs(2) + "#endregion"); sb.AppendLine(); #endregion #region Methods sb.AppendLine(AddTabs(2) + "#region Methods"); sb.AppendLine(); sb.AppendLine(AddTabs(3) + "public " + class_name + "()"); sb.AppendLine(AddTabs(3) + "{"); sb.AppendLine(AddTabs(4) + "InitializeComponent();"); sb.AppendLine(); sb.AppendLine(AddTabs(4) + "LoadPopulateItemList();"); sb.AppendLine(AddTabs(3) + "}"); sb.AppendLine(); sb.AppendLine(AddTabs(3) + "private bool LoadPopulateItemList()"); sb.AppendLine(AddTabs(3) + "{"); sb.AppendLine(AddTabs(4) + "this.Cursor = Cursors.WaitCursor;"); sb.AppendLine(); sb.AppendLine(AddTabs(4) + "try"); sb.AppendLine(AddTabs(4) + "{"); sb.AppendLine(AddTabs(5) + "" + dal_name + " dal = new " + dal_name + "(_SQLConnection);"); sb.AppendLine(); sb.AppendLine(AddTabs(5) + "if (dal.LoadAllFromDb())"); sb.AppendLine(AddTabs(5) + "{"); sb.AppendLine(AddTabs(6) + "if (dal.Collection != null && dal.Collection.Count != 0)"); sb.AppendLine(AddTabs(6) + "{"); sb.AppendLine(AddTabs(7) + "cboItemList.BeginUpdate();"); sb.AppendLine(AddTabs(7) + "cboItemList.ValueMember = \"" + FindIdField(sqlTable) + "\";"); sb.AppendLine(AddTabs(7) + "cboItemList.DisplayMember = \"" + FindNameField(sqlTable) + "\";"); sb.AppendLine(AddTabs(7) + "cboItemList.DataSource = dal.Collection;"); sb.AppendLine(AddTabs(7) + "cboItemList.EndUpdate();"); sb.AppendLine(AddTabs(6) + "}"); sb.AppendLine(AddTabs(5) + "}"); sb.AppendLine(AddTabs(4) + "}"); sb.AppendLine(AddTabs(4) + "catch"); sb.AppendLine(AddTabs(4) + "{"); sb.AppendLine(AddTabs(5) + "return false;"); sb.AppendLine(AddTabs(4) + "}"); sb.AppendLine(); sb.AppendLine(AddTabs(4) + "this.Cursor = Cursors.Default;"); sb.AppendLine(AddTabs(4) + "return true;"); sb.AppendLine(AddTabs(3) + "}"); sb.AppendLine(); sb.AppendLine(AddTabs(2) + "#endregion"); sb.AppendLine(); #endregion #region Events sb.AppendLine(AddTabs(2) + "#region Events"); sb.AppendLine(); sb.AppendLine(AddTabs(3) + "private void btnCancel_Click(object sender, EventArgs e)"); sb.AppendLine(AddTabs(3) + "{"); sb.AppendLine(AddTabs(3) + "}"); sb.AppendLine(AddTabs(3) + "private void btnSave_Click(object sender, EventArgs e)"); sb.AppendLine(AddTabs(3) + "{"); sb.AppendLine(AddTabs(3) + "}"); sb.AppendLine(AddTabs(3) + "private void cboItemList_SelectedIndexChanged(object sender, EventArgs e)"); sb.AppendLine(AddTabs(3) + "{"); sb.AppendLine(AddTabs(3) + "}"); sb.AppendLine(); sb.AppendLine(AddTabs(2) + "#endregion"); #endregion sb.AppendLine(AddTabs(1) + "}"); sb.AppendLine("}"); output.Body = sb.ToString(); return(output); }