private void BindRealTag(String SAID)
{
using (SATagMapDataAccess DataAccess = new SATagMapDataAccess()) {
TagRepeater.DataSource = DataAccess.GetSATagMaps(SAID);
TagRepeater.DataBind();
}
}
public void Populate(string linkUrl)
{
if (TicketToDisplay != null)
{
TicketAttachmentsDataSource.WhereParameters["TicketId"].DefaultValue = TicketToDisplay.TicketId.ToString();
AttachmentsRepeater.DataSourceID = "TicketAttachmentsDataSource";
AttachmentsRepeater.DataBind();
TicketId.Text = TicketToDisplay.TicketId.ToString();
TicketId.NavigateUrl = linkUrl;
TicketTitle.Text = TicketToDisplay.Title;
TicketTitle.NavigateUrl = linkUrl;
if (TicketToDisplay.IsHtml)
{
Details.Text = TicketToDisplay.Details;
}
else
{
var md = new Markdown();
Details.Text = md.Transform(TicketToDisplay.Details, true);
}
Category.Text = TicketToDisplay.Category;
//Category.NavigateUrl = string.Format("~/TicketCenter.aspx?View=tagsandcategories&Category={0}", TicketToDisplay.Category);
TicketType.Text = TicketToDisplay.Type;
TicketType.NavigateUrl = linkUrl;
CreatedBy.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.CreatedBy);
CreatedDate.Text = TicketToDisplay.CreatedDate.ToString("g");
Owner.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.Owner);
AssignedTo.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.AssignedTo);
//AssignedTo.NavigateUrl = string.Format("~/TicketCenter.aspx?View=assigned&User={0}", TicketToDisplay.AssignedTo);
CurrentStatus.Text = TicketToDisplay.CurrentStatus;
//CurrentStatus.NavigateUrl = string.Format("~/TicketCenter.aspx?View=status&Status={0}", TicketToDisplay.CurrentStatus.Replace(" ", string.Empty).ToLowerInvariant());
CurrentStatusBy.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.CurrentStatusSetBy);
CurrentStatusDate.Text = TicketToDisplay.CurrentStatusDate.ToString("g");
LastUpdateBy.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.LastUpdateBy);
LastUpdateDate.Text = TicketToDisplay.LastUpdateDate.ToString("g");
Priority.Text = TicketToDisplay.Priority;
AffectsCustomer.Text = (TicketToDisplay.AffectsCustomer) ? "Yes" : "No";
PublishedToKb.Text = (TicketToDisplay.PublishedToKb) ? "Yes" : "No";
var Tags = from t in TicketToDisplay.TicketTags
select new
{
//Url = string.Format("~/TicketCenter.aspx?View=tagsandcategories&TagName={0}", t.TagName),
TagName = t.TagName
};
TagRepeater.DataSource = Tags;
TagRepeater.DataBind();
CommentLogRepeater.DataSource = TicketToDisplay.TicketComments.OrderByDescending(tc => tc.CommentedDate);
CommentLogRepeater.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
IList <Tag> list = TagService.GetInstance().GetTag(null);
TagRepeater.DataSource = list;
TagRepeater.DataBind();
News news = new News();
news.Title = "2";
IList <News> listNews = NewsService.GetInstance().GetNews(news);
NewsRepeater.DataSource = listNews;
NewsRepeater.DataBind();
}
public void DataBaseWork(int id)
{
PageWaif = new Waifu();
bool res = PageWaif.ReadFromBase(id);
if (res)
{
Comments.Data = PageWaif.Comments;
ChapterRepeater.DataSource = PageWaif.Chapters;
TagRepeater.DataSource = PageWaif.FormatTags;
TagRepeater.DataBind();
ChapterRepeater.DataBind();
}
else
{
Server.Transfer("MainPage.aspx", true);
Response.Write("Base error");
}
}
public void LoadTags()
{
using (var _connection = new SqlConnection(Global.WaifString))
{
_connection.Open();
using (var cmd = new SqlCommand("SELECT TagName FROM WaifuTags ORDER BY Popularity DESC", _connection))
{
var rd = cmd.ExecuteReader();
while (rd.Read())
{
FormatedTags.Add(rd["TagName"].ToString());
}
rd.Close();
}
}
TagRepeater.DataSource = FormatedTags;
TagRepeater.DataBind();
TagsRepeaterM.DataSource = FormatedTags;
TagsRepeaterM.DataBind();
}
public void DataBaseWork(int id)
{
PageWaif = new Waifu();
bool res = PageWaif.ReadFromBase(id);
if (res)
{
using (_connection = new SqlConnection(Global.WaifString))
{
_connection.Open();
using (var cmd = new SqlCommand("SELECT TOP 3 Id, Name, Image, Popularity FROM Waifu ORDER BY Popularity DESC",
_connection))
{
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
TopPopWaif.Add(new WaifuLight(rd) as LightElement);
}
}
}
using (var cmd = new SqlCommand("SELECT TOP 3 w.Id, w.Name, w.Image, " +
"(SELECT COUNT(f.Id) FROM Favorites as f WHERE f.WaifuId = w.Id) " +
"as Favority FROM Waifu as w ORDER BY Favority DESC", _connection))
{
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
var temp = new WaifuLight(rd);
temp.Popularity = temp.Favority;
TopFavWaif.Add(temp as LightElement);
}
}
}
}
var redacted = PageWaif.Chapters.Select(x =>
{
x.Elements = x.Elements.Select(y =>
{
if (!String.IsNullOrWhiteSpace(y.Title))
{
y.Title += " : ";
}
return(y);
}).ToList();
return(x);
}).ToList();
ChapterRepeater.DataSource = redacted;
TagRepeater.DataSource = PageWaif.OurTags;
TagRepeater.DataBind();
ChapterRepeater.DataBind();
FavListControl.Data = TopFavWaif;
PopListControl.Data = TopPopWaif;
}
else
{
Response.Redirect("/error/404");
}
}
private void PopulateDisplay()
{
if (TicketToDisplay != null)
{
DisplayActivityButtons();
TicketId.Text = TicketToDisplay.TicketId.ToString();
TicketTitle.Text = TicketToDisplay.Title;
if (TicketToDisplay.IsHtml)
{
Details.Text = TicketToDisplay.Details;
}
else
{
var md = new Markdown();
Details.Text = md.Transform(TicketToDisplay.Details, true);
}
Category.Text = TicketToDisplay.Category;
Category.NavigateUrl = string.Format("~/TicketSearch.aspx?cat={0}", Page.Server.UrlEncode(TicketToDisplay.Category));
TicketType.Text = TicketToDisplay.Type;
CreatedBy.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.CreatedBy);
CreatedDate.Text = TicketToDisplay.CreatedDate.ToString("g");
Owner.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.Owner);
if (!string.IsNullOrEmpty(TicketToDisplay.Owner))
{
Owner.NavigateUrl = string.Format("~/TicketSearch.aspx?owner={0}", Page.Server.UrlEncode(TicketToDisplay.Owner));
}
AssignedTo.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.AssignedTo);
if (!string.IsNullOrEmpty(TicketToDisplay.AssignedTo))
{
AssignedTo.NavigateUrl = string.Format("~/TicketSearch.aspx?assign={0}", Page.Server.UrlEncode(TicketToDisplay.AssignedTo));
}
CurrentStatus.Text = TicketToDisplay.CurrentStatus;
CurrentStatus.NavigateUrl = string.Format("~/TicketSearch.aspx?status={0}", Page.Server.UrlEncode(TicketToDisplay.CurrentStatus));
CurrentStatusBy.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.CurrentStatusSetBy);
CurrentStatusDate.Text = TicketToDisplay.CurrentStatusDate.ToString("g");
LastUpdateBy.Text = SecurityManager.GetUserDisplayName(TicketToDisplay.LastUpdateBy);
LastUpdateDate.Text = TicketToDisplay.LastUpdateDate.ToString("g");
Priority.Text = TicketToDisplay.Priority;
if (!string.IsNullOrEmpty(TicketToDisplay.Priority))
{
Priority.NavigateUrl = string.Format("~/TicketSearch.aspx?priority={0}", Page.Server.UrlEncode(TicketToDisplay.Priority));;
}
AffectsCustomer.Text = (TicketToDisplay.AffectsCustomer) ? "Yes" : "No";
TicketAttachmentsControl.Refresh();
var Tags = from t in TicketToDisplay.TicketTags
select new
{
Url = string.Format("~/TicketSearch.aspx?tag={0}", Page.Server.UrlEncode(t.TagName)),
TagName = t.TagName
};
TagRepeater.DataSource = Tags;
TagRepeater.DataBind();
CommentLogRepeater.DataSource = TicketToDisplay.TicketComments.OrderByDescending(tc => tc.CommentedDate);
CommentLogRepeater.DataBind();
}
}
