/// <summary>
///
/// </summary>
/// <returns></returns>
public JsonResult GetEntity(string clientid)
{
System.Data.DataTable dt = new DataTable();
ClientServer c = new ClientServer(clientid);
Data.DBDatabase db = Data.DBDatabase.Create(c.GetServer().Connection(), "MySql.Data.MySqlClient");
// Data.DBDatabase db = Data.DBDatabase.Create("Server=52.163.241.42; Uid=admin;Pwd=smrtalentoz3106;Initial Catalog=jumbo_talentoz; ", "MySql.Data.MySqlClient");
//Server=52.163.241.42; Uid=admin;Pwd=smrtalentoz3106;Initial Catalog=jumbo_talentoz;
Data.Schema.DBSchemaProvider provider = db.GetSchemaProvider();
IEnumerable <Data.Schema.DBSchemaItemRef> tables = provider.GetAllTables();
IEnumerable <Data.Schema.DBSchemaItemRef> tables1 = provider.GetAllViews();
tables = tables.Concat(tables1);
return(Json(Newtonsoft.Json.JsonConvert.SerializeObject(tables), JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="tb"></param>
/// <returns></returns>
public JsonResult GetFields(string clientid, string tb)
{
System.Data.DataTable dt = new DataTable();
ClientServer c = new ClientServer(clientid);
Data.DBDatabase db = Data.DBDatabase.Create(c.GetServer().Connection(), "MySql.Data.MySqlClient");
// Data.DBDatabase db = Data.DBDatabase.Create("Server=52.163.241.42; Uid=admin;Pwd=smrtalentoz3106;Initial Catalog=jumbo_talentoz; ", "MySql.Data.MySqlClient");
Data.Schema.DBSchemaProvider provider = db.GetSchemaProvider();
DBSchemaTable tables = provider.GetTable(tb);
if (tables == null)
{
DBSchemaView view = provider.GetView(tb);
return(Json(Newtonsoft.Json.JsonConvert.SerializeObject(view), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(Newtonsoft.Json.JsonConvert.SerializeObject(tables), JsonRequestBehavior.AllowGet));
}
}