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>");
}
}
public void PostNewEvent(eventsBO new_event)
{
try
{
adminfunction.PostNewEvent(new_event);
}
catch
{
throw;
}
}
//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));
}
