public void Save_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.ViewModel.UniqueRowKey = ajaxResponse.ReturnObj.As <JsString>();
var everythingPage = UI.Pages.EverythingPage.Get_The_EverythingPage();
var tableGridMain = everythingPage.TableGridMain;
if (tableGridMain.IsInstantiated)
{
tableGridMain.Refresh();
}
jF(".SavedBar").slideDown(200).delay(400).slideUp(200);
jF(".BttnBar").slideUp(200).delay(400).slideDown(200);
if (this.Model.ActionType == TableGrid.Objs.UniqueRowKey.ActionTypes.Get)
{
this.Close();
this.Open();
}
else
{
this.RecordsList_Click(false);
}
}
public void GetIndexes_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (ajaxResponse.Error != null)
{
alert("Error: " + ajaxResponse.Error.Message); return;
}
this.Model = ajaxResponse.ReturnObj.As <Index[]>();
if (this.Model.Length < 1)
{
jF(".WhenZero_Hide").hide();
jF(".WhenZero_Show").show();
}
else
{
jF(".WhenZero_Hide").show();
jF(".WhenZero_Show").hide();
var table_IndexItems = jF2(".Table_IndexItems");
this.IndexesRows = new IndexesRow[0];
for (int i = 0; i < this.Model.Length; i++)
{
this.IndexesRows[i] = new IndexesRow(i);
this.IndexesRows[i].Model = this.Model[i];
this.IndexesRows[i].ViewModel = this.ViewModel;
this.IndexesRows[i].OnChange.After.AddHandler(this, "IndexesRow_OnChange", 0);
this.IndexesRows[i].OnEdit_Enter.After.AddHandler(this, "IndexesRow_OnEdit_Enter", 0);
this.IndexesRows[i].OnEdit_Exit.After.AddHandler(this, "IndexesRow_OnEdit_Exit", 0);
this.IndexesRows[i].Instantiate();
table_IndexItems.append(this.IndexesRows[i].jRoot);
}
}
}
public void GetAssetsLists_AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
var response = ajaxResponse.ReturnObj.As <DataObjects.ManageAssets.ManageAssetResponse>();
var assetsListsInfo = response.AssetsListsInfo;
jF2(".Menu_TablesActive span").html("(" + assetsListsInfo.Tables_Active.Length + ")");
jF2(".Menu_TablesHidden span").html("(" + assetsListsInfo.Tables_Hidden.Length + ")");
jF2(".Menu_SQLViewsActive span").html("(" + assetsListsInfo.SqlViews_Active.Length + ")");
jF2(".Menu_SQLViewsHidden span").html("(" + assetsListsInfo.SqlViews_Hidden.Length + ")");
jF2(".Menu_Schemas span").html("(" + assetsListsInfo.Schemas.Length + ")");
jF2(".LoadingLabel").hide();
jF2(".MA_Main").show();
this.TablesPanel_Active.Model = assetsListsInfo.Tables_Active;
this.TablesPanel_Hidden.Model = assetsListsInfo.Tables_Hidden;
this.SQLViewsPanel_Active.Model = assetsListsInfo.SqlViews_Active;
this.SQLViewsPanel_Hidden.Model = assetsListsInfo.SqlViews_Hidden;
this.SchemasPanel.Model = assetsListsInfo.Schemas;
jF2(".Label_ConnectionName").html("[" + assetsListsInfo.ConnectionName + "]");
}
public void GetUploadedExcelInfo_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.Model = ajaxResponse.ReturnObj.As <ImportExcelInfo>();
if (this.Model.Worksheets.Length < 1)
{
alert("No worksheets were found in this Excel file");
this.Close();
}
else if (this.Model.Worksheets.Length > 1)
{
this.Populate_Screen_SelectWorksheet();
jF(".Screen_SelectWorksheet").show();
jF(".Bttn_Prev3").show();
}
else
{
this.Populate_Screen_SelectKeys();
jF(".Bttn_Prev3").hide();
jF(".Screen_SelectKeys").show();
this.ViewModel.SelectedWorksheet = this.Model.Worksheets[0];
}
}
public void Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.Model = ajaxResponse.ReturnObj.As <LogoBoxModel>();
switch (this.Model.CustomLogoType)
{
case LogoBoxModel.CustomLogoTypes.None:
break;
case LogoBoxModel.CustomLogoTypes.Image:
jF(".LogoLink").hide();
jF(".CustomLogoBox").show();
jF(".LogoImg")[0].style.display = "block";
jF(".LogoImg")[0].style.background = st.New("url('{0}') no-repeat").Format1(this.Model.LogoURL).TheString;
jF(".LogoImg").attr("title", this.Model.LogoText);
break;
case LogoBoxModel.CustomLogoTypes.Text:
jF(".LogoLink").hide();
jF(".CustomLogoBox").show();
jF(".LogoTxt")[0].style.display = "block";
jF(".LogoTxt").html(this.Model.LogoText).attr("title", this.Model.LogoText);
break;
}
}
//----------------------------------------------------------------------------------------------------
public void AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.SetModel(ajaxResponse);
string keyString1 = "";
string keyString2 = "";
bool commanFound = false;
for (int i = 0; i < this.Model.KeyValue.Length; i++)
{
if (i > 0)
{
keyString1 += ", ";
keyString2 += ", ";
}
string item = this.Model.KeyValue[i];
keyString1 += item;
keyString2 += "\"" + item + "\"";
if (st.New(item).Contains(",", false))
{
commanFound = true;
}
}
if (commanFound)
{
keyString1 = keyString2;
}
string label2 = st.New("[{0}].[{1}].[{2}] : {3}").Format4(this.Model.ConnectionName, this.Model.Schema, this.Model.TableName, keyString1).TheString;
jF(".Label2").html(label2);
var menuTable = jF(".MenuTable").html("");
this.MenuItems = new HistoryMenuItem[0];
for (int i = 0; i < this.Model.HistoryRecords.Length; i++)
{
this.MenuItems[i] = new HistoryMenuItem();
this.MenuItems[i].Model = this.Model.HistoryRecords[i];
this.MenuItems[i].Instantiate();
this.MenuItems[i].OnChange.After.AddHandler(this, "HistoryMenuItem_Change", 1);
menuTable.append(this.MenuItems[i].jRoot);
}
if (this.Model.HistoryRecords.Length < 1)
{
jF(".EmptyPanel").html("This record does not have any saved history.");
}
else
{
jF(".EmptyPanel").html("(Select a Time Point)");
}
UI.PagesFramework.BasePage.WindowResized();
}
public void Views_ShowHide_Response(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.OnChange.After.Fire();
}
//------------------------------------------------------------------------------------------ Events --
public void TablesMethod_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.OnChange.After.Fire();
}
public void DeleteRecords_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.RecordsList_Click(true);
}
public void Delete_AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.ExitPage();
}
public void Save_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (ajaxResponse.Error != null)
{
alert("Error: " + ajaxResponse.Error.Message); return;
}
this.OnChange.After.Fire();
}
//----------------------------------------------------------------------------------------------------
public void GetInstallState_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (ajaxResponse.Error != null)
{
jF(".Screen").hide();
jF(".Screen_Error").show().html(ajaxResponse.Error.Message + "<br /><br />To try again, refresh your browser.");
return;
}
this.Model = ajaxResponse.ReturnObj.As <Objs.InstallInfo>();
jF(".SubscriptionAgreement").html(this.Model.AboutPageInfo.SubscriptionAgreement);
if (!this.ViewModel.LegalHasBeenAccepted)
{
this.Model.InstallState = InstallInfo.InstallStates.LegalNotYetAccepted;
}
jF(".Screen").hide();
switch (this.Model.InstallState)
{
case InstallInfo.InstallStates.LegalNotYetAccepted:
jF(".Screen_GetStarted").show();
break;
case InstallInfo.InstallStates.NoConnectionString:
if (this.ViewModel.IsFirstAttempt_AddingConnectionString)
{
this.ViewModel.IsFirstAttempt_AddingConnectionString = false;
jF(".Screen_NeedConnectionString").show();
}
else
{
jF(".Screen_ConnectionStringNotFound").show();
jF(".Label_InvalidConnectionString").html(this.Model.ResponseMsg);
}
break;
case InstallInfo.InstallStates.CannotConnectToDB:
jF(".Screen_ConnectionStringNotFound").show();
jF(".Label_InvalidConnectionString").html(this.Model.ResponseMsg);
break;
case InstallInfo.InstallStates.DatabaseNotReady:
if (!this.AjaxSender.IsReady)
{
this.AjaxSender.Initialize();
}
else
{
jF(".Screen_GetUserInfo").show();
}
break;
case InstallInfo.InstallStates.Installed:
jF(".Screen_InstallComplete").show();
break;
}
}
public void AjaxReturn2(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
jF(".EmptyPanel").hide();
jF(".Loading2").hide();
jF(".CompareTbl").show();
jF(".FieldView").hide();
this.SubModel = ajaxResponse.ReturnObj.As <HistoryRecord>();
var compareTbl = jF(".CompareTbl");
compareTbl.find(".TrRow").detach();
for (int i = 0; i < this.SubModel.Fields_3ValArr.Length; i++)
{
var item = this.SubModel.Fields_3ValArr[i];
string v1 = item.v1;
string v2 = item.v2;
string v3 = item.v3;
if (v1 == null)
{
v1 = " ";
}
if (v2 == null)
{
v2 = " ";
}
if (v3 == null)
{
v3 = " ";
}
string matchTDsClass = "";
if (!item.match)
{
matchTDsClass = "Hightlight";
}
string altClass = "TrRow1";
if (i % 2 == 1)
{
altClass = "TrRow2";
}
compareTbl.append(st.New(@"
<tr class='TrRow {0}' Index='{1}'>
<td><div>{2}</div></td>
<td class='{6}'><div>{3}</div></td>
<td class='{6}'><div>{4}</div></td>
<td><div>{5}</div></td>
</tr>").Format7(altClass, i, item.ColumnName_OrigCasing, v1, v2, v3, matchTDsClass).TheString);
}
var thisObj = this;
eval(@" compareTbl.find('.TrRow').click(function(){ thisObj.FieldItem_Click( $(this).attr('Index') ); }); ");
}
//------------------------------------------------------------------------------------------ Events --
public void GetList_AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
var dbConnResponse = ajaxResponse.ReturnObj.As <ASPdatabaseNET.DataObjects.DatabaseConnections.DatabaseConnectionResponse>();
jF2(".Span_ActiveConnections_Count").html("(" + dbConnResponse.ActiveConnections.Length + ")");
jF2(".Span_HiddenConnections_Count").html("(" + dbConnResponse.HiddenConnections.Length + ")");
jF2(".SectionDiv_NoConnections").show();
jF2(".SectionDiv_Active").hide();
if (dbConnResponse.ActiveConnections.Length > 0)
{
var div1 = jF2(".ActiveItemsDiv");
for (int i = 0; i < dbConnResponse.ActiveConnections.Length; i++)
{
var item = dbConnResponse.ActiveConnections[i];
string tmpIdClass = "TmpId_" + item.ConnectionId;
string html = ASPdb.FrameworkUI.JsStr.StrFormat3(@"
<div class='ConnectionItem'>
<div class='NameLabel'>{0}</div>
<div class='BttnsHolder'>
<a class='Bttn_ModifyConnection {1}' href='#00-ConnectionProperties-{2}'>Edit Connection</a>
<a class='Bttn_ManageAssets' href='#00-ManageAssets-{2}'>Manage Assets</a>
</div>
<div class='clear'></div>
</div>", item.ConnectionName, tmpIdClass, item.ConnectionId.As <string>());
div1.append(html);
}
jF2(".SectionDiv_NoConnections").hide();
jF2(".SectionDiv_Active").show();
}
jF2(".SectionDiv_Hidden").hide();
if (dbConnResponse.HiddenConnections.Length > 0)
{
var div2 = jF2(".HiddenItemsDiv");
for (int i = 0; i < dbConnResponse.HiddenConnections.Length; i++)
{
var item = dbConnResponse.HiddenConnections[i];
string tmpIdClass = "TmpId_" + item.ConnectionId;
string html = ASPdb.FrameworkUI.JsStr.StrFormat3(@"
<div class='ConnectionItem'>
<div class='NameLabel'>{0}</div>
<div class='BttnsHolder'>
<a class='Bttn_ModifyConnection {1}' href='#00-ConnectionProperties-{2}'>Edit Connection</a>
</div>
<div class='clear'></div>
</div>", item.ConnectionName, tmpIdClass, item.ConnectionId.As <string>());
div2.append(html);
}
jF2(".SectionDiv_NoConnections").hide();
jF2(".SectionDiv_Hidden").show();
}
}
public void AppProperties__Get_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.ViewModel.AppPropertiesInfo = ajaxResponse.ReturnObj.As <UI.PageParts.TableDesign.AppProperties.Objs.AppPropertiesInfo>();
this.Edit_Click_2();
}
//----------------------------------------------------------------------------------------------------
public void SetImpersonationUser_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (ajaxResponse.Error != null)
{
alert("Error: " + ajaxResponse.Error.Message); return;
}
window.location = "ASPdatabase.NET.aspx".As <Location>();
}
public void Guid_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.ViewModel.GuidKey = ajaxResponse.ReturnObj.As <string>();
jF(".Bttn1").show();
}
public void Save_AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.OnSaved.After.Fire1("Columns");
}
public void Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.Model = ajaxResponse.ReturnObj.As <AboutPageInfo>();
this.BindUI();
}
public void Save_AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.OnChange.After.Fire();
this.ExitPage();
}
public void Save_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
alert("Saved");
this.Open();
}
public void SavePassword_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
jF(".P1").focus();
return;
}
alert("Password Saved");
this.Close();
}
public void SaveUser_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.ViewModel.CurrentId = ajaxResponse.ReturnObj.As <JsNumber>();
this.OnChange.After.Fire();
alert("Saved");
}
public void Save_Response(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
jF2(".NewSchemaBox_PleaseWait").hide();
jF2(".Txt_NewSchemaName").val("");
this.OnChange.After.Fire();
}
public void GetInfo_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.Model = ajaxResponse.ReturnObj.As <FeedbackInfo>();
this.BindUI();
jF(".Main1").show();
jF(".T_Name").focus();
}
public void Send_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
jF(".Main1").hide();
jF(".Main2").show().html(ajaxResponse.ReturnObj.As <string>());
}
public void DeleteUser_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.ViewModel.CurrentId = -1;
this.Model.UserId = -1;
this.Close();
this.OnChange.After.Fire();
}
//------------------------------------------------------------------------------------------ Events --
public void Get_AjaxReturn(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (UI.Errors.ExceptionHandler.Check(ajaxResponse))
{
return;
}
this.Model = ajaxResponse.ReturnObj
.As <DataObjects.DatabaseConnections.DatabaseConnectionResponse>().SingleConnectionInfo;
this.Load_FromModel();
}
public void IsInDemoMode_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
try
{
if (ajaxResponse.ReturnObj.As <bool>() == true)
{
jF(".Txt_Username").val("demo");
jF(".Txt_Password").val("1234Demo1234");
}
}
catch { }
}
//----------------------------------------------------------------------------------------------------
public void GetSessionPublicKey_Return(ASPdb.Ajax.AjaxResponse ajaxResponse)
{
if (this.HandleError(ajaxResponse, "GetSessionPublicKey_Return"))
{
return;
}
var arr = ajaxResponse.ReturnObj.As <string[]>();
this.AESIndex = arr[0];
this.PublicKeyPem = arr[1];
this.Create_and_Send_AESKey();
}
