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()); }
//---------------------------------- #region Old and Unused code /// <summary> /// Generates code for an UPDATE or INSERT Stored Procedure /// </summary> /// <param name="sptypeGenerate">The type of SP to generate, INSERT or UPDATE</param> /// <param name="Fields">A ColumnCollection collection</param> /// <returns>The SP code</returns> private void Generate(StoredProcedureTypes sptypeGenerate, SqlProvider dmoMain) { try { StringBuilder sGeneratedCode = new StringBuilder(); StringBuilder sParamDeclaration = new StringBuilder(); StringBuilder sBody = new StringBuilder(); StringBuilder sINSERTValues = new StringBuilder(); string finnal = ""; // Setup SP code, begining is the same no matter the type sGeneratedCode.AppendFormat("CREATE PROCEDURE {0}.[{1}_{2}]", new string[] { SqlProvider.obj.DatabaseOwner, Globals.GetProgramatlyName(Table), sptypeGenerate.ToString() }); sGeneratedCode.Append(Environment.NewLine); // Setup body code, different for UPDATE and INSERT switch (sptypeGenerate) { case StoredProcedureTypes.Create: sBody.AppendFormat("INSERT INTO [{0}] (", Table); sBody.Append(Environment.NewLine); sINSERTValues.Append("VALUES ("); sINSERTValues.Append(Environment.NewLine); break; case StoredProcedureTypes.Update: sBody.AppendFormat("UPDATE [{0}]", Table); sBody.Append(Environment.NewLine); sBody.Append("SET"); sBody.Append(Environment.NewLine); break; case StoredProcedureTypes.GetAll: sBody.AppendFormat("Select * From [{0}] ", Table); sBody.Append(Environment.NewLine); break; case StoredProcedureTypes.GetOneByID: sBody.AppendFormat("Select * From [{0}] ", Table); sBody.Append(Environment.NewLine); break; case StoredProcedureTypes.Delete: sBody.AppendFormat("Delete * From [{0}] ", Table); sBody.Append(Environment.NewLine); break; } #region Add Parametars if (sptypeGenerate == StoredProcedureTypes.GetAll) { sGeneratedCode.Append("AS"); sGeneratedCode.Append(Environment.NewLine); sGeneratedCode.Append(sBody.Remove(sBody.Length - 3, 3)); } else if (sptypeGenerate != StoredProcedureTypes.GetOneByID || sptypeGenerate != StoredProcedureTypes.Delete) { //The finanal of procedure if (ID != null) { sParamDeclaration.AppendFormat(" @{0} {1}", new string[] { Globals.GetProgramatlyName(ID.Name), ID.Datatype }); finnal = "Where [" + ID.Name + "] =@" + Globals.GetProgramatlyName(ID.Name); } } else { foreach (Column colCurrent in Fields) { if (ID != null && colCurrent.Name == ID.Name) { sParamDeclaration.AppendFormat(" @{0} {1}", new string[] { Globals.GetProgramatlyName(colCurrent.Name), colCurrent.Datatype }); } if (ID != null && colCurrent.Name == ID.Name && Globals.CheckIsAddedBySql(colCurrent) && sptypeGenerate == StoredProcedureTypes.Create) { sParamDeclaration.AppendFormat(" out"); } // Only binary, char, nchar, nvarchar, varbinary and varchar may have their length declared if ( colCurrent.Datatype == "binary" || colCurrent.Datatype == "char" || colCurrent.Datatype == "nchar" || colCurrent.Datatype == "nvarchar" || colCurrent.Datatype == "varbinary" || colCurrent.Datatype == "varchar") { sParamDeclaration.AppendFormat("({0})", colCurrent.Length); } sParamDeclaration.Append(","); sParamDeclaration.Append(Environment.NewLine); // Body construction, different for INSERT and UPDATE switch (sptypeGenerate) { case StoredProcedureTypes.Create: //not Added BySQL if (ID == null && colCurrent.Name != ID.Name || !Globals.CheckIsAddedBySql(colCurrent)) { sINSERTValues.AppendFormat(" @{0},", Globals.GetProgramatlyName(colCurrent.Name)); sINSERTValues.Append(Environment.NewLine); sBody.AppendFormat(" [{0}],", colCurrent.Name); sBody.Append(Environment.NewLine); } break; case StoredProcedureTypes.Update: if (ID == null && colCurrent.Name != ID.Name) { sBody.AppendFormat(" [{0}] = @{1},", new string[] { colCurrent.Name, Globals.GetProgramatlyName(colCurrent.Name) }); sBody.Append(Environment.NewLine); } break; case StoredProcedureTypes.GetOneByID: // sBody.AppendFormat("Where {0} = @{0},", new string[]{colCurrent.Name, }); sBody.Append(Environment.NewLine); break; } } //The finanal of procedure if (ID != null) { if (sptypeGenerate == StoredProcedureTypes.Create && Globals.CheckIsAddedBySql(ID)) { finnal = "Set @" + Globals.GetProgramatlyName(ID.Name) + " = @@Identity"; } else if (sptypeGenerate == StoredProcedureTypes.Update) { finnal = "Where [" + ID.Name + "] =@" + Globals.GetProgramatlyName(ID.Name); } } #endregion // Now stitch the body parts together into the SP whole sGeneratedCode.Append(sParamDeclaration.Remove(sParamDeclaration.Length - 3, 3)); sGeneratedCode.Append(Environment.NewLine); sGeneratedCode.Append("AS"); sGeneratedCode.Append(Environment.NewLine); sGeneratedCode.Append(sBody.Remove(sBody.Length - 3, 3)); if (sptypeGenerate == StoredProcedureTypes.Create) { sGeneratedCode.Append(")"); sGeneratedCode.Append(Environment.NewLine); sGeneratedCode.Append(sINSERTValues.Remove(sINSERTValues.Length - 3, 3)); sGeneratedCode.Append(")"); } } sGeneratedCode.Append(Environment.NewLine); sGeneratedCode.Append(finnal); WriteStoredProcedure(sGeneratedCode.ToString()); } catch (Exception ex) { MessageBox.Show("My Generated Code Exception:" + ex.Message); } }
//------------------------------------- public string CreateGetAllMethod(SQLDMO.Column conditionalColumn, bool isAvailableMethod) { try { string MethodName = StoredProcedureTypes.GetAll.ToString(); string sqlDataProviderMethodName2 = "GetAll"; string sqlDataProviderMethodCaller = global.SqlDataProviderClass + ".Instance." + sqlDataProviderMethodName2; string methodParameters = ""; string sqlMethodParameters = ""; string additionalPreviousBodyLines = ""; //------------------------------ bool hasPreviousMethodParameter = false; bool hasPreviousSqlMethodParameter = false; //------------------------------ bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); if (isMaultiLanguages) { if (!isAvailableMethod) { methodParameters += "Languages langID"; hasPreviousMethodParameter = true; } sqlMethodParameters += "langID"; hasPreviousSqlMethodParameter = true; } //------------------------------ if (conditionalColumn != null) { //Check Previous Parameters if (hasPreviousMethodParameter) { methodParameters += ", "; } if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } //----------------------- MethodName += "By" + Globals.GetProgramatlyName(conditionalColumn.Name); sqlDataProviderMethodCaller += "By" + Globals.GetProgramatlyName(conditionalColumn.Name); methodParameters += Globals.GetAliasDataType(conditionalColumn.Datatype) + " " + Globals.ConvetStringToCamelCase(Globals.GetProgramatlyName(conditionalColumn.Name)); sqlMethodParameters += Globals.ConvetStringToCamelCase(Globals.GetProgramatlyName(conditionalColumn.Name)); //----------------------- hasPreviousMethodParameter = true; hasPreviousSqlMethodParameter = true; } //------------------------------ bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); if (hasIsAvailable) { if (!isAvailableMethod) { //Check Previous Parameters if (hasPreviousMethodParameter) { methodParameters += ", "; } if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } //------------------------- methodParameters += "bool " + Globals.ConvetStringToCamelCase(ProjectBuilder.IsAvailableConditionParam); sqlMethodParameters += Globals.ConvetStringToCamelCase(ProjectBuilder.IsAvailableConditionParam); //----------------------- hasPreviousMethodParameter = true; hasPreviousSqlMethodParameter = true; } else { //Check Previous Parameter if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } sqlDataProviderMethodCaller = MethodName; //if (userType == UserType.Admin) //{ // MethodName += "ForAdmin"; // sqlMethodParameters += "false"; // additionalPreviousBodyLines = "Languages langID = (Languages) ResourceManager.GetCurrentLanguage();"; //} //else //{ // MethodName += "ForUser"; // sqlMethodParameters += "true"; // additionalPreviousBodyLines = "Languages langID = (Languages) ResourceManager.GetCurrentLanguage();"; //} ////----------------------- hasPreviousSqlMethodParameter = true; } } //------------------------------ //Check Previous Parameters if (hasPreviousMethodParameter) { methodParameters += ", "; } if (hasPreviousSqlMethodParameter) { sqlMethodParameters += ", "; } //------------------------- methodParameters += "int pageIndex, int pageSize, out int totalRecords"; sqlMethodParameters += "pageIndex, pageSize, out totalRecords"; //XXXXXXXXXXXXXXX //XXXXXXXXXXXXXXX string MethodReturn = "List<" + global.TableEntityClass + ">"; //XML Documentaion string xmlDocumentation = "\n\t/// <summary>\n"; xmlDocumentation += "\t/// Gets All " + SqlProvider.obj.TableName + ".\n"; xmlDocumentation += "\t/// <example>[Example]" + MethodReturn + " " + global.EntityClassList + "=" + ClassName + "." + MethodName + "(" + sqlMethodParameters + ");.</example>\n"; xmlDocumentation += "\t/// </summary>\n"; xmlDocumentation += "\t/// <returns>All " + SqlProvider.obj.TableName + ".</returns>"; //Method Body StringBuilder methodBody = new StringBuilder(); methodBody.Append("\n\t#region --------------" + MethodName + "--------------"); if (ProjectBuilder.AllowXmlDocumentation) { methodBody.Append(xmlDocumentation); } methodBody.Append("\n\tpublic static " + MethodReturn + " " + MethodName + "(" + methodParameters + ")"); methodBody.Append("\n\t{"); methodBody.Append("\n\t\t" + additionalPreviousBodyLines); methodBody.Append("\n\t\treturn " + sqlDataProviderMethodCaller + "(" + sqlMethodParameters + ");"); methodBody.Append("\n\t}"); methodBody.Append("\n\t" + Globals.MetthodsSeparator); methodBody.Append("\n\t#endregion"); return(methodBody.ToString()); } catch (Exception ex) { MessageBox.Show("My Generated Code Exception:" + ex.Message); return(""); } }
// private string CreateLoadData() { StringBuilder loadData = new StringBuilder(); loadData.Append("\n\t#region --------------LoadData--------------"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\t//LoadData"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\tprivate void LoadData()"); loadData.Append("\n\t{"); loadData.Append("\n\t\tpager.PageSize = SiteSettings.Instance.AdminPageSize;"); loadData.Append("\n\t\tint totalRecords = 0;"); string methodParameters = ""; string methodName = StoredProcedureTypes.GetAllWithPager.ToString(); bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); if (hasIsAvailable) { methodName += "ForAdmin"; } bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); if (isMaultiLanguages) { if (!hasIsAvailable) { loadData.Append("\n\t\tLanguages langID = (Languages)ResourceManager.GetCurrentLanguage();"); methodParameters = "langID,"; } } methodParameters += "pager.CurrentPage, pager.PageSize, out totalRecords"; loadData.Append("\n\t\tList<" + global.TableEntityClass + "> " + global.EntityClassList + "= " + global.TableFactoryClass + "." + methodName + "(" + methodParameters + ");"); loadData.Append("\n\t\tif(" + global.EntityClassList + "!=null&&" + global.EntityClassList + ".Count >0)"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".DataSource= " + global.EntityClassList + ";"); if (ID != null) { loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".DataKeyField=\"" + Globals.GetProgramatlyName(ID.Name) + "\";"); } loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".AllowPaging=false;"); //-------- loadData.Append("\n\t\t\tpager.Visible = true;"); loadData.Append("\n\t\t\tpager.TotalRecords = totalRecords;"); //-------- loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".DataBind();"); loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".Visible = true;"); loadData.Append("\n\t\t}"); loadData.Append("\n\t\telse"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t" + global.ViewAllDataGrid + ".Visible=false;"); loadData.Append("\n\t\t\tpager.Visible = false;"); loadData.Append("\n\t\t\tlblResult.ForeColor = Color.Red;"); loadData.Append("\n\t\t\tlblResult.Text = " + ResourcesTesxtsBuilder.AddAdminGlobalText("ThereIsNoData", TextType.Text) + ";"); loadData.Append("\n\t\t}"); loadData.Append("\n\t}"); loadData.Append("\n\t//--------------------------------------------------------"); loadData.Append("\n\t#endregion"); return(loadData.ToString()); }
static SqlProvider() { obj = new SqlProvider(); }
//-------------------------------------- private string CreateLoadData() { StringBuilder loadData = new StringBuilder(); loadData.Append("\n\t#region --------------LoadData--------------"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\t//LoadData"); loadData.Append("\n\t//---------------------------------------------------------"); loadData.Append("\n\tprivate void LoadData()"); loadData.Append("\n\t{"); loadData.Append("\n\t\tpager.PageSize = SiteSettings.Instance.DefaultPageSize;"); loadData.Append("\n\t\tint totalRecords = 0;"); string methodParameters = ""; string methodName = StoredProcedureTypes.GetAllWithPager.ToString(); bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName); if (hasIsAvailable) { methodName += "ForUser"; } bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName)); if (isMaultiLanguages) { if (!hasIsAvailable) { loadData.Append("\n\t\tLanguages langID = (Languages)ResourceManager.GetCurrentLanguage();"); methodParameters = "langID,"; } } methodParameters += "pager.CurrentPage, pager.PageSize, out totalRecords"; loadData.Append("\n\t\tList<" + global.TableEntityClass + "> " + global.EntityClassList + " = " + global.TableFactoryClass + "." + methodName + "(" + methodParameters + ");"); loadData.Append("\n\t\tif(" + global.EntityClassList + "!=null&&" + global.EntityClassList + ".Count >0)"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t//Load data list design"); loadData.Append("\n\t\t\tDataList dl;"); loadData.Append("\n\t\t\tdl = LoadDataList(\"" + repeaterID + "\");"); loadData.Append("\n\t\t\t" + repeaterID + ".ItemTemplate = dl.ItemTemplate;"); loadData.Append("\n\t\t\t" + repeaterID + ".HeaderTemplate = dl.HeaderTemplate;"); loadData.Append("\n\t\t\t" + repeaterID + ".FooterTemplate = dl.FooterTemplate;"); loadData.Append("\n\t\t\t" + repeaterID + ".ShowHeader = dl.ShowHeader;"); loadData.Append("\n\t\t\t" + repeaterID + ".ShowFooter = dl.ShowFooter;"); loadData.Append("\n\t\t\t" + repeaterID + ".Width = dl.Width;"); loadData.Append("\n\t\t\t" + repeaterID + ".RepeatColumns = dl.RepeatColumns;"); loadData.Append("\n\t\t\t//-----------------------------------------"); loadData.Append("\n\t\t\t" + repeaterID + ".DataSource= " + global.EntityClassList + ";"); loadData.Append("\n\t\t\t" + repeaterID + ".DataBind();"); loadData.Append("\n\t\t\t" + repeaterID + ".Visible = true;"); //-------- loadData.Append("\n\t\t\tpager.Visible = true;"); loadData.Append("\n\t\t\tpager.TotalRecords = totalRecords;"); loadData.Append("\n\t\t\tPagerManager.PrepareUserPager(pager);"); //-------- loadData.Append("\n\t\t}"); loadData.Append("\n\t\telse"); loadData.Append("\n\t\t{"); loadData.Append("\n\t\t\t" + repeaterID + ".Visible=false;"); loadData.Append("\n\t\t\tpager.Visible = false;"); loadData.Append("\n\t\t}"); loadData.Append("\n\t}"); loadData.Append("\n\t//--------------------------------------------------------"); loadData.Append("\n\t#endregion"); return(loadData.ToString()); }