Example #1
0
 public static void RefreshClientTier(CurrPrj CPrj, CurrSrc CSrc)
 {
     File.Copy(CPrj.SrcRuleProgramPath + "Service" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Service" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\Service" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Service" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Facade" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\Facade" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Service" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Rule" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\Rule" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Service" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Access" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\Access" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Service" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Common" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\Common" + CSrc.SrcSystemId.ToString() + ".dll", true);
 }
Example #2
0
 public static void CompileProxy(CurrPrj CPrj, CurrSrc CSrc)
 {
     // Need to recompile Facade layer to make MkWsProxy works:
     CompilePrj("Facade" + CSrc.SrcSystemId.ToString() + "\\Facade" + CSrc.SrcSystemId.ToString() + ".csproj");
     File.Copy(CPrj.SrcRuleProgramPath + "Facade" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Facade" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcWsProgramPath + "\\Bin\\Facade" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Facade" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Rule" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcWsProgramPath + "\\Bin\\Rule" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Facade" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Access" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcWsProgramPath + "\\Bin\\Access" + CSrc.SrcSystemId.ToString() + ".dll", true);
     File.Copy(CPrj.SrcRuleProgramPath + "Facade" + CSrc.SrcSystemId.ToString() + "\\Bin\\Debug\\Common" + CSrc.SrcSystemId.ToString() + ".dll", CPrj.SrcWsProgramPath + "\\Bin\\Common" + CSrc.SrcSystemId.ToString() + ".dll", true);
 }
Example #3
0
        public override DataTable GetWizardRule(Int32 wizardId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OdbcCommand cmd = new OdbcCommand("GetWizardRule", new OdbcConnection(Config.ConvertOleDbConnStrToOdbcConnStr(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword))));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@wizardId", OdbcType.Numeric).Value = wizardId;
            da.SelectCommand = TransformCmd(cmd);
            DataTable dt = new DataTable();

            da.Fill(dt);
            return(dt);
        }
        //public DataTable GetAdvRule(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc)
        //{
        //    if (da == null)
        //    {
        //        throw new System.ObjectDisposedException(GetType().FullName);
        //    }
        //    OleDbCommand cmd = new OleDbCommand("GetAdvRule", new OleDbConnection(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword)));
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.Add("@screenId", OleDbType.Numeric).Value = screenId;
        //    da.SelectCommand = cmd;
        //    DataTable dt = new DataTable();
        //    da.Fill(dt);
        //    return dt;
        //}

        public DataTable GetWebRule(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OleDbCommand cmd = new OleDbCommand("GetWebRule", new OleDbConnection(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword)));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@screenId", OleDbType.Numeric).Value = screenId;
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();

            da.Fill(dt);
            return(dt);
        }
Example #5
0
        public override DataTable GetWizardColumns(Int32 wizardId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OdbcCommand cmd = new OdbcCommand("GetWizardColumns", new OdbcConnection(Config.ConvertOleDbConnStrToOdbcConnStr(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword))));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@wizardId", OdbcType.Numeric).Value = wizardId;
            da.SelectCommand = TransformCmd(cmd);
            DataTable dt = new DataTable();

            da.Fill(dt);
            ApplicationAssert.CheckCondition(dt.Rows.Count > 0, "GetWizardColumns", "Wizard Columns Issue", "Columns for Wizard #'" + wizardId.ToString() + "' not available!");
            return(dt);
        }
        public DataTable GetDistinctScreenTab(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OleDbCommand cmd = new OleDbCommand("GetDistinctScreenTab", new OleDbConnection(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword)));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@screenId", OleDbType.Numeric).Value = screenId;
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();

            da.Fill(dt);
            ApplicationAssert.CheckCondition(dt.Rows.Count > 0, "GetDistinctScreenTab", "Screen Issue", "Tab Folder numbers not available for Screen #'" + screenId.ToString() + "'!");
            return(dt);
        }
Example #7
0
        public override DataTable GetReportColumns(string GenPrefix, Int32 reportId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OleDbCommand cmd = new OleDbCommand("GetReportColumns", new OleDbConnection(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword)));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@GenPrefix", OleDbType.VarChar).Value = GenPrefix;
            cmd.Parameters.Add("@reportId", OleDbType.Numeric).Value  = reportId;
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();

            da.Fill(dt);
            ApplicationAssert.CheckCondition(dt.Rows.Count > 0, "GetReportColumns", "Report Columns Issue", "Columns for Report #'" + reportId.ToString() + "' not available!");
            return(dt);
        }
Example #8
0
        public static string CompileAuxProj(CurrPrj CPrj)
        {
            string[] auxProj = new string[] { "SystemFramewk", "WebRules", "WebControls", "UsrAccess", "UsrRules" };
            string   result  = "";

            foreach (string proj in auxProj)
            {
                if (Directory.Exists(Config.RuleTierPath + "\\" + proj))
                {
                    result = result + CompilePrj(proj + "\\" + proj + ".csproj");
                    File.Copy(CPrj.SrcRuleProgramPath + proj + "\\Bin\\Debug\\" + proj + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\" + proj + ".dll", true);
                    if (proj == "SystemFramewk")
                    {
                        File.Copy(CPrj.SrcRuleProgramPath + proj + "\\Bin\\Debug\\" + proj + ".dll", CPrj.SrcClientProgramPath + "\\Bin\\" + proj + ".dll", true);
                    }
                }
            }
            return(result);
        }
        public override DataTable GetWizardById(Int32 wizardId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OleDbCommand cmd = new OleDbCommand("GetWizardById", new OleDbConnection(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword)));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@desDatabase", OleDbType.VarChar).Value = CPrj.SrcDesDatabase;
            cmd.Parameters.Add("@srcDatabase", OleDbType.VarChar).Value = CSrc.SrcDbDatabase;
            cmd.Parameters.Add("@wizardId", OleDbType.Numeric).Value    = wizardId;
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();

            da.Fill(dt);
            ApplicationAssert.CheckCondition(dt.Rows.Count == 1, "GetWizardById", "Wizard Issue", "Information for Wizard #'" + wizardId.ToString() + "' not available!");
            return(dt);
        }
        public override DataTable GetReportById(string GenPrefix, Int32 reportId, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OdbcCommand cmd = new OdbcCommand("GetReportById", new OdbcConnection(Config.ConvertOleDbConnStrToOdbcConnStr(CSrc.SrcConnectionString + DecryptString(CSrc.SrcDbPassword))));

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@GenPrefix", OdbcType.VarChar).Value   = GenPrefix;
            cmd.Parameters.Add("@desDatabase", OdbcType.VarChar).Value = CPrj.SrcDesDatabase;
            cmd.Parameters.Add("@srcDatabase", OdbcType.VarChar).Value = CSrc.SrcDbDatabase;
            cmd.Parameters.Add("@reportId", OdbcType.Numeric).Value    = reportId;
            da.SelectCommand = TransformCmd(cmd);
            DataTable dt = new DataTable();

            da.Fill(dt);
            ApplicationAssert.CheckCondition(dt.Rows.Count == 1, "GetReportById", "Report Issue", "Information for Report #'" + reportId.ToString() + "' not available!");
            return(dt);
        }
        public string GetDByteOle(string DataTypeName, CurrPrj CPrj)
        {
            if (da == null)
            {
                throw new System.ObjectDisposedException(GetType().FullName);
            }
            OleDbConnection cn = new OleDbConnection(CPrj.SrcDesConnectionString + DecryptString(CPrj.SrcDesPassword));

            cn.Open();
            OleDbCommand cmd = new OleDbCommand("GetDByteOle", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@DataTypeName", OleDbType.VarChar).Value = DataTypeName;
            string dbole = (string)cmd.ExecuteScalar();

            cmd.Dispose();
            cmd = null;
            cn.Close();
            ApplicationAssert.CheckCondition(dbole != null && dbole != string.Empty, "GetDByteOle", "Invalid Data Type", "Business rule data type '" + DataTypeName + "' not recognized!");
            return(dbole);
        }
        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);
        }
