// Get email and other info for a specific user.
public DataTable WrGetUsrEmail(string UsrId)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetUsrEmail(UsrId));
}
}
// Return ScreenId given program name.
public string WrGetScreenId(string ProgramName, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetScreenId(ProgramName, dbConnectionString, dbPassword));
}
}
public DataTable WrGetScreenObj(string ScreenId, Int16 CultureId, string ScreenObjId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetScreenObj(ScreenId, CultureId, ScreenObjId, dbConnectionString, dbPassword));
}
}
public void WrUpdScreenTab(string ScreenTabId, string TabFolderOrder, string TabFolderName, string CultureId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.WrUpdScreenTab(ScreenTabId, TabFolderOrder, TabFolderName, CultureId, dbConnectionString, dbPassword);
}
}
public bool WrDelScreenObj(string ScreenObjId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrDelScreenObj(ScreenObjId, dbConnectionString, dbPassword));
}
}
public bool WrDelMenu(string MenuId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrDelMenu(MenuId, dbConnectionString, dbPassword));
}
}
public DataTable WrAddScreenTab(string TabFolderOrder, string ScreenId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrAddScreenTab(TabFolderOrder, ScreenId, dbConnectionString, dbPassword));
}
}
// Create a copy of report template based on report wizard in advanced report definition.
public bool WrXferRpt(Int32 ReportId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrXferRpt(ReportId, dbConnectionString, dbPassword));
}
}
// Replace GetDdlPermId3S1751:
public DataTable WrGetDdlPermId(string PermKeyId, Int32 ScreenId, Int32 TableId, bool bAll, string keyId, string dbConnectionString, string dbPassword, UsrImpr ui, UsrCurr uc)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetDdlPermId(PermKeyId, ScreenId, TableId, bAll, keyId, dbConnectionString, dbPassword, ui, uc));
}
}
// Generate or synchronize report template based on report wizard.
public string WrRptwizGen(Int32 RptwizId, string SystemId, string AppDatabase, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrRptwizGen(RptwizId, SystemId, AppDatabase, dbConnectionString, dbPassword));
}
}
// Obtain table-valued function from the physical database for virtual table.
public string WrGetVirtualTbl(string TableId, byte DbId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetVirtualTbl(TableId, DbId, dbConnectionString, dbPassword));
}
}
// Return default CultureId or CultureTypeName as a string.
public string WrGetDefCulture(bool bCultureId)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetDefCulture(bCultureId));
}
}
// Translate ScreenObjHlp table:
private int WrTrlScreenObjHlp(int MaxCnt, string DefCulture, string CultureId, string CultureName, string dbConnectionString, string dbPassword)
{
int cnt = 0;
DataTable dt;
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dt = dac.WrGetScreenObjHlp(CultureId, dbConnectionString, dbPassword);
}
foreach (DataRow dr in dt.Rows)
{
if (",28,36,37,".IndexOf("," + dr["DisplayModeId"].ToString() + ",") < 0) // Not Image, Placeholder or Html Editor;
{
dr["ColumnHeader"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["ColumnHeader"].ToString().Trim(), dbConnectionString, dbPassword);
}
dr["TbHint"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["TbHint"].ToString().Trim(), dbConnectionString, dbPassword);
dr["ToolTip"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["ToolTip"].ToString().Trim(), dbConnectionString, dbPassword);
dr["ErrMessage"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["ErrMessage"].ToString().Trim(), dbConnectionString, dbPassword);
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.WrInsScreenObjHlp(dr, CultureId, dbConnectionString, dbPassword);
}
cnt = cnt + 1; if (cnt >= MaxCnt)
{
break;
}
}
return(cnt);
}
// Translate ScreenHlp table:
private int WrTrlScreenHlp(int MaxCnt, string DefCulture, string CultureId, string CultureName, string dbConnectionString, string dbPassword)
{
int cnt = 0;
DataTable dt;
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dt = dac.WrGetScreenHlp(CultureId, dbConnectionString, dbPassword);
}
foreach (DataRow dr in dt.Rows)
{
dr["DefaultHlpMsg"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["DefaultHlpMsg"].ToString().Trim(), dbConnectionString, dbPassword);
dr["FootNote"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["FootNote"].ToString().Trim(), dbConnectionString, dbPassword);
dr["ScreenTitle"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["ScreenTitle"].ToString().Trim(), dbConnectionString, dbPassword);
dr["AddMsg"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["AddMsg"].ToString().Trim(), dbConnectionString, dbPassword);
dr["UpdMsg"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["UpdMsg"].ToString().Trim(), dbConnectionString, dbPassword);
dr["DelMsg"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["DelMsg"].ToString().Trim(), dbConnectionString, dbPassword);
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.WrInsScreenHlp(dr, CultureId, dbConnectionString, dbPassword);
}
cnt = cnt + 1; if (cnt >= MaxCnt)
{
break;
}
}
return(cnt);
}
public void RmTranslatedLbl(string LabelId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.RmTranslatedLbl(LabelId, dbConnectionString, dbPassword);
}
}
public DataTable WrGetAdmMenuPerm(Int32 screenId, string keyId58, string dbConnectionString, string dbPassword, Int32 screenFilterId, UsrImpr ui, UsrCurr uc)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetAdmMenuPerm(screenId, keyId58, dbConnectionString, dbPassword, screenFilterId, ui, uc));
}
}
public DataTable WrAddMenu(string PMenuId, string ParentId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrAddMenu(PMenuId, ParentId, dbConnectionString, dbPassword));
}
}
public Int32 CountEmailsSent()
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.CountEmailsSent());
}
}
public void WrUpdMenu(string MenuId, string PMenuId, string ParentId, string MenuText, string CultureId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.WrUpdMenu(MenuId, PMenuId, ParentId, MenuText, CultureId, dbConnectionString, dbPassword);
}
}
// For report generator:
public DataTable GetDdlOriColumnId33S1682(string rptwizCatId, bool bAll, string keyId, string dbConnectionString, string dbPassword, UsrImpr ui, UsrCurr uc, Int16 cultureId)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.GetDdlOriColumnId33S1682(rptwizCatId, bAll, keyId, dbConnectionString, dbPassword, ui, uc, cultureId));
}
}
// Return true if physical table has been synchronized successfully.
public string WrSyncToDb(byte SystemId, string TableId, string TableName, bool MultiDesignDb, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrSyncToDb(SystemId, TableId, TableName, MultiDesignDb, dbConnectionString, dbPassword));
}
}
public DataTable GetDdlSelColumnId77S1682(Int32 screenId, bool bAll, string keyId, string filterId, string dbConnectionString, string dbPassword, UsrImpr ui, UsrCurr uc, Int16 cultureId)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.GetDdlSelColumnId77S1682(screenId, bAll, keyId, filterId, dbConnectionString, dbPassword, ui, uc, cultureId));
}
}
public DataTable WrAddScreenObj(string ScreenId, string PScreenObjId, string TabFolderId, bool IsTab, bool NewRow, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrAddScreenObj(ScreenId, PScreenObjId, TabFolderId, IsTab, NewRow, dbConnectionString, dbPassword));
}
}
// Return column details from physical database.
public string WrSyncByDb(int UsrId, byte SystemId, byte DbId, string TableId, string TableName, string TableDesc, bool MultiDesignDb, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrSyncByDb(UsrId, SystemId, DbId, TableId, TableName, TableDesc, MultiDesignDb, dbConnectionString, dbPassword));
}
}
public void WrUpdScreenObj(string ScreenObjId, string PScreenObjId, string TabFolderId, string ColumnHeader, string CultureId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.WrUpdScreenObj(ScreenObjId, PScreenObjId, TabFolderId, ColumnHeader, CultureId, dbConnectionString, dbPassword);
}
}
public DataTable GetDdlOperator3S1652(string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.GetDdlOperator3S1652(dbConnectionString, dbPassword));
}
}
// Return MasterTable given Screen ID and DB Column Id.
public string WrGetMasterTable(string ScreenId, string ColumnId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrGetMasterTable(ScreenId, ColumnId, dbConnectionString, dbPassword));
}
}
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));
}
}
// Return SQL script for cloning purpose given Screen ID.
public string WrCloneScreen(string ScreenId, string dbConnectionString, string dbPassword)
{
using (Access3.WebAccess dac = new Access3.WebAccess())
{
return(dac.WrCloneScreen(ScreenId, dbConnectionString, dbPassword));
}
}
// Translate ??CultureLbl table:
private int WrTrlCultureLbl(int MaxCnt, string DefCulture, string CultureId, string CultureName, string dbConnectionString, string dbPassword)
{
int cnt = 0;
if (dbConnectionString.IndexOf("Design") >= 0)
{
DataTable dt;
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dt = dac.WrGetCultureLbl(CultureId);
}
foreach (DataRow dr in dt.Rows)
{
dr["Label"] = WrGetTranslation(DefCulture, CultureId, CultureName, dr["Label"].ToString().Trim(), dbConnectionString, dbPassword);
using (Access3.WebAccess dac = new Access3.WebAccess())
{
dac.WrInsCultureLbl(dr, CultureId);
}
cnt = cnt + 1; if (cnt >= MaxCnt)
{
break;
}
}
}
return(cnt);
}
