//protected void addone(object sender, EventArgs e)
//{
// ((Panel)this.loginview.FindControl("container")).Visible = true;
// ViewState["cont_visible"] = true;
//}
//protected void bt_nonewe(object sender, EventArgs e)
//{
// ((Panel)this.loginview.FindControl("container")).Visible = false;
// ViewState["cont_visible"] = false;
//}
protected void mycalsel()
{
Calendar mycal=(Calendar)loginview.FindControl("mycalendar");
DateTime date = mycal.SelectedDate;
calendar_entity db = new calendar_entity();
string unm = (string)Session["selectedfriend_name"];// Membership.GetUser().UserName;
IEnumerable<calendar_event> evt = calendarcontext.getEvent(unm, date);
//(from i in db.calendar_event
// let uid = (from j in db.aspnet_Users
// where j.UserName == unm orderby i.createtime
// select j.UserId).FirstOrDefault()
// where uid == i.UserId && i.createtime==date
// select i);
//((GridView)loginview.FindControl("gv")).DataSource = evt;
//((GridView)loginview.FindControl("gv")).DataBind();
string txt="";
for (int i = 0; i < evt.Count(); i++)
{
txt += "<div style='background-color:#81aa32'><a style='color:white' href='eventroom.aspx?eventid=" + evt.ElementAt(i).eventid + "&tittle=" + evt.ElementAt(i).tittle + "&event=" +
Server.UrlEncode(evt.ElementAt(i).content) + "&username="******"&date=" + date + "&place=" + evt.ElementAt(i).place + "'>" + evt.ElementAt(i).tittle + "</a><br/></div><br/>";
}
((Literal)loginview.FindControl("Literal1")).Text = txt;
// Response.Redirect("eventroom.aspx?event="+Server.UrlEncode(txt));
}
public void listevent()
{
Calendar mycal=(Calendar)loginview.FindControl("mycalendar");
DateTime date = mycal.SelectedDate;
calendar_entity db = new calendar_entity();
string unm = Membership.GetUser().UserName;
IEnumerable<calendar_event> evt = calendarContext.getEvent(unm, date);
List<string> tmp = new List<string>();
string txt="";
for (int i = 0; i < evt.Count(); i++)
{
if(evt.ElementAt(i).tittle!=null)
tmp.Insert(tmp.Count(), evt.ElementAt(i).tittle);
}
Session["list"] = evt;
if ((GridView)loginview.FindControl("gv") != null)
{
((GridView)loginview.FindControl("gv")).DataSource = tmp;
((GridView)loginview.FindControl("gv")).DataBind();
}
// Response.Redirect("eventroom.aspx?event="+Server.UrlEncode(txt));
}
protected void Button1_Click(object sender, EventArgs e)
{
calendar_entity db = new calendar_entity();
Guid evtid = new Guid(Request.QueryString["eventid"]);
eventcontex.insertComment(Membership.GetUser().UserName,
evtid,
this.TextBox1.Text);
}
public IEnumerable<calendar_event> getEvent(string username, DateTime date)
{
calendar_entity db = new calendar_entity();
IEnumerable<calendar_event> ce= (from i in db.calendar_event
let uid = (from j in db.aspnet_Users
where j.UserName == username
orderby i.createtime
select j.UserId).FirstOrDefault()
where uid == i.UserId && i.createtime == date
select i);
return ce;
}
protected void loadmsg()
{
calendar_entity db = new calendar_entity();
Guid eventid = new Guid(Request.QueryString["eventid"]);
IEnumerable<calendar_message> evt = eventcontex.getComment(eventid);
//(from i in db.calendar_message
// where i.eventid == eventid
// orderby i.createtime descending
// select i);
string bluestyle = "\"bluechatbar\"";
string greenstyle = "\"greenchatbar\"";
string res = "";
PlaceHolder1.Controls.Clear();
if (evt != null && evt.Count() > 0)
{
bool flag = false;
for (int i = 0; i < evt.Count(); i++)
{
//flag = !flag;
//if (!flag)
// res += "<div class=" + bluestyle + ">" + evt.ElementAt(i).UserName + "said: " + evt.ElementAt(i).content + "----At " + evt.ElementAt(i).createtime + "</div><br/><br/>";
//else
// res += "<div class=" + greenstyle + ">" + evt.ElementAt(i).UserName + "said: " + evt.ElementAt(i).content + "----At " + evt.ElementAt(i).createtime + "</div><br/><br/>";
User_Controls.comment c = (User_Controls.comment)Page.LoadControl("User_Controls/comment.ascx");
c.Users = evt.ElementAt(i).UserName;
c.Contents = evt.ElementAt(i).content;
c.Time = evt.ElementAt(i).createtime;
PlaceHolder1.Controls.Add(c);
}
this.Literal1.Text = res;
}
else
this.Literal1.Text = "No message";
}
protected void bt_newEvent(object sender, EventArgs e)
{
((Panel)this.loginview.FindControl("container")).Visible = false;
ViewState["cont_visible"] = false;
calendar_entity db = new calendar_entity();
string unm = Membership.GetUser().UserName;
Guid uid = (from user in db.aspnet_Users
where user.UserName == unm
select user.UserId).Single();
DateTime start = ((Calendar)this.loginview.FindControl("mycalendar")).SelectedDate;
DateTime end = ((Calendar)this.loginview.FindControl("mycalendar")).SelectedDate;
start=start.AddHours( ((TimeSelector)this.loginview.FindControl("startTimeSel")).Hour);
start=start.AddMinutes( ((TimeSelector)this.loginview.FindControl("startTimeSel")).Minute);
end = end.AddHours(((TimeSelector)this.loginview.FindControl("endTimeSel")).Hour);
end = end.AddMinutes(((TimeSelector)this.loginview.FindControl("endTimeSel")).Minute);
calendar_event evt= calendarContext.insertEvent(uid,
Guid.NewGuid(),
((TextBox)this.loginview.FindControl("tittle")).Text,
((TextBox)this.loginview.FindControl("TextBox1")).Text,
((TextBox)this.loginview.FindControl("TextBox2")).Text,
((Calendar)this.loginview.FindControl("mycalendar")).SelectedDate,
start,
end);
calendar_globalevent newge=new calendar_globalevent(){ userid=uid, eventtype="addedcalevent", createtime=DateTime.Today};
this.globalevent_context.insertevent(newge,this.Page,evt);
//calendar_event newe = new calendar_event()
//{
// UserId = uid,
// eventid = Guid.NewGuid(),
// content = ((TextBox)this.loginview.FindControl("TextBox1")).Text,
// place = ((TextBox)this.loginview.FindControl("TextBox2")).Text,
// createtime = ((Calendar)this.loginview.FindControl("mycalendar")).SelectedDate
//};
//db.calendar_event.AddObject(newe);
//db.SaveChanges();
}
private void loadjoinlist()
{
User_Controls.joinevent joinevent1 = (User_Controls.joinevent)Page.LoadControl("User_Controls/joinevent.ascx");
calendar_entity db = new calendar_entity();
Guid newg=new Guid(Request.QueryString["eventid"]);//temporarily holds the event id. newg means "new guid holder"
joinevent1.Eventid = newg;
joinevent1.Visiterid = (Guid)Membership.GetUser().ProviderUserKey;
Guid ownerid = calendarcontex.getEventByIdReternUserId(newg);
//(from i in db.calendar_event
// where i.eventid == newg
// select i.UserId).First();
joinevent1.Myid = ownerid;
this.PlaceHolder_join.Controls.Add(joinevent1);
}
public GlobalEvent_BLL(calendar_entity db)
{
this.db = db;
}
