public void Refresh()
{
_TableName = "";
id = null;
_Table = null;
TableParentTables = null;
}
public Generator()
{
Fields = SqlProvider.obj.Fields;
//-----------------------------
ID = SqlProvider.obj.ID;
Table = SqlProvider.obj.TableName;
global = new Globals();
}
//------------------------------------------------------------
public static bool CheckIsAddedBySql(SQLDMO.Column clmn)
{
if (clmn.Identity && clmn.IdentityIncrement > 0)
{
return(true);
}
else
{
return(false);
}
}
//------------------------------------------------------------
public static int GetTextBoxMaxLength(SQLDMO.Column column)
{
if (column.Datatype.ToLower() == SqlDbType.BigInt.ToString().ToLower())
{
return(20);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Binary.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Bit.ToString().ToLower())
{
return(1);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Char.ToString().ToLower())
{
return(column.Length);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.DateTime.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Decimal.ToString().ToLower())
{
return(40);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Float.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Image.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Int.ToString().ToLower())
{
return(9);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Money.ToString().ToLower())
{
return(20);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.NChar.ToString().ToLower())
{
return(column.Length);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.NText.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.NVarChar.ToString().ToLower())
{
return(column.Length);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Real.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.SmallDateTime.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.SmallInt.ToString().ToLower())
{
return(6);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.SmallMoney.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Text.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Timestamp.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.TinyInt.ToString().ToLower())
{
return(3);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.UniqueIdentifier.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.VarBinary.ToString().ToLower())
{
return(0);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.VarChar.ToString().ToLower())
{
return(column.Length);
}
//-----------------------------------
else if (column.Datatype.ToLower() == SqlDbType.Variant.ToString().ToLower())
{
return(0);
}
else
{
return(0);
}
}
//-------------------------------------
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("");
}
}
//--------------------------------------
//
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());
}
