//inserting data into news
public int news_DAL_insert(newsBO news_bo)
{
try
{
Next_ID nid = new Next_ID();
news_bo.news_id = nid.incrementer("news_id", "news");
s_querry = "insert into news values(@news_id,@admin_id,@news_title,@news_desc,@date_time_of_post,@news_pic)";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(s_querry, con);
cmd.Parameters.AddWithValue("@news_id", news_bo.news_id);
cmd.Parameters.AddWithValue("@admin_id", news_bo.admin_id);
cmd.Parameters.AddWithValue("@news_title", news_bo.news_title);
cmd.Parameters.AddWithValue("@news_desc", news_bo.news_desc);
cmd.Parameters.AddWithValue("@date_time_of_post", news_bo.date_time_of_post);
cmd.Parameters.AddWithValue("@news_pic", news_bo.news_pic);
return(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally { cmd.Dispose(); con.Close(); con.Dispose(); }
}
//delete
public int news_DAL_del(newsBO news_bo)
{
try
{
return(newsdal.news_DAL_del(news_bo));
}
catch (Exception)
{
throw;
}
}
//view by id
public DataTable news_DAL_view_id(newsBO news_bo)
{
try
{
return(newsdal.news_DAL_view_id(news_bo));
}
catch (Exception)
{
throw;
}
}
protected void loadNews()
{
newsBAL news_bal = new newsBAL();
newsBO news_bo = new newsBO();
try
{
DataSet ds = news_bal.news_DAL_viewALL();
newsLoad.DataSource = ds;
newsLoad.DataBind();
}
catch (Exception ex)
{
ErrorReportBAL error = new ErrorReportBAL();
error.SendErrorReport("News.aspx", ex.ToString());
Response.Write("<script>alert('Some Error Occured \n Sorry for inconvenience');</script>");
}
}
public void load_news()
{
newsBO n_bo = new newsBO();
newsBAL n_bal = new newsBAL();
try
{
DataSet ds = n_bal.news_top3_BAL_view();
news.DataSource = ds;
news.DataBind();
}
catch (Exception ex)
{
ErrorReportBAL error = new ErrorReportBAL();
error.SendErrorReport("UserProfleHome.aspx", ex.ToString());
Response.Write("<script>alert('Some Error Occured \n Sorry for inconvenience');</script>");
}
}
protected void displaynewsByID(int NewsID)
{
newsBAL news_bal = new newsBAL();
newsBO news_bo = new newsBO();
news_bo.news_id = NewsID;
try
{
DataTable dt = news_bal.news_DAL_view_id(news_bo);
newsLoad.DataSource = dt;
newsLoad.DataBind();
}
catch (Exception ex)
{
ErrorReportBAL error = new ErrorReportBAL();
error.SendErrorReport("NewsView.aspx", ex.ToString());
Response.Write("<script>alert('Some Error Occured \n Sorry for inconvenience');</script>");
}
}
//delete
public int news_DAL_del(newsBO news_bo)
{
try
{
s_querry = "delete from news where news_id =@news_id";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(s_querry, con);
cmd.Parameters.AddWithValue("@news_id", news_bo.news_id);
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
con.Close();
}
}
//view news byr news_id
public DataTable news_DAL_view_id(newsBO news_bo)
{
try
{
s_querry = "select * from news where news_id =@news_id";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(s_querry, con);
cmd.Parameters.AddWithValue("@news_id", news_bo.news_id);
da = new SqlDataAdapter(cmd);
dSet = new DataSet();
da.Fill(dSet);
return((DataTable)dSet.Tables[0]);
}
catch (Exception)
{
throw;
}
finally { cmd.Dispose(); con.Close(); con.Dispose(); }
}
