protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { Response.Redirect("~/Admin/AdminLogin.aspx"); } else { if (!(Page.IsPostBack)) { try { eventsBO eventbo = new eventsBO(); eventbo.event_id = Convert.ToInt32(Request.QueryString["id"]); if (Request.QueryString["type"] == "Delete") { if (adminBlogFunctions.event_BAL_delete(eventbo) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "fun", "alert('Event Remove Successfully..........');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "fun", "alert('Sorry For Inconvenience......');", true); } } dlEvent.DataSource = adminBlogFunctions.AdminEventLister(); dlEvent.DataBind(); } catch (Exception ex) { Response.Write("Error Ocured : " + ex.ToString()); } } } }
//for Updating Events public int event_DAL_update(eventsBO event_bo) { try { query = "UPDATE events set admin_id=@admin_id,event_title=@event_title,event_desc=@event_desc,event_time=@event_time,event_place=@event_place,event_pic=@event_pic,date_time_of_post=@date_time_of_post where event_id=@event_id"; if (newcon.State == ConnectionState.Closed) { newcon.Open(); } command = new SqlCommand(query, newcon); command.Parameters.AddWithValue("@admin_id", event_bo.admin_id); command.Parameters.AddWithValue("@event_title", event_bo.event_title); command.Parameters.AddWithValue("@event_desc", event_bo.event_desc); command.Parameters.AddWithValue("@event_time", event_bo.event_time); command.Parameters.AddWithValue("@event_place", event_bo.event_place); command.Parameters.AddWithValue("@event_pic", event_bo.event_pic); command.Parameters.AddWithValue("@date_time_of_post", event_bo.date_time_of_post); command.Parameters.AddWithValue("@event_id", event_bo.event_id); return(command.ExecuteNonQuery()); } catch { throw; } finally { command.Dispose(); newcon.Close(); newcon.Dispose(); } }
//update events public int event_Bal_Update(eventsBO event_bo) { try { return(adminfunction.event_DAL_update(event_bo)); } catch { throw; } }
public void PostNewEvent(eventsBO new_event) { try { adminfunction.PostNewEvent(new_event); } catch { throw; } }
// Admin Events functions public void PostNewEvent(eventsBO new_event) //post new event { try { Next_ID nid = new Next_ID(); new_event.event_id = nid.incrementer("event_id", "events"); if (newcon.State == ConnectionState.Closed) { newcon.Open(); } String query = "insert into events(event_id,admin_id,event_title,event_desc,event_time,event_place,event_pic,date_time_of_post) values(@eid,@aid,@title,@desc,@etime,@eplace,@epic,@datetime)"; command = new SqlCommand(query, newcon); command.Parameters.AddWithValue("@eid", new_event.event_id); command.Parameters.AddWithValue("@aid", new_event.admin_id); command.Parameters.AddWithValue("@title", new_event.event_title.ToString()); command.Parameters.AddWithValue("@desc", new_event.event_desc.ToString()); command.Parameters.AddWithValue("@etime", new_event.event_time); command.Parameters.AddWithValue("@eplace", new_event.event_place.ToString()); command.Parameters.AddWithValue("@epic", new_event.event_pic); command.Parameters.AddWithValue("@datetime", new_event.date_time_of_post); command.ExecuteNonQuery(); command.Dispose(); newcon.Close(); } catch { throw; } finally { if (newcon.State == ConnectionState.Open) { newcon.Close(); } } }
protected void displayEventByID(int EventID) { AdminFunctionsBAL adminBlogFunctions = new AdminFunctionsBAL(); eventsBO eventsbo = new eventsBO(); eventsbo.event_id = EventID; try { DataSet dt = adminBlogFunctions.event_retrive(eventsbo); eventLoad.DataSource = dt; eventLoad.DataBind(); } catch (Exception ex) { ErrorReportBAL error = new ErrorReportBAL(); error.SendErrorReport("EventView.aspx", ex.ToString()); String scr = "<script type='text/javascript'> alert('Some Error Occured , Sorry for Inconvenience'); </script> "; Page.ClientScript.RegisterStartupScript(this.GetType(), "script1", scr); } }
protected void displayEventByID(int EventID) { AdminFunctionsBAL adminBlogFunctions = new AdminFunctionsBAL(); eventsBO eventsbo = new eventsBO(); eventsbo.event_id = EventID; try { DataSet dt = adminBlogFunctions.event_retrive(eventsbo); eventLoad.DataSource = dt; eventLoad.DataBind(); } catch (Exception ex) { //throw; ErrorReportBAL error = new ErrorReportBAL(); error.SendErrorReport("Event.aspx", ex.ToString()); Response.Write("<script>alert('Sorry for inconvenience');</script>"); } }
public DataSet events_DAl_Retrive(eventsBO eventbo) { try { string s_querry = "Select * from events where event_id =@event_id"; if (newcon.State == ConnectionState.Closed) { newcon.Open(); } command = new SqlCommand(s_querry, newcon); command.Parameters.AddWithValue("@event_id", eventbo.event_id); adapter = new SqlDataAdapter(command); ds = new DataSet(); adapter.Fill(ds); return(ds); } catch (Exception) { throw; } }
//for deleting events public int event_DAL_del(eventsBO event_bo) { try { query = "delete from events where event_id =@event_id"; if (newcon.State == ConnectionState.Closed) { newcon.Open(); } command = new SqlCommand(query, newcon); command.Parameters.AddWithValue("@event_id", event_bo.event_id); return(command.ExecuteNonQuery()); } catch { throw; } finally { newcon.Close(); } }
protected void loadEvent() { AdminFunctionsBAL adminBlogFunctions = new AdminFunctionsBAL(); eventsBO eventsbo = new eventsBO(); event_subscriberBO ebo = new event_subscriberBO(); event_subscriberBAL ebal = new event_subscriberBAL(); try { DataSet ds = adminBlogFunctions.AdminEventLister(); eventLoad.DataSource = ds; eventLoad.DataBind(); } catch (Exception ex) { //throw; ErrorReportBAL error = new ErrorReportBAL(); error.SendErrorReport("Event.aspx", ex.ToString()); Response.Write("<script>alert('Sorry for inconvenience');</script>"); } }
//post new event // Admin Events functions public void PostNewEvent(eventsBO new_event) { try { Next_ID nid = new Next_ID(); new_event.event_id = nid.incrementer("event_id", "events"); if (newcon.State == ConnectionState.Closed) { newcon.Open(); } String query = "insert into events(event_id,admin_id,event_title,event_desc,event_time,event_place,date_time_of_post) values(@eid,@aid,@title,@desc,@etime,@eplace,@datetime)"; command = new SqlCommand(query, newcon); command.Parameters.AddWithValue("@eid", new_event.event_id); command.Parameters.AddWithValue("@aid",new_event.admin_id); command.Parameters.AddWithValue("@title", new_event.event_title.ToString()); command.Parameters.AddWithValue("@desc",new_event.event_desc.ToString()); command.Parameters.AddWithValue("@etime",new_event.event_time); command.Parameters.AddWithValue("@eplace",new_event.event_place.ToString()); command.Parameters.AddWithValue("@datetime", new_event.date_time_of_post); command.ExecuteNonQuery(); command.Dispose(); newcon.Close(); } catch { throw; } finally { if (newcon.State == ConnectionState.Open) { newcon.Close(); } } }
//deletind events by using event_id public int event_BAL_delete(eventsBO eventbo) { return(adminfunction.event_DAL_del(eventbo)); }
//retriving Events public DataSet event_retrive(eventsBO eventbo) { return(adminfunction.events_DAl_Retrive(eventbo)); }