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