Example #13
0
        private StringBuilder MakeCss(DataTable dtObj, string SectionNm, CurrPrj CPrj, CurrSrc CSrc)
        {
            StringBuilder sb = new StringBuilder();
            string        str;
            DataView      dvLnk = null;

            sb.Append(Environment.NewLine + "/* " + SectionNm + " */" + Environment.NewLine);
            foreach (DataRowView drv in dtObj.DefaultView)
            {
                str = sb.ToString();
                if (!string.IsNullOrEmpty(drv["SctGrpRowId"].ToString()) && str.IndexOf(".SctGrpRow" + drv["SctGrpRowId"].ToString()) < 0)
                {
                    sb.Append(".SctGrpRow" + drv["SctGrpRowId"].ToString() + " { " + drv["SctGrpRowCss"].ToString() + " }" + Environment.NewLine);
                }
                if (!string.IsNullOrEmpty(drv["SctGrpColId"].ToString()))
                {
                    if (str.IndexOf(".SctGrpCol" + drv["SctGrpColId"].ToString()) < 0)
                    {
                        sb.Append(".SctGrpCol" + drv["SctGrpColId"].ToString() + " { " + drv["SctGrpColCss"].ToString() + " }" + Environment.NewLine);
                    }
                    if (str.IndexOf(".SctGrpDiv" + drv["SctGrpColId"].ToString()) < 0)
                    {
                        sb.Append(".SctGrpDiv" + drv["SctGrpColId"].ToString() + " { " + drv["SctGrpColDiv"].ToString() + " }" + Environment.NewLine);
                    }
                }
                sb.Append(".PageObj" + drv["PageObjId"].ToString() + " { " + drv["PageObjCss"].ToString() + " }" + Environment.NewLine);
                using (Access3.GenSectionAccess dac = new Access3.GenSectionAccess())
                {
                    dvLnk = dac.GetPageLnk(drv["PageObjId"].ToString()).DefaultView;
                }
                foreach (DataRowView drvn in dvLnk)
                {
                    sb.Append(".PageLnk" + drvn["PageLnkId"].ToString() + " { " + drvn["PageLnkCss"].ToString() + " }" + Environment.NewLine);
                }
            }
            return(sb);
        }
 private void ExecProgD(string ProcedureName, string ss, CurrPrj CPrj, CurrSrc CSrc, CurrTar CTar)
 {
     using (Access3.RobotAccess dac = new Access3.RobotAccess())
     {
         if (CPrj.SrcDesProviderCd == "S")
         {
             dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSINULL ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
                         + ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
                         + " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CSrc.SrcConnectionString, CSrc.SrcDbPassword);
         }
         else
         {
             dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
                         + ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
                         + " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CSrc.SrcConnectionString, CSrc.SrcDbPassword);
         }
     }
     if (CTar.TarDbServer != CSrc.SrcDbServer && CPrj.SrcDesProviderCd == "M")
     {
         using (Access3.RobotAccess dac = new Access3.RobotAccess())
         {
             if (CPrj.TarDesProviderCd == "S")
             {
                 dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSINULL ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
                             + ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
                             + " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CTar.TarConnectionString, CTar.TarDbPassword);
             }
             else
             {
                 dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
                             + ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
                             + " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CTar.TarConnectionString, CTar.TarDbPassword);
             }
         }
     }
 }
Example #15
0
        public static StringBuilder MkWsProxy(string ProgramName, CurrPrj CPrj, CurrSrc CSrc)
        {
            if (!File.Exists(Config.WsdlExe))
            {
                throw new Exception("Expected program wsdl.exe not found at location " + Config.WsdlExe + "!");
            }
            StringBuilder sb = new StringBuilder();
            string        ss;
            string        url     = Config.WsBaseUrl + "/" + ProgramName + "Ws.asmx";
            string        cs_file = Path.GetTempFileName();
            string        cmd_arg = " /nologo /namespace:" + CPrj.EntityCode + ".Service" + CSrc.SrcSystemId.ToString() + " /out:\"" + cs_file + "\" " + "\"" + url + "\"";

            ss = Utils.WinProc(Config.WsdlExe, cmd_arg, true);
            if (ss.IndexOf("Error:") >= 0)
            {
                throw new Exception(ss);
            }
            using (StreamReader sr = new StreamReader(cs_file))
            {
                sb.Append(sr.ReadToEnd());
            }
            File.Delete(cs_file);
            return(sb);
        }
 public int ImportRows(Int32 wizardId, string procedureName, bool bOverwrite, Int32 usrId, DataSet ds, int iStart, string fileName, string dbConnectionString, string dbPassword, CurrPrj CPrj, CurrSrc CSrc, bool noTrans = false, int commandTimeOut = 1800)
 {
     using (Access3.AdminAccess dac = new Access3.AdminAccess(commandTimeOut))
     {
         return(dac.ImportRows(wizardId, procedureName, bOverwrite, usrId, ds, iStart, fileName, dbConnectionString, dbPassword, CPrj, CSrc, noTrans));
     }
 }
 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 void ProxyProgram(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc)
        //{
        //    (new GenScreensRules()).ProxyProgram(screenId, CPrj, CSrc);
        //}

        public bool DeleteProgram(string programName, Int32 screenId, string appDatabase, string multiDesignDb, string sysProgram, CurrPrj CPrj, CurrSrc CSrc, CurrTar CTar)
        {
            return((new GenScreensRules()).DeleteProgram(programName, screenId, appDatabase, multiDesignDb, sysProgram, CPrj, CSrc, CTar));
        }
 public bool CreateProgram(Int32 screenId, string screenTitle, string dbAppDatabase, CurrPrj CPrj, CurrSrc CSrc, CurrTar CTar, string dbConnectionString, string dbPassword)
 {
     return((new GenScreensRules()).CreateProgram(screenId, screenTitle, dbAppDatabase, CPrj, CSrc, CTar, dbConnectionString, dbPassword));
 }
Example #20
0
 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);
Example #21
0
 public abstract int ImportRows(Int32 wizardId, string procedureName, bool bOverwrite, Int32 usrId, DataSet ds, int iStart, string fileName, string dbConnectionString, string dbPassword, CurrPrj CPrj, CurrSrc CSrc, bool noTrans);
