//
private string Create_CreateButtonHandler()
{
StringBuilder _CreateButtonHandler = new StringBuilder();
_CreateButtonHandler.Append("\n\tprotected void btnCreate_Click(object sender, System.EventArgs e)");
_CreateButtonHandler.Append("\n\t{");
_CreateButtonHandler.Append("\n\t\tif (!Page.IsValid)");
_CreateButtonHandler.Append("\n\t\t{");
_CreateButtonHandler.Append("\n\t\t\treturn;");
_CreateButtonHandler.Append("\n\t\t}");
_CreateButtonHandler.Append("\n\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " = new " + global.TableEntityClass + "();");
string datatype;
foreach (SQLDMO.Column column in Fields)
{
if (allParameters != null && !allParameters.Contains(column.Name))
{
continue;
}
if (ID == null || column.Name != ID.Name || !Globals.CheckIsAddedBySql(ID))
{
datatype = Globals.GetAliasDataType(column.Datatype);
TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name);
if (datatype == "string")
{
if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = fck" + Globals.GetProgramatlyName(column.Name) + ".Value;");
}
else
{
if (cnstr == null)
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = txt" + Globals.GetProgramatlyName(column.Name) + ".Text;");
}
else
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + ".SelectedValue;");
}
}
}
//DateTime
else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.DateTime)
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Convert.To" + Globals.GetDataType(column.Datatype) + "(txt" + Globals.GetProgramatlyName(column.Name) + ".Value);");
}
//DateTime
else if (datatype == "bool")
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = cb" + Globals.GetProgramatlyName(column.Name) + ".Checked;");
}
else if (datatype == "Guid")
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Guid.NewGuid();");
}
else if (datatype != "byte[]" && datatype != "Object")
{
if (cnstr == null)
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Convert.To" + Globals.GetDataType(column.Datatype) + "(txt" + Globals.GetProgramatlyName(column.Name) + ".Text);");
}
else
{
_CreateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Convert.To" + Globals.GetDataType(column.Datatype) + "(ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + ".SelectedValue);");
}
}
}
}
_CreateButtonHandler.Append("\n\t\tbool result = " + global.TableFactoryClass + "." + MethodType.Create.ToString() + "(" + global.EntityClassObject + ");");
_CreateButtonHandler.Append("\n\t\tif(result)");
_CreateButtonHandler.Append("\n\t\t{");
_CreateButtonHandler.Append("\n\t\t\tlblResult.ForeColor=Color.Blue ;");
_CreateButtonHandler.Append("\n\t\t\tlblResult.Text=\"Êã ÇáÅÖÇÝÉ ÈäÌÇÍ\";");
_CreateButtonHandler.Append("\n\t\t\t" + global.ClearControlsMethod + ";");
_CreateButtonHandler.Append("\n\t\t}");
_CreateButtonHandler.Append("\n\t\telse");
_CreateButtonHandler.Append("\n\t\t{");
_CreateButtonHandler.Append("\n\t\t\tlblResult.ForeColor=Color.Red ;");
_CreateButtonHandler.Append("\n\t\t\tlblResult.Text=\"ÝÔáÊ ÚãáíÉ ÇáÅÖÇÝÉ\";");
_CreateButtonHandler.Append("\n\t\t}");
_CreateButtonHandler.Append("\n\t}");
return(_CreateButtonHandler.ToString());
}
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());
}
//
private string CreateDeleteCommandHandler()
{
string dataGridID = "dg" + global.TableProgramatlyName;
string id = Globals.GetProgramatlyName(ID.Name);
id = Globals.ConvetStringToCamelCase(id);
StringBuilder pageIndexHandler = new StringBuilder();
pageIndexHandler.Append("\n\tprotected void " + dataGridID + "_DeleteCommand(object source, DataGridCommandEventArgs e)");
pageIndexHandler.Append("\n\t{");
// pageIndexHandler.Append("\n\t\tTestData.Tables[0].Rows.Remove(TestData.Tables[0].Rows.Find(" + global.ViewAllDataGrid + ".DataKeys[e.Item.ItemIndex]));");
pageIndexHandler.Append("\n\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(" + dataGridID + ".DataKeys[e.Item.ItemIndex]);");
pageIndexHandler.Append("\n\t\tif(" + global.TableFactoryClass + "." + MethodType.Delete.ToString() + "(" + id + "))");
pageIndexHandler.Append("\n\t\t{");
pageIndexHandler.Append("\n\t\tint x = " + dataGridID + ".CurrentPageIndex;");
pageIndexHandler.Append("\n\t\tif (" + dataGridID + ".PageCount - 1 > x) " + dataGridID + ".CurrentPageIndex = x;");
pageIndexHandler.Append("\n\t\telse");
pageIndexHandler.Append("\n\t\t{");
pageIndexHandler.Append("\n\t\tif (" + dataGridID + ".PageCount != 1)" + dataGridID + ".CurrentPageIndex = x - 1;");
pageIndexHandler.Append("\n\t\t}");
pageIndexHandler.Append("\n\t\t\tLoadData();");
pageIndexHandler.Append("\n\t\t}");
pageIndexHandler.Append("\n\t}");
return(pageIndexHandler.ToString());
//
}
private string CreateLoadData()
{
StringBuilder loadData = new StringBuilder();
string id = Globals.GetProgramatlyName(ID.Name);
id = Globals.ConvetStringToCamelCase(id);
loadData.Append("\n\tprivate void LoadData()");
loadData.Append("\n\t{try{");
loadData.Append("\n\t\tif(Request.QueryString[\"" + id + "\"]!=null)");
loadData.Append("\n\t\t{");
loadData.Append("\n\t\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(Request.QueryString[\"" + id + "\"]);");
loadData.Append("\n\t\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " =" + global.TableFactoryClass + ".Get" + global.TableProgramatlyName + "Object(" + id + ");");
string datatype;
foreach (SQLDMO.Column column in Fields)
{
if (allParameters != null && !allParameters.Contains(column.Name))
{
continue;
}
if (ID == null || column.Name != ID.Name) //||!Globals.CheckIsAddedBySql(ID))
{
TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name);
datatype = Globals.GetAliasDataType(column.Datatype);
string ddl = "";
if (datatype == "string")
{
if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
{
loadData.Append("\n\t\t\tfck" + Globals.GetProgramatlyName(column.Name) + ".Value = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ";");
}
else
{
if (cnstr == null)
{
loadData.Append("\n\t\t\ttxt" + Globals.GetProgramatlyName(column.Name) + ".Text = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ";");
}
else
{
ddl = "ddl" + Globals.GetProgramatlyName(cnstr.ParentTable);
loadData.Append("\n\t\t\tMyDropDownList.LoadDataAndSetSelectedValue(" + ddl + "," + Globals.GetProgramatlyName(cnstr.ParentTable) + "Factory.GetAll(),\"" +
SqlProvider.obj.GetExpectedNameForParent(cnstr.ParentTable) + "\",\"" + Globals.GetProgramatlyName(cnstr.ParentColID) + "\"," + global.EntityClassObject + "." +
Globals.GetProgramatlyName(column.Name) + ".ToString());");
}
}
}
//DateTime
else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.DateTime)
{
loadData.Append("\n\t\t\ttxt" + Globals.GetProgramatlyName(column.Name) + ".Value = Convert.ToString(" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ");");
}
//DateTime
else if (datatype == "bool")
{
loadData.Append("\n\t\t\tcb" + Globals.GetProgramatlyName(column.Name) + ".Checked = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ";");
}
else if (datatype != "byte[]" && datatype != "Object" && datatype != "Guid")
{
if (cnstr == null)
{
loadData.Append("\n\t\t\ttxt" + Globals.GetProgramatlyName(column.Name) + ".Text = " + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + ".ToString();");
}
else
{
ddl = "ddl" + Globals.GetProgramatlyName(cnstr.ParentTable);
loadData.Append("\n\t\t\tMyDropDownList.LoadDataAndSetSelectedValue(" + ddl + "," + Globals.GetProgramatlyName(cnstr.ParentTable) + "Factory.GetAll(),\"" +
SqlProvider.obj.GetExpectedNameForParent(cnstr.ParentTable) + "\",\"" + Globals.GetProgramatlyName(cnstr.ParentColID) + "\"," + global.EntityClassObject + "." +
Globals.GetProgramatlyName(column.Name) + ".ToString());");
}
}
}
}
loadData.Append("\n\t\t}");
loadData.Append("\n\t\telse");
loadData.Append("\n\t\tthis.Visible=false;");
loadData.Append("\n\t}catch{Response.Redirect(\"default.aspx\");}}");
return(loadData.ToString());
}
//
private string Create_CreateButtonHandler()
{
StringBuilder _UpdateButtonHandler = new StringBuilder();
string id = Globals.GetProgramatlyName(ID.Name);
_UpdateButtonHandler.Append("\n\tprotected void btnUpdate_Click(object sender, System.EventArgs e)");
_UpdateButtonHandler.Append("\n\t{");
_UpdateButtonHandler.Append("\n\t\tif (!Page.IsValid)");
_UpdateButtonHandler.Append("\n\t\t{");
_UpdateButtonHandler.Append("\n\t\t\treturn;");
_UpdateButtonHandler.Append("\n\t\t}");
//_UpdateButtonHandler.Append("\n\t\t"+global.TableEntityClass+" "+global.EntityClassObject+" = new "+global.TableEntityClass+"();");
//_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(ID.Name) + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(Request.QueryString[\"" + Globals.GetProgramatlyName(ID.Name) + "\"]);");
//Diver
_UpdateButtonHandler.Append("\n\t\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(Request.QueryString[\"" + id + "\"]);");
_UpdateButtonHandler.Append("\n\t\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " =" + global.TableFactoryClass + ".Get" + global.TableProgramatlyName + "Object(" + id + ");");
//Diver
string datatype;
foreach (SQLDMO.Column column in Fields)
{
if (ID == null || column.Name != ID.Name) //||!Globals.CheckIsAddedBySql(ID))
{
TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name);
datatype = Globals.GetAliasDataType(column.Datatype);
if (datatype == "string")
{
if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = fck" + Globals.GetProgramatlyName(column.Name) + ".Value;");
}
else
{
if (cnstr == null)
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = txt" + Globals.GetProgramatlyName(column.Name) + ".Text;");
}
else
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + ".SelectedValue;");
}
}
}
//DateTime
else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.DateTime)
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Convert.To" + Globals.GetDataType(column.Datatype) + "(txt" + Globals.GetProgramatlyName(column.Name) + ".Value);");
}
//DateTime
else if (datatype == "bool")
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = cb" + Globals.GetProgramatlyName(column.Name) + ".Checked;");
}
else if (datatype == "Guid")
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Guid.NewGuid();");
}
else if (datatype != "byte[]" && datatype != "Object")
{
if (cnstr == null)
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Convert.To" + Globals.GetDataType(column.Datatype) + "(txt" + Globals.GetProgramatlyName(column.Name) + ".Text);");
}
else
{
_UpdateButtonHandler.Append("\n\t\t" + global.EntityClassObject + "." + Globals.GetProgramatlyName(column.Name) + " = Convert.To" + Globals.GetDataType(column.Datatype) + "(ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + ".SelectedValue);");
}
}
}
}
_UpdateButtonHandler.Append("\n\t\tbool result = " + global.TableFactoryClass + "." + MethodType.Update.ToString() + "(" + global.EntityClassObject + ");");
_UpdateButtonHandler.Append("\n\t\tif(result)");
_UpdateButtonHandler.Append("\n\t\t{");
//_UpdateButtonHandler.Append("\n\t\t\tlblResult.ForeColor=Color.Blue ;");
//_UpdateButtonHandler.Append("\n\t\t\tlblResult.Text=\"Êã ÇáÊÚÏíá ÈäÌÇÍ\";");
_UpdateButtonHandler.Append("\n\t\t\tResponse.Redirect(\"default.aspx\");");
_UpdateButtonHandler.Append("\n\t\t}");
_UpdateButtonHandler.Append("\n\t\telse");
_UpdateButtonHandler.Append("\n\t\t{");
_UpdateButtonHandler.Append("\n\t\t\tlblResult.ForeColor=Color.Red ;");
_UpdateButtonHandler.Append("\n\t\t\tlblResult.Text=\"ÝÔáÊ ÚãáíÉ ÇáÊÚÏíá\";");
_UpdateButtonHandler.Append("\n\t\t}");
_UpdateButtonHandler.Append("\n\t}");
return(_UpdateButtonHandler.ToString());
}
//
private string CreateDeleteCommandHandler()
{
string dataGridID = "dg" + global.TableProgramatlyName;
string id = Globals.GetProgramatlyName(ID.Name);
id = Globals.ConvetStringToCamelCase(id);
StringBuilder pageIndexHandler = new StringBuilder();
pageIndexHandler.Append("\n\t#region --------------" + dataGridID + "_DeleteCommand--------------");
pageIndexHandler.Append("\n\t//---------------------------------------------------------");
pageIndexHandler.Append("\n\t//" + dataGridID + "_DeleteCommand");
pageIndexHandler.Append("\n\t//---------------------------------------------------------");
pageIndexHandler.Append("\n\tprotected void " + dataGridID + "_DeleteCommand(object source, DataGridCommandEventArgs e)");
pageIndexHandler.Append("\n\t{");
pageIndexHandler.Append("\n\t\t" + Globals.GetAliasDataType(ID.Datatype) + " " + id + " = Convert.To" + Globals.GetDataType(ID.Datatype) + "(" + dataGridID + ".DataKeys[e.Item.ItemIndex]);");
pageIndexHandler.Append("\n\t\t" + global.TableEntityClass + " " + global.EntityClassObject + " =" + global.TableFactoryClass + ".Get" + global.TableProgramatlyName + "Object(" + id + ");");
pageIndexHandler.Append("\n\t\tif(" + global.TableFactoryClass + "." + MethodType.Delete.ToString() + "(" + id + "))");
pageIndexHandler.Append("\n\t\t{");
//XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX//
#region XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
string datatype;
bool siteurlObject = false;
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) && 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.IndexOf("Extension") > 0 && !siteurlObject)
{
pageIndexHandler.Append("\n\t\t\t" + SiteUrlsBuilder.GetFullDeclaration());
siteurlObject = true;
}
//--------------------------------------------
if (column.Name == ProjectBuilder.PhotoExtensionColumnName)
{
pageIndexHandler.Append("\n\t\t\t//Photo-----------------------------");
pageIndexHandler.Append("\n\t\t\t//Delete old original photo");
//Add Urls Property
SiteUrlsBuilder.AddDirectoryUrl("OriginalPhotos", SiteUrlsBuilder.photoOriginalUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("MicroPhotoThumbs", SiteUrlsBuilder.photoMicroUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("MiniPhotoThumbs", SiteUrlsBuilder.photoMiniUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("NormalPhotoThumbs", SiteUrlsBuilder.photoNormalUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("BigPhotoThumbs", SiteUrlsBuilder.photoBigUrl, Globals.GetProgramatlyName(Table), "");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.OriginalPhotos) + " + global.EntityClassObject + ".Photo" + ");");
pageIndexHandler.Append("\n\t\t\t//Delete old Thumbnails");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls." + "MicroPhotoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "PhotoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls." + "MiniPhotoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "PhotoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls." + "NormalPhotoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "PhotoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls." + "BigPhotoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "PhotoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\t//------------------------------------------------");
}
else if (column.Name == "LogoExtension")
{
pageIndexHandler.Append("\n\t\t\t//Logo-----------------------------");
pageIndexHandler.Append("\n\t\t\t//Delete old original Logo");
//Add Urls Property
SiteUrlsBuilder.AddDirectoryUrl("OriginalLogos", SiteUrlsBuilder.logoOriginalUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("MicroLogoThumbs", SiteUrlsBuilder.logoMicroUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("MiniLogoThumbs", SiteUrlsBuilder.logoMiniUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("NormalLogoThumbs", SiteUrlsBuilder.logoNormalUrl, Globals.GetProgramatlyName(Table), "");
SiteUrlsBuilder.AddDirectoryUrl("BigLogoThumbs", SiteUrlsBuilder.logoBigUrl, Globals.GetProgramatlyName(Table), "");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.OriginalLogos) + " + global.EntityClassObject + ".Logo" + ");");
pageIndexHandler.Append("\n\t\t\t//Delete old Thumbnails");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.MicroLogoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "LogoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.MiniLogoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "LogoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.NormalLogoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "LogoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.BigLogoThumbs) + " + global.TableFactoryClass + ".Create" + Table + "LogoName(" + id + " ) + MoversFW.Thumbs.thumbnailExetnsion);");
}
else if (column.Name == "FileExtension")
{
pageIndexHandler.Append("\n\t\t\t//File-----------------------------");
pageIndexHandler.Append("\n\t\t\t//Delete old original file");
//Add Urls Property
SiteUrlsBuilder.AddDirectoryUrl("OriginalFiles", SiteUrlsBuilder.filesUrl, Globals.GetProgramatlyName(Table), "");
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.OriginalFiles) + " + global.EntityClassObject + ".File" + ");");
pageIndexHandler.Append("\n\t\t\t\t//------------------------------------------------");
}
else if (column.Name.IndexOf("Extension") > 0)
{
string[] stringSeparators = new string[] { "Extension" };
string[] separatingResult = column.Name.Split(stringSeparators, StringSplitOptions.None);
string propertyName = separatingResult[0];
string uploaderID = "fu" + propertyName;
pageIndexHandler.Append("\n\t\t\t//File-----------------------------");
//Add Urls Property
SiteUrlsBuilder.AddDirectoryUrl("Original" + propertyName, SiteUrlsBuilder.otherFilesUrl, Globals.GetProgramatlyName(Table), propertyName + "s");
pageIndexHandler.Append("\n\t\t\t//Delete old original " + propertyName);
pageIndexHandler.Append("\n\t\t\tFile.Delete(Server.MapPath(urls.Original" + propertyName + ") + " + global.EntityClassObject + "." + propertyName + ");");
}
}
}
}
}
#endregion
//XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX//
pageIndexHandler.Append("\n\t\t\tlblResult.ForeColor = Color.Blue;");
pageIndexHandler.Append("\n\t\t\tlblResult.Text = " + ResourcesTesxtsBuilder.AddAdminGlobalText("DeletingOprationDone", TextType.Text) + ";");
pageIndexHandler.Append("\n\t\t\t//if one item in datagrid");
pageIndexHandler.Append("\n\t\t\tif (" + dataGridID + ".Items.Count == 1)");
pageIndexHandler.Append("\n\t\t\t{");
pageIndexHandler.Append("\n\t\t\t\t--pager.CurrentPage;");
pageIndexHandler.Append("\n\t\t\t}");
pageIndexHandler.Append("\n\t\t\tLoadData();");
pageIndexHandler.Append("\n\t\t}");
pageIndexHandler.Append("\n\t\telse");
pageIndexHandler.Append("\n\t\t{");
pageIndexHandler.Append("\n\t\t\tlblResult.ForeColor = Color.Red;");
pageIndexHandler.Append("\n\t\t\tlblResult.Text =" + ResourcesTesxtsBuilder.AddAdminGlobalText("DeletingOprationFaild", TextType.Text) + ";");
pageIndexHandler.Append("\n\t\t}");
pageIndexHandler.Append("\n\t}");
pageIndexHandler.Append("\n\t//--------------------------------------------------------");
pageIndexHandler.Append("\n\t#endregion");
return(pageIndexHandler.ToString());
//
}
//--------------------------------------
//
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());
}