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