public bool UpdAdmRptWiz95(LoginUsr LUser, UsrCurr LCurr, DataSet ds, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.UpdAdmRptWiz95(LUser, LCurr, ds, dbConnectionString, dbPassword));
}
}
public DataTable GetScreenLabel(Int32 ScreenId, Int16 CultureId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetScreenLabel(ScreenId, CultureId, ui, uc, dbConnectionString, dbPassword));
}
}
public bool DelAdmRptWiz95(LoginUsr LUser, UsrCurr LCurr, DataSet ds, string dbConnectionString, string dbPassword)
{
using (WebAccessBase dac = GetWebAccess())
{
return(dac.DelAdmRptWiz95(LUser, LCurr, ds, dbConnectionString, dbPassword));
}
}
public DataTable GetAuthExp(Int32 ScreenId, Int16 CultureId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (AdminAccessBase dac = GetAdminAccess())
{
return(dac.GetAuthExp(ScreenId, CultureId, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetRptDt(Int32 reportId, string procedureName, UsrImpr ui, UsrCurr uc, DataSet ds, DataView dvCri, string dbConnectionString, string dbPassword, bool bUpd, bool bXls, bool bVal, int commandTimeOut = 1800)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess(commandTimeOut))
{
return(dac.GetRptDt(reportId, procedureName, ui, uc, ds, dvCri, dbConnectionString, dbPassword, bUpd, bXls, bVal));
}
}
public DataTable RunWrRule(int screenId, string procedureName, string dbConnectionString, string dbPassword, string parameterXML, UsrImpr ui, UsrCurr uc, bool noTrans = false)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.RunWrRule(screenId, procedureName, dbConnectionString, dbPassword, parameterXML, ui, uc, noTrans));
}
}
public abstract DataTable GetIn(Int32 reportId, string procedureName, int TotalCnt, string RequiredValid, bool bAll, string keyId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword);
public DataTable GetDdlAccessCd(bool bAll, string keyId, string dbConnectionString, string dbPassword, UsrImpr ui, UsrCurr uc)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetDdlAccessCd(bAll, keyId, dbConnectionString, dbPassword, ui, uc));
}
}
/* For backward compatibility only - to be deleted */
public DataTable GetIn(string reportId, string programName, string RequiredValid, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetIn(reportId, programName, 0, RequiredValid, true, string.Empty, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetIn(Int32 reportId, string procedureName, int TotalCnt, string RequiredValid, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetIn(reportId, procedureName, TotalCnt, RequiredValid, true, string.Empty, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetDtlById(Int32 screenId, string procedureName, string keyId, string dbConnectionString, string dbPassword, Int32 screenFilterId, UsrImpr ui, UsrCurr uc)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetDtlById(screenId, procedureName, keyId, dbConnectionString, dbPassword, screenFilterId, ui, uc));
}
}
public abstract DataTable RunWrRule(int screenId, string procedureName, string dbConnectionString, string dbPassword, string parameterXML, UsrImpr ui, UsrCurr uc, bool noTrans);
public abstract DataTable GetScreenLabel(Int32 ScreenId, Int16 CultureId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword);
public abstract 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);
public abstract DataTable GetRptDt(Int32 reportId, string procedureName, UsrImpr ui, UsrCurr uc, DataSet ds, DataView dvCri, string dbConnectionString, string dbPassword, bool bUpd, bool bXls, bool bVal);
public abstract DataTable GetLis(Int32 screenId, string procedureName, bool bAddNew, string useGlobalFilter, int topN, string dbConnectionString, string dbPassword, Int32 screenFilterId, string key, string filterTxt, DataView dvCri, UsrImpr ui, UsrCurr uc, DataSet ds);
public abstract DataTable GetIn(Int32 reportId, string procedureName, bool bAddNew, UsrImpr ui, UsrCurr uc, string dbConnectionString, string 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 (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetExp(screenId, procedureName, useGlobalFilter, dbConnectionString, dbPassword, screenFilterId, dvCri, ui, uc, ds));
}
}
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 (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetLis(screenId, procedureName, bAddRow, useGlobalFilter, topN, dbConnectionString, dbPassword, screenFilterId, key, filterTxt, dvCri, ui, uc, ds));
}
}
public abstract bool UpdData(Int32 ScreenId, bool bDeferError, LoginUsr LUser, UsrImpr LImpr, UsrCurr LCurr, DataSet ds, string dbConnectionString, string dbPassword, CurrPrj CPrj, CurrSrc CSrc, bool noTrans = false);
public bool DelData(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 (Access3.AdminAccess dac = new Access3.AdminAccess(commandTimeOut))
{
return(dac.DelData(ScreenId, bDeferError, LUser, LImpr, LCurr, ds, dbConnectionString, dbPassword, CPrj, CSrc, noTrans));
}
}
public DataTable GetDdlRptMemFld(string GenPrefix, bool bAll, string keyId, string dbConnectionString, string dbPassword, UsrImpr ui, UsrCurr uc)
{
using (Access3.SqlReportAccess dac = new Access3.SqlReportAccess())
{
return(dac.GetDdlRptMemFld(GenPrefix, bAll, keyId, dbConnectionString, dbPassword, ui, uc));
}
}
// To be deleted: for backward compatibility only.
public DataTable GetIn(Int32 reportId, string procedureName, bool bAddNew, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetIn(reportId, procedureName, bAddNew, ui, uc, dbConnectionString, dbPassword));
}
}
/* 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 (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetScreenIn(screenId, procedureName, TotalCnt, RequiredValid, topN, FilterTxt, bAll, keyId, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetIn(string reportId, string programName, int TotalCnt, string RequiredValid, bool bAll, string keyid, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetIn(reportId, programName, TotalCnt, RequiredValid, bAll, keyid, ui, uc, dbConnectionString, dbPassword));
}
}
/* 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 (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetScreenIn(screenId, procedureName, 0, RequiredValid, topN, FilterTxt, true, string.Empty, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetDdlRptMemCri(string GenPrefix, string reportId, bool bAll, int topN, string keyId, string dbConnectionString, string dbPassword, string filterTxt, UsrImpr ui, UsrCurr uc)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetDdlRptMemCri(GenPrefix, reportId, bAll, topN, keyId, dbConnectionString, dbPassword, filterTxt, ui, uc));
}
}
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 (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.GetDdl(screenId, procedureName, bAddNew, bAll, topN, keyId, dbConnectionString, dbPassword, filterTxt, ui, uc));
}
}
public DataTable GetSqlReport(string reportId, string programName, DataView dvCri, UsrImpr ui, UsrCurr uc, DataSet ds, string dbConnectionString, string dbPassword, bool bUpd, bool bXls, bool bVal, int commandTimeOut = 1800)
{
using (SqlReportAccessBase dac = GetSqlReportAccess(commandTimeOut))
{
return(dac.GetSqlReport(reportId, programName, dvCri, ui, uc, ds, dbConnectionString, dbPassword, bUpd, bXls, bVal));
}
}
public abstract DataTable GetExp(Int32 screenId, string procedureName, string useGlobalFilter, string dbConnectionString, string dbPassword, Int32 screenFilterId, DataView dvCri, UsrImpr ui, UsrCurr uc, DataSet ds);
