public int CountScrCri(string ScreenCriId, string MultiDesignDb, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.CountScrCri(ScreenCriId, MultiDesignDb, dbConnectionString, dbPassword)); } }
public string AddData(Int32 ScreenId, bool bDeferError, LoginUsr LUser, UsrImpr LImpr, UsrCurr LCurr, DataSet ds, string dbConnectionString, string dbPassword, CurrPrj CPrj, CurrSrc CSrc, bool noTrans = false, int commandTimeOut = 1800) { using (AdminAccessBase dac = GetAdminAccess(commandTimeOut)) { return(dac.AddData(ScreenId, bDeferError, LUser, LImpr, LCurr, ds, dbConnectionString, dbPassword, CPrj, CSrc, noTrans)); } }
public string GetScrImpTmpl(Int32 screenId, Int16 cultureId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetScrImpTmpl(screenId, cultureId, dbConnectionString, dbPassword)); } }
public DataTable GetExp(Int32 screenId, string procedureName, string useGlobalFilter, string dbConnectionString, string dbPassword, Int32 screenFilterId, DataView dvCri, UsrImpr ui, UsrCurr uc, DataSet ds) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetExp(screenId, procedureName, useGlobalFilter, dbConnectionString, dbPassword, screenFilterId, dvCri, ui, uc, ds)); } }
/* Albeit rare, this overload shall take care of more than one column as primary key */ public DataTable GetMstById(string procedureName, string keyId1, string keyId2, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetMstById(procedureName, keyId1, keyId2, dbConnectionString, dbPassword)); } }
public DataTable GetScreenLabel(Int32 ScreenId, Int16 CultureId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetScreenLabel(ScreenId, CultureId, ui, uc, dbConnectionString, dbPassword)); } }
public DataTable GetDdl(Int32 screenId, string procedureName, bool bAddNew, bool bAll, int topN, string keyId, string dbConnectionString, string dbPassword, string filterTxt, UsrImpr ui, UsrCurr uc) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetDdl(screenId, procedureName, bAddNew, bAll, topN, keyId, dbConnectionString, dbPassword, filterTxt, ui, uc)); } }
public DataTable GetInfoByCol(Int32 ScreenId, string ColumnName, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetInfoByCol(ScreenId, ColumnName, dbConnectionString, dbPassword)); } }
// "string dbConnectionString, string dbPassword" is for backward compatibility and should be deleted: public bool IsValidOvride(Credential cr, Int32 usrId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.IsValidOvride(cr, usrId)); } }
public DataTable GetScreenCriHlp(Int32 screenId, Int16 cultureId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetScreenCriHlp(screenId, cultureId, dbConnectionString, dbPassword)); } }
public void LogUsage(Int32 UsrId, string UsageNote, string EntityTitle, Int32 ScreenId, Int32 ReportId, Int32 WizardId, string Miscellaneous, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { dac.LogUsage(UsrId, UsageNote, EntityTitle, ScreenId, ReportId, WizardId, Miscellaneous, dbConnectionString, dbPassword); } }
public DataTable GetGlobalFilter(Int32 usrId, Int32 screenId, Int16 cultureId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetGlobalFilter(usrId, screenId, cultureId, dbConnectionString, dbPassword)); } }
public DataTable GetClientRule(Int32 screenId, Int32 reportId, Int16 cultureId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetClientRule(screenId, reportId, cultureId, dbConnectionString, dbPassword)); } }
public DataTable GetButtonHlp(Int32 screenId, Int32 reportId, Int32 wizardId, Int16 cultureId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetButtonHlp(screenId, reportId, wizardId, cultureId, dbConnectionString, dbPassword)); } }
public void UpdScrCriteria(string screenId, string programName, DataView dvCri, Int32 usrId, bool isCriVisible, DataSet ds, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { dac.UpdScrCriteria(screenId, programName, dvCri, usrId, isCriVisible, ds, dbConnectionString, dbPassword); } }
// Obtain translated labels as one category from the table "Label" on system dependent database. public DataTable GetLabels(Int16 CultureId, string LabelCat, string CompanyId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetLabels(CultureId, LabelCat, CompanyId, dbConnectionString, dbPassword)); } }
public DataTable GetAuthRow(Int32 ScreenId, string RowAuthoritys, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetAuthRow(ScreenId, RowAuthoritys, dbConnectionString, dbPassword)); } }
public DataTable GetScrCriteria(string screenId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetScrCriteria(screenId, dbConnectionString, dbPassword)); } }
public DataTable GetHomeTabs(Int32 UsrId, Int32 CompanyId, Int32 ProjectId, byte SystemId) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetHomeTabs(UsrId, CompanyId, ProjectId, SystemId)); } }
public void MkGetScreenIn(string screenId, string screenCriId, string procedureName, string appDatabase, string sysDatabase, string multiDesignDb, string dbConnectionString, string dbPassword, bool reGen = true) { using (AdminAccessBase dac = GetAdminAccess()) { dac.MkGetScreenIn(screenId, screenCriId, procedureName, appDatabase, sysDatabase, multiDesignDb, dbConnectionString, dbPassword, reGen); } }
public DataTable RunWrRule(int screenId, string procedureName, string dbConnectionString, string dbPassword, string parameterXML, UsrImpr ui, UsrCurr uc, bool noTrans = false) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.RunWrRule(screenId, procedureName, dbConnectionString, dbPassword, parameterXML, ui, uc, noTrans)); } }
// For screens: public string GetMaintMsg() { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetMaintMsg()); } }
public DataTable GetLis(Int32 screenId, string procedureName, bool bAddRow, string useGlobalFilter, int topN, string dbConnectionString, string dbPassword, Int32 screenFilterId, string key, string filterTxt, DataView dvCri, UsrImpr ui, UsrCurr uc, DataSet ds) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetLis(screenId, procedureName, bAddRow, useGlobalFilter, topN, dbConnectionString, dbPassword, screenFilterId, key, filterTxt, dvCri, ui, uc, ds)); } }
/* revised to allow filtering by keyid at server level */ public DataTable GetScreenIn(string screenId, string procedureName, int TotalCnt, string RequiredValid, int topN, string FilterTxt, bool bAll, string keyId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetScreenIn(screenId, procedureName, TotalCnt, RequiredValid, topN, FilterTxt, bAll, keyId, ui, uc, dbConnectionString, dbPassword)); } }
public DataTable GetDtlById(Int32 screenId, string procedureName, string keyId, string dbConnectionString, string dbPassword, Int32 screenFilterId, UsrImpr ui, UsrCurr uc) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetDtlById(screenId, procedureName, keyId, dbConnectionString, dbPassword, screenFilterId, ui, uc)); } }
/* For backward compatibility only - to be deleted */ public DataTable GetScreenIn(string screenId, string procedureName, string RequiredValid, int topN, string FilterTxt, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.GetScreenIn(screenId, procedureName, 0, RequiredValid, topN, FilterTxt, true, string.Empty, ui, uc, dbConnectionString, dbPassword)); } }
public string UpdDshFld(string PublicAccess, string DshFldId, string DshFldName, Int32 usrId, string dbConnectionString, string dbPassword) { using (AdminAccessBase dac = GetAdminAccess()) { return(dac.UpdDshFld(PublicAccess, DshFldId, DshFldName, usrId, dbConnectionString, dbPassword)); } }
public DataTable GetLastCriteria(Int32 rowsExpected, Int32 screenId, Int32 reportId, Int32 usrId, string dbConnectionString, string dbPassword) { DataTable dt = null; using (AdminAccessBase dac = GetAdminAccess()) { dt = dac.GetLastCriteria(screenId, reportId, usrId, dbConnectionString, dbPassword); } if (dt.Rows.Count != rowsExpected) { using (AdminAccessBase dac = GetAdminAccess()) { dac.DelLastCriteria(screenId, reportId, usrId, dbConnectionString, dbPassword); dac.IniLastCriteria(screenId, reportId, usrId, dbConnectionString, dbPassword); dt = dac.GetLastCriteria(screenId, reportId, usrId, dbConnectionString, dbPassword); } } return(dt); }
public string GetMsg(string Msg, Int16 CultureId, string TechnicalUsr, string dbConnectionString, string dbPassword) { string mm = Msg; using (AdminAccessBase dac = GetAdminAccess()) { try { int ic = mm.IndexOf("{"); if (ic >= 0) { mm = mm.Substring(ic, mm.Length - ic); MatchCollection sa = Regex.Matches(mm, @"{[^}]*}"); if (sa[0].Value != string.Empty) // Found MsgId and process only the first one. { DataTable dt = dac.GetMsg(Int32.Parse(sa[0].Value.Substring(1, sa[0].Value.Length - 2)), CultureId, dbConnectionString, dbPassword); if (dt != null && dt.Rows.Count > 0) { string ss = dt.Rows[0]["Msg"].ToString(); for (int ii = 1; ii < sa.Count; ii++) { ss = SubPar(ss, ii, sa[ii].Value.Substring(1, sa[ii].Value.Length - 2), dt.Rows[0]["CultureTypeName"].ToString()); } if (TechnicalUsr == "Y") { return(dt.Rows[0]["MsgSource"].ToString() + ": " + ss); } else { return(ss); } } else { return(Msg); } } else { return(Msg); } } else // Remove all messages in front including Sybase extra messages between "[" and "]". { int i0 = mm.IndexOf("["); if (i0 >= 0) { int i1 = mm.IndexOf("]"); if (i1 >= 0) { int i2 = mm.Substring(i1 + 1).IndexOf("]"); if (i2 >= 0) { mm = mm.Substring(0, i0) + mm.Substring(i1 + i2 + 2).Trim(); } } } return(mm); } } catch { return(Msg); } } }