//----------------------------------------------------------
private string GenerateClassBody()
{
StringBuilder MethodsBuilder = new StringBuilder();
MethodsBuilder.Append("\n" + CreateGetChacheKeyMethod());
MethodsBuilder.Append("\n" + CreateCreateMethod());
MethodsBuilder.Append("\n" + CreateUpdateMethod());
MethodsBuilder.Append("\n" + CreateDeleteMethod());
bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName);
bool isMaultiLanguages = (ProjectBuilder.HasMultiLanguages && SqlProvider.CheckISATableIsMultiLanguage(SqlProvider.obj.TableName));
//CreateGetAllMethod
//----------------------
//CreateGetAllMethod
MethodsBuilder.Append("\n" + CreateGetAllMethod());
//----------------------
//CreateGetCountMethod
MethodsBuilder.Append("\n" + CreateGetCountMethod());
//----------------------
//GenerateReletionalGetData
MethodsBuilder.Append(GenerateReletionalGetData());
if (ID != null)
{
MethodsBuilder.Append("\n" + CreateGetOneMethod());
}
//MethodsBuilder.Append("\n" + CreatePopulateObjectMethod());
return(MethodsBuilder.ToString());
}
//----------------------------------------------------------
#endregion
//----------------------------------------------------------
#region GenerateReletionalGetData
private string GenerateReletionalGetData()
{
StringBuilder relationalMethods = new StringBuilder();
bool hasIsAvailable = SqlProvider.CheckIsATableHasIsAvailableColumnName(SqlProvider.obj.TableName);
foreach (SQLDMO.Column column in Fields)
{
//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))
{
TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name);
if (cnstr != null)
{
relationalMethods.Append("\n" + CreateGetAllMethod(column, false));
relationalMethods.Append("\n" + CreateGetCountMethod(column, false));
}
}
}
return(relationalMethods.ToString());
}
//-------------------------------------
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());
}
//--------------------------------------
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());
}