Example #22
0
        //public void ProxyProgram(string GenPrefix, Int32 reportId, CurrPrj CPrj, CurrSrc CSrc)
        //{
        //    (new GenReportsRules()).ProxyProgram(GenPrefix, reportId, CPrj, CSrc);
        //}

        public bool DeleteProgram(string GenPrefix, string programName, Int32 reportId, string appDatabase, CurrPrj CPrj, CurrSrc CSrc, CurrTar CTar)
        {
            return((new GenReportsRules()).DeleteProgram(GenPrefix, programName, reportId, appDatabase, CPrj, CSrc, CTar));
        }
Example #23
0
 public bool CreateProgram(string GenPrefix, Int32 reportId, string reportTitle, string dbAppDatabase, CurrPrj CPrj, CurrSrc CSrc, CurrTar CTar, string dbConnectionString, string dbPassword)
 {
     return((new GenReportsRules()).CreateProgram(GenPrefix, reportId, reportTitle, dbAppDatabase, CPrj, CSrc, CTar, dbConnectionString, dbPassword));
 }
 public abstract DataTable GetServerRule(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc, UsrImpr ui, UsrCurr uc);
 public abstract DataTable GetScreenCriteria(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc);
 public abstract DataTable GetWebRule(Int32 screenId, CurrPrj CPrj, CurrSrc CSrc);
Example #27
0
 public abstract DataTable GetWizardRule(Int32 wizardId, CurrPrj CPrj, CurrSrc CSrc);
