protected string GenerateControls()
{
string propertyName;
string trPropertyName;
string datatype;
StringBuilder controls = new StringBuilder();
bool hasPasswordField = false;
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Result\" align=\"center\" colspan=\"2\">");
controls.Append("\n\t\t\t\t\t\t<asp:Label id=\"lblResult\" runat=\"server\"></asp:Label>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
foreach (SQLDMO.Column column in Fields)
{
propertyName = Globals.GetProgramatlyName(column.Name);
trPropertyName = "tr" + propertyName;
//if (ID == null || column.Name != ID.Name)//||!Globals.CheckIsAddedBySql(ID))
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 == "bool")
{
if (ProjectBuilder.HasConfiguration)
{
controls.Append("\n\t\t\t\t<tr id=\"" + trPropertyName + "\" runat=\"server\" >");
}
else
{
controls.Append("\n\t\t\t\t<tr>");
}
controls.Append("\n\t\t\t\t\t<td class=\"Text\">" + ResourcesTesxtsBuilder.AddUserText(propertyName, TextType.HtmlClassic));
if (!column.AllowNulls)
{
controls.Append("<span class=\"RequiredField\"><asp:Label runat=\"server\" Text=\"*\" /></span>");
}
controls.Append("</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
if (propertyName.ToLower().IndexOf("isavailable") > -1)
{
controls.Append("\n\t\t\t\t\t\t<asp:CheckBox id=\"cb" + propertyName + "\" Checked=\"true\" CssClass=\"Controls\" runat=\"server\" ValidationGroup=\"" + Table + "\"></asp:CheckBox>");
}
else
{
controls.Append("\n\t\t\t\t\t\t<asp:CheckBox id=\"cb" + propertyName + "\" CssClass=\"Controls\" runat=\"server\" ValidationGroup=\"" + Table + "\"></asp:CheckBox>");
}
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
{
if (column.Name.ToLower().IndexOf("details") > -1)
{
if (ProjectBuilder.HasConfiguration)
{
controls.Append("\n\t\t\t\t<tr id=\"" + trPropertyName + "\" runat=\"server\" >");
}
else
{
controls.Append("\n\t\t\t\t<tr>");
}
controls.Append("\n\t\t\t\t\t<td class=\"Text\">" + ResourcesTesxtsBuilder.AddUserText(propertyName, TextType.HtmlClassic));
if (!column.AllowNulls)
{
controls.Append("<span class=\"RequiredField\"><asp:Label runat=\"server\" Text=\"*\" /></span>");
}
controls.Append("</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
//FREETEXTBOX
if (ProjectBuilder.IsFreeTextBoxEditor)
{
controls.Append("\n\t\t\t\t\t\t<FTB:FREETEXTBOX id=\"txt" + propertyName + "\" runat=\"server\" TextDirection=\"" + ResourcesTesxtsBuilder.AddAdminGlobalText("EditorDirection", TextType.ServerControl) + "\" ");
controls.Append("\n\t\t\t\t\t\tToolbarLayout=\"Bold,Italic,Underline,Strikethrough,Superscript,Subscript;");
controls.Append("\n\t\t\t\t\t\tJustifyLeft,JustifyRight,JustifyCenter,JustifyFull;");
controls.Append("\n\t\t\t\t\t\tCut,Copy,Paste,Delete,Undo,Redo,Print,Save,ieSpellCheck|");
controls.Append("\n\t\t\t\t\t\tParagraphMenu,FontFacesMenu,FontSizesMenu,FontForeColorsMenu,FontBackColorsMenu,FontForeColorPicker,FontBackColorPicker|StyleMenu,SymbolsMenu,InsertHtmlMenu|InsertRule,InsertDate,InsertTime|WordClean|");
controls.Append("\n\t\t\t\t\t\tCreateLink,Unlink;RemoveFormat,BulletedList,NumberedList,Indent,Outdent;InsertTable,EditTable,InsertTableRowBefore,InsertTableRowAfter,DeleteTableRow,InsertTableColumnBefore,InsertTableColumnAfter,DeleteTableColumn|\"");
controls.Append("\n\t\t\t\t\t\tSupportFolder=\"/phyEditorImages/FreeTextBox/\" ButtonSet=\"NotSet\" Width=\"450px\" ButtonWidth=\"21\"></FTB:FREETEXTBOX>");
}
else
{
controls.Append("\n\t\t\t\t\t\t<fckeditorv2:fckeditor id=\"txt" + propertyName + "\" runat=\"server\"></fckeditorv2:fckeditor>");
}
//-----------
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
IshasFreeTextBoxControl = true;
}
else
{
if (ProjectBuilder.HasConfiguration)
{
controls.Append("\n\t\t\t\t<tr id=\"" + trPropertyName + "\" runat=\"server\" >");
}
else
{
controls.Append("\n\t\t\t\t<tr>");
}
controls.Append("\n\t\t\t\t\t<td class=\"Text\">" + ResourcesTesxtsBuilder.AddUserText(propertyName, TextType.HtmlClassic));
if (!column.AllowNulls)
{
controls.Append("<span class=\"RequiredField\"><asp:Label runat=\"server\" Text=\"*\" /></span>");
}
controls.Append("</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
controls.Append("\n\t\t\t\t\t\t<asp:TextBox id=\"txt" + propertyName + "\" runat=\"server\" TextMode=\"MultiLine\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\"></asp:TextBox>");
//controls.Append("\n\t\t\t\t\t\t<input type=\"text\" class=\"Controls\" name=\"txt" + propertyName + "LengthControler\" id=\"txt" + propertyName + "LengthControler\" style=\"width: 40px;\" disabled>");
//-----------
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
}
else if (datatype != "byte[]" && datatype != "Object" && datatype != "Guid")
{
if (ProjectBuilder.HasConfiguration)
{
controls.Append("\n\t\t\t\t<tr id=\"" + trPropertyName + "\" runat=\"server\" >");
}
else
{
controls.Append("\n\t\t\t\t<tr>");
}
controls.Append("\n\t\t\t\t\t<td class=\"Text\">" + ResourcesTesxtsBuilder.AddUserText(propertyName, TextType.HtmlClassic));
if (!column.AllowNulls)
{
controls.Append("<span class=\"RequiredField\"><asp:Label runat=\"server\" Text=\"*\" /></span>");
}
controls.Append("</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
//XXXXXXXXXXXXXXXXXXXXXXXXXXXXXDownLoadExistFile
if (cnstr == null)
{
if (column.Name.IndexOf(ProjectBuilder.ExtensionInColumnName) > -1)
{
if (column.Name == ProjectBuilder.PhotoExtensionColumnName)
{
controls.Append("\n\t\t\t\t\t\t<asp:FileUpload ID=\"" + photoUploadreID + "\" runat=\"server\" CssClass=\"Controls\" />");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyName + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"" + photoUploadreID + "\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
}
else if (column.Name == "LogoExtension")
{
controls.Append("\n\t\t\t\t\t\t<asp:FileUpload ID=\"" + logoUploadreID + "\" runat=\"server\" CssClass=\"Controls\" />");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyName + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"" + logoUploadreID + "\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
}
else if (column.Name == "FileExtension")
{
controls.Append("\n\t\t\t\t\t\t<asp:FileUpload ID=\"" + fileUploadreID + "\" runat=\"server\" CssClass=\"Controls\" />");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyName + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"" + fileUploadreID + "\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
}
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;
controls.Append("\n\t\t\t\t\t\t<asp:FileUpload ID=\"" + uploaderID + "\" runat=\"server\" CssClass=\"Controls\" />");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyName + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"" + uploaderID + "\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
}
}
//Check Priority
else if (column.Name.ToLower() == ProjectBuilder.PriorityColumnName.ToLower())
{
controls.Append("\n\t\t\t\t\t\t<asp:DropDownList id=\"" + ProjectBuilder.PriorityDropDownList + "\" runat=\"server\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\"></asp:DropDownList>");
}
else
{
if (column.Name.ToLower().IndexOf("password") > -1)
{
hasPasswordField = true;
controls.Append("\n\t\t\t\t\t\t<asp:TextBox MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" id=\"txt" + propertyName + "\" runat=\"server\" TextMode=\"Password\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\"></asp:TextBox>");
if (datatype == "int" || datatype == "long" || datatype == "short")
{
controls.Append("\n\t\t\t\t\t\t<asp:RegularExpressionValidator Display=\"Dynamic\" ID=\"rev" + propertyName + "\" runat=\"server\" ControlToValidate=\"txt" + propertyName + "\" ErrorMessage=\"\" ValidationGroup=\"" + Table + "\" ValidationExpression=\"\\d*\"></asp:RegularExpressionValidator>");
}
else if (column.Name.ToLower().IndexOf("email") > -1)
{
controls.Append("\n\t\t\t\t\t\t<asp:RegularExpressionValidator Display=\"Dynamic\" ID=\"rev" + propertyName + "\" runat=\"server\" ControlToValidate=\"txt" + propertyName + "\" ErrorMessage=\"\" ValidationGroup=\"" + Table + "\" ValidationExpression=\"\\w+([-+.']\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*\"></asp:RegularExpressionValidator>");
}
}
else if (column.Length > 128)
{
controls.Append("\n\t\t\t\t\t\t<asp:TextBox MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" id=\"txt" + propertyName + "\" runat=\"server\" TextMode=\"MultiLine\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\" maxlengthS=\"" + Globals.GetTextBoxMaxLength(column) + "\" onkeyup=\"return ismaxlength(this,document.forms[0].txt" + propertyName + "LengthControler)\" onfocus=\"return ismaxlength(this,document.forms[0].txt" + propertyName + "LengthControler)\"></asp:TextBox>");
controls.Append("\n\t\t\t\t\t\t<input type=\"text\" class=\"Controls\" name=\"txt" + propertyName + "LengthControler\" id=\"txt" + propertyName + "LengthControler\" style=\"width: 40px;\" disabled>");
if (datatype == "int" || datatype == "long" || datatype == "short")
{
controls.Append("\n\t\t\t\t\t\t<asp:RegularExpressionValidator Display=\"Dynamic\" ID=\"rev" + propertyName + "\" runat=\"server\" ControlToValidate=\"txt" + propertyName + "\" ErrorMessage=\"\" ValidationGroup=\"" + Table + "\" ValidationExpression=\"\\d*\"></asp:RegularExpressionValidator>");
}
else if (column.Name.ToLower().IndexOf("email") > -1)
{
controls.Append("\n\t\t\t\t\t\t<asp:RegularExpressionValidator Display=\"Dynamic\" ID=\"rev" + propertyName + "\" runat=\"server\" ControlToValidate=\"txt" + propertyName + "\" ErrorMessage=\"\" ValidationGroup=\"" + Table + "\" ValidationExpression=\"\\w+([-+.']\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*\"></asp:RegularExpressionValidator>");
}
}
else
{
controls.Append("\n\t\t\t\t\t\t<asp:TextBox MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" id=\"txt" + propertyName + "\" runat=\"server\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\"></asp:TextBox>");
if (datatype == "int" || datatype == "long" || datatype == "short")
{
controls.Append("\n\t\t\t\t\t\t<asp:RegularExpressionValidator Display=\"Dynamic\" ID=\"rev" + propertyName + "\" runat=\"server\" ControlToValidate=\"txt" + propertyName + "\" ErrorMessage=\"\" Text=\"" + ResourcesTesxtsBuilder.AddAdminGlobalText("InvalidNumericalData", TextType.ServerControl) + "\" ValidationGroup=\"" + Table + "\" ValidationExpression=\"\\d*\"></asp:RegularExpressionValidator>");
}
else if (column.Name.ToLower().IndexOf("email") > -1)
{
controls.Append("\n\t\t\t\t\t\t<asp:RegularExpressionValidator Display=\"Dynamic\" ID=\"rev" + propertyName + "\" runat=\"server\" ControlToValidate=\"txt" + propertyName + "\" ErrorMessage=\"\" Text=\"" + ResourcesTesxtsBuilder.AddAdminGlobalText("InvalidEmail", TextType.ServerControl) + "\" ValidationGroup=\"" + Table + "\" ValidationExpression=\"\\w+([-+.']\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*\"></asp:RegularExpressionValidator>");
}
}
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyName + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"txt" + propertyName + "\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
}
}
else
{
controls.Append("\n\t\t\t\t\t\t<asp:DropDownList id=\"ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + "\" runat=\"server\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\"></asp:DropDownList>");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyName + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + "\" InitialValue=\"-1\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
}
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
//--------------------------------------------
//Confirm Password
//--------------------------------------------
if (hasPasswordField)
{
string propertyConfirm = propertyName + "Confirm";
controls.Append("\n\t\t\t\t\t<td class=\"Text\">" + ResourcesTesxtsBuilder.AddUserText(propertyConfirm, TextType.HtmlClassic));
if (!column.AllowNulls)
{
controls.Append("<span class=\"RequiredField\"><asp:Label runat=\"server\" Text=\"*\" /></span>");
}
controls.Append("</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
controls.Append("\n\t\t\t\t\t\t<asp:TextBox MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" id=\"txt" + propertyConfirm + "\" runat=\"server\" TextMode=\"Password\" CssClass=\"Controls\" ValidationGroup=\"" + Table + "\"></asp:TextBox>");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator Display=\"Dynamic\" id=\"rfv" + propertyConfirm + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"txt" + propertyName + "\" ValidationGroup=\"" + Table + "\" Text=\"*\"></asp:RequiredFieldValidator>");
}
controls.Append("\n\t\t\t\t\t\t <asp:CompareValidator ID=\"cv" + propertyConfirm + "\" runat=\"server\" ControlToCompare=\"txt" + propertyName + "\" ControlToValidate=\"txt" + propertyConfirm + "\" ErrorMessage=\"" + ResourcesTesxtsBuilder.AddUserText("InvalidConfirmPassord", TextType.ServerControl) + "\" Text=\"" + ResourcesTesxtsBuilder.AddUserText("InvalidConfirmPassord", TextType.ServerControl) + "\" ValidationGroup=\"" + Table + "\"></asp:CompareValidator>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
hasPasswordField = false;
}
}
}
}
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Result\" align=\"center\" colspan=\"2\">");
//New
controls.Append("\n\t\t\t\t\t\t<asp:HyperLink ID=\"hlCancel\" ImageUrl=\"/App_Design/Admin/Icons/Buttons/Cancel.jpg\" runat=\"server\" Text=\"" + ResourcesTesxtsBuilder.AddAdminGlobalText("Cancel", TextType.ServerControl) + "\" NavigateUrl=\"default.aspx\"></asp:HyperLink>");
controls.Append("\n\t\t\t\t\t\t<asp:ImageButton ID=\"ibtnCreateThenNew\" ImageUrl=\"/App_Design/Admin/Icons/Buttons/CreateNew.png\" runat=\"server\" AlternateText=\"" + ResourcesTesxtsBuilder.AddAdminGlobalText("CreateThenNew", TextType.ServerControl) + "\" onclick=\"ibtnCreateThenNew_Click\" ValidationGroup=\"" + Table + "\" />");
controls.Append("\n\t\t\t\t\t\t<asp:ImageButton ID=\"ibtnCreateThenFinish\" ImageUrl=\"/App_Design/Admin/Icons/Buttons/CreateFinish.png\" runat=\"server\" AlternateText=\"<" + ResourcesTesxtsBuilder.AddAdminGlobalText("CreateThenFinish", TextType.ServerControl) + "\" onclick=\"ibtnCreateThenFinish_Click\" ValidationGroup=\"" + Table + "\" />");
//OLD
//controls.Append("\n\t\t\t\t\t\t<asp:Button id=\"btnCreate\" runat=\"server\" Width=\"100px\" Text=\"\" CssClass=\"Button\" OnClick=\"btnCreate_Click\" ValidationGroup=\"" + Table + "\"></asp:Button>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
//
return(controls.ToString());
}
//
private string GenerateControls()
{
StringBuilder controls = new StringBuilder();
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Result\" align=\"center\" colspan=\"2\">");
controls.Append("\n\t\t\t\t\t\t<asp:Label id=\"lblResult\" runat=\"server\"></asp:Label>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
string datatype;
foreach (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);
if (datatype == "bool")
{
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
controls.Append("\n\t\t\t\t\t\t<asp:CheckBox id=\"cb" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" ValidationGroup=\"" + ClassName + "\" ></asp:CheckBox>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
{
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
//FREETEXTBOX
controls.Append("\n\t\t\t\t\t\t<FTB:FREETEXTBOX id=\"ftb" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" TextDirection=\"RightToLeft\" ");
controls.Append("\n\t\t\t\t\t\tToolbarLayout=\"Bold,Italic,Underline,Strikethrough,Superscript,Subscript;");
controls.Append("\n\t\t\t\t\t\tJustifyLeft,JustifyRight,JustifyCenter,JustifyFull;");
controls.Append("\n\t\t\t\t\t\tCut,Copy,Paste,Delete,Undo,Redo,Print,Save,ieSpellCheck|");
controls.Append("\n\t\t\t\t\t\tParagraphMenu,FontFacesMenu,FontSizesMenu,FontForeColorsMenu,FontBackColorsMenu,FontForeColorPicker,FontBackColorPicker|StyleMenu,SymbolsMenu,InsertHtmlMenu|InsertRule,InsertDate,InsertTime|WordClean|");
controls.Append("\n\t\t\t\t\t\tCreateLink,Unlink;RemoveFormat,BulletedList,NumberedList,Indent,Outdent;InsertTable,EditTable,InsertTableRowBefore,InsertTableRowAfter,DeleteTableRow,InsertTableColumnBefore,InsertTableColumnAfter,DeleteTableColumn|\"");
controls.Append("\n\t\t\t\t\t\tSupportFolder=\"/phyEditorImages/FreeTextBox/\" ButtonSet=\"NotSet\" Width=\"450px\" ButtonWidth=\"21\"></FTB:FREETEXTBOX>"); //
//-----------
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
//
IshasFreeTextBoxControl = true;
}
else if (datatype != "byte[]" && datatype != "Object" && datatype != "Guid")
{
TableConstraint cnstr = SqlProvider.obj.GetParentColumn(column.Name);
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
if (cnstr == null)
{
controls.Append("\n\t\t\t\t\t\t<asp:TextBox id=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" CssClass=\"Control\" MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" ValidationGroup=\"" + ClassName + "\" ></asp:TextBox>");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator id=\"rfv" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" ValidationGroup=\"" + ClassName + "\">ÃÏÎá åÐÇ ÇáÈíÇä</asp:RequiredFieldValidator>");
}
}
else
{
controls.Append("\n\t\t\t\t\t\t<asp:DropDownList id=\"ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + "\" runat=\"server\" CssClass=\"Control\" ValidationGroup=\"" + ClassName + "\" ></asp:DropDownList>");
}
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
}
}
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Result\" align=\"center\" colspan=\"2\">");
controls.Append("\n\t\t\t\t\t\t<asp:Button id=\"btnCreate\" runat=\"server\" Width=\"100px\" Text=\"ÅÖÇÝÉ\" CssClass=\"Submit\" OnClick=\"btnCreate_Click\" ValidationGroup=\"" + ClassName + "\"></asp:Button>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
return(controls.ToString());
}
//
protected string GenerateControls()
{
StringBuilder controls = new StringBuilder();
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Result\" align=\"center\" colspan=\"2\">");
controls.Append("\n\t\t\t\t\t\t<asp:Label id=\"lblResult\" runat=\"server\"></asp:Label>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
string datatype;
int coulmnNo = 0;
foreach (SQLDMO.Column column in Fields)
{
coulmnNo = coulmnNo + 1;
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);
//dateTime
if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.DateTime)
{
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\"><script language=\"javascript\" type=\"text/javascript\" src=\"/sitescripts/datetimepicker.js\"></script>");
controls.Append("\n\t\t\t\t\t\t<input id=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" class=\"Control\" style=\"width:250px\" type=\"text\" readonly=\"readonly\" /><a href=\"javascript:NewCal('ctl00$BasicContent$txt" + Globals.GetProgramatlyName(column.Name) + "\','ddmmyyyy')\"><img src=\"/images/cal.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"ÇÎÊÑ ÇáÊÇÑíÎ\"></a>");
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<anthem:RequiredFieldValidator id=\"rfv" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" ValidationGroup=\"" + ClassName + "\">*</anthem:RequiredFieldValidator>");
}
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
//dateTime
else if (datatype == "bool")
{
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
controls.Append("\n\t\t\t\t\t\t<asp:CheckBox id=\"cb" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" ValidationGroup=\"" + ClassName + "\"></asp:CheckBox>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
else if (Globals.GetSqlDataType(column.Datatype) == SqlDbType.NText)
{
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
//FREETEXTBOX
#region OlD FREE
//controls.Append("\n\t\t\t\t\t\t<FTB:FREETEXTBOX id=\"ftb" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" TextDirection=\"RightToLeft\" ");
//controls.Append("\n\t\t\t\t\t\tToolbarLayout=\"Bold,Italic,Underline,Strikethrough,Superscript,Subscript;");
//controls.Append("\n\t\t\t\t\t\tJustifyLeft,JustifyRight,JustifyCenter,JustifyFull;");
//controls.Append("\n\t\t\t\t\t\tCut,Copy,Paste,Delete,Undo,Redo,Print,Save,ieSpellCheck|");
//controls.Append("\n\t\t\t\t\t\tParagraphMenu,FontFacesMenu,FontSizesMenu,FontForeColorsMenu,FontBackColorsMenu,FontForeColorPicker,FontBackColorPicker|StyleMenu,SymbolsMenu,InsertHtmlMenu|InsertRule,InsertDate,InsertTime|WordClean|");
//controls.Append("\n\t\t\t\t\t\tCreateLink,Unlink;RemoveFormat,BulletedList,NumberedList,Indent,Outdent;InsertTable,EditTable,InsertTableRowBefore,InsertTableRowAfter,DeleteTableRow,InsertTableColumnBefore,InsertTableColumnAfter,DeleteTableColumn|\"");
//controls.Append("\n\t\t\t\t\t\tSupportFolder=\"/phyEditorImages/FreeTextBox/\" ButtonSet=\"NotSet\" Width=\"450px\" ButtonWidth=\"21\"></FTB:FREETEXTBOX>"); //
controls.Append("\n\t\t\t\t\t\t<fckeditorv2:fckeditor id=\"fck" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\"></fckeditorv2:fckeditor>");
#endregion
//-----------
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
IshasFreeTextBoxControl = true;
}
else if (datatype != "byte[]" && datatype != "Object" && datatype != "Guid")
{
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Title\">" + column.Name + "</td>");
controls.Append("\n\t\t\t\t\t<td class=\"Control\">");
if (cnstr == null)
{
#region old
//controls.Append("\n\t\t\t\t\t\t<asp:TextBox id=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" CssClass=\"Control\" ValidationGroup=\"" + ClassName + "\"></asp:TextBox>");
//if (!column.AllowNulls)
// controls.Append("\n\t\t\t\t\t\t<asp:RequiredFieldValidator id=\"rfv" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" ValidationGroup=\"" + ClassName + "\">ÃÏÎá åÐÇ ÇáÈíÇä</asp:RequiredFieldValidator>");
#endregion
if (Globals.GetTextBoxMaxLength(column) > 499)
{
controls.Append("\n\t\t\t\t\t\t<anthem:TextBox TextMode=\"MultiLine\" id=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" CssClass=\"Control\" maxlengthS=\"" + Globals.GetTextBoxMaxLength(column) + "\" MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" ValidationGroup=\"" + ClassName + "\" onkeyup=\"return ismaxlength(this,document.forms[0].thelength" + coulmnNo + ")\" onfocus=\"return ismaxlength(this,document.forms[0].thelength" + coulmnNo + ")\" height=150 width=350 ></anthem:TextBox>");
controls.Append("\n\t\t\t\t\t\t<input type=\"text\" class=\"Control\" name=\"thelength" + coulmnNo + "\" id=\"thelength" + coulmnNo + "\" style=\"height: 20px; width: 40px;\" disabled> <script src=\"/SiteScripts/textarea.js\"></script>");
}
else
{
controls.Append("\n\t\t\t\t\t\t<anthem:TextBox id=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" CssClass=\"Control\" MaxLength=\"" + Globals.GetTextBoxMaxLength(column) + "\" ValidationGroup=\"" + ClassName + "\" ></anthem:TextBox>");
}
if (!column.AllowNulls)
{
controls.Append("\n\t\t\t\t\t\t<anthem:RequiredFieldValidator id=\"rfv" + Globals.GetProgramatlyName(column.Name) + "\" runat=\"server\" ErrorMessage=\"*\" ControlToValidate=\"txt" + Globals.GetProgramatlyName(column.Name) + "\" ValidationGroup=\"" + ClassName + "\">*</anthem:RequiredFieldValidator>");
}
}
else
{
controls.Append("\n\t\t\t\t\t\t<asp:DropDownList id=\"ddl" + Globals.GetProgramatlyName(cnstr.ParentTable) + "\" runat=\"server\" CssClass=\"Control\" ValidationGroup=\"" + ClassName + "\"></asp:DropDownList>");
}
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
}
}
}
controls.Append("\n\t\t\t\t<tr>");
controls.Append("\n\t\t\t\t\t<td class=\"Result\" align=\"center\" colspan=\"2\">");
controls.Append("\n\t\t\t\t\t\t<asp:Button id=\"btnUpdate\" runat=\"server\" Width=\"100px\" Text=\"ÊÚÏíá\" CssClass=\"Submit\" OnClick=\"btnUpdate_Click\" ValidationGroup=\"" + ClassName + "\"></asp:Button>");
controls.Append("\n\t\t\t\t\t</td>");
controls.Append("\n\t\t\t\t</tr>");
//
return(controls.ToString());
}