protected void lnkBContentFile_Command(object sender, CommandEventArgs e)
{
try
{
dbo_NewsClass2 _news = dbo_NewsDataClass2.Select_Record(hdfNEWS_ID.Value);
if (string.IsNullOrEmpty(_news.Content_FileName) || string.IsNullOrEmpty(_news.Content_FileType))
{
}
else
{
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = _news.Content_FileType;
Response.AddHeader("content-disposition", "attachment;filename=" + _news.Content_FileName);
Response.BinaryWrite(_news.Content_File);
Response.Flush();
Response.End();
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
string News_ID = Request.QueryString["News_ID"];
hdfNEWS_ID.Value = News_ID;
// Session.Remove("News_ID");
dbo_NewsClass2 _news = dbo_NewsDataClass2.Select_Record(News_ID);
if (!string.IsNullOrEmpty(_news.Content_FileName))
{
lnkBContentFile.Text = _news.Content_FileName;
lnkBContentFile.CommandArgument = News_ID;
}
else
{
lnkBContentFile.Visible = false;
}
if (_news.Photo_MemoryStream != null)
{
imgNewsPhoto.ImageUrl = string.Format("data:image/png;base64,{0}", Convert.ToBase64String(_news.Photo_MemoryStream, 0, _news.Photo_MemoryStream.Length));
}
txtSubjectDiv.InnerHtml = _news.Subject;
// txtSubjectH1.Text =
txtContentDiv.InnerHtml = _news.Content;
txtStart_Effective_Date.Text = _news.Start_Date.Value.ToShortDateString();
txtEnd_Effective_Date.Text = _news.End_Date.Value.ToShortDateString();
// linkVidoes.Attributes.Add("href", _news.VDO_Hyperlink);
linkVidoes.HRef = _news.VDO_Hyperlink;
linkVidoes.InnerText = _news.VDO_Hyperlink;
gg.Src = _news.VDO_Hyperlink;
dbo_ReadNewsClass readnew = new dbo_ReadNewsClass();
readnew.User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
readnew.News_ID = News_ID;
readnew.Read_Date = DateTime.Now;
dbo_ReadNewsDataClass.Add(readnew);
}
catch (Exception ex)
{
}
}
}
public static dbo_NewsClass2 Select_Record(String News_ID)
{
dbo_NewsClass2 clsdbo_News = new dbo_NewsClass2();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[NewsSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@News_ID", News_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_News.News_ID = reader["News_ID"] is DBNull ? null : reader["News_ID"].ToString();
clsdbo_News.News_Type = reader["News_Type"] is DBNull ? null : reader["News_Type"].ToString();
clsdbo_News.Agent_Name = reader["Agent_Name"] is DBNull ? null : reader["Agent_Name"].ToString();
clsdbo_News.Subject = reader["Subject"] is DBNull ? null : reader["Subject"].ToString();
clsdbo_News.Content = reader["Content"] is DBNull ? null : reader["Content"].ToString();
clsdbo_News.Content_FileName = reader["Content_FileName"] is DBNull ? null : reader["Content_FileName"].ToString();
clsdbo_News.Content_FileType = reader["Content_FileType"] is DBNull ? null : reader["Content_FileType"].ToString();
clsdbo_News.VDO_Hyperlink = reader["VDO_Hyperlink"] is DBNull ? null : reader["VDO_Hyperlink"].ToString();
clsdbo_News.Start_Date = reader["Start_Date"] is DBNull ? null : (DateTime?)reader["Start_Date"];
clsdbo_News.End_Date = reader["End_Date"] is DBNull ? null : (DateTime?)reader["End_Date"];
clsdbo_News.Photo_Name = reader["Photo_Name"] is DBNull ? null : reader["Photo_Name"].ToString();
clsdbo_News.Photo_MemoryStream = reader["Photo"] is DBNull ? null : (byte[])reader["Photo"];
clsdbo_News.Content_File = reader["Content_File"] is DBNull ? null : (Byte[])reader["Content_File"];
}
else
{
clsdbo_News = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_News);
}
finally
{
connection.Close();
}
return(clsdbo_News);
}
