public JsonResult GetTableById(double tableID)
{
IGumruk _iGumruk = new BSGumruk();
int tblID = (int)(tableID / 0.123123);
d_b_tables dbTable = _iGumruk.GetTableById(tblID);
//string json = JsonConvert.SerializeObject(schemas);
TableProperties dt = new Models.TableProperties()
{
TableName = dbTable.name,
SchemaName = dbTable.d_b_schemas.name,
ColumnCount = dbTable.d_b_columns.Count,
SchemaID = dbTable.d_b_schemasId,
};
foreach (var item2 in dbTable.d_b_columns)
{
foreach (var item3 in item2.d_b_column_lookups)
{
item3.d_b_Column_to = _iGumruk.GetColumnById(item3.column_to_id);
dt.RelatedTables = dt.RelatedTables + " " + item3.d_b_Column_to.d_b_tables.d_b_schemas.name + "." +
item3.d_b_Column_to.d_b_tables.name + "." + item3.d_b_Column_to.name;
}
}
return(Json(dt, JsonRequestBehavior.AllowGet));
}
public ActionResult GetTablePropertiesByNameSchemaName(string tableName, string schemaName)
{
IGumruk _iGumruk = new BSGumruk();
d_b_tables dbTable = _iGumruk.GetTableByNameSchemaName(tableName, schemaName);
return(PartialView("../Home/Table", dbTable));
}
public ActionResult GetTablesModules(int ID)
{
IGumruk _iGumruk = new BSGumruk();
d_b_tables dbTable = _iGumruk.GetTableById(ID);
return(PartialView("TableModules", dbTable.Modules));
}
public ActionResult GetTablePropertiesById(int tableID)
{
IGumruk _iGumruk = new BSGumruk();
d_b_tables dbTable = _iGumruk.GetTableById(tableID);
return(PartialView("Table", dbTable));
}
public int AddTables(string tablename, string details, int schema_id, int isempty, bool isView)
{
IGumruk _iGumruk = new BSGumruk();
d_b_tables tbl = new d_b_tables();
tbl.id = 0;
tbl.mid = 0;
tbl.name = tablename;
tbl.d_b_schemasId = schema_id;
tbl.details = details;
tbl.updated_at = DateTime.Now;
tbl.created_at = DateTime.Now;
tbl.isempty = Convert.ToBoolean(isempty);
tbl.isView = isView;
return(_iGumruk.NewTable(tbl));
}
public JsonResult GetTableModules(double tableID)
{
IGumruk iGumruk = new BSGumruk();
int tblID = (int)(tableID / 0.123123);
d_b_tables dbTable = iGumruk.GetTableById(tblID);
List <TableModules> modules = new List <TableModules>();
foreach (var item in dbTable.app_module_operations)
{
TableModules tblMod = new TableModules()
{
ModuleName = item.app_sub_modules.app_base_modules.name,
Operation = item.operation,
Query = item.query,
SubModuleName = item.app_sub_modules.name,
};
modules.Add(tblMod);
}
return(Json(modules, JsonRequestBehavior.AllowGet));
}