public bool eventSubscriber_getEvent_id_DAL(event_subscriberBO event_subscriber_bo)
{
try
{
s_querry = "select event_id from event_subscriber where user_id='" + event_subscriber_bo.user_id + "' AND event_id = '" + event_subscriber_bo.event_id + "' ";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(s_querry, con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
finally { cmd.Dispose(); con.Close(); dr.Close(); dr.Dispose(); }
}
protected void subscribeToIvent_Command(object sender, CommandEventArgs e)
{
event_subscriberBAL event_bal = new event_subscriberBAL();
event_subscriberBO event_bo = new event_subscriberBO();
event_bo.user_id = Convert.ToInt32(Session["user_id"]);
event_bo.event_id = Convert.ToInt32(e.CommandArgument.ToString());
try
{
//if (Session["user_id"] == null)
//{
// Page.ClientScript.RegisterStartupScript(Page.GetType(), "Script", "alert('Please Login First');", true);
//}
//else if (event_bal.eventSubscriber_getEvent_id_DAL(event_bo))
//{
// Page.ClientScript.RegisterStartupScript(Page.GetType(), "Script", "alert('You Already Subscribe To This Event');", true);
//}
if (event_bal.evetnsubscriberDAL(event_bo) > 0)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Script", "alert('You are subscribed to this event');window.open('Event.aspx','_self');", true);
}
//Response.Redirect("~/Event.aspx");
}
catch (Exception ex)
{
ErrorReportBAL error = new ErrorReportBAL();
error.SendErrorReport("Event.aspx", ex.ToString());
Response.Write("<script>alert('Some Error Occured \n Sorry for inconvenience');</script>");
}
}
//public DataTable eventSubscriber_getEvetnID_DAL(event_subscriberBO event_subscriber_bo)
//{
// try
// {
// return event_subscriber__dal.eventSubscriber_getEvetnID_DAL(event_subscriber_bo);
// }
// catch (Exception)
// {
// throw;
// }
//}
public bool eventSubscriber_getEvent_id_DAL(event_subscriberBO event_subscriber_bo)
{
try
{
return(event_subscriber__dal.eventSubscriber_getEvent_id_DAL(event_subscriber_bo));
}
catch (Exception)
{
throw;
}
}
public int evetnsubscriberDAL(event_subscriberBO event_subscriber_bo)
{
try
{
return(event_subscriber__dal.evetnsubscriberDAL(event_subscriber_bo));
}
catch (Exception)
{
throw;
}
}
//del events subscri
public int evetns_sub_delBAL(event_subscriberBO event_subBO)
{
try
{
return(event_subscriber__dal.event_subs_delDAL(event_subBO));
}
catch (Exception)
{
throw;
}
}
//protected void load_all_subscibed_ID()
//{
// event_subscriberBAL ebal = new event_subscriberBAL();
// event_subscriberBO ebo = new event_subscriberBO();
// ebo.user_id = Convert.ToInt32(Session["user_id"]);
// DataSet dtUserRegistered = new DataSet();
// dtUserRegistered = ebal.eventSubscriber_getSubscibedEventID_DAL(ebo);
//}
protected void eventLoad_ItemDataBound(object sender, DataListItemEventArgs e)
{
try
{
event_subscriberBAL event_bal = new event_subscriberBAL();
event_subscriberBO event_bo = new event_subscriberBO();
if (Session["user_id"] != null)
{
event_bo.user_id = Convert.ToInt32(Session["user_id"]);
event_bo.event_id = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "event_id"));
ImageButton imgbtn_subscribe_unsubs = new ImageButton();
imgbtn_subscribe_unsubs.CssClass = "subscribe_btn";
if (event_bal.eventSubscriber_getEvent_id_DAL(event_bo)) //already subscribbed make the unsubscribe button
{
imgbtn_subscribe_unsubs.ImageUrl = "img/unsubscibe.png";
imgbtn_subscribe_unsubs.Command += new CommandEventHandler(Unsubscribe_Command);
imgbtn_subscribe_unsubs.CommandArgument = DataBinder.Eval(e.Item.DataItem, "event_id").ToString();
}
else //not subcribbed to any event
{
imgbtn_subscribe_unsubs.ImageUrl = "img/subscibe.png";
imgbtn_subscribe_unsubs.Command += new CommandEventHandler(subscribeToIvent_Command);
imgbtn_subscribe_unsubs.CommandArgument = DataBinder.Eval(e.Item.DataItem, "event_id").ToString();
}
System.Web.UI.HtmlControls.HtmlGenericControl div_subscribe = (System.Web.UI.HtmlControls.HtmlGenericControl)e.Item.FindControl("subscribe");
div_subscribe.Controls.Add(imgbtn_subscribe_unsubs);
}
else
{
ImageButton imgbtn_subscribe = new ImageButton();
imgbtn_subscribe.OnClientClick = "SignInMessage();";
imgbtn_subscribe.CssClass = "subscribe_btn";
imgbtn_subscribe.ImageUrl = "img/subscibe.png";
System.Web.UI.HtmlControls.HtmlGenericControl div_subscribe = (System.Web.UI.HtmlControls.HtmlGenericControl)e.Item.FindControl("subscribe");
div_subscribe.Controls.Add(imgbtn_subscribe);
}
}
catch (Exception ex)
{
ErrorReportBAL error = new ErrorReportBAL();
error.SendErrorReport("Event.aspx", ex.ToString());
//Response.Write("<script>alert('Some Error Occured \n Sorry for inconvenience');</script>");
}
}
//unsubscirbe event
public int evetnUnSubscribeDAL(event_subscriberBO event_subscriber_bo)
{
try
{
// con = new SqlConnection(ConfigurationManager.ConnectionStrings["HIT"].ToString());
s_querry = "delete from event_subscriber where event_id =" + event_subscriber_bo.event_id + " AND user_id=" + event_subscriber_bo.user_id + "";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(s_querry, con);
return(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally { cmd.Dispose(); con.Close(); }
}
public int evetnsubscriberDAL(event_subscriberBO event_subscriber_bo)
{
try
{
s_querry = "insert into event_subscriber values(@event_id,@user_id)";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(s_querry, con);
cmd.Parameters.AddWithValue("@event_id", event_subscriber_bo.event_id);
cmd.Parameters.AddWithValue("@user_id", event_subscriber_bo.user_id);
return(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally { cmd.Dispose(); con.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>");
}
}
//Deleting event_subs
public int event_subs_delDAL(event_subscriberBO event_subsbo)
{
try
{
s_querry = "Delete from event_subscriber where event_id=@event_id";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@event_id", event_subsbo.event_id);
cmd = new SqlCommand(s_querry, con);
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
con.Close();
con.Dispose();
}
}
