C# (CSharp) Islemler.GetColumns Examples

Example #1

        private static void GenerateModel()
        {
            TextInfo textInfo = new CultureInfo("en-US", false).TextInfo;

            DataTable tables = Islemler.GetTables();

            foreach (DataRow item in tables.Rows)
            {
                string    Content     = string.Empty;
                string    TableName   = item["TABLE_NAME"].ToString();
                string    FolderName  = item["FOLDER_NAME"].ToString();
                string    Columns     = string.Empty;
                DataTable columns     = Islemler.GetColumns(TableName);
                DataTable ForeingKeys = Islemler.GetFK(TableName);
                DataTable Referances  = Islemler.GetRef(TableName);

                TableName = textInfo.ToTitleCase(textInfo.ToLower(TableName)).Replace("_", "");

                foreach (DataRow Col in columns.Rows)
                {
                    string ColumnName = textInfo.ToTitleCase(textInfo.ToLower(Col["COLUMN_NAME"].ToString())).Replace("_", "");
                    string DbType     = Col["DATA_TYPE"].ToString();
                    string DataType   = string.Empty;

                    switch (DbType)
                    {
                    case "NUMBER":
                        DataType = "decimal";
                        break;

                    case "CHAR":
                        DataType = "string";
                        break;

                    case "VARCHAR2":
                        DataType = "string";
                        break;

                    case "DATE":
                        DataType = "DateTime";
                        break;

                    case "LONG":
                        DataType = "string";
                        break;

                    case "LONG RAW":
                        DataType = "string";
                        break;

                    case "BLOB":
                        DataType = "string";
                        break;

                    case "CLOB":
                        DataType = "string";
                        break;

                    default:
                        DataType = "string";
                        break;
                    }

                    Columns += @"
        " + (Col["NULLABLE"].ToString() == "N" ? Environment.NewLine + "\t\t[Required]" : string.Empty) + @"
        public " + DataType + " " + ColumnName + " { get; set; }";
                }


                string FKs = string.Empty;
                foreach (DataRow fk in ForeingKeys.Rows)
                {
                    FKs += Environment.NewLine + Environment.NewLine + "\t\tpublic " + textInfo.ToTitleCase(textInfo.ToLower(fk["R_TABLE_NAME"].ToString())).Replace("_", "") + "Model " + textInfo.ToTitleCase(textInfo.ToLower(fk["R_TABLE_NAME"].ToString())).Replace("_", "") + " { get; }";
                }

                string Refs = string.Empty;
                foreach (DataRow r in Referances.Rows)
                {
                    Refs += Environment.NewLine + Environment.NewLine + "\t\tpublic virtual IList<" + textInfo.ToTitleCase(textInfo.ToLower(r["TABLE_NAME"].ToString())).Replace("_", "") + "Model> " + textInfo.ToTitleCase(textInfo.ToLower(r["TABLE_NAME"].ToString())).Replace("_", "") + " { get; set; }";
                }

                Content = @"using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;

namespace " + Namespace + FolderName + @"
{
    public class " + TableName + @"Model : BaseModel<uint>
    {" + Columns + FKs + Refs + @"
    }
}
";

                CreateFiles(TableName + "Model", FolderName, Content);
            }
        }