public void UpdateImagesOrder(Tag tag, int startid, int endid)
{
bool isMovedDown = startid < endid ? true : false;
int temp_start = startid < endid ? startid : endid;
int temp_end = startid < endid ? endid : startid;
var imageTagList = (from imgTag in DatabaseContext.ImageTags
where imgTag.Tag.TagId == tag.TagId
orderby imgTag.OrderNumber
select imgTag);
foreach (Westgate.Data.ImageTag imgTag in imageTagList)
{
if (imgTag.OrderNumber == startid)
{
imgTag.OrderNumber = endid;
continue;
}
if (isMovedDown)
{
if (imgTag.OrderNumber > temp_start && imgTag.OrderNumber <= temp_end)
imgTag.OrderNumber--;
}
else
{
if (imgTag.OrderNumber >= temp_start && imgTag.OrderNumber < temp_end)
imgTag.OrderNumber++;
}
}
DatabaseContext.SaveChanges();
}
private void SetImagesOrderNumber(Tag tag)
{
var imageTagList = (from imgTag in DatabaseContext.ImageTags
where imgTag.Tag.TagId == tag.TagId
orderby imgTag.OrderNumber
select imgTag);
int orderNumber = 1;
foreach (Westgate.Data.ImageTag imgTag in imageTagList)
{
imgTag.OrderNumber = orderNumber++;
}
DatabaseContext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Tag allTag = new Tag
{
TagId = 0,
Name = "All"
};
List<Tag> taglist = (from row in DatabaseContext.Tags where row.ShowInTabs orderby row.OrderNumber select row).ToList();
taglist.Insert(0, allTag);
Repeater2.DataSource = taglist;
Repeater2.DataBind();
}
if (Request["tagId"] != null)
{
int tagId = int.Parse(Request["tagId"]);
Tag tag = (from t in DatabaseContext.Tags
where t.TagId == tagId
select t).FirstOrDefault();
SetGallery(tagId);
if (Request["deleteID"] != null)
{
int imageId = Int32.Parse(Request["deleteID"]);
Westgate.Data.Image img = (from image in DatabaseContext.Images
where image.ImageId == imageId
select image).FirstOrDefault();
var imageTag = (from imgTag in DatabaseContext.ImageTags
where imgTag.ImageId == img.ImageId
&& imgTag.TagId == tagId
select imgTag).FirstOrDefault();
DatabaseContext.ImageTags.DeleteObject(imageTag);
DatabaseContext.SaveChanges();
SetImagesOrderNumber(tag);
// Response.Redirect("~/Admin/Gallery.aspx?tagId=" + tag.TagId);
}
}
else
{
SetGallery();
}
}
protected void AddButton_Click(object sender, EventArgs e)
{
int orderNumber = 1;
var preRecords = (from tag in DatabaseContext.Tags
select tag.OrderNumber).Max();
if (preRecords.Value != null && preRecords.Value > 0)
{
orderNumber = preRecords.Value + 1;
}
Tag TagItem = new Tag
{
Name = NameText.Text,
Description = DescriptionText.Text,
ShowInTabs = RadioButtonYes.Checked,
OrderNumber = orderNumber
};
DatabaseContext.AddToTags(TagItem);
DatabaseContext.SaveChanges();
Response.Redirect("~/Admin/AddTag.aspx?Save=true", false);
}
private void SetTag(Tag tag)
{
if (!tag.IsEditable)
{
this.NameText.Enabled = false;
this.RadioButtonYes.Enabled = false;
this.RadioButtonNo.Enabled = false;
}
}
/// <summary>
/// Create a new Tag object.
/// </summary>
/// <param name="tagId">Initial value of the TagId property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="showInTabs">Initial value of the ShowInTabs property.</param>
/// <param name="isEditable">Initial value of the IsEditable property.</param>
public static Tag CreateTag(global::System.Int32 tagId, global::System.String name, global::System.Boolean showInTabs, global::System.Boolean isEditable)
{
Tag tag = new Tag();
tag.TagId = tagId;
tag.Name = name;
tag.ShowInTabs = showInTabs;
tag.IsEditable = isEditable;
return tag;
}
/// <summary>
/// Deprecated Method for adding a new object to the Tags EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToTags(Tag tag)
{
base.AddObject("Tags", tag);
}
protected void Page_Load(object sender, EventArgs e)
{
Tag allTag = new Tag
{
TagId = 0,
Name = "All"
};
Tag galleryTag = new Tag
{
TagId = 3,
Name = "Gallery"
};
WestgateEntities DatabaseContext = new WestgateEntities();
List<Tag> taglistMain = (from row in DatabaseContext.Tags where row.ShowInTabs orderby row.OrderNumber select row).ToList();
taglistMain.Insert(2, galleryTag);
Repeater1.DataSource = taglistMain;
Repeater1.DataBind();
/*List<Tag> taglistMore = (from row in DatabaseContext.Tags where row.ShowInTabs orderby row.OrderNumber select row).ToList();
if (taglistMore.Count>6)
{
div_repeatermore.Visible = true;
for (int i = 0; i < 6; i++)
{
taglistMore.RemoveAt(0);
}
RepeaterMore.DataSource = taglistMore;
RepeaterMore.DataBind();
}
else
{
div_repeatermore.Visible = false;
}
*/
div_repeatermore.Visible = false;
// Repeater1.DataSource = (from row in DatabaseContext.Tags where row.ShowInTabs orderby row.OrderNumber select row).Take(7);
// Repeater1.DataBind();
//List<Tag> taglist = (from row in DatabaseContext.Tags where row.ShowInTabs orderby row.OrderNumber select row).ToList();
//taglist.Insert(0, allTag);
//Repeater2.DataSource = taglist;
//Repeater2.DataBind();
if (!IsPostBack)
{
//TreeNode categoriesNode = new TreeNode("All");
//categoriesNode.NavigateUrl = "javascript:onGalleryClick()";
//categoriesNode.Expand();
//List<Tag> listTags = (from t in DatabaseContext.Tags orderby t.Name select t).ToList();
//foreach (Tag tag in listTags)
//{
// TreeNode catNode = new TreeNode(tag.Name, tag.TagId.ToString());
// catNode.NavigateUrl = "javascript:onGalleryClick("+tag.TagId+")";
// catNode.CollapseAll();
// categoriesNode.ChildNodes.Add(catNode);
//}
//tvStructure.Nodes.Add(categoriesNode);
}
}
