public string GetAttachedFiles(int pageTemplateId, int columnDefId, int recordId)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
StringBuilder sb = new StringBuilder();
ColumnDef columnDef = SessionService.ColumnDef(columnDefId);
sb.AppendLine("");
var files = Db.FileAttachments.Where(w => w.ColumnDefId == columnDefId && w.RecordId == recordId).OrderBy(o => o.UploadDate);
if (files != null)
{
sb.AppendLine("<select class='site-select-element' id='download" + columnDefId + "_" + recordId + "' onchange='DownloadFile(" + columnDefId + "," + recordId + ")' style='width:" + columnDef.ElementWidth + "px;'>");
sb.AppendLine("<option value=''>Select file to download (" + files.Count() + " files)</option>");
foreach (var file in files)
{
sb.AppendLine("<option value='" + file.FileAttachmentId + "'>" + file.FileName + "</option>");
//sb.AppendLine("<a href='javascript:;' onclick='DownloadFile(" + file.FileAttachmentId + ")'>" + file.FileName + "</a><br>");
}
sb.AppendLine("</select>");
}
return(sb.ToString());
}
}
public void UploadFile(int columnDefId_, int recordId_, HttpPostedFileBase postedFile)
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
using (SourceControlEntities Db = new SourceControlEntities())
{
Db.FileAttachments.Add(new FileAttachment
{
ColumnDefId = columnDefId_,
RecordId = recordId_,
FileName = Path.GetFileName(postedFile.FileName),
FileSize = postedFile.ContentLength,
UploadDate = DateTime.Now,
UploadBy = SessionService.UserId,
ContentType = postedFile.ContentType,
FileData = bytes
});
Db.SaveChanges();
}
}
public ActionResult NoteWindow(int columnDefId, int recordId, int getAll)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
// Get data for the record column
StringBuilder sb = new StringBuilder();
sb.AppendLine("<table class='note-table' style='width:98%;'>");
sb.AppendLine("<tr>");
sb.AppendLine("<td>Date</td>");
sb.AppendLine("<td>Added By</td>");
sb.AppendLine("<td>Note</td>");
sb.AppendLine("</tr>");
var recs = Db.Notes.Where(w => w.ColumnDefId == columnDefId && w.RecordId == recordId).OrderByDescending(o => o.InsertDate);
foreach (var rec in recs)
{
sb.AppendLine("<tr class='note-table-tr'>");
sb.AppendLine("<td>" + rec.InsertDate.ToString("MM/dd/yyyy hh:mm tt") + "</td>");
sb.AppendLine("<td>" + rec.InsertByName + "</td>");
sb.AppendLine("<td>" + rec.NoteText + "</td>");
sb.AppendLine("</tr>");
}
sb.AppendLine("</table>");
ViewBag.DataValue = sb.ToString();
}
return(View());
}
public string GetReportClass()
{
using (SourceControlEntities Db = new SourceControlEntities())
{
List <ValueText> valueTexts = new List <ValueText>();
string reportLibraryPath = AppDomain.CurrentDomain.BaseDirectory + @"ReportLibrary";
if (Directory.Exists(reportLibraryPath))
{
foreach (string file in Directory.GetFiles(reportLibraryPath))
{
if (Path.GetFileName(file).Contains(".cs") && !Path.GetFileName(file).Contains("Designer.cs"))
{
ValueText valueText0 = new ValueText();
valueText0.ValueField = Path.GetFileNameWithoutExtension(file);
valueText0.TextField = Path.GetFileNameWithoutExtension(file);
valueTexts.Add(valueText0);
}
}
}
var json = new JavaScriptSerializer().Serialize(valueTexts);
return(json);
}
}
public ActionResult ChangeHistoryWindow(int pageTemplateId, int recordId)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
// Get data for the record column
StringBuilder sb = new StringBuilder();
sb.AppendLine("<table class='change-history' style='width:98%;'>");
sb.AppendLine("<tr>");
sb.AppendLine("<td>Modified Date</td>");
sb.AppendLine("<td>Updated By</td>");
sb.AppendLine("<td>Changes</td>");
sb.AppendLine("</tr>");
//var recs = Db.ChangeHistories.Where(w => w.PageTemplateId == pageTemplateId && w.RecordId == recordId).OrderByDescending(o => o.InsertDate);
//foreach (var rec in recs)
//{
// sb.AppendLine("<tr class='change-history-tr'>");
// sb.AppendLine("<td>" + rec.InsertDate.ToString("MM/dd/yyyy hh:mm tt") + "</td>");
// sb.AppendLine("<td>" + rec.Username + "</td>");
// sb.AppendLine("<td>" + rec.ChangeHistoryText.Replace("] [", "]<br>[") + "</td>");
// sb.AppendLine("</tr>");
//}
sb.AppendLine("</table>");
ViewBag.DataValue = sb.ToString();
}
return(View());
}
//[HttpPost]
//[ValidateInput(false)]
//public string EditHelp(int helpId, string helpTitle, string helpContent)
//{
// var exe = string.Format("UPDATE Help SET HelpTitle = '{0}', HelpContent = '{1}' WHERE HelpId = {2}", Helper.ToDbString(helpTitle), Helper.ToDbString(helpContent), helpId);
// DataService.Execute(exe);
// return "T";
//}
public string GetHelpOptions()
{
using (SourceControlEntities Db = new SourceControlEntities())
{
List <ValueText> valueTexts = new List <ValueText>();
ValueText valueText0 = new ValueText();
valueText0.ValueField = "0";
valueText0.TextField = "";
valueTexts.Add(valueText0);
var parentHelps = Db.Helps.Where(w => w.ParentId == 0).OrderBy(o => o.HelpOrder).Select(s => new { s.HelpId, s.HelpTitle, s.HasChildren });
foreach (var parentHelp in parentHelps)
{
//ValueText valueText = new ValueText();
//valueText.ValueField = parentHelp.HelpId.ToString();
//valueText.TextField = parentHelp.HelpTitle;
//valueTexts.Add(valueText);
// get children
if ((bool)parentHelp.HasChildren)
{
GetChildrenHelpOptions(parentHelp.HelpId, parentHelp.HelpTitle, ref valueTexts);
}
}
var json = new JavaScriptSerializer().Serialize(valueTexts);
return(json);
}
}
public ActionResult GetHelpDoc(int helpDocId)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var help = Db.Helps.Find(helpDocId);
ViewBag.HelpContent = help.HelpContent;
return(PartialView("_HelpDoc"));
}
//if (HelpDocId > 0)
//{
// StringBuilder sb = new StringBuilder();
// sb.AppendLine("dataBound: function (e) {");
// sb.AppendLine("var treeView = $(\"#treeHelpDoc\").data(\"kendoTreeView\");");
// sb.AppendLine("treeView.expandTo(" + HelpDocId + ");");
// sb.AppendLine("},");
// ViewBag.ExpandTo = sb.ToString();
//}
//else
//{
// ViewBag.ExpandTo = "";
//}
}
public string GetHelpLevel0(string scope, int selectHelpId)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
bool expandAll = false;
string selectHelpIds = "";
if (scope == "ALL")
{
expandAll = true;
}
else if (selectHelpId > 0)
{
selectHelpIds = Db.Database.SqlQuery <string>("dbo.GetHelpParentIds " + selectHelpId).FirstOrDefault();
selectHelpIds = ":" + selectHelpIds.Replace(",", ":").Replace(" ", "") + ":";
}
StringBuilder sb = new StringBuilder();
sb.AppendLine("<ul id='ulHelp0' class='sortULHelp'>");
var helps = Db.Helps.Where(w => w.ParentId == 0).OrderBy(o => o.HelpOrder).Select(s => new { s.HelpId, s.HelpTitle, s.HasChildren, s.IsDoc });
foreach (var help in helps)
{
sb.AppendLine("<li id='liHelp" + help.HelpId + "'>");
if ((bool)help.HasChildren)
{
sb.AppendLine("<span id='expanderHelp" + help.HelpId + "' onclick='ExpandHelp(" + help.HelpId + ")' class='help-expander k-icon " + ((expandAll) ? " k-i-collapse" : " k-i-expand") + "'> </span>");
}
else
{
sb.AppendLine("<span id='expanderHelp" + help.HelpId + "' class='help-spacer'> </span>");
}
if (help.IsDoc)
{
sb.AppendLine("<span class=\'k-sprite doc\'></span>");
}
else
{
sb.AppendLine("<span class=\'k-sprite folder\'></span>");
}
sb.AppendLine("<span class='help-item li-state-default' id='Help0_" + help.HelpId + "' IsDoc='" + help.IsDoc + "' onclick='SelectHelp(this)'>");
sb.AppendLine(help.HelpTitle);
sb.AppendLine("</span>");
if ((expandAll || selectHelpIds.Contains(":" + help.HelpId + ":")) && (bool)help.HasChildren)
{
sb.AppendLine(GetHelpChild(help.HelpId, selectHelpIds, true));
}
sb.AppendLine("</li>");
}
sb.AppendLine("</ul>");
return(sb.ToString());
}
}
public string SortRootMenu(int menuId, int newOrder)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
Db.Database.ExecuteSqlCommand(string.Format("SortRootMenu {0}, {1}", menuId, newOrder));
return("T");
}
}
public FileResult DownloadFile(int fileAttachmentId)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
FileAttachment file = Db.FileAttachments.ToList().Find(p => p.FileAttachmentId == fileAttachmentId);
return(File(file.FileData, file.ContentType, file.FileName));
}
}
public string SortHelp(int parentId, int helpId, int newOrder)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
Db.Database.ExecuteSqlCommand(string.Format("SortHelp {0}, {1}, {2}", parentId, helpId, newOrder));
return("T");
}
}
public string GetPageTemplateOptions()
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var recs = Db.PageTemplates.OrderBy(o => o.TemplateName).Select(s => new { ValueField = s.PageTemplateId, TextField = s.TemplateName, s.TableName });
return(JsonConvert.SerializeObject(recs));
}
}
public string GetDbEntity()
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var recs = Db.DbEntities.OrderBy(o => o.EntityName).Select(s => new { ValueField = s.DbEntityId, TextField = s.EntityName });
return(JsonConvert.SerializeObject(recs));
}
}
public static List <DebugLog> GetDebugLog()
{
using (SourceControlEntities db = new SourceControlEntities())
{
var recs = db.DebugLogs.OrderByDescending(o => o.LogDate).Take(10).ToList();
return(recs);
}
}
public string GetAvailRoleUsers(int id)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
int[] haveIds = Db.UserRoles.Where(w => w.RoleId == id).Select(s => s.UserId).ToArray();
var recs = Db.AppUsers.Where(w => !haveIds.Contains(w.UserId)).OrderBy(o => o.LastName).ThenBy(t => t.FirstName).ToList();
var json = new JavaScriptSerializer().Serialize(recs);
return(json);
}
}
public string GetAssignedRoles(int id)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
int[] haveIds = Db.UserRoles.Where(w => w.UserId == id).Select(s => s.RoleId).ToArray();
var recs = Db.Roles.Where(w => haveIds.Contains(w.RoleId)).OrderBy(o => o.RoleName).ToList();
var json = new JavaScriptSerializer().Serialize(recs);
return(json);
}
}
public string DeleteRootMenu(int menuId)
{
string ids = DataService.GetStringValue("SELECT dbo.GetMenuChildrenIds(" + menuId + ")");
using (SourceControlEntities Db = new SourceControlEntities())
{
Db.Database.ExecuteSqlCommand("DELETE FROM Menu WHERE MenuId IN (" + ids + ");");
SortRootMenu(0, 0);
}
return("T");
}
public string GetLevelOneItems(int menuId)
{
string goesTo = "";
using (SourceControlEntities Db = new SourceControlEntities())
{
StringBuilder sb = new StringBuilder();
var menu = Db.Menus.Find(menuId);
sb.AppendLine("<ul id=\"ul" + menuId + "\">");
if ((bool)menu.HasSubMenu)
{
var subMenus = Db.Menus.Where(w => w.ParentId == menuId).OrderBy(o => o.MenuOrder);
foreach (var subMenu in subMenus)
{
goesTo = (subMenu.TemplateName != null && subMenu.TemplateName.Length > 0) ? subMenu.TemplateName : (subMenu.PageFile.Length > 0) ? subMenu.PageFile : "";
sb.AppendLine("<li id='li" + subMenu.MenuId + "'>");
sb.AppendLine("<table width=\"100%\">");
sb.AppendLine("<tr class='app-menu-submenu'>");
sb.AppendLine("<td class=\"index\" id=\"td" + menuId + "_" + subMenu.MenuId + "_M\" width=\"40%\">");
sb.AppendLine(subMenu.MenuTitle);
sb.AppendLine("</td>");
sb.AppendLine("<td nowrap width=\"40%\">" + goesTo + "</td>");
sb.AppendLine("<td nowrap align='right' width=\"20%\" nowrap>");
sb.AppendLine("<a href='javascript:EditSubMenu(" + subMenu.MenuId + ")'>Edit</a> | ");
if (subMenu.IsSystem)
{
sb.AppendLine("<a href=\"javascript:alert('System menu. Cannot delete.')\">Delete</a>");
}
else
{
sb.AppendLine("<a href='javascript:DeleteSubMenu(" + subMenu.ParentId + "," + subMenu.MenuId + ")'>Delete</a>");
}
sb.AppendLine("</td>");
sb.AppendLine("</tr>");
sb.AppendLine("</table>");
sb.AppendLine("</li>");
}
}
sb.AppendLine("</ul>");
return(sb.ToString());
}
}
public static DbEntity DbEntity(int dbEntityId)
{
if (HttpContext.Current.Session["sec.DbEntity" + dbEntityId] == null)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var dbEntity = Db.Database.SqlQuery <DbEntity>("SELECT * FROM DbEntity WHERE DbEntityId = " + dbEntityId).FirstOrDefault();
HttpContext.Current.Session["sec.DbEntity" + dbEntityId] = dbEntity;
}
}
return((DbEntity)(HttpContext.Current.Session["sec.DbEntity" + dbEntityId]));
}
public string GetHelp(int helpId)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var helpContent = DataService.GetStringValue("SELECT HelpContent FROM Help WHERE HelpId = " + helpId);
if (helpContent != null)
{
return(helpContent);
}
return("");
}
}
public static string GetPrimaryKey(string tableName)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var columnName = Db.Database.SqlQuery <string>("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA + '.' + CONSTRAINT_NAME), 'IsPrimaryKey') = 1 AND TABLE_NAME = '" + tableName + "'").FirstOrDefault();
if (columnName != null)
{
return(columnName);
}
}
return("");
}
public static string GetMenuTreeView(int userId)
{
StringBuilder sb = new StringBuilder();
var json = "";
using (SourceControlEntities Db = new SourceControlEntities())
{
json += "[ { \"id\": -1, \"text\": \"Available Pages\", \"expanded\": \"true\", \"spriteCssClass\": \"rootfolder\", \"items\": [";
var rootMenus = Db.Menus.Where(w => w.ParentId == 0).OrderBy(o => o.MenuOrder);
foreach (var rootMenu in rootMenus)
{
json += "{ \"id\": " + rootMenu.MenuId + ", \"text\": \"" + rootMenu.MenuTitle + "\", \"expanded\": \"true\", \"spriteCssClass\": \"image\", \"items\": [";
//var isRequest = Db.Database.SqlQuery<string>("SELECT CASE IsRequest WHEN 0 THEN '0' ELSE '1' END AS IsRequest FROM UserMenuAccess WHERE UserId = " + userId + " ORDER BY IsRequest").FirstOrDefault();
//if (isRequest == null)
//{
// isRequest = "1";
//}
var subMenus = Db.Database.SqlQuery <MenuModel>("SELECT a.*, b.UserId FROM Menu a LEFT JOIN UserMenuAccess b ON a.MenuId = b.MenuId AND b.UserId = " + userId + " WHERE a.ParentId = " + rootMenu.MenuId + " ORDER BY a.MenuOrder");
foreach (var subMenu in subMenus)
{
if (subMenu.UserId != null)
{
json += "{ \"id\": " + subMenu.MenuId + ", \"text\": \"" + subMenu.MenuTitle + "\", \"spriteCssClass\": \"html\", \"checked\": \"true\" },";
}
else
{
json += "{ \"id\": " + subMenu.MenuId + ", \"text\": \"" + subMenu.MenuTitle + "\", \"spriteCssClass\": \"html\" },";
}
}
if (json.Substring(json.Length - 1, 1) == ",")
{
json = json.Substring(0, json.Length - 1);
}
json += "] },";
}
if (json.Substring(json.Length - 1, 1) == ",")
{
json = json.Substring(0, json.Length - 1);
}
json += "] } ]";
}
return(json);
}
public string IsExistingTable(string tableName)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var rec = Db.Database.SqlQuery <ValueText>("SELECT c.name AS ValueField, c.name AS TextField FROM sys.columns c JOIN sys.objects o ON o.object_id = c.object_id WHERE o.type = 'U' AND o.name = '" + tableName + "' ORDER BY c.name").FirstOrDefault();
if (rec != null)
{
return("T");
}
}
return("F");
}
public string AddHelp(int parentId, string helpTitle, string helpContent, int isDoc)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var helpOrder = Db.Database.SqlQuery <int>("SELECT ISNULL(MAX(HelpOrder), -1) + 1 FROM Help WHERE ParentId = " + parentId).FirstOrDefault();
var exe = string.Format("INSERT INTO Help(ParentId, HelpTitle, HelpContent, HelpOrder, IsDoc) VALUES({0},'{1}','{2}',{3},{4}); SELECT CAST(@@IDENTITY AS int);", parentId, Helper.ToDbString(helpTitle), Helper.ToDbString(helpContent), helpOrder, isDoc);
var helpId = Db.Database.SqlQuery <int>(exe).FirstOrDefault();
return(helpId.ToString());
}
}
public static string GetAccessMenus()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("");
try
{
var levelCount = 0;
var childClasses = "";
using (SourceControlEntities Db = new SourceControlEntities())
{
sb.AppendLine("<table class='table-object'>");
sb.AppendLine("<tr class='table-header'><td>Menu</td><td>Add</td><td>Edit</td><td>Delete</td><td>Download</td><td>Print</td></tr>");
var menus = Db.Menus.Where(w => w.ParentId == 0).OrderBy(o => o.MenuOrder);
foreach (var menu in menus)
{
sb.AppendLine("<tr class='table-parent-record'>");
if (menu.PageFile.Length > 3 || menu.MenuPageTemplateId > 0)
{
sb.AppendLine("<td><input type='checkbox' id='MenuId" + menu.MenuId + "' class='menu-access' value='" + menu.MenuId + "' parentId='0'> " + menu.MenuTitle + "</td>");
sb.AppendLine("<td align='center'><input type='checkbox' id='MenuAdd" + menu.MenuId + "' class='menu-add' value='" + menu.MenuId + "' parentId='0'></td>");
sb.AppendLine("<td align='center'><input type='checkbox' id='MenuEdit" + menu.MenuId + "' class='menu-edit' value='" + menu.MenuId + "' parentId='0'></td>");
sb.AppendLine("<td align='center'><input type='checkbox' id='MenuDelete" + menu.MenuId + "' class='menu-delete' value='" + menu.MenuId + "' parentId='0'></td>");
sb.AppendLine("<td align='center'><input type='checkbox' id='MenuDownload" + menu.MenuId + "' class='menu-download' value='" + menu.MenuId + "' parentId='0'></td>");
sb.AppendLine("<td align='center'><input type='checkbox' id='MenuPrint" + menu.MenuId + "' class='menu-print' value='" + menu.MenuId + "' parentId='0'></td>");
}
else
{
sb.AppendLine("<td colspan='6'><input type='checkbox' id='MenuId" + menu.MenuId + "' class='menu-expand' value='" + menu.MenuId + "' parentId='0'> " + menu.MenuTitle + "</td>");
}
sb.AppendLine("</tr>");
var subMenus = Db.Menus.Where(w => w.ParentId == menu.MenuId).OrderBy(o => o.MenuOrder).ToList();
if (subMenus.Count > 0)
{
levelCount = 0;
childClasses = " childOf" + menu.MenuId;
GetAccessSubMenus(Db, menu.MenuId, subMenus, ref sb, ref levelCount, ref childClasses);
}
}
sb.AppendLine("</table>");
}
}
catch (Exception)
{
return("");
}
return(sb.ToString());
}
public string GetHelpChild(int parentId, string selectHelpIds = "", bool expandAll = false)
{
using (SourceControlEntities Db = new SourceControlEntities())
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("<ul id='ulHelp" + parentId + "' class='sortULHelp'>");
var helps = Db.Helps.Where(w => w.ParentId == parentId).OrderBy(o => o.HelpOrder).Select(s => new { s.HelpId, s.HelpTitle, s.HasChildren, s.IsDoc, s.ParentId });
foreach (var help in helps)
{
sb.AppendLine("<li id='liHelp" + help.HelpId + "'>");
if ((bool)help.HasChildren)
{
sb.AppendLine("<span id='expanderHelp" + help.HelpId + "' onclick='ExpandHelp(" + help.HelpId + ")' class='help-expander k-icon " + ((expandAll) ? " k-i-collapse" : " k-i-expand") + "'> </span>");
}
else
{
sb.AppendLine("<span id='expanderHelp" + help.HelpId + "' class='help-spacer'> </span>");
}
if (help.IsDoc)
{
sb.AppendLine("<span class=\'k-sprite doc\'></span>");
}
else
{
sb.AppendLine("<span class=\'k-sprite folder\'></span>");
}
sb.AppendLine("<span class='help-item li-state-default' id='Help" + help.ParentId + "_" + help.HelpId + "' IsDoc='" + help.IsDoc + "' onclick='SelectHelp(this)'>");
sb.AppendLine(help.HelpTitle);
sb.AppendLine("</span>");
if ((expandAll || selectHelpIds.Contains(":" + help.HelpId + ":")) && (bool)help.HasChildren)
{
sb.AppendLine(GetHelpChild(help.HelpId, selectHelpIds, true));
}
sb.AppendLine("</li>");
}
sb.AppendLine("</ul>");
return(sb.ToString());
}
}
public string DeletePageTemplate(int pageTemplateId)
{
try
{
using (SourceControlEntities Db = new SourceControlEntities())
{
Db.Database.ExecuteSqlCommand("DELETE FROM Menu WHERE MenuPageTemplateId = " + pageTemplateId + ";DELETE FROM PageTemplate WHERE PageTemplateId = " + pageTemplateId + ";DELETE FROM ColumnDef WHERE PageTemplateId = " + pageTemplateId);
}
SessionService.ResetPageSession(pageTemplateId);
return("");
}
catch (Exception ex)
{
return("Unable to process DeletePageTemplate() - " + ex.Message);
}
}
public static string ClearError()
{
try
{
using (SourceControlEntities Db = new SourceControlEntities())
{
Db.Database.ExecuteSqlCommand("TRUNCATE TABLE DebugLog");
Db.SaveChanges();
return("");
}
}
catch (Exception ex)
{
return(ex.StackTrace + ex.Message);
}
}
public string GetParentMenu()
{
using (SourceControlEntities Db = new SourceControlEntities())
{
List <ValueText> valueTexts = new List <ValueText>();
ValueText valueText0 = new ValueText();
valueText0.ValueField = "0";
valueText0.TextField = "Is Root Menu";
valueTexts.Add(valueText0);
var rootMenus = Db.Menus.Where(w => w.ParentId == 0 && w.MenuPageTemplateId == 0 && w.PageFile.Length < 4).OrderBy(o => o.MenuOrder);
foreach (var rootMenu in rootMenus)
{
ValueText valueText1 = new ValueText();
valueText1.ValueField = rootMenu.MenuId.ToString();
valueText1.TextField = rootMenu.MenuTitle;
valueTexts.Add(valueText1);
var subMenus = Db.Menus.Where(w => w.ParentId == rootMenu.MenuId && w.MenuPageTemplateId == 0 && w.PageFile.Length < 4).OrderBy(o => o.MenuOrder);
foreach (var subMenu in subMenus)
{
ValueText valueText2 = new ValueText();
valueText2.ValueField = subMenu.MenuId.ToString();
valueText2.TextField = rootMenu.MenuTitle + " > " + subMenu.MenuTitle;
valueTexts.Add(valueText2);
if ((bool)subMenu.HasSubMenu)
{
var lastSubMenus = Db.Menus.Where(w => w.ParentId == subMenu.MenuId && w.MenuPageTemplateId == 0 && w.PageFile.Length < 4).OrderBy(o => o.MenuOrder);
foreach (var lastSubMenu in lastSubMenus)
{
ValueText valueText3 = new ValueText();
valueText3.ValueField = lastSubMenu.MenuId.ToString();
valueText3.TextField = rootMenu.MenuTitle + " > " + subMenu.MenuTitle + " > " + lastSubMenu.MenuTitle;
valueTexts.Add(valueText3);
}
}
}
}
var json = new JavaScriptSerializer().Serialize(valueTexts);
return(json);
}
}
public string ChangeDataLength(int pageTemplateId, int columnDefId, string currentColumnName, string currentDataType, int currentDataLength, int formDataLength)
{
try
{
using (SourceControlEntities Db = new SourceControlEntities())
{
var pageTemplate = Db.PageTemplates.Find(pageTemplateId);
Db.Database.ExecuteSqlCommand("ALTER TABLE " + pageTemplate.TableName + " ALTER COLUMN " + currentColumnName + " " + Helper.GetDBDataType(currentDataType) + " (" + formDataLength + ")");
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
