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