Example #1
0
        private string CreateLoadData()
        {
            StringBuilder loadDataStart  = new StringBuilder();
            StringBuilder loadDataChecks = new StringBuilder();
            StringBuilder loadDataBody   = new StringBuilder();
            StringBuilder loadDataEnd    = new StringBuilder();
            string        id             = Globals.GetProgramatlyName(ID.Name);

            id = Globals.ConvetStringToCamelCase(id);
            loadDataStart.Append("\n\t#region ---------------LoadData---------------");
            loadDataStart.Append("\n\t//-----------------------------------------------");
            loadDataStart.Append("\n\t//LoadData");
            loadDataStart.Append("\n\t//-----------------------------------------------");
            loadDataStart.Append("\n\tprotected void LoadData()");
            loadDataStart.Append("\n\t{");
            //Add Urls Property
            SiteUrlsBuilder.AddParameter(Globals.GetProgramatlyName(ID.Name));
            loadDataStart.Append("\n\t\tif(MoversFW.Components.UrlManager.ChechIsValidIntegerParameter(" + SiteUrlsBuilder.GetIdentifire() + Globals.GetProgramatlyName(ID.Name) + "))");
            loadDataStart.Append("\n\t\t{");
            loadDataStart.Append("\n\t\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(Request.QueryString[" + SiteUrlsBuilder.GetIdentifire() + Globals.GetProgramatlyName(ID.Name) + "]);");

            loadDataStart.Append("\n\t\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " =" + global.TableFactoryClass + ".Get" + global.TableProgramatlyName + "Object(" + id + ");");
            loadDataChecks.Append("\n\t\t\tif (" + global.EntityClassObject + " != null)");
            loadDataChecks.Append("\n\t\t\t{");
            if (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName))
            {
                loadDataChecks.Append("\n\t\t\t\t//");
                loadDataChecks.Append("\n\t\t\t\t//Check Valid Language to avoid changing query string manualy");
                loadDataChecks.Append("\n\t\t\t\tLanguages langid = (Languages)ResourceManager.GetCurrentLanguage();");
                loadDataChecks.Append("\n\t\t\t\tif (langid != " + global.EntityClassObject + ".LangID)");
                loadDataChecks.Append("\n\t\t\t\t{");
                loadDataChecks.Append("\n\t\t\t\t\tResponse.Redirect(\"default.aspx\");");
                loadDataChecks.Append("\n\t\t\t\t}");
            }
            //----------------------------------------------------------*/
            string datatype;
            string propertyName;
            string trPropertyName;
            string lblPropertyName;
            string optionalPropertyName;

            foreach (SQLDMO.Column column in Fields)
            {
                propertyName         = Globals.GetProgramatlyName(column.Name);
                trPropertyName       = "tr" + propertyName;
                lblPropertyName      = "lbl" + propertyName;
                optionalPropertyName = SiteOptionsBuilder.GetHasPropertyString(propertyName);
                //if ((ID == null || column.Name != ID.Name) && (column.Default == null || column.Default.Length != 0) && column.Name.ToLower() != ProjectBuilder.LangID)
                if ((ID == null || column.Name != ID.Name) && (column.Name.IndexOf("_") < 0) &&
                    column.Name.ToLower().IndexOf("password") < 0 &&
                    column.Name.ToLower().IndexOf("shortdescription") < 0 &&
                    column.Name.ToLower().IndexOf(ProjectBuilder.PriorityColumnName.ToLower()) < 0 &&
                    column.Name.ToLower().IndexOf(ProjectBuilder.IsAvailable.ToLower()) < 0 &&
                    column.Name.ToLower() != ProjectBuilder.LangID)
                {
                    TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name);
                    datatype = Globals.GetAliasDataType(column.Datatype);
                    if (datatype == "string")
                    {
                        if (cnstr == null)
                        {
                            if (column.Name == ProjectBuilder.PhotoExtensionColumnName)
                            {
                                //	hasPhoto = true;
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + ".HasPhotoExtension)");
                                loadDataBody.Append("\n\t\t\t\t{");
                                //Add Urls Property

                                SiteUrlsBuilder.AddDirectoryUrl("PhotoNormalThumbs", SiteUrlsBuilder.photoNormalUrl, Globals.GetProgramatlyName(Table), "");

                                loadDataBody.Append("\n\t\t\t\t\t" + imageName + ".Text = \" <a href='\" + " + SiteUrlsBuilder.GetIdentifire() + "BigPhotoThumbs + " + global.EntityClassObject + ".BigPhotoThumbs+\"' rel='lightbox'>\";");
                                loadDataBody.Append("\n\t\t\t\t\t" + imageName + ".Text += \"<img border='0' src='\" +" + SiteUrlsBuilder.GetIdentifire() + "PhotoNormalThumbs + " + global.EntityClassObject + ".NormalPhotoThumbs+\"'   class='Image' alt='\" + " + global.EntityClassObject + ".Title+\"' /></a>\";");

                                loadDataBody.Append("\n\t\t\t\t}");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t{");
                                loadDataBody.Append("\n\t\t\t\t\t" + PhotoContainerTr + ".Visible = false;");
                                loadDataBody.Append("\n\t\t\t\t}");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                                //loadDataBody.Append("\n\t\t\t\tViewState[\"" + ProjectBuilder.PhotoExtensionColumnName + "\"] = " + global.EntityClassObject + "." + ProjectBuilder.PhotoExtensionColumnName + ";");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                            }
                            else if (column.Name == "LogoExtension")
                            {
                                //hasPhoto = true;
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + ".HasLogoExtension)");
                                loadDataBody.Append("\n\t\t\t\t{");
                                //Add Urls Property
                                SiteUrlsBuilder.AddDirectoryUrl("LogoNormalThumbs", SiteUrlsBuilder.logoNormalUrl, Globals.GetProgramatlyName(Table), "");


                                loadDataBody.Append("\n\t\t\t\t\t" + logoName + ".Text = \" <a href='\" + " + SiteUrlsBuilder.GetIdentifire() + "BigLogoThumbs + " + global.EntityClassObject + ".BigLogoThumbs+\"' rel='lightbox'>\";");
                                loadDataBody.Append("\n\t\t\t\t\t" + logoName + ".Text += \"<img border='0' src='\" +" + SiteUrlsBuilder.GetIdentifire() + "LogoNormalThumbs + " + global.EntityClassObject + ".NormalLogoThumbs+\"'   class='Image' alt='\" + " + global.EntityClassObject + ".Title+\"' /></a>\";");


                                loadDataBody.Append("\n\t\t\t\t}");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t{");
                                loadDataBody.Append("\n\t\t\t\t\t" + LogoContainerTr + ".Visible = false;");
                                loadDataBody.Append("\n\t\t\t\t}");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                                //loadDataBody.Append("\n\t\t\t\tViewState[\"" + ProjectBuilder.LogoExtensionColumnName + "\"] = " + global.EntityClassObject + "." + ProjectBuilder.LogoExtensionColumnName + ";");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                            }
                            else if (column.Name == "FileExtension")
                            {
                                //hasFile = true;
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + ".HasFileExtension)");
                                loadDataBody.Append("\n\t\t\t\t{");
                                //Add Urls Property
                                SiteUrlsBuilder.AddDirectoryUrl("Files", SiteUrlsBuilder.filesUrl, Globals.GetProgramatlyName(Table), "");
                                loadDataBody.Append("\n\t\t\t\t\t" + fileName + ".NavigateUrl = " + SiteUrlsBuilder.GetIdentifire() + "Files + " + global.EntityClassObject + ".File;");
                                loadDataBody.Append("\n\t\t\t\t\t" + fileName + ".Text = " + ResourcesTesxtsBuilder.AddAdminGlobalText("DownLoadExistFile", TextType.Text) + ";");
                                loadDataBody.Append("\n\t\t\t\t}");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t{");
                                loadDataBody.Append("\n\t\t\t\t\t" + trPropertyName + ".Visible=false ;");
                                loadDataBody.Append("\n\t\t\t\t}");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                                //loadDataBody.Append("\n\t\t\t\tViewState[\"" + ProjectBuilder.FileExtensionColumnName + "\"] = " + global.EntityClassObject + "." + ProjectBuilder.FileExtensionColumnName + ";");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                            }
                            else if (column.Name.IndexOf("Extension") > -1)
                            {
                                string[] stringSeparators = new string[] { "Extension" };
                                string[] separatingResult = column.Name.Split(stringSeparators, StringSplitOptions.None);
                                propertyName = separatingResult[0];
                                string uploaderID     = "fu" + propertyName;
                                string downloadLinkID = "hl" + propertyName;

                                //hasFile = true;
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + ".Has" + propertyName + "Extension)");
                                loadDataBody.Append("\n\t\t\t\t{");
                                //Add Urls Property
                                SiteUrlsBuilder.AddDirectoryUrl(propertyName + "s", SiteUrlsBuilder.otherFilesUrl, Globals.GetProgramatlyName(Table), propertyName + "s");
                                loadDataBody.Append("\n\t\t\t\t\t" + downloadLinkID + ".NavigateUrl = " + SiteUrlsBuilder.GetIdentifire() + propertyName + "s + " + global.EntityClassObject + "." + propertyName + ";");
                                loadDataBody.Append("\n\t\t\t\t\t" + downloadLinkID + ".Text =" + ResourcesTesxtsBuilder.AddAdminGlobalText("DownLoadExistFile", TextType.Text) + ";");
                                loadDataBody.Append("\n\t\t\t\t}");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t{");
                                loadDataBody.Append("\n\t\t\t\t\t" + trPropertyName + ".Visible=false ;");
                                loadDataBody.Append("\n\t\t\t\t}");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                                //loadDataBody.Append("\n\t\t\t\tViewState[\"" + Globals.GetProgramatlyName(column.Name) + "\"] = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ";");
                                //loadDataBody.Append("\n\t\t\t\t//------------------------------------------");
                            }
                            else if (column.Name.IndexOf("Date") > -1)
                            {
                                loadDataBody.Append("\n\t\t\t\t//-------------------------------");
                                loadDataBody.Append("\n\t\t\t\t//" + Globals.GetProgramatlyName(column.Name));
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + "." + optionalPropertyName + ")");
                                loadDataBody.Append("\n\t\t\t\t\tlbl" + Globals.GetProgramatlyName(column.Name) + ".Text = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ".ToString();");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t\t" + trPropertyName + ".Visible=false ;");
                                loadDataBody.Append("\n\t\t\t\t//-------------------------------");
                            }
                            else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
                            {
                                loadDataBody.Append("\n\t\t\t\t//-------------------------------");
                                loadDataBody.Append("\n\t\t\t\t//" + Globals.GetProgramatlyName(column.Name));
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + "." + optionalPropertyName + ")");
                                loadDataBody.Append("\n\t\t\t\t\tlbl" + Globals.GetProgramatlyName(column.Name) + ".Text = Globals.SetLines(" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ");");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t\t" + lblPropertyName + ".Visible=false ;");

                                loadDataBody.Append("\n\t\t\t\t//-------------------------------");
                            }
                            else
                            {
                                loadDataBody.Append("\n\t\t\t\t//-------------------------------");
                                loadDataBody.Append("\n\t\t\t\t//" + Globals.GetProgramatlyName(column.Name));
                                loadDataBody.Append("\n\t\t\t\tif (" + global.EntityClassObject + "." + optionalPropertyName + ")");
                                loadDataBody.Append("\n\t\t\t\t\tlbl" + Globals.GetProgramatlyName(column.Name) + ".Text = Globals.SetLines(" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ");");
                                loadDataBody.Append("\n\t\t\t\telse");
                                loadDataBody.Append("\n\t\t\t\t\t" + trPropertyName + ".Visible=false ;");
                                loadDataBody.Append("\n\t\t\t\t//-------------------------------");
                            }
                        }
                        else
                        {
                        }
                    }
                    else if (datatype == "bool")
                    {
                        //loadDataBody.Append("\n\t\t\t\tcb" + Globals.GetProgramatlyName(column.Name) + ".Checked = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ";");
                        loadDataBody.Append("\n\t\t\t\tlbl" + Globals.GetProgramatlyName(column.Name) + ".Text = " + ResourcesTesxtsBuilder.AddUserText("True", TextType.Text) + ";");
                    }
                    else if (datatype != "byte[]" && datatype != "Object" && datatype != "Guid")
                    {
                        if (cnstr == null)
                        {
                            loadDataBody.Append("\n\t\t\t\tlbl" + Globals.GetProgramatlyName(column.Name) + ".Text = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ".ToString();");
                        }
                        else
                        {
                            //string text = SqlProvider.obj.GetExpectedNameForParent(cnstr.ParentTable);
                            //string _value = Globals.GetProgramatlyName(cnstr.ParentColID);
                            //string ddl;
                            //string methodName;
                            //BuildDropDownListsLoaderMethod(cnstr.ParentTable, text, _value, out ddl, out methodName);
                            //loadDataBody.Append("\n\t\t\t\t" + methodName + ";");
                            //loadDataBody.Append("\n\t\t\t\t" + ddl + ".SelectedValue = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ".ToString();");
                        }
                    }
                }
            }
            //End of object null value check
            loadDataEnd.Append("\n\t\t\t}");
            loadDataEnd.Append("\n\t\t\telse");
            loadDataEnd.Append("\n\t\t\t{");
            loadDataEnd.Append("\n\t\t\t\tResponse.Redirect(\"default.aspx\");");
            loadDataEnd.Append("\n\t\t\t}");
            //-------------------------------------
            //End of envalid parammeter check
            loadDataEnd.Append("\n\t\t}");
            loadDataEnd.Append("\n\t\telse");
            loadDataEnd.Append("\n\t\t{");
            loadDataEnd.Append("\n\t\t\tResponse.Redirect(\"default.aspx\");");
            loadDataEnd.Append("\n\t\t}");
            loadDataEnd.Append("\n\t}");
            loadDataEnd.Append("\n\t//-----------------------------------------------");
            loadDataEnd.Append("\n\t#endregion");

            return(loadDataStart.ToString() + loadDataChecks.ToString() + loadDataBody.ToString() + loadDataEnd.ToString());
        }
Example #2
0
        //
        private string GeneratePageLoad()
        {
            string pageLoadBody = "\n\t\tlblResult.Text=\"\";";

            pageLoadBody += "\n\t\tif(!IsPostBack)";
            pageLoadBody += "\n\t\t{";
            if (ProjectBuilder.HasConfiguration)
            {
                pageLoadBody += "\n\t\t\tSiteOptions.CheckModuleWithHandling(Resources.SiteOptions." + SiteOptionsBuilder.GetHasPropertyString(Table) + ", ViewerType.Admin);";
            }
            pageLoadBody += "\n\t\t\tPagerManager.PrepareAdminPager(pager);";
            pageLoadBody += "\n\t\t\tpager.Visible = false;";
            string gridID = "dg" + global.TableProgramatlyName;

            //pageLoadBody += "\n\t\t\t" + gridID + ".Columns[" + gridID + ".Columns.Count - 2].HeaderText = " + ResourcesTesxtsBuilder.AddAdminGlobalText("Update", TextType.Text) + ";";
            //pageLoadBody += "\n\t\t\t" + gridID + ".Columns[" + gridID + ".Columns.Count - 1].HeaderText = " + ResourcesTesxtsBuilder.AddAdminGlobalText("Delete", TextType.Text) + ";";
            pageLoadBody += "\n\t\t\tLoadData();";
            pageLoadBody += "\n\t\t}";
            return(GeneratePageLoadHandler(pageLoadBody));
        }
Example #3
0
        //--------------------------------------
        //
        protected string GenerateClass()
        {
            StringBuilder pageCode = new StringBuilder();

            pageCode.Append("using System;\n");
            pageCode.Append("using System.Data;\n");
            pageCode.Append("using System.Configuration;\n");
            pageCode.Append("using System.Collections;\n");
            pageCode.Append("using System.Web;\n");
            pageCode.Append("using System.Web.Security;\n");
            pageCode.Append("using System.Web.UI;\n");
            pageCode.Append("using System.Web.UI.WebControls;\n");
            pageCode.Append("using System.Web.UI.WebControls.WebParts;\n");
            pageCode.Append("using System.Web.UI.HtmlControls;\n");
            pageCode.Append("using System.Drawing;\n");
            pageCode.Append("\npublic partial class Default : System.Web.UI.Page");
            pageCode.Append("\n{");
            pageCode.Append("\n\t#region --------------LoadData--------------");
            pageCode.Append("\n\t//---------------------------------------------------------");
            pageCode.Append("\n\t//Page_Load");
            pageCode.Append("\n\t//---------------------------------------------------------");
            pageCode.Append("\n\tprotected void Page_Load(object sender, EventArgs e)");
            pageCode.Append("\n\t{");
            pageCode.Append("\n\t\tif (!IsPostBack)");
            pageCode.Append("\n\t\t{");
            if (ProjectBuilder.HasConfiguration)
            {
                pageCode.Append("\n\t\t\tSiteOptions.CheckModuleWithHandling(Resources.SiteOptions." + SiteOptionsBuilder.GetHasPropertyString(global.TableProgramatlyName) + ", ViewerType.User);");
            }
            pageCode.Append("\n\t\t}");
            pageCode.Append("\n\t}");
            pageCode.Append("\n\t//--------------------------------------------------------");
            pageCode.Append("\n\t#endregion");
            pageCode.Append("\n\t");
            pageCode.Append("\n}");
            return(pageCode.ToString());
        }
        //
        public static void AddItems()
        {
            Globals global = new Globals();

            //depend on the current table
            _NavigationItems.Append("\n\t\t\t#region --------------" + global.TableProgramatlyName + "--------------");
            string tabforIf = "";

            if (ProjectBuilder.HasConfiguration)
            {
                _NavigationItems.Append("\n\t\t\tif (SiteOptions.CheckModule(Resources.SiteOptions." + SiteOptionsBuilder.GetHasPropertyString(global.TableProgramatlyName) + ", ViewerType.Admin))");
                _NavigationItems.Append("\n\t\t\t{");
                tabforIf = "\t";
            }
            _NavigationItems.Append("\n\t\t\t" + tabforIf + "//---------------------------------------");
            _NavigationItems.Append("\n\t\t\t" + tabforIf + "//" + global.TableProgramatlyName);
            _NavigationItems.Append("\n\t\t\t" + tabforIf + "NavItem nav" + global.TableProgramatlyName + " = new NavItem(\"" + global.TableProgramatlyName + "\", " + ResourcesTesxtsBuilder.AddUserText(global.TableProgramatlyName + "ModuleTitle", TextType.Text) + ");");
            //_NavigationItems.Append("\n\t\t\t" + tabforIf + "nav" + global.TableProgramatlyName + ".AddLink(" + ResourcesTesxtsBuilder.AddUserText("AddNew" + global.TableProgramatlyName, TextType.Text) + ", \"/Admin/" + global.TableProgramatlyName + "/add.aspx\");");
            //_NavigationItems.Append("\n\t\t\t" + tabforIf + "nav" + global.TableProgramatlyName + ".AddLink(" + ResourcesTesxtsBuilder.AddUserText("ShowAll" + global.TableProgramatlyName, TextType.Text) + ", \"/Admin/" + global.TableProgramatlyName + "/default.aspx\");");
            _NavigationItems.Append("\n\t\t\t" + tabforIf + "nav" + global.TableProgramatlyName + ".AddLink(Resources.Admin.Add ,  \"/Admin/" + global.TableProgramatlyName + "/add.aspx\");");
            _NavigationItems.Append("\n\t\t\t" + tabforIf + "nav" + global.TableProgramatlyName + ".AddLink(Resources.Admin.ViewAll , \"/Admin/" + global.TableProgramatlyName + "/default.aspx\");");

            _NavigationItems.Append("\n\t\t\t" + tabforIf + "menu.Controls.Add(nav" + global.TableProgramatlyName + ");");
            _NavigationItems.Append("\n\t\t\t" + tabforIf + "//--------------------------------------");
            if (ProjectBuilder.HasConfiguration)
            {
                _NavigationItems.Append("\n\t\t\t}");
            }
            _NavigationItems.Append("\n\t\t\t#endregion");
        }
        //--------------------------------------
        //
        protected string GenerateClass()
        {
            string id = Globals.GetProgramatlyName(ID.Name);

            id = Globals.ConvetStringToCamelCase(id);
            string headerProperity = "";
            string boxHeader       = "";

            if (Fields.Count >= 2)
            {
                SQLDMO.Column headerColumn = (SQLDMO.Column)Fields.Item(1);

                headerProperity = Globals.GetProgramatlyName(headerColumn.Name);
                boxHeader       = global.EntityClassObject + "." + headerProperity;
            }
            else
            {
                boxHeader = "\"\"";
            }
            StringBuilder pageCode = new StringBuilder();

            pageCode.Append("using System;\n");
            pageCode.Append("using System.Data;\n");
            pageCode.Append("using System.Configuration;\n");
            pageCode.Append("using System.Collections;\n");
            pageCode.Append("using System.Web;\n");
            pageCode.Append("using System.Web.Security;\n");
            pageCode.Append("using System.Web.UI;\n");
            pageCode.Append("using System.Web.UI.WebControls;\n");
            pageCode.Append("using System.Web.UI.WebControls.WebParts;\n");
            pageCode.Append("using System.Web.UI.HtmlControls;\n");
            pageCode.Append("using System.Drawing;\n");
            pageCode.Append("\npublic partial class Details : System.Web.UI.Page");
            pageCode.Append("\n{");
            pageCode.Append("\n\t#region --------------LoadData--------------");
            pageCode.Append("\n\t//---------------------------------------------------------");
            pageCode.Append("\n\t//Page_Load");
            pageCode.Append("\n\t//---------------------------------------------------------");
            pageCode.Append("\n\tprotected void Page_Load(object sender, EventArgs e)");
            pageCode.Append("\n\t{");
            pageCode.Append("\n\t\tif (!IsPostBack)");
            pageCode.Append("\n\t\t{");
            if (ProjectBuilder.HasConfiguration)
            {
                pageCode.Append("\n\t\t\tSiteOptions.CheckModuleWithHandling(Resources.SiteOptions." + SiteOptionsBuilder.GetHasPropertyString(Table) + ", ViewerType.User);");
            }
            pageCode.Append("\n\t\t\t//Set Boxes Headers");
            pageCode.Append("\n\t\t\tSetBoxesHeaders();");
            pageCode.Append("\n\t\t}");
            pageCode.Append("\n\t}");
            pageCode.Append("\n\t//--------------------------------------------------------");
            pageCode.Append("\n\t#endregion");
            pageCode.Append("\n\t");
            pageCode.Append("\n\t#region Set Boxes Headers");
            pageCode.Append("\n\t//--------------------------------------------------------");
            pageCode.Append("\n\t//Set Boxes Headers");
            pageCode.Append("\n\t//--------------------------------------------------------");
            pageCode.Append("\n\tprotected void SetBoxesHeaders()");
            pageCode.Append("\n\t{");
            SiteUrlsBuilder.AddParameter(Globals.GetProgramatlyName(ID.Name));
            pageCode.Append("\n\t\tif(MoversFW.Components.UrlManager.ChechIsValidIntegerParameter(" + SiteUrlsBuilder.GetIdentifire() + Globals.GetProgramatlyName(ID.Name) + "))");
            pageCode.Append("\n\t\t{");
            pageCode.Append("\n\t\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(Request.QueryString[" + SiteUrlsBuilder.GetIdentifire() + Globals.GetProgramatlyName(ID.Name) + "]);");

            pageCode.Append("\n\t\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " =" + global.TableFactoryClass + ".Get" + global.TableProgramatlyName + "Object(" + id + ");");
            pageCode.Append("\n\t\t\tif (" + global.EntityClassObject + " != null)");
            pageCode.Append("\n\t\t\t{");
            pageCode.Append("\n\t\t\t\t" + masterBoxID + ".Header = " + boxHeader + ";");
            pageCode.Append("\n\t\t\t}");

            pageCode.Append("\n\t\t\telse");
            pageCode.Append("\n\t\t\t{");
            pageCode.Append("\n\t\t\t\tResponse.Redirect(\"/default.aspx\");");
            pageCode.Append("\n\t\t\t}");
            pageCode.Append("\n\t\t}");
            pageCode.Append("\n\t\telse");
            pageCode.Append("\n\t\t{");
            pageCode.Append("\n\t\t\tResponse.Redirect(\"/default.aspx\");");
            pageCode.Append("\n\t\t}");

            pageCode.Append("\n\t}");
            pageCode.Append("\n\t//--------------------------------------------------------");
            pageCode.Append("\n\t#endregion");
            pageCode.Append("\n}");
            return(pageCode.ToString());
        }
        //
        #region ClassMember
        public string CreateInfoPropreties()
        {
            try
            {
                //Add Optional
                if (ProjectBuilder.HasConfiguration)
                {
                    string tableOptional = SiteOptionsBuilder.GetHasPropertyString(global.TableProgramatlyName);
                    SiteOptionsBuilder.AddSiteOption(tableOptional);
                }
                //
                string xmlDocumentation = "";
                //
                StringBuilder EntityPropreties = new StringBuilder();
                //
                string dataType;
                string dataTypeAlias;
                string propertyName;
                string memberName;
                foreach (SQLDMO.Column colCurrent in Fields)
                {
                    //Note dataType for checks & dataTypeAlias for writing
                    dataType      = Globals.GetAliasDataType(colCurrent.Datatype);
                    dataTypeAlias = dataType;
                    propertyName  = Globals.GetProgramatlyName(colCurrent.Name);
                    memberName    = " _" + Globals.GetProgramatlyName(colCurrent.Name);
                    #region Base Property
                    EntityPropreties.Append("\n\t#region --------------" + propertyName + "--------------");
                    if (colCurrent.Name.ToLower() == "langid")
                    {
                        dataTypeAlias = "Languages";
                    }
                    if (dataType == "string")
                    {
                        EntityPropreties.Append("\n\tprivate " + dataTypeAlias + memberName + "= \"\";");
                    }
                    else if (dataType == "Guid")
                    {
                        EntityPropreties.Append("\n\tprivate " + dataTypeAlias + memberName + "= Guid.NewGuid();");
                    }
                    else if (dataType == "DateTime")
                    {
                        EntityPropreties.Append("\n\tprivate " + dataTypeAlias + memberName + "= DateTime.MinValue;");
                    }
                    else
                    {
                        EntityPropreties.Append("\n\tprivate " + dataTypeAlias + memberName + ";");
                    }
                    //XML Documentaion
                    xmlDocumentation  = "\n";
                    xmlDocumentation += "\n\t/// <summary>\n";
                    xmlDocumentation += "\t/// Gets or sets " + SqlProvider.obj.TableName + " " + propertyName + ". \n";
                    xmlDocumentation += "\t/// </summary>";
                    if (ProjectBuilder.AllowXmlDocumentation)
                    {
                        EntityPropreties.Append(xmlDocumentation);
                    }
                    //Propretie body
                    EntityPropreties.Append("\n\tpublic " + dataTypeAlias + " " + propertyName);
                    EntityPropreties.Append("\n\t{");
                    EntityPropreties.Append("\n\t\tget { return " + memberName + " ; }");
                    EntityPropreties.Append("\n\t\tset { " + memberName + "= value ; }");
                    EntityPropreties.Append("\n\t}");
                    EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                    EntityPropreties.Append("\n\t#endregion");
                    #endregion
                    if (ProjectBuilder.HasProprety)
                    {
                        #region ------------HasProperty---------------
                        if ((ID == null || colCurrent.Name != ID.Name))
                        {
                            string hasPropertyString     = SiteOptionsBuilder.GetHasPropertyString(propertyName);
                            string fullHasPropertyString = SiteOptionsBuilder.GetFullHasPropertyString(propertyName);
                            string conditionLine         = "";
                            if (ProjectBuilder.HasConfiguration)
                            {
                                SiteOptionsBuilder.AddTableOption(fullHasPropertyString);
                            }
                            if (dataType == "string" || dataType == "byte[]")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + ".Length > 0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + ".Length > 0) ";
                                }
                                //--------------------------------------------------
                            }

                            else if (dataType == "bool")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + ") ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "DateTime")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " != DateTime.MinValue" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " != DateTime.MinValue) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "decimal")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " > 0.0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " > 0.0) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "double")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " > 0.0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " > 0.0) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "Single")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " != null" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " != null) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "short")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " > 0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " > 0) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "int")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " > 0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " > 0) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "long")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " > 0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " > 0) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "byte")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " > 0" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " > 0) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "Guid")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " != null" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " != null) ";
                                }
                                //--------------------------------------------------
                            }
                            else if (dataType == "Object")
                            {
                                //--------------------------------------------------
                                if (ProjectBuilder.HasConfiguration)
                                {
                                    conditionLine = "if( " + memberName + " != null" + SiteOptionsBuilder.GetOptionalCondition(fullHasPropertyString, true) + ") ";
                                }
                                else
                                {
                                    conditionLine = "if( " + memberName + " != null) ";
                                }
                                //--------------------------------------------------
                            }



                            EntityPropreties.Append("\n\t#region --------------" + hasPropertyString + "--------------");
                            EntityPropreties.Append("\n\tpublic bool " + hasPropertyString);
                            EntityPropreties.Append("\n\t{");
                            EntityPropreties.Append("\n\t\tget");
                            EntityPropreties.Append("\n\t\t{");
                            EntityPropreties.Append("\n\t\t\t" + conditionLine);
                            EntityPropreties.Append("\n\t\t\t{ ");
                            EntityPropreties.Append("\n\t\t\t\treturn true;");
                            EntityPropreties.Append("\n\t\t\t} ");
                            EntityPropreties.Append("\n\t\t\telse");
                            EntityPropreties.Append("\n\t\t\t{");
                            EntityPropreties.Append("\n\t\t\t\treturn false;");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t}");
                            EntityPropreties.Append("\n\t}");
                            EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                            EntityPropreties.Append("\n\t#endregion");
                            //------------------------------------------
                        }
                        #endregion
                    }
                    #region Additional Properties for files properties
                    //Additional Properties for files properties
                    if (dataType == "string" && colCurrent.Name.IndexOf("Extension") > -1)
                    {
                        string[] stringSeparators = new string[] { "Extension" };
                        string[] separatingResult = colCurrent.Name.Split(stringSeparators, StringSplitOptions.None);
                        propertyName = separatingResult[0];

                        //Property
                        EntityPropreties.Append("\n\t#region --------------" + propertyName + "--------------");

                        EntityPropreties.Append("\n\tpublic string " + propertyName);
                        EntityPropreties.Append("\n\t{");
                        EntityPropreties.Append("\n\t\tget");
                        EntityPropreties.Append("\n\t\t{");
                        EntityPropreties.Append("\n\t\t\tif( " + memberName + ".Length > 0) ");
                        EntityPropreties.Append("\n\t\t\t{ ");
                        EntityPropreties.Append("\n\t\t\t\treturn " + global.TableFactoryClass + ".Create" + Table + propertyName + "Name(_" + Globals.GetProgramatlyName(ID.Name) + ")+ " + memberName + ";");
                        EntityPropreties.Append("\n\t\t\t}");
                        EntityPropreties.Append("\n\t\t\telse");
                        EntityPropreties.Append("\n\t\t\t{");
                        EntityPropreties.Append("\n\t\t\t\treturn \"\";");
                        EntityPropreties.Append("\n\t\t\t}");
                        EntityPropreties.Append("\n\t\t}");
                        EntityPropreties.Append("\n\t}");
                        EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                        EntityPropreties.Append("\n\t#endregion");
                        //----------------------------------------------------------
                        //Additional photos Properties
                        if (colCurrent.Name.ToLower().IndexOf("photo") > -1 || colCurrent.Name.ToLower().IndexOf("logo") > -1)
                        {
                            //Micro thumbnail
                            EntityPropreties.Append("\n\t#region --------------Micro" + propertyName + "Thumbs--------------");
                            EntityPropreties.Append("\n\tpublic string Micro" + propertyName + "Thumbs");
                            EntityPropreties.Append("\n\t{");
                            EntityPropreties.Append("\n\t\tget");
                            EntityPropreties.Append("\n\t\t{");
                            EntityPropreties.Append("\n\t\t\tif( " + memberName + ".Length > 0) ");
                            EntityPropreties.Append("\n\t\t\t{ ");
                            EntityPropreties.Append("\n\t\t\t\treturn " + global.TableFactoryClass + ".Create" + Table + propertyName + "Name(_" + Globals.GetProgramatlyName(ID.Name) + ")+  MoversFW.Thumbs.thumbnailExetnsion ;");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t\telse");
                            EntityPropreties.Append("\n\t\t\t{");
                            EntityPropreties.Append("\n\t\t\t\treturn \"\";");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t}");
                            EntityPropreties.Append("\n\t}");
                            EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                            EntityPropreties.Append("\n\t#endregion");
                            //-----------------------------------------------------------
                            //Mini thumbnail
                            EntityPropreties.Append("\n\t#region --------------Mini" + propertyName + "Thumbs--------------");
                            EntityPropreties.Append("\n\tpublic string Mini" + propertyName + "Thumbs");
                            EntityPropreties.Append("\n\t{");
                            EntityPropreties.Append("\n\t\tget");
                            EntityPropreties.Append("\n\t\t{");
                            EntityPropreties.Append("\n\t\t\tif( " + memberName + ".Length > 0) ");
                            EntityPropreties.Append("\n\t\t\t{ ");
                            EntityPropreties.Append("\n\t\t\t\treturn " + global.TableFactoryClass + ".Create" + Table + propertyName + "Name(_" + Globals.GetProgramatlyName(ID.Name) + ")+  MoversFW.Thumbs.thumbnailExetnsion ;");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t\telse");
                            EntityPropreties.Append("\n\t\t\t{");
                            EntityPropreties.Append("\n\t\t\t\treturn \"\";");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t}");
                            EntityPropreties.Append("\n\t}");
                            EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                            EntityPropreties.Append("\n\t#endregion");
                            //-----------------------------------------------------------
                            //Normal thumbnail
                            EntityPropreties.Append("\n\t#region --------------Normal" + propertyName + "Thumbs--------------");
                            EntityPropreties.Append("\n\tpublic string Normal" + propertyName + "Thumbs");
                            EntityPropreties.Append("\n\t{");
                            EntityPropreties.Append("\n\t\tget");
                            EntityPropreties.Append("\n\t\t{");
                            EntityPropreties.Append("\n\t\t\tif( " + memberName + ".Length > 0) ");
                            EntityPropreties.Append("\n\t\t\t{ ");
                            EntityPropreties.Append("\n\t\t\t\treturn " + global.TableFactoryClass + ".Create" + Table + propertyName + "Name(_" + Globals.GetProgramatlyName(ID.Name) + ")+  MoversFW.Thumbs.thumbnailExetnsion ;");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t\telse");
                            EntityPropreties.Append("\n\t\t\t{");
                            EntityPropreties.Append("\n\t\t\t\treturn \"\";");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t}");
                            EntityPropreties.Append("\n\t}");
                            EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                            EntityPropreties.Append("\n\t#endregion");
                            //-----------------------------------------------------------
                            //Big thumbnail
                            EntityPropreties.Append("\n\t#region --------------Big" + propertyName + "Thumbs--------------");
                            EntityPropreties.Append("\n\tpublic string Big" + propertyName + "Thumbs");
                            EntityPropreties.Append("\n\t{");
                            EntityPropreties.Append("\n\t\tget");
                            EntityPropreties.Append("\n\t\t{");
                            EntityPropreties.Append("\n\t\t\tif( " + memberName + ".Length > 0) ");
                            EntityPropreties.Append("\n\t\t\t{ ");
                            EntityPropreties.Append("\n\t\t\t\treturn " + global.TableFactoryClass + ".Create" + Table + propertyName + "Name(_" + Globals.GetProgramatlyName(ID.Name) + ")+  MoversFW.Thumbs.thumbnailExetnsion ;");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t\telse");
                            EntityPropreties.Append("\n\t\t\t{");
                            EntityPropreties.Append("\n\t\t\t\treturn \"\";");
                            EntityPropreties.Append("\n\t\t\t}");
                            EntityPropreties.Append("\n\t\t}");
                            EntityPropreties.Append("\n\t}");
                            EntityPropreties.Append("\n\t" + Globals.MetthodsSeparator);
                            EntityPropreties.Append("\n\t#endregion");
                            //-----------------------------------------------------------
                        }
                    }
                    #endregion
                }
                //

                EntityPropreties.Append("\n");
                return(EntityPropreties.ToString());
            }
            catch (Exception ex)
            {
                MessageBox.Show("My Generated Code Exception:" + ex.Message);
                return("");
            }
        }