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); }
}
}
