public List <vmColumn> GetDatabaseTableColumnList([FromBody] vmParam model)
{
List <vmColumn> data = new List <vmColumn>();
string conString_ = conString + " Database=" + model.DatabaseName + ";";
using (SqlConnection con = new SqlConnection(conString_))
{
int count = 0; con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT COLUMN_NAME, DATA_TYPE, ISNULL(CHARACTER_MAXIMUM_LENGTH,0), IS_NULLABLE, TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + model.TableName + "' ORDER BY ORDINAL_POSITION", con))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
count++;
data.Add(new vmColumn()
{
ColumnId = count,
ColumnName = dr[0].ToString(),
DataType = dr[1].ToString(),
MaxLength = dr[2].ToString(),
IsNullable = dr[3].ToString(),
Tablename = model.TableName.ToString(),
TableSchema = dr[4].ToString()
});
}
}
}
}
return(data.ToList());
}
public List <ColumnInfo> GetDatabaseTableColumnList([FromBody] vmParam model)
{
var dbName = model.DatabaseName;
var tableName = model.TableName;
return(getColumnsFromTable(dbName, tableName));
}
public List <TableInfo> GetDatabaseTableList([FromBody] vmParam model)
{
var dbName = model.DatabaseName;
List <TableInfo> data = getAllTableFromDb(dbName);
return(data.ToList());
}
public IActionResult GetMapColumns([FromBody] vmParam model)
{
var result = "";
string webRootPath = _hostingEnvironment.WebRootPath; //From web
var filePath = webRootPath + "\\template\\ColumnMap\\colmap.json";
if (!System.IO.File.Exists(filePath))
{
using (StreamWriter sw = System.IO.File.CreateText(filePath)) {
sw.Write("[]");
}
}
var content = System.IO.File.ReadAllText(filePath, Encoding.UTF8);
result = content;
return(Json(result));
}
public List <vmTable> GetDatabaseTableList([FromBody] vmParam model)
{
List <vmTable> data = new List <vmTable>();
string conString_ = conString + " Database=" + model.DatabaseName + ";";
using (SqlConnection con = new SqlConnection(conString_))
{
int count = 0; con.Open();
DataTable schema = con.GetSchema("Tables");
foreach (DataRow row in schema.Rows)
{
count++;
data.Add(new vmTable()
{
TableId = count,
TableName = row[2].ToString()
});
}
}
return(data.ToList());
}
public List <vmColumn> GetDatabaseTableColumnList([FromBody] vmParam model)
{
return(GetTableColumns(model.DatabaseName, model.TableName).ToList());
}