Example #28
0
        private StringBuilder MakeHAscx(DataTable dtObj, string SectionNm, CurrPrj CPrj, CurrSrc CSrc)
        {
            DataView      dvLnk = null;
            DataRow       drObj = null;
            StringBuilder sb    = new StringBuilder();
            StringBuilder tm    = new StringBuilder();
            StringBuilder rp    = new StringBuilder();

            sb.Append("<%@ Control Language=\"c#\" Inherits=\"RO.Web." + SectionNm + "Module\" CodeFile=\"" + SectionNm + "Module.ascx.cs\" CodeFileBaseClass=\"RO.Web.ModuleBase\" %>" + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'CUL'").Count() > 0)
            {
                sb.Append("<%@ Register TagPrefix=\"rcasp\" Namespace=\"RoboCoder.WebControls\" Assembly=\"WebControls, Culture=neutral\" %>" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'MNT'").Count() > 0)
            {
                sb.Append("<%@ Register TagPrefix=\"Module\" TagName=\"MenuTop\" Src=\"MenuTopModule.ascx\" %>" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'MNS'").Count() > 0)
            {
                sb.Append("<%@ Register TagPrefix=\"Module\" TagName=\"MenuSid\" Src=\"MenuSidModule.ascx\" %>" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'PRF'").Count() > 0)
            {
                sb.Append("<%@ Register TagPrefix=\"Module\" TagName=\"Profile\" Src=\"MyProfileModule.ascx\" %>" + Environment.NewLine);
            }

            // Prepare body tm:
            if (SectionNm == "Header")
            {
                tm.Append("<div class=\"mobileHeader\">" + Environment.NewLine);
                if (dtObj.Select("LinkTypeCd = 'LGO'").Count() > 0)
                {
                    drObj = (dtObj.Select("LinkTypeCd = 'LGO'"))[0];
                    using (Access3.GenSectionAccess dac = new Access3.GenSectionAccess())
                    {
                        dvLnk = dac.GetPageLnk(drObj["PageObjId"].ToString()).DefaultView;
                    }
                    tm.Append("    <div class=\"mobileLogo\"><asp:HyperLink NavigateUrl=\"" + Utils.AddTilde(dvLnk[0]["PageLnkRef"].ToString()) + "\" runat=\"server\"><asp:Image ImageUrl=\"" + Utils.AddTilde(dvLnk[0]["PageLnkAlt"].ToString()) + "\" runat=\"server\" /></asp:HyperLink></div>" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'BRC'").Count() > 0)
                {
                    tm.Append("    <div class=\"crumbSec\"><asp:HyperLink ID=\"cMobileCrumb\" CssClass=\"crumbMobile\" runat=\"server\" /></div>" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'MNT'").Count() > 0)
                {
                    tm.Append("    <div><section id=\"mobileMenu\"><div class=\"sb-navbar sb-slide\"><div class=\"sb-toggle-right\">" + Environment.NewLine);
                    tm.Append("        <asp:Label ID=\"mMenuTitle\" CssClass=\"mMenuTitle\" Text=\"MENU\" runat=\"server\"></asp:Label>" + Environment.NewLine);
                    tm.Append("        <div class=\"navicon-line\"></div><div class=\"navicon-line\"></div><div class=\"navicon-line\"></div>" + Environment.NewLine);
                    tm.Append("    </div></div></section></div>" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'PRF'").Count() > 0)
                {
                    tm.Append("    <div><asp:HyperLink ID=\"cSignIn\" CssClass=\"SignInMobile\" Text=\"Sign In\" runat=\"server\" /></div>" + Environment.NewLine);
                    tm.Append("    <div><asp:Button ID=\"cProfileButton\" CssClass=\"ProfBtnSec\" OnClientClick=\"slide(this); return false\" Text=\"Profile\" runat=\"server\" /></div>" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'HDR'").Count() > 0)
                {
                    tm.Append("    <div><asp:Button ID=\"cLinkButton\" CssClass=\"LinkBtnSec\" OnClientClick=\"openLinkSec(); return false;\" Text=\"Link\" runat=\"server\" /></div>" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'SSO'").Count() > 0)
                {
                    tm.Append("    <div><asp:Button ID=\"cSociButton\" CssClass=\"SociBtnSec\" OnClientClick=\"openSociSec(); return false;\" Text=\"Social\" runat=\"server\" /></div>" + Environment.NewLine);
                }
                tm.Append("</div>" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'BKI'").Count() > 0)
            {
                drObj = (dtObj.Select("LinkTypeCd = 'BKI'"))[0];
                tm.Append("<div class=\"HideBgImgOnMobile PageObj" + drObj["PageObjId"].ToString() + "\">" + Environment.NewLine);
            }
            string PreviousRow = string.Empty;
            string PreviousCol = string.Empty;

            foreach (DataRowView drv in dtObj.DefaultView)
            {
                if (PreviousRow != string.Empty && drv["RowCssClass"].ToString() != PreviousRow)
                {
                    PreviousRow = "NewRow"; PreviousCol = "NewCol";     // For PreviousCol below.
                }
                if (PreviousCol != string.Empty && drv["ColCssClass"].ToString() != PreviousCol)
                {
                    tm.Append("    </div>" + Environment.NewLine);
                    if (PreviousCol.LastIndexOf("-12") == PreviousCol.Length - 3)
                    {
                        PreviousRow = "NewRow"; PreviousCol = "NewCol";
                    }
                }
                if (PreviousRow != string.Empty && drv["RowCssClass"].ToString() != PreviousRow)
                {
                    tm.Append("</div></div>" + Environment.NewLine);
                }
                if (!string.IsNullOrEmpty(drv["SctGrpRowId"].ToString()) && !string.IsNullOrEmpty(drv["SctGrpColId"].ToString()))
                {
                    if (drv["RowCssClass"].ToString() != PreviousRow)
                    {
                        tm.Append("<div class=\"r-table " + drv["RowCssClass"].ToString() + " SctGrpRow" + drv["SctGrpRowId"].ToString() + "\"><div class=\"r-tr\">" + Environment.NewLine);
                        PreviousRow = drv["RowCssClass"].ToString(); PreviousCol = "NewCol";
                    }
                    if (drv["ColCssClass"].ToString() != PreviousCol)
                    {
                        tm.Append("    <div class=\"r-td " + drv["ColCssClass"].ToString() + " SctGrpCol" + drv["SctGrpColId"].ToString());
                        if (",LGO,CDD,CDT,BRC,".IndexOf("," + drv["LinkTypeCd"].ToString() + ",") >= 0)
                        {
                            tm.Append(" HideOnMobile");
                        }
                        tm.Append("\">" + Environment.NewLine);
                        PreviousCol = drv["ColCssClass"].ToString();
                    }
                    if (drv["LinkTypeCd"].ToString() == "LGO")
                    {
                        tm.Append("        <div ID=\"cLogoHolder\" class=\"SctGrpDiv" + drv["SctGrpColId"].ToString() + "\" runat=\"server\">" + Environment.NewLine);
                    }
                    else if (drv["LinkTypeCd"].ToString() == "HDR")
                    {
                        tm.Append("        <div ID=\"cLinkHolder\" class=\"link-content" + (SectionNm == "Header" ? " hideMoreButtonSec" : "") + " SctGrpDiv" + drv["SctGrpColId"].ToString() + "\" runat=\"server\">" + Environment.NewLine);
                    }
                    else if (drv["LinkTypeCd"].ToString() == "SSO")
                    {
                        tm.Append("        <div ID=\"cSociHolder\" class=\"link-content" + (SectionNm == "Header" ? " hideMoreButtonSec" : "") + " SctGrpDiv" + drv["SctGrpColId"].ToString() + "\" runat=\"server\">" + Environment.NewLine);
                    }
                    else if (drv["LinkTypeCd"].ToString() == "CUL")
                    {
                        tm.Append("        <div class=\"reset-lang SctGrpDiv" + drv["SctGrpColId"].ToString() + "\">" + Environment.NewLine);
                    }
                    else if (drv["LinkTypeCd"].ToString() == "CRS")
                    {
                        tm.Append("        <div class=\"flexslider SctGrpDiv" + drv["SctGrpColId"].ToString() + "\">" + Environment.NewLine);
                    }
                    else
                    {
                        tm.Append("        <div class=\"SctGrpDiv" + drv["SctGrpColId"].ToString() + "\">" + Environment.NewLine);
                    }
                    using (Access3.GenSectionAccess dac = new Access3.GenSectionAccess())
                    {
                        dvLnk = dac.GetPageLnk(drv["PageObjId"].ToString()).DefaultView;
                    }
                    if (",HDR,SSO,LNK,CRS,".IndexOf("," + drv["LinkTypeCd"].ToString() + ",") >= 0)
                    {
                        if (drv["LinkTypeCd"].ToString() == "CRS")
                        {
                            tm.Append("        <ul class=\"slides PageObj" + drv["PageObjId"].ToString() + "\">" + Environment.NewLine);
                        }
                        else
                        {
                            tm.Append("        <div class=\"r-table PageObj" + drv["PageObjId"].ToString() + "\"><div class=\"r-tr\"><div class=\"r-td\">" + Environment.NewLine);
                        }
                        bool bFirstLnk = true;
                        foreach (DataRowView drvn in dvLnk)
                        {
                            tm.Append("            ");
                            if (drv["LinkTypeCd"].ToString() == "CRS")
                            {
                                if (bFirstLnk)
                                {
                                    tm.Append("<li class=\"flex-active-slide\">"); bFirstLnk = false;
                                }
                                else
                                {
                                    tm.Append("<li style=\"display:none;\">");
                                }
                            }
                            /* Stack image on top of text */
                            if (!string.IsNullOrEmpty(drvn["PageLnkImg"].ToString()))
                            {
                                // Cannot use asp:HyperLink because of mouseover script:
                                tm.Append("<asp:ImageButton ID=\"PageLnk" + drvn["PageLnkId"].ToString() + "Img\"");
                                tm.Append(" ImageUrl=\"" + Utils.AddTilde(drvn["PageLnkImg"].ToString()) + "\"");
                                // CSS applies to text if both image and text exist:
                                if (string.IsNullOrEmpty(drvn["PageLnkTxt"].ToString()))
                                {
                                    tm.Append(" CssClass=\"PageLnk" + drvn["PageLnkId"].ToString() + "\"");
                                }
                                if (!string.IsNullOrEmpty(drvn["PageLnkRef"].ToString()))
                                {
                                    if (drvn["PageLnkRef"].ToString().ToLower().IndexOf("javascript:") >= 0)
                                    {
                                        tm.Append(" OnClientClick=\"" + drvn["PageLnkRef"].ToString().Substring(drvn["PageLnkRef"].ToString().ToLower().IndexOf("javascript:") + 11) + "\"");
                                    }
                                    else if (drvn["Popup"].ToString() == "Y" && !drvn["PageLnkRef"].ToString().ToLower().StartsWith("mailto"))
                                    {
                                        tm.Append(" OnClientClick=\"SearchLink('" + drvn["PageLnkRef"].ToString() + "','','',''); return stopEvent(this,event);\" NavigateUrl=\"#\"");
                                    }
                                    else
                                    {
                                        tm.Append(" NavigateUrl=\"" + Utils.AddTilde(drvn["PageLnkRef"].ToString()) + "\"");
                                    }
                                }
                                tm.Append(" runat=\"server\" />");
                                // Prepare toggle script rp:
                                if (drv["LinkTypeCd"].ToString() != "LGO" && !string.IsNullOrEmpty(drvn["PageLnkAlt"].ToString()))
                                {
                                    rp.Append("    Sys.Application.add_load(function () { var pid = $('#<%=PageLnk" + drvn["PageLnkId"].ToString() + "Img.ClientID%>');" + Environment.NewLine);
                                    rp.Append("        pid.mouseover(function () { pid.attr('src','" + Utils.StripTilde(drvn["PageLnkAlt"].ToString(), false) + "'); });" + Environment.NewLine);
                                    rp.Append("        pid.mouseout(function () { pid.attr('src','" + Utils.StripTilde(drvn["PageLnkImg"].ToString(), false) + "'); });" + Environment.NewLine);
                                    rp.Append("    });" + Environment.NewLine);
                                }
                            }
                            if (!string.IsNullOrEmpty(drvn["PageLnkTxt"].ToString()))
                            {
                                tm.Append("<asp:HyperLink Text=\"" + drvn["PageLnkTxt"].ToString() + "\"");
                                tm.Append(" CssClass=\"PageLnk" + drvn["PageLnkId"].ToString() + "\"");
                                if (!string.IsNullOrEmpty(drvn["PageLnkRef"].ToString()))
                                {
                                    if (drvn["PageLnkRef"].ToString().ToLower().IndexOf("javascript:") >= 0)
                                    {
                                        tm.Append(" OnClick=\"" + drvn["PageLnkRef"].ToString().Substring(drvn["PageLnkRef"].ToString().ToLower().IndexOf("javascript:") + 11) + "\"");
                                    }
                                    else if (drvn["Popup"].ToString() == "Y" && !drvn["PageLnkRef"].ToString().ToLower().StartsWith("mailto"))
                                    {
                                        tm.Append(" OnClick=\"SearchLink('" + drvn["PageLnkRef"].ToString() + "','','',''); return stopEvent(this,event);\" NavigateUrl=\"#\"");
                                    }
                                    else
                                    {
                                        tm.Append(" NavigateUrl=\"" + Utils.AddTilde(drvn["PageLnkRef"].ToString()) + "\"");
                                    }
                                }
                                tm.Append(" runat=\"server\" />");
                            }
                            if (drv["LinkTypeCd"].ToString() == "CRS")
                            {
                                tm.Append("</li>" + Environment.NewLine);
                            }
                            else
                            {
                                tm.Append(Environment.NewLine);
                            }
                        }
                        if (drv["LinkTypeCd"].ToString() == "CRS")
                        {
                            tm.Append("        </ul>" + Environment.NewLine);
                        }
                        else
                        {
                            tm.Append("        </div></div></div>" + Environment.NewLine);
                        }
                    }
                    else /* Singular Object: do not allow button as PostBackUrl is causing validation issue. One can always style an image button or hyperlink as a button via css. */
                    {
                        tm.Append("        <div class=\"PageObj" + drv["PageObjId"].ToString() + "\">" + Environment.NewLine);
                        if (drv["LinkTypeCd"].ToString() == "LGO" || drv["LinkTypeCd"].ToString() == "IMG")
                        {
                            tm.Append("            <asp:HyperLink NavigateUrl=\"" + Utils.AddTilde(dvLnk[0]["PageLnkRef"].ToString()) + "\" runat=\"server\"><asp:Image CssClass=\"PageLnk" + dvLnk[0]["PageLnkId"].ToString() + "\" ImageUrl=\"" + Utils.AddTilde(dvLnk[0]["PageLnkImg"].ToString()) + "\" runat=\"server\" /></asp:HyperLink>" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "PRF")
                        {
                            tm.Append("            <Module:Profile ID=\"ModuleProfile\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "MNT")
                        {
                            tm.Append("            <Module:MenuTop ID=\"ModuleMenuTop\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "MNS")
                        {
                            tm.Append("            <Module:MenuSid ID=\"ModuleMenuSid\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "BRC")
                        {
                            tm.Append("            <asp:Literal ID=\"cBreadCrumb\" EnableViewState=\"false\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "CDD" || drv["LinkTypeCd"].ToString() == "CDT")
                        {
                            tm.Append("            <asp:Label ID=\"cWelcomeTime\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "CUL")
                        {
                            tm.Append("            <rcasp:ComboBox ID=\"cLang\" CssClass=\"inp-ddl\" Mode=\"A\" AutoPostBack=\"true\" OnPostBack=\"cbPostBack\" OnSearch=\"cbCultureId\" DataValueField=\"CultureTypeId\" DataTextField=\"CultureTypeLabel\" runat=\"server\" OnSelectedIndexChanged=\"cLang_SelectedIndexChanged\" />" + Environment.NewLine);
                            tm.Append("            <asp:ImageButton ID=\"lanResetBtn\" CssClass=\"lanResetBtn\" runat=\"server\" ImageUrl=\"~/images/reset.jpg\" OnClick=\"lanResetBtn_Click\" ToolTip=\"Reset Language\" CausesValidation=\"false\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "VER")
                        {
                            tm.Append("            <asp:Label id=\"cVersionTxt\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else if (drv["LinkTypeCd"].ToString() == "LAB")
                        {
                            tm.Append("            <asp:Label CssClass=\"PageLnk" + dvLnk[0]["PageLnkId"].ToString() + "\" Text=\"" + dvLnk[0]["PageLnkTxt"].ToString() + "\" runat=\"server\" />" + Environment.NewLine);
                        }
                        else /* Just in case */
                        {
                            tm.Append("" + Environment.NewLine);
                        }
                        tm.Append("        </div>" + Environment.NewLine);
                    }
                    tm.Append("        </div>" + Environment.NewLine);
                }
            }
            /* Take care of the last */
            if (PreviousCol != string.Empty)
            {
                tm.Append("    </div>" + Environment.NewLine);
            }
            if (PreviousRow != string.Empty)
            {
                tm.Append("</div></div>" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'BKI'").Count() > 0)
            {
                tm.Append("</div>" + Environment.NewLine);
            }

            // Complete the page:
            sb.Append("<script>" + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'HDR'").Count() > 0)
            {
                sb.Append("    function openLinkSec() { var linkContainer = $('#<%=cLinkHolder.ClientID%>'); if (linkContainer.hasClass('hideMoreButtonSec')) { linkContainer.removeClass('hideMoreButtonSec'); } else { linkContainer.addClass('hideMoreButtonSec'); }; }" + Environment.NewLine);
                sb.Append("    $(document).mouseup(function (e) { var linkContainer = $('#<%=cLinkHolder.ClientID%>'); if ($(window).width() <= 1024) { if (!linkContainer.is(e.target) && linkContainer.has(e.target).length === 0 && !linkContainer.hasClass('hideMoreButtonSec')) { openLinkSec(); } } });" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'SSO'").Count() > 0)
            {
                sb.Append("    function openSociSec() { var socialContainer = $('#<%=cSociHolder.ClientID%>'); if (socialContainer.hasClass('hideMoreButtonSec')) { socialContainer.removeClass('hideMoreButtonSec'); } else { socialContainer.addClass('hideMoreButtonSec'); }; }" + Environment.NewLine);
                sb.Append("    $(document).mouseup(function (e) { var socialContainer = $('#<%=cSociHolder.ClientID%>'); if ($(window).width() <= 1024) { if (!socialContainer.is(e.target) && socialContainer.has(e.target).length === 0 && !socialContainer.hasClass('hideMoreButtonSec')) { openSociSec(); } } });" + Environment.NewLine);
            }
            if (dtObj.Select("PageObjSrp is not null AND PageObjSrp <> ''").Count() > 0)
            {
                foreach (DataRowView drv in dtObj.DefaultView)
                {
                    if (!string.IsNullOrEmpty(drv["PageObjSrp"].ToString()) && sb.ToString().IndexOf(drv["PageObjSrp"].ToString()) < 0)
                    {
                        sb.Append(drv["PageObjSrp"].ToString() + Environment.NewLine);
                    }
                }
            }
            sb.Append(rp.ToString());
            sb.Append("</script>" + Environment.NewLine);
            sb.Append(tm.ToString());
            return(sb);
        }
Example #29
0
        public bool CreateProgram(string SectionCd, CurrPrj CPrj, CurrSrc CSrc)
        {
            using (Access3.GenSectionAccess dac = new Access3.GenSectionAccess())
            {
                StreamWriter  sw;
                StringBuilder Ascx;
                StringBuilder AscxCs;
                StringBuilder Css = new StringBuilder();
                DataTable     dtObj;

                /* Take care of Default page */
                if (SectionCd == "D")
                {
                    dtObj = dac.GetPageObj(SectionCd);    // Get Default info.
                    Ascx  = MakeHAscx(dtObj, "Default", CPrj, CSrc);
                    sw    = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\DefaultModule.ascx"); try { sw.Write(Ascx); }
                    finally { sw.Close(); }
                    AscxCs = MakeHAscxCs(dtObj, SectionCd, "Default", CPrj, CSrc);
                    sw     = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\DefaultModule.ascx.cs"); try { sw.Write(AscxCs); }
                    finally { sw.Close(); }
                    Css.Append(MakeCss(dtObj, "Default", CPrj, CSrc));
                    sw = new StreamWriter(CPrj.SrcClientProgramPath + @"css\sectionD.css"); try { sw.Write(Css); } finally { sw.Close(); }
                }

                /* Take care of Header */
                if (SectionCd == "H")
                {
                    dtObj = dac.GetPageObj(SectionCd);    // Get Header info.
                    Ascx  = MakeHAscx(dtObj, "Header", CPrj, CSrc);
                    sw    = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\HeaderModule.ascx"); try { sw.Write(Ascx); }
                    finally { sw.Close(); }
                    AscxCs = MakeHAscxCs(dtObj, SectionCd, "Header", CPrj, CSrc);
                    sw     = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\HeaderModule.ascx.cs"); try { sw.Write(AscxCs); }
                    finally { sw.Close(); }
                    Css.Append(MakeCss(dtObj, "Header", CPrj, CSrc));
                    sw = new StreamWriter(CPrj.SrcClientProgramPath + @"css\sectionH.css"); try { sw.Write(Css); } finally { sw.Close(); }
                }

                /* Take care of Footer */
                if (SectionCd == "F")
                {
                    dtObj = dac.GetPageObj(SectionCd);    // Get Footer info.
                    Ascx  = MakeHAscx(dtObj, "Footer", CPrj, CSrc);
                    sw    = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\FooterModule.ascx"); try { sw.Write(Ascx); }
                    finally { sw.Close(); }
                    AscxCs = MakeHAscxCs(dtObj, SectionCd, "Footer", CPrj, CSrc);
                    sw     = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\FooterModule.ascx.cs"); try { sw.Write(AscxCs); }
                    finally { sw.Close(); }
                    Css.Append(MakeCss(dtObj, "Footer", CPrj, CSrc));
                    sw = new StreamWriter(CPrj.SrcClientProgramPath + @"css\sectionF.css"); try { sw.Write(Css); } finally { sw.Close(); }
                }

                /* Take care of Sidebar */
                if (SectionCd == "S")
                {
                    dtObj = dac.GetPageObj(SectionCd);    // Get Sidebar info.
                    Ascx  = MakeHAscx(dtObj, "Sidebar", CPrj, CSrc);
                    sw    = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\SidebarModule.ascx"); try { sw.Write(Ascx); }
                    finally { sw.Close(); }
                    AscxCs = MakeHAscxCs(dtObj, SectionCd, "Sidebar", CPrj, CSrc);
                    sw     = new StreamWriter(CPrj.SrcClientProgramPath + @"modules\SidebarModule.ascx.cs"); try { sw.Write(AscxCs); }
                    finally { sw.Close(); }
                    Css.Append(MakeCss(dtObj, "Sidebar", CPrj, CSrc));
                    sw = new StreamWriter(CPrj.SrcClientProgramPath + @"css\sectionS.css"); try { sw.Write(Css); } finally { sw.Close(); }
                }
            }
            // Reset regen flag to NO:
            using (Access3.GenSectionAccess dac = new Access3.GenSectionAccess())
            {
                dac.SetSctNeedRegen(SectionCd);
            }
            return(true);
        }
Example #30
0
        private StringBuilder MakeHAscxCs(DataTable dtObj, string SectionCd, string SectionNm, CurrPrj CPrj, CurrSrc CSrc)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("namespace RO.Web" + Environment.NewLine);
            sb.Append("{" + Environment.NewLine);
            sb.Append("    using System;" + Environment.NewLine);
            sb.Append("    using System.Data;" + Environment.NewLine);
            sb.Append("    using System.Drawing;" + Environment.NewLine);
            sb.Append("    using System.Web;" + Environment.NewLine);
            sb.Append("    using System.Web.UI.WebControls;" + Environment.NewLine);
            sb.Append("    using System.Web.UI.HtmlControls;" + Environment.NewLine);
            sb.Append("    using RO.Facade3;" + Environment.NewLine);
            sb.Append("    using RO.Common3;" + Environment.NewLine);
            sb.Append("    using RO.Common3.Data;" + Environment.NewLine + Environment.NewLine);
            sb.Append("    public partial class " + SectionNm + "Module : RO.Web.ModuleBase" + Environment.NewLine);
            sb.Append("    {" + Environment.NewLine);
            sb.Append("        private const string KEY_" + SectionNm + "Generated = \"Cache:" + SectionNm + "Generated\";" + Environment.NewLine + Environment.NewLine);
            sb.Append("        public " + SectionNm + "Module()" + Environment.NewLine);
            sb.Append("        {" + Environment.NewLine);
            sb.Append("            this.Init += new System.EventHandler(Page_Init);" + Environment.NewLine);
            sb.Append("        }" + Environment.NewLine + Environment.NewLine);
            sb.Append("        protected void Page_Load(object sender, System.EventArgs e)" + Environment.NewLine);
            sb.Append("        {" + Environment.NewLine);
            sb.Append("            if (!IsPostBack)" + Environment.NewLine);
            sb.Append("            {" + Environment.NewLine);
            sb.Append("                if (Session[KEY_" + SectionNm + "Generated] == null) try" + Environment.NewLine);
            sb.Append("                {" + Environment.NewLine);
            sb.Append("                    if (base.CPrj != null && base.CSrc != null && Config.DeployType == \"DEV\" && (new AdminSystem()).IsRegenNeeded(\"" + SectionNm + "\", 0, 0, 0, string.Empty, string.Empty))" + Environment.NewLine);
            sb.Append("                    {" + Environment.NewLine);
            sb.Append("                        (new GenSectionSystem()).CreateProgram(\"" + SectionCd + "\", base.CPrj, base.CSrc);" + Environment.NewLine);
            sb.Append("                        Session[KEY_" + SectionNm + "Generated] = true; Response.Redirect(Request.RawUrl);" + Environment.NewLine);
            sb.Append("                    }" + Environment.NewLine);
            sb.Append("                }" + Environment.NewLine);
            sb.Append("                catch (Exception err) { throw new ApplicationException(err.Message); }" + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'PRF'").Count() > 0)
            {
                sb.Append("                if (!Request.IsAuthenticated || LUser == null || LUser.LoginName.ToLower() == \"anonymous\")" + Environment.NewLine);
                sb.Append("                {" + Environment.NewLine);
                sb.Append("                    string loginUrl = System.Web.Security.FormsAuthentication.LoginUrl;" + Environment.NewLine);
                sb.Append("                    if (string.IsNullOrEmpty(loginUrl)) loginUrl = \"MyAccount.aspx\";" + Environment.NewLine);
                sb.Append("                    cSignIn.Visible = true; cSignIn.NavigateUrl = \"~/\" + loginUrl + (loginUrl.Contains(\"?\") ? \"&\" : \"?\") + \"logo=N\"; cProfileButton.Visible = false;" + Environment.NewLine);
                sb.Append("                }" + Environment.NewLine);
                sb.Append("                else" + Environment.NewLine);
                sb.Append("                {" + Environment.NewLine);
                sb.Append("                    cSignIn.Visible = false; cProfileButton.Visible = true;" + Environment.NewLine);
                sb.Append("                }" + Environment.NewLine);
            }
            sb.Append("                if (Request.IsAuthenticated && base.LUser != null)" + Environment.NewLine);
            sb.Append("                {" + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'VER'").Count() > 0)
            {
                sb.Append("                    try {" + Environment.NewLine);
                sb.Append("                        byte sid = byte.Parse(((DropDownList)Page.Master.FindControl(\"ModuleHeader\").FindControl(\"ModuleProfile\").FindControl(\"SystemsList\")).SelectedValue);" + Environment.NewLine);
                sb.Append("                        cVersionTxt.Text = \"&#169;1999-\" + DateTime.Now.Year.ToString() + \" Robocoder Corporation. All rights reserved (V\" + (new LoginSystem()).GetAppVersion(base.SysConnectStr(sid), base.AppPwd(sid)) + \" by R\" + (new LoginSystem()).GetRbtVersion() + \"). Protected by U.S. Patent 6,876,314.\";" + Environment.NewLine);
                sb.Append("                    } catch { cVersionTxt.Text = \"&#169;1999-\" + DateTime.Now.Year.ToString() + \" Robocoder Corporation. All rights reserved.\"; }" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'CUL'").Count() > 0)
            {
                sb.Append("                    SetCultureId(cLang, LUser.CultureId.ToString());" + Environment.NewLine);
            }
            if (dtObj.Select("LinkTypeCd = 'CDD'").Count() > 0)
            {
                sb.Append("                    cWelcomeTime.Text = Utils.fmLongDate(DateTime.Now.ToString(), LUser.Culture);" + Environment.NewLine);
            }
            else if (dtObj.Select("LinkTypeCd = 'CDT'").Count() > 0)
            {
                sb.Append("                    cWelcomeTime.Text = Utils.fmLongDateTime(DateTime.Now.ToString(), LUser.Culture);" + Environment.NewLine);
            }
            sb.Append("                }" + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'LGO'").Count() > 0 || dtObj.Select("LinkTypeCd = 'HDR'").Count() > 0 || dtObj.Select("LinkTypeCd = 'SSO'").Count() > 0)
            {
                sb.Append("                if (base.LUser != null && base.LPref != null && Request.QueryString[\"typ\"] != null && Request.QueryString[\"typ\"].ToString() == \"N\")" + Environment.NewLine);
                sb.Append("                {" + Environment.NewLine);
                if (dtObj.Select("LinkTypeCd = 'LGO'").Count() > 0)
                {
                    sb.Append("                    cLogoHolder.Visible = false;" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'HDR'").Count() > 0)
                {
                    sb.Append("                    cLinkHolder.Visible = false;" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'SSO'").Count() > 0)
                {
                    sb.Append("                    cSociHolder.Visible = false;" + Environment.NewLine);
                }
                sb.Append("                }" + Environment.NewLine);
            }
            if (SectionNm == "Header")
            {
                if (dtObj.Select("LinkTypeCd = 'HDR'").Count() > 0)
                {
                    sb.Append("                if (cLinkHolder.Controls.Count <= 0) { cLinkButton.Visible = false; }" + Environment.NewLine);
                }
                if (dtObj.Select("LinkTypeCd = 'SSO'").Count() > 0)
                {
                    sb.Append("                if (cSociHolder.Controls.Count <= 0) { cSociButton.Visible = false; }" + Environment.NewLine);
                }
            }
            sb.Append("            }" + Environment.NewLine);
            sb.Append("        }" + Environment.NewLine + Environment.NewLine);
            sb.Append("        protected void Page_PreRender(object sender, System.EventArgs e)" + Environment.NewLine);
            sb.Append("        {" + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'MNT'").Count() > 0)
            {
                sb.Append("            if (this.Visible && Request.IsAuthenticated && base.LUser != null && base.VMenu != null)" + Environment.NewLine);
                sb.Append("            {" + Environment.NewLine);
                sb.Append("                base.VMenu.RowFilter = \"QId='\" + PageBase.ExpandNode + \"'\";" + Environment.NewLine);
                sb.Append("            }" + Environment.NewLine);
                if (dtObj.Select("LinkTypeCd = 'BRC'").Count() > 0)
                {
                    sb.Append("            if (base.VMenu != null && base.VMenu.Count > 0)" + Environment.NewLine);
                    sb.Append("            {" + Environment.NewLine);
                    sb.Append("                string ftr = base.VMenu.RowFilter;" + Environment.NewLine);
                    sb.Append("                cBreadCrumb.Text = \"<strong>\" + base.VMenu[0][\"MenuText\"].ToString() + \"</strong>\";" + Environment.NewLine);
                    sb.Append("                while (base.VMenu[0][\"ParentQId\"].ToString() != string.Empty)" + Environment.NewLine);
                    sb.Append("                {" + Environment.NewLine);
                    sb.Append("                    base.VMenu.RowFilter = \"QId='\" + base.VMenu[0][\"ParentQId\"].ToString() + \"'\";" + Environment.NewLine);
                    sb.Append("                    cBreadCrumb.Text = base.VMenu[0][\"MenuText\"].ToString() + \"&gt; \" + cBreadCrumb.Text;" + Environment.NewLine);
                    sb.Append("                }" + Environment.NewLine);
                    sb.Append("                base.VMenu.RowFilter = ftr;" + Environment.NewLine);
                    sb.Append("                if (HttpContext.Current.Request.Url.AbsolutePath.Contains(Config.SslUrl)) { cMobileCrumb.Text = Config.WebTitle; } else { cMobileCrumb.Text = base.VMenu[0][\"MenuText\"].ToString(); }" + Environment.NewLine);
                    sb.Append("            }" + Environment.NewLine);
                }
            }
            sb.Append("        }" + Environment.NewLine + Environment.NewLine);
            sb.Append("        protected void Page_Init(object sender, EventArgs e)" + Environment.NewLine);
            sb.Append("        {" + Environment.NewLine);
            sb.Append("            InitializeComponent();" + Environment.NewLine);
            sb.Append("        }" + Environment.NewLine + Environment.NewLine);
            sb.Append("        #region Web Form Designer generated code" + Environment.NewLine);
            sb.Append("        ///		Required method for Designer support - do not modify"+ Environment.NewLine);
            sb.Append("        ///		the contents of this method with the code editor."+ Environment.NewLine);
            sb.Append("        /// </summary>" + Environment.NewLine);
            sb.Append("        private void InitializeComponent()" + Environment.NewLine);
            sb.Append("        {" + Environment.NewLine);
            if (SectionNm.ToLower() == "default")
            {
                sb.Append("            base.CheckAuthentication(true, true);  // Authorized users only;" + Environment.NewLine);
            }
            else
            {
                sb.Append("" + Environment.NewLine);
            }
            sb.Append("        }" + Environment.NewLine);
            sb.Append("        #endregion" + Environment.NewLine + Environment.NewLine);
            if (dtObj.Select("LinkTypeCd = 'CUL'").Count() > 0)
            {
                sb.Append("        protected void cbPostBack(object sender, System.EventArgs e)" + Environment.NewLine);
                sb.Append("        {" + Environment.NewLine);
                sb.Append("        }" + Environment.NewLine + Environment.NewLine);
                sb.Append("        protected void cbCultureId(object sender, System.EventArgs e)" + Environment.NewLine);
                sb.Append("        {" + Environment.NewLine);
                sb.Append("            SetCultureId((RoboCoder.WebControls.ComboBox)sender, string.Empty);" + Environment.NewLine);
                sb.Append("        }" + Environment.NewLine + Environment.NewLine);
                sb.Append("        private void SetCultureId(RoboCoder.WebControls.ComboBox ddl, string keyId)" + Environment.NewLine);
                sb.Append("        {" + Environment.NewLine);
                sb.Append("            System.Collections.Generic.Dictionary<string, string> context = new System.Collections.Generic.Dictionary<string, string>();" + Environment.NewLine);
                sb.Append("            context[\"method\"] = \"GetDdlCultureId\";" + Environment.NewLine);
                sb.Append("            context[\"addnew\"] = \"Y\";" + Environment.NewLine);
                sb.Append("            context[\"mKey\"] = \"CultureTypeId\";" + Environment.NewLine);
                sb.Append("            context[\"mVal\"] = \"CultureTypeLabel\";" + Environment.NewLine);
                sb.Append("            context[\"mTip\"] = \"CultureTypeLabel\";" + Environment.NewLine);
                sb.Append("            context[\"mImg\"] = \"CultureTypeLabel\";" + Environment.NewLine);
                sb.Append("            context[\"ssd\"] = Request.QueryString[\"ssd\"];" + Environment.NewLine);
                sb.Append("            context[\"scr\"] = \"1\";" + Environment.NewLine);
                sb.Append("            context[\"csy\"] = \"3\";" + Environment.NewLine);
                sb.Append("            context[\"filter\"] = \"0\";" + Environment.NewLine);
                sb.Append("            context[\"isSys\"] = \"N\";" + Environment.NewLine);
                sb.Append("            context[\"conn\"] = string.Empty;" + Environment.NewLine);
                sb.Append("            ddl.AutoCompleteUrl = \"AutoComplete.aspx/DdlSuggests\";" + Environment.NewLine);
                sb.Append("            ddl.DataContext = context;" + Environment.NewLine);
                sb.Append("            if (ddl != null)" + Environment.NewLine);
                sb.Append("            {" + Environment.NewLine);
                sb.Append("                DataView dv = null;" + Environment.NewLine);
                sb.Append("                if (keyId == string.Empty && ddl.SearchText.StartsWith(\"**\")) { keyId = ddl.SearchText.Substring(2); }" + Environment.NewLine);
                sb.Append("                try { dv = new DataView((new AdminSystem()).GetDdl(1, \"GetDdlCultureId\", true, false, 0, keyId, null, null, string.Empty, base.LImpr, base.LCurr)); } catch { return; }" + Environment.NewLine);
                sb.Append("                ddl.DataSource = dv;" + Environment.NewLine);
                sb.Append("                try { ddl.SelectByValue(keyId, string.Empty, false); } catch { try { ddl.SelectedIndex = 0; } catch { } }" + Environment.NewLine);
                sb.Append("            }" + Environment.NewLine);
                sb.Append("        }" + Environment.NewLine + Environment.NewLine);
                sb.Append("        protected void cLang_SelectedIndexChanged(object sender, EventArgs e)" + Environment.NewLine);
                sb.Append("        {" + Environment.NewLine);
                sb.Append("            if (!string.IsNullOrEmpty(cLang.SelectedValue))" + Environment.NewLine);
                sb.Append("            {" + Environment.NewLine);
                sb.Append("                base.LUser.CultureId = short.Parse(cLang.SelectedValue);" + Environment.NewLine);
                sb.Append("                base.LUser.Culture = (new AdminSystem()).SetCult(base.LUser.UsrId, base.LUser.CultureId);" + Environment.NewLine);
                sb.Append("                base.LImpr = null; SetImpersonation(LUser.UsrId);" + Environment.NewLine);
                sb.Append("                base.VMenu = new DataView((new MenuSystem()).GetMenu(base.LUser.CultureId, base.LCurr.SystemId, base.LImpr, base.SysConnectStr(base.LCurr.SystemId), base.AppPwd(base.LCurr.SystemId), null, null, null));" + Environment.NewLine);
                sb.Append("                Response.Redirect(Request.Url.PathAndQuery);    // No need to SetCultureId(cLang, LUser.CultureId.ToString());" + Environment.NewLine);
                sb.Append("            }" + Environment.NewLine);
                sb.Append("        }" + Environment.NewLine + Environment.NewLine);
                sb.Append("        protected void lanResetBtn_Click(object sender, System.Web.UI.ImageClickEventArgs e)" + Environment.NewLine);
                sb.Append("        {" + Environment.NewLine);
                sb.Append("            base.LUser.CultureId = 1;" + Environment.NewLine);
                sb.Append("            base.LUser.Culture = (new AdminSystem()).SetCult(base.LUser.UsrId, base.LUser.CultureId);" + Environment.NewLine);
                sb.Append("            if ((LUser.LoginName ?? string.Empty).ToLower() != \"anonymous\") { base.LImpr = null; SetImpersonation(LUser.UsrId); } else { base.LImpr.Cultures = base.LUser.CultureId.ToString(); }" + Environment.NewLine);
                sb.Append("            base.VMenu = new DataView((new MenuSystem()).GetMenu(base.LUser.CultureId, base.LCurr.SystemId, base.LImpr, base.SysConnectStr(base.LCurr.SystemId), base.AppPwd(base.LCurr.SystemId), null, null, null));" + Environment.NewLine);
                sb.Append("            Response.Redirect(Request.Url.PathAndQuery);" + Environment.NewLine);
                sb.Append("        }" + Environment.NewLine);
            }
            sb.Append("    }" + Environment.NewLine);
            sb.Append("}" + Environment.NewLine);
            return(sb);
        }