//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(); } }