public void bindgriddata()
{
DataSet ds = new DataSet();
NewsService.FeedServiceClient client = new NewsService.FeedServiceClient();
ds = client.GetNews();
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet ds = new DataSet();
NewsService.FeedServiceClient client = new NewsService.FeedServiceClient();
ds = client.GetNews();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
DataRow r = ds.Tables[0].Rows[i];
Label title = new Label();
title.Text = "<b><p style=font-size:30px;font-family:verdana>" + r.Field <String>(2) + "</p></b>";
newspanel.Controls.Add(title);
Label author = new Label();
author.Text = "<p style=color:red;font-size:12px>By " + r.Field <String>(1) + "</p>";
newspanel.Controls.Add(author);
Label date = new Label();
date.Text = "<p>Updated on : " + r.Field <DateTime>(3) + "</p>";
newspanel.Controls.Add(date);
Image image = new Image();
byte[] bytes = r.Field <byte[]>(6);
string strBase64 = Convert.ToBase64String(bytes);
image.ImageUrl = "data:Image/png;base64," + strBase64;
image.Width = 300;
image.Height = 300;
newspanel.Controls.Add(image);
Label newline1 = new Label();
newline1.Text = "<br><br>";
newspanel.Controls.Add(newline1);
Label content = new Label();
content.Text = "<p width:500px;height:100px;border:1px solid #000; style=color:grey;font-family:Courier New>" + r.Field <String>(4) + "</p>";
newspanel.Controls.Add(content);
string url = r.Field <String>(7);
Label link = new Label();
link.Text = "Video Link : <a href=" + url + " target = blank>" + url + "</a>" + "<br><br>";
newspanel.Controls.Add(link);
Label hrline = new Label();
hrline.Text = "<hr>";
newspanel.Controls.Add(hrline);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
}
}
protected void dltbtn_Click(object sender, EventArgs e)
{
NewsService.FeedServiceClient client = new NewsService.FeedServiceClient();
NewsService.News news = new NewsService.News();
news.NewsID = TextBox.Text.Trim();
string result = client.DeleteNews(news);
if (result == "News Deleted Successfully!")
{
bindgriddata();
deletelabel.Text = "News ID : " + TextBox.Text.Trim() + " Deleted Successfully !";
}
else
{
deletelabel.Text = "News ID : " + TextBox.Text.Trim() + " Not Found !";
}
}
protected void add_news_Click(object sender, EventArgs e)
{
try
{
byte[] bytes;
NewsService.News nw = new NewsService.News();
nw.NewsID = newsId.Text;
nw.Authorname = author.Text;
nw.Title = ntitle.Text;
nw.PublishDate = Convert.ToDateTime(publishdate.Text);
nw.Content = content.Text;
HttpPostedFile postedFile = imageUpload.PostedFile;
string filename = Path.GetFileName(postedFile.FileName);
string fileExtension = Path.GetExtension(filename);
int fileSize = postedFile.ContentLength;
nw.Category = categorylist.SelectedValue;
nw.VideoLink = link.Text;
Console.WriteLine(fileExtension);
if (fileExtension.ToLower() == ".jpeg" || fileExtension.ToLower() == ".png" || fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".jfif")
{
Stream stream = postedFile.InputStream;
BinaryReader binaryReader = new BinaryReader(stream);
bytes = binaryReader.ReadBytes((int)stream.Length);
nw.NewsImage = bytes;
Console.WriteLine(bytes);
NewsService.FeedServiceClient client = new NewsService.FeedServiceClient();
success.Text = "News Id : " + nw.NewsID + " " + client.AddNews(nw);
}
else
{
error.Text = "Image may be not in proper format.";
}
}
catch (Exception ex)
{
success.Text = "News ID must be unique! or Error";
}
}