private void CreateLeftMenu()
{
DataClassesCmsDataContext db = new DataClassesCmsDataContext();
List <ReviseResourceValue> LRRV = db.ReviseResourceValues.ToList();
List <LOV_ContentsGroup> LLCG = db.LOV_ContentsGroups.ToList();
List <ReviseResourceKey> LRRK = db.ReviseResourceKeys.OrderBy(x => x.KeyTitle).ToList();
foreach (LOV_ContentsGroup LCG in LLCG)
{
TreeNode TN = new TreeNode(LCG.Name, "parentMenu");
this.selectionTree.Nodes.Add(TN);
TN.Expand();
TN.SelectAction = TreeNodeSelectAction.Expand;
foreach (ReviseResourceKey RRK in LRRK)
{
if (RRK.ContentsGroupID.Equals(LCG.LOV_ContentsGroupID))
{
string title = RRK.KeyTitle.Equals("") ? RRK.ResourceKey : RRK.KeyTitle;
TreeNode TNsub = new TreeNode(title, db.ReviseResourceKeys.Where(p => p.ResourceKeyID.Equals(RRK.ResourceKeyID)).First().ResourceKeyID.ToString());
TN.ChildNodes.Add(TNsub);
}
}
}
selectionTree.CollapseAll();
}
/// <summary>
/// text item in existing language added to key
/// </summary>
private void ModifyKeyAndValue()
{
var db = new DataClassesCmsDataContext();
var val = db.ReviseResourceValues.
Single(p => p.ResourceKeyID.Equals(HiddenSubmitID.Value) && p.CultureCode.Equals(HiddenCultureCode.Value));
val.ResourceValue = editor.Visible ? editor.Value : simpleEditor.Text;
db.SubmitChanges();
}
protected void submitContent(object sender, EventArgs e)
{
var db = new DataClassesCmsDataContext();
List <ReviseResourceValue> LRRV = db.ReviseResourceValues.Where(p => p.ResourceKeyID.Equals(hiddenSubmitID.Value)).ToList();
if (editor.Visible)
{
LRRV.First().ResourceValue = editor.Value;
}
if (simpleEditor.Visible)
{
LRRV.First().ResourceValue = simpleEditor.Text;
}
db.SubmitChanges();
btnCancel.Enabled = false;
}
/// <summary>
/// new language added to key
/// </summary>
private void InsertValue()
{
var db = new DataClassesCmsDataContext();
// retrieving to key
var key = db.ReviseResourceKeys.Single(x => x.ResourceKeyID.Equals(HiddenSubmitID.Value));
// creating text in new language
var value = new ReviseResourceValue()
{
CultureCode = LanguageList.SelectedValue,
ResourceKeyID = key.ResourceKeyID,
ResourceValue = editor.Visible ? editor.Value : simpleEditor.Text
};
key.ReviseResourceValues.Add(value);
db.SubmitChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
db = new DataClassesCmsDataContext();
cultures = new DataClassesCultureDataContext().LOV_Cultures;
textKeys = db.ReviseResourceKeys.OrderBy(x => x.KeyTitle);
textValues = db.ReviseResourceValues;
textGroups = db.LOV_ContentsGroups;
if (!IsPostBack)
{
CreateTreeView();
SubmitButtonStyle.Visible = false;
editor.Visible = false;
displayTitleDescription.Visible = false;
IntroductionDisplay.Visible = true;
SubmitButtonStyle.Visible = false;
}
}
protected void selectionChange(Object sender, EventArgs e)
{
if (!selectionTree.SelectedNode.Value.Equals("parentMenu"))
{
var db = new DataClassesCmsDataContext();
List <ReviseResourceValue> LRRV = db.ReviseResourceValues.Where(p => p.ResourceKeyID.Equals(selectionTree.SelectedNode.Value)).ToList();
List <ReviseResourceKey> LRRK = db.ReviseResourceKeys.Where(p => p.ResourceKeyID.Equals(selectionTree.SelectedNode.Value)).ToList();
editor.Value = LRRV.First().ResourceValue;
hiddenSubmitID.Value = selectionTree.SelectedNode.Value;
lblTitle.Text = LRRK.First().KeyTitle;
lblDescription.Text = LRRK.First().KeyDescription;
displayTitleDescription.Visible = true;
IntroductionDisplay.Visible = false;
descriptionLabel.Visible = (lblDescription.Text.Length > 0);
if (LRRK.First().AllowHTML)
{
editor.Visible = true;
simpleEditor.Visible = false;
infoLabel.Visible = false;
editor.Value = LRRV.First().ResourceValue;
}
else
{
simpleEditor.Visible = true;
infoLabel.Visible = true;
editor.Visible = false;
simpleEditor.Text = LRRV.First().ResourceValue;
}
SubmitButtonStyle.Visible = true;
}
}
