public bool DelData(Int32 ScreenId, bool bDeferError, LoginUsr LUser, UsrImpr LImpr, UsrCurr LCurr, DataSet ds, string dbConnectionString, string dbPassword, CurrPrj CPrj, CurrSrc CSrc)
{
using (Access3.AdminAccess dac = new Access3.AdminAccess())
{
return(dac.DelData(ScreenId, bDeferError, LUser, LImpr, LCurr, ds, dbConnectionString, dbPassword, CPrj, CSrc));
}
}
public UsrImpr GetUsrImpr(Int32 UsrId, Int32 CompanyId, Int32 ProjectId, byte SystemId)
{
if (da == null)
{
throw new System.ObjectDisposedException(GetType().FullName);
}
OleDbCommand cmd = new OleDbCommand("GetUsrImpr", new OleDbConnection(GetDesConnStr()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@usrId", OleDbType.Numeric).Value = UsrId;
cmd.Parameters.Add("@companyId", OleDbType.Numeric).Value = CompanyId;
cmd.Parameters.Add("@projectId", OleDbType.Numeric).Value = ProjectId;
cmd.Parameters.Add("@systemId", OleDbType.Numeric).Value = SystemId;
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
ApplicationAssert.CheckCondition(dt.Rows.Count <= 1, "GetUsrImpr", "Integrity Failure", "Non-unique user Impersonation!");
if (dt.Rows.Count != 1)
{
return(null);
}
else
{
DataRow dr = dt.Rows[0];
UsrImpr impr = new UsrImpr(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString()
, dr[5].ToString(), dr[6].ToString(), dr[7].ToString(), dr[8].ToString(), dr[9].ToString(), dr[10].ToString(), dr[11].ToString()
, dr[12].ToString(), dr[13].ToString(), dr[14].ToString());
return(impr);
}
}
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 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));
}
}
// 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));
}
}
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 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 DataTable GetMenu(Int16 CultureId, byte SystemId, UsrImpr ui, string dbConnectionString, string dbPassword, int?ScreenId, int?ReportId, int?WizardId)
{
using (MenuAccessBase dac = GetMenuAccess())
{
return(dac.GetMenu(CultureId, SystemId, ui, dbConnectionString, dbPassword, ScreenId, ReportId, WizardId));
}
}
public DataTable GetMenu(Int16 CultureId, byte SystemId, UsrImpr ui, string dbConnectionString, string dbPassword, int?ScreenId, int?ReportId, int?WizardId)
{
//if (!dbConnectionString.Contains("Design")) checkValidLicense();
if (da == null)
{
throw new System.ObjectDisposedException(GetType().FullName);
}
OleDbCommand cmd = new OleDbCommand("GetMenu", new OleDbConnection(dbConnectionString + DecryptString(dbPassword)));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CultureId", OleDbType.Numeric).Value = CultureId;
cmd.Parameters.Add("@SystemId", OleDbType.Numeric).Value = SystemId;
cmd.Parameters.Add("@RowAuthoritys", OleDbType.VarChar).Value = ui.RowAuthoritys;
cmd.Parameters.Add("@Usrs", OleDbType.VarChar).Value = ui.Usrs;
cmd.Parameters.Add("@UsrGroups", OleDbType.VarChar).Value = ui.UsrGroups;
cmd.Parameters.Add("@Companys", OleDbType.VarChar).Value = ui.Companys;
cmd.Parameters.Add("@Projects", OleDbType.VarChar).Value = ui.Projects;
cmd.Parameters.Add("@Agents", OleDbType.VarChar).Value = ui.Agents;
cmd.Parameters.Add("@Brokers", OleDbType.VarChar).Value = ui.Brokers;
cmd.Parameters.Add("@Customers", OleDbType.VarChar).Value = ui.Customers;
cmd.Parameters.Add("@Investors", OleDbType.VarChar).Value = ui.Investors;
cmd.Parameters.Add("@Members", OleDbType.VarChar).Value = ui.Members;
cmd.Parameters.Add("@Vendors", OleDbType.VarChar).Value = ui.Vendors;
if (ScreenId.HasValue)
{
cmd.Parameters.Add("@ScreenId", OleDbType.Numeric).Value = ScreenId.Value;
}
else
{
cmd.Parameters.Add("@ScreenId", OleDbType.Numeric).Value = DBNull.Value;
}
if (ReportId.HasValue)
{
cmd.Parameters.Add("@ReportId", OleDbType.Numeric).Value = ReportId.Value;
}
else
{
cmd.Parameters.Add("@ReportId", OleDbType.Numeric).Value = DBNull.Value;
}
if (WizardId.HasValue)
{
cmd.Parameters.Add("@WizardId", OleDbType.Numeric).Value = WizardId.Value;
}
else
{
cmd.Parameters.Add("@WizardId", OleDbType.Numeric).Value = DBNull.Value;
}
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
private UsrImpr SetImpersonation(UsrImpr LImpr, Int32 usrId, byte systemId, Int32 companyId, Int32 projectId)
{
UsrImpr ui = null;
ui = (new LoginSystem()).GetUsrImpr(usrId, companyId, projectId, systemId);
if (ui != null)
{
if (LImpr == null)
{
LImpr = ui;
//if (LUser.LoginName == "Anonymous") { LImpr.Cultures = LUser.CultureId.ToString(); }
}
else // Append:
{
LImpr.Usrs = ui.Usrs;
LImpr.UsrGroups = ui.UsrGroups;
LImpr.Cultures = ui.Cultures;
LImpr.RowAuthoritys = ui.RowAuthoritys;
LImpr.Companys = ui.Companys;
LImpr.Projects = ui.Projects;
LImpr.Investors = ui.Investors;
LImpr.Customers = ui.Customers;
LImpr.Vendors = ui.Vendors;
LImpr.Agents = ui.Agents;
LImpr.Brokers = ui.Brokers;
LImpr.Members = ui.Members;
}
DataTable dt = (new LoginSystem()).GetUsrImprNext(usrId);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string TestDupUsrs = (char)191 + LImpr.Usrs + (char)191;
if (TestDupUsrs.IndexOf((char)191 + dr["ImprUsrId"].ToString() + (char)191) < 0)
{
SetImpersonation(LImpr, Int32.Parse(dr["ImprUsrId"].ToString()), systemId, companyId, projectId);
}
}
}
}
return(LImpr);
}
public DataTable GetServerRule(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc, UsrImpr ui, UsrCurr uc)
{
if (da == null)
{
throw new System.ObjectDisposedException(GetType().FullName);
}
OleDbCommand cmd = new OleDbCommand("GetServerRule", new OleDbConnection(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword)));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@screenId", OleDbType.Numeric).Value = screenId;
if (ui != null && uc != null)
{
cmd.Parameters.Add("@Usrs", OleDbType.VarChar).Value = ui.Usrs;
cmd.Parameters.Add("@RowAuthoritys", OleDbType.VarChar).Value = ui.RowAuthoritys;
cmd.Parameters.Add("@Customers", OleDbType.VarChar).Value = ui.Customers;
cmd.Parameters.Add("@Vendors", OleDbType.VarChar).Value = ui.Vendors;
cmd.Parameters.Add("@Members", OleDbType.VarChar).Value = ui.Members;
cmd.Parameters.Add("@Investors", OleDbType.VarChar).Value = ui.Investors;
cmd.Parameters.Add("@Agents", OleDbType.VarChar).Value = ui.Agents;
cmd.Parameters.Add("@Brokers", OleDbType.VarChar).Value = ui.Brokers;
cmd.Parameters.Add("@UsrGroups", OleDbType.VarChar).Value = ui.UsrGroups;
cmd.Parameters.Add("@Companys", OleDbType.VarChar).Value = ui.Companys;
cmd.Parameters.Add("@Projects", OleDbType.VarChar).Value = ui.Projects;
cmd.Parameters.Add("@Cultures", OleDbType.VarChar).Value = ui.Cultures;
cmd.Parameters.Add("@Borrowers", OleDbType.VarChar).Value = ui.Borrowers;
cmd.Parameters.Add("@Guarantors", OleDbType.VarChar).Value = ui.Guarantors;
cmd.Parameters.Add("@Lenders", OleDbType.VarChar).Value = ui.Lenders;
cmd.Parameters.Add("@currCompanyId", OleDbType.Numeric).Value = uc.CompanyId;
cmd.Parameters.Add("@currProjectId", OleDbType.Numeric).Value = uc.ProjectId;
}
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
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 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 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 DataTable GetMenu(Int16 CultureId, byte SystemId, UsrImpr ui, string dbConnectionString, string dbPassword, int?ScreenId, int?ReportId, int?WizardId)
{
//if (!dbConnectionString.Contains("Design")) checkValidLicense();
if (da == null)
{
throw new System.ObjectDisposedException(GetType().FullName);
}
OleDbCommand cmd = new OleDbCommand("GetMenu", new OleDbConnection(dbConnectionString + DecryptString(dbPassword)));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CultureId", OleDbType.Numeric).Value = CultureId;
cmd.Parameters.Add("@SystemId", OleDbType.Numeric).Value = SystemId;
cmd.Parameters.Add("@RowAuthoritys", OleDbType.VarChar).Value = ui.RowAuthoritys;
cmd.Parameters.Add("@Usrs", OleDbType.VarChar).Value = ui.Usrs;
cmd.Parameters.Add("@UsrGroups", OleDbType.VarChar).Value = ui.UsrGroups;
cmd.Parameters.Add("@Companys", OleDbType.VarChar).Value = ui.Companys;
cmd.Parameters.Add("@Projects", OleDbType.VarChar).Value = ui.Projects;
cmd.Parameters.Add("@Agents", OleDbType.VarChar).Value = ui.Agents;
cmd.Parameters.Add("@Brokers", OleDbType.VarChar).Value = ui.Brokers;
cmd.Parameters.Add("@Customers", OleDbType.VarChar).Value = ui.Customers;
cmd.Parameters.Add("@Investors", OleDbType.VarChar).Value = ui.Investors;
cmd.Parameters.Add("@Members", OleDbType.VarChar).Value = ui.Members;
cmd.Parameters.Add("@Vendors", OleDbType.VarChar).Value = ui.Vendors;
if (ScreenId.HasValue)
{
cmd.Parameters.Add("@ScreenId", OleDbType.Numeric).Value = ScreenId.Value;
}
else
{
cmd.Parameters.Add("@ScreenId", OleDbType.Numeric).Value = DBNull.Value;
}
if (ReportId.HasValue)
{
cmd.Parameters.Add("@ReportId", OleDbType.Numeric).Value = ReportId.Value;
}
else
{
cmd.Parameters.Add("@ReportId", OleDbType.Numeric).Value = DBNull.Value;
}
if (WizardId.HasValue)
{
cmd.Parameters.Add("@WizardId", OleDbType.Numeric).Value = WizardId.Value;
}
else
{
cmd.Parameters.Add("@WizardId", OleDbType.Numeric).Value = DBNull.Value;
}
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
int licensedCount = GetLicensedModuleCount();
if (licensedCount > 0)
{
int ii = 0;
bool rowsRemoved = false;
foreach (DataRow dr in dt.Rows)
{
if (ii >= licensedCount && dr["SystemId"].ToString() != "3" && dr["SystemId"].ToString() != "5")
{
dr.Delete();
rowsRemoved = true;
}
ii = ii + 1;
}
if (rowsRemoved)
{
dt.AcceptChanges();
}
}
return(dt);
}
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 abstract DataTable GetScreenLabel(Int32 ScreenId, Int16 CultureId, UsrImpr ui, UsrCurr uc, string dbConnectionString, string 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));
}
}
/* 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 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 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 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 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 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));
}
}
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 abstract DataTable RunWrRule(int screenId, string procedureName, string dbConnectionString, string dbPassword, string parameterXML, UsrImpr ui, UsrCurr uc, bool noTrans);
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));
}
}
/* 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 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 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));
}
}
