//----------------------------------------------------------------------------------------------------
public static TableDesignResponse GetInfo_ForModify(int tableId)
{
AjaxService.ASPdatabaseService.GetSetVal();
var rtn = new TableDesignResponse()
{
ResponseType = TableDesignResponse.ResponseTypesEnum.GetInfo_ForModify
};
rtn.ConnectionId = -1;
rtn.TableId = tableId;
rtn.TableStructure = DbInterfaces.SQLServerInterface.Tables__Get(tableId, true, false, false);
if (rtn.TableStructure == null)
{
throw new Exception("rtn.TableStructure is null");
}
var connectionInfo = DataAccess.DatabaseConnectionsCRUD.Get(rtn.TableStructure.ConnectionId, false);
rtn.ConnectionName = connectionInfo.SingleConnectionInfo.ConnectionName;
rtn.TableStructure.ConnectionName = connectionInfo.SingleConnectionInfo.ConnectionName;
rtn.ConnectionId = rtn.TableStructure.ConnectionId;
rtn.Schema = rtn.TableStructure.Schema;
rtn.TableName = rtn.TableStructure.TableName;
rtn.AllTables_InDb = SQLObjectsCRUD.ASPdb_Table__GetAll(rtn.ConnectionId, true).ToArray();
return(rtn);
}
//----------------------------------------------------------------------------------------------------
public static DatabaseConnectionResponse Save(ASPdb_Connection connectionInfo)
{
AjaxService.ASPdatabaseService.GetSetVal();
connectionInfo.ConnectionName = connectionInfo.ConnectionName.Trim();
SQLObjectsCRUD.ASPdb_Connection__Save(connectionInfo);
return new DatabaseConnectionResponse() { ResponseType = DatabaseConnectionResponse.ResponseTypesEnum.Save, SaveSuccess = true };
}
//----------------------------------------------------------------------------------------------------
public static DatabaseConnectionResponse Delete(int connectionId)
{
AjaxService.ASPdatabaseService.GetSetVal();
var rtn = new DatabaseConnectionResponse() { ResponseType = DatabaseConnectionResponse.ResponseTypesEnum.Delete };
// check user permissions
// check SiteId
// what to do with related tables ... such as [" + Config.SystemProperties.AppSchema + @"].[ASPdb_Tables]
SQLObjectsCRUD.ASPdb_Connection__Delete(connectionId);
rtn.DeleteSuccess = true;
return rtn;
}
//----------------------------------------------------------------------------------------------------
public static DatabaseConnectionResponse Test(ASPdb_Connection aspdb_Connection, bool saveOnSuccess)
{
AjaxService.ASPdatabaseService.GetSetVal();
var rtn = new DatabaseConnectionResponse() { ResponseType = DatabaseConnectionResponse.ResponseTypesEnum.Test };
rtn.SaveOnSuccess = saveOnSuccess;
rtn.TestConnection_Passed = false;
try
{
string validationString = aspdb_Connection.GetValidationMessage();
if (validationString != "")
throw new Exception(validationString);
string connectionString = aspdb_Connection.GetConnectionString();
var tableItems = SQLObjectsCRUD.ASPdb_Table__GetRawList_NoCache(aspdb_Connection);
string s = "";
s += String.Format("{0} Tables Found<br /><br />", tableItems.Count);
if(tableItems.Count == 1)
s = String.Format("{0} Table Found<br /><br />", tableItems.Count);
foreach (var item in tableItems)
s += String.Format("<div class='TableItem1'><span>{0}.</span>{1}</div>", item.SchemaName, item.TableName);
rtn.TestConnection_Passed = true;
rtn.TestConnection_Message = s;
}
catch (Exception exc)
{
rtn.TestConnection_Passed = false;
rtn.TestConnection_Message += exc.Message; // +"<hr />" + exc.StackTrace;
}
return rtn;
}
//----------------------------------------------------------------------------------------------------
public static TableDesignResponse GetInfo_ForCreateNew(int connectionId)
{
AjaxService.ASPdatabaseService.GetSetVal();
var rtn = new TableDesignResponse()
{
ResponseType = TableDesignResponse.ResponseTypesEnum.GetInfo_ForCreateNew
};
rtn.ConnectionId = connectionId;
rtn.TableId = -1;
var connectionInfo = DataAccess.DatabaseConnectionsCRUD.Get(connectionId, false);
rtn.ConnectionName = connectionInfo.SingleConnectionInfo.ConnectionName;
var schemaInfos = DbInterfaces.GenericInterface.Schemas__GetAll(connectionId);
rtn.Schemas = (from s in schemaInfos orderby s.SchemaName select s.SchemaName).ToArray();
rtn.AllTables_InDb = SQLObjectsCRUD.ASPdb_Table__GetAll(rtn.ConnectionId, true).ToArray();
return(rtn);
}
//------------------------------------------------------------------------------------------ static --
public static NavSiteInfo GetSiteNav(bool resetCache)
{
AjaxService.ASPdatabaseService.GetSetVal();
if (resetCache)
{
ASPdatabaseNET.Memory.AppCache.Reset();
}
var userSessionInfo = ASPdatabaseNET.Users.UserSessionLogic.GetUser();
var usersPermissions = userSessionInfo.UserInfo.AllPermissions;
var rtn = new NavSiteInfo();
var tmpNavDatabaseArray = new List <NavDatabaseInfo>();
var dbList = SQLObjectsCRUD.ASPdb_Connection__GetAll(true);
foreach (var dbItem in dbList)
{
if (dbItem.Active)
{
tmpNavDatabaseArray.Add(new NavDatabaseInfo()
{
ConnectionId = dbItem.ConnectionId, ConnectionName = dbItem.ConnectionName
});
}
}
rtn.Databases = tmpNavDatabaseArray.ToArray();
foreach (var database in rtn.Databases)
{
try
{
var aspdb_Tables = SQLObjectsCRUD.ASPdb_Table__GetAll(database.ConnectionId, false);
var tmpList1 = new List <NavSectionItemInfo>();
foreach (var table in aspdb_Tables)
{
if (!table.Hide && usersPermissions.CheckPermissions(table.ConnectionId, table.Schema, table.TableId).View)
{
string url = String.Format("#00-Table-{0}", table.TableId);
tmpList1.Add(new NavSectionItemInfo()
{
Id = table.TableId, Name = table.TableName, Schema = table.Schema, URL = url
});
}
}
var aspdb_Views = SQLObjectsCRUD.ASPdb_View__GetAll(database.ConnectionId);
var tmpList2 = new List <NavSectionItemInfo>();
foreach (var view in aspdb_Views)
{
if (!view.Hide && usersPermissions.CheckPermissions(view.ConnectionId, view.Schema, -1).View)
{
string url = String.Format("#00-View-{0}", view.ViewId);
tmpList2.Add(new NavSectionItemInfo()
{
Id = view.ViewId, Name = view.ViewName, Schema = view.Schema, URL = url
});
}
}
if (tmpList1.Count > 0)
{
database.Section_Tables = new NavSectionInfo()
{
SectionName = String.Format("Tables ({0})", tmpList1.Count),
SectionType = NavSectionInfo.SectionTypes.Tables,
Items = tmpList1.ToArray()
}
}
;
if (tmpList2.Count > 0)
{
database.Section_Views = new NavSectionInfo()
{
SectionName = String.Format("Views ({0})", tmpList2.Count),
SectionType = NavSectionInfo.SectionTypes.Views,
Items = tmpList2.ToArray()
}
}
;
}
catch (Exception exc)
{
ASPdb.Framework.Debug.RecordException(exc);
database.ConnectionName += " (Error)";
string msg = exc.Message;
if (msg.Length > 171)
{
msg = msg.Substring(0, 170);
var arr = msg.Split(new char[] { ' ' });
msg = msg.Substring(0, msg.Length - arr.Last().Length) + "...";
}
database.Section_Tables = new NavSectionInfo()
{
SectionName = msg
};
}
}
var tmpDatabases = new List <NavDatabaseInfo>();
foreach (var database in rtn.Databases)
{
bool isEmpty = true;
if (database.Section_Tables != null && database.Section_Tables.Items != null && database.Section_Tables.Items.Length > 0)
{
isEmpty = false;
database.Section_Tables.Items = (from r in database.Section_Tables.Items
orderby r.Schema, r.Name
select r).ToArray();
}
if (database.Section_Views != null && database.Section_Views.Items != null && database.Section_Views.Items.Length > 0)
{
isEmpty = false;
}
if (!isEmpty)
{
tmpDatabases.Add(database);
}
}
rtn.Databases = tmpDatabases.ToArray();
rtn.IsInDemoMode = Users.UserSessionLogic.IsInDemoMode;
return(rtn);
}
//----------------------------------------------------------------------------------------------------
public static ManageAssetResponse GetAssetsLists(int connectionId)
{
AjaxService.ASPdatabaseService.GetSetVal();
var rtn = new AssetsLists_PopulatorHelper(connectionId, true);
var aspdb_Connection = DataAccess.SQLObjectsCRUD.ASPdb_Connection__Get(connectionId);
if (!aspdb_Connection.Active)
{
throw new Exception("This connection is inactive.");
}
rtn.ConnectionName = aspdb_Connection.ConnectionName;
//-----------------------------------------------------------
var aspdb_Tables = SQLObjectsCRUD.ASPdb_Table__GetAll(connectionId, true);
foreach (var item in aspdb_Tables)
{
var basicAssetInfo = item.ToBasicAssetInfo();
if (basicAssetInfo.Active)
{
rtn.Tables_Active.Add(basicAssetInfo);
}
else
{
rtn.Tables_Hidden.Add(basicAssetInfo);
}
}
//-----------------------------------------------------------
var aspdb_Views = SQLObjectsCRUD.ASPdb_View__GetAll(connectionId);
foreach (var item in aspdb_Views)
{
var basicAssetInfo = item.ToBasicAssetInfo();
if (basicAssetInfo.Active)
{
rtn.SqlViews_Active.Add(basicAssetInfo);
}
else
{
rtn.SqlViews_Hidden.Add(basicAssetInfo);
}
}
//-----------------------------------------------------------
var schemaInfos = GenericInterface.Schemas__GetAll(connectionId);
foreach (var item in schemaInfos)
{
var basicAssetInfo = new BasicAssetInfo(true, BasicAssetInfo.E_AssetTypes.Schema);
basicAssetInfo.ConnectionId = connectionId;
basicAssetInfo.GenericId = item.SchemaId;
basicAssetInfo.Schema = item.SchemaName;
rtn.Schemas.Add(basicAssetInfo);
}
return(new ManageAssetResponse()
{
ResponseType = ManageAssetResponse.ResponseTypesEnum.GetAssetsLists,
AssetsListsInfo = rtn.ToAssetsLists()
});
}
