protected void gv_active_SelectedIndexChanged(object sender, EventArgs e) { var ctx = new QuaackEntities(); var result = (from p in ctx.profile select p).ToList(); //Ophalen argumenten die vanaf de browser zijn meegestuurd. var x = this.Request.Form["__EVENTARGUMENT"]; //in __EVENTARGUMENT zit een regelwaarde voorgegaan door een dollarteken. //maw regel 1 van de gridview (en dus van de lijst result) indien erop geklikt, enz. en parse int regel = int.Parse(x.Substring(x.IndexOf("$") + 1)); //JdJ: niet profile maar follower tabel kiezen. Dus eigen volger blokkeren var tempBlocked = result[regel].tempblocked; profile t = new profile(); if (tempBlocked) { t.tempblocked = false; // t.tempblockeddatetime = null; } else { t.tempblocked = true; t.tempblockeddatetime = DateTime.Now; } //JdJ: het doorvoeren van de wijziging lukt nog niet //ctx.profile. ctx.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { string value = Request.QueryString["id"]; if (value != null) { int myval = int.Parse(value); var ctx = new QuaackEntities(); var q = (from i in ctx.profile where i.profileid == myval select i).FirstOrDefault(); if (q != null) { // if (q.verficationpendingdatetime.Value > (int)(DateTime.Now.Subtract) { q.verificationpending = false; ctx.SaveChanges(); lbl_message.Text = "Uw registratie is gelukt"; } } else { lbl_message.Text = "Uw registratie is niet gelukt"; } } }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { int subjectID = Convert.ToInt32(Session["profileID"]); var ctx = new QuaackEntities(); var result = (from f in ctx.follower orderby f.subject join p in ctx.profile on f.follower1 equals p.profileid where f.subject == subjectID select new { p.username, p.permblocked, p.permblockeddatetime }).ToList(); /* var result = (from p in ctx.profile join f in ctx.follower on subjectID == where select new { p.username, p.mobilenumber, p.tempblocked, p.tempblockeddatetime }).ToList(); */ gv_active.DataSource = result; gv_active.DataBind(); } else { //Response.Redirect("/Account/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { string value = Request.QueryString["id"]; if (value != null) { int myval = int.Parse(value); var ctx = new QuaackEntities(); var q = (from i in ctx.profile where i.profileid == myval where i.verificationpending == true select i).FirstOrDefault(); if (q != null) { var dateTimeNow = DateTime.Now; var verificationDateTime = (from i in ctx.profile where i.profileid == myval select i.verficationpendingdatetime).FirstOrDefault(); var checkVerificatioDateTime = verificationDateTime.Value.AddMinutes(10); if (checkVerificatioDateTime >= dateTimeNow) { q.verificationpending = false; ctx.SaveChanges(); lbl_message.Text = "Uw registratie is gelukt"; } else { lbl_message.Text = "Uw registratie is niet gelukt doordat niet binnen 10 minuten gereageerd is"; } } else { lbl_message.Text = "Uw registratie is niet gelukt of is al geactiveerd"; } } }
protected void gv_addremovefollower_SelectedIndexChanged(object sender, EventArgs e) { var ctx = new QuaackEntities(); var result = (from p in ctx.profile select p).ToList(); //Ophalen argumenten die vanaf de browser zijn meegestuurd. var x = this.Request.Form["__EVENTARGUMENT"]; //in __EVENTARGUMENT zit een regelwaarde voorgegaan door een dollarteken. //maw regel 1 van de gridview (en dus van de lijst result) indien erop geklikt, enz. en parse int regel = int.Parse(x.Substring(x.IndexOf("$") + 1)); var naam = result[regel].username; var id = result[regel].profileid; int profileID = Convert.ToInt32(Session["profileID"]); follower f = new follower(); f.subject = profileID; f.follower1 = id; ctx.follower.Add(f); ctx.SaveChanges(); Response.Redirect("Follower.aspx"); }
protected void Page_Load(object sender, EventArgs e) { var ctx = new QuaackEntities(); var result = (from l in ctx.profile select l).ToList(); gv_profile.DataSource = result; gv_profile.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var ctx = new QuaackEntities(); var result = (from f in ctx.follower select f).ToList(); gv_follower.DataSource = result; gv_follower.DataBind(); }
public profile getProfile(int userId) { var qe = new QuaackEntities(); var profileResult = (from q in qe.profile where q.profileid == userId select q).First(); return profileResult; }
protected void Page_Load(object sender, EventArgs e) { int subjectID = Convert.ToInt32(Session["profileID"]); var ctx = new QuaackEntities(); var result = (from f in ctx.follower join p in ctx.profile on f.follower1 equals p.profileid where f.subject == subjectID select new {p.username}).ToList(); gv_follower.DataSource = result; gv_follower.DataBind(); }
protected void btn_send_Click(object sender, EventArgs e) { //let op: SMSgateway kent een GSM nr. Followers van deze user of profile kunnen dit ook in OwnPage zien, dus geen persoonlijke berichten. if (tb_mobilenumber.Text == "") { lbl_message.Text = "Select follower for mobile number"; } else { var ctx = new QuaackEntities(); int sendID = Convert.ToInt32(Session["profileID"]); message m = new message(); m.messdatetime = DateTime.Now; m.sender = sendID; m.message1 = tb_email.Text; ctx.message.Add(m); ctx.SaveChanges(); var link = string.Format("http://Quaack.system-Engineer.nl:8080/Twitter.aspx?id={0}", m.messid.ToString()); //indien SMS gateway zal het mobilenr ingevuld moeten worden ipv dit standaard email account. //MailMessage mail = new MailMessage("*****@*****.**", mobilenumber, "message", link); MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**", "message", link); mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient("smtp.gmail.com"); smtp.EnableSsl = true; smtp.Port = 587; System.Net.NetworkCredential c = new System.Net.NetworkCredential(); c.UserName = "******"; c.Password = "******"; smtp.Credentials = c; try { smtp.Send(mail); } catch (Exception errormsg) { Console.Write(errormsg); } Response.Redirect("OwnPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { var ctx = new QuaackEntities(); var result = (from p in ctx.profile select new { p.username, p.mobilenumber }).ToList(); gv_addremovefollower.DataSource = result; gv_addremovefollower.DataBind(); } else { Response.Redirect("/Account/Login.aspx"); } }
public List<message> getCurrentUserLast10Messages() { List<message> result = new List<message>(); QuaackEntities qe = new QuaackEntities(); var messages = (from qem in qe.message where qem.sender == currentUserId && qem.parentmessid == null orderby qem.messdatetime select qem).Take(10); foreach (var message in messages) { result.Add(message); } return result; }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { int subjectID = Convert.ToInt32(Session["profileID"]); var ctx = new QuaackEntities(); var resultOwnMessage = (from m in ctx.message where subjectID == m.sender select new { m.messdatetime, m.message1 }).ToList(); gv_ownmessage.DataSource = resultOwnMessage; gv_ownmessage.DataBind(); //creeer lijst met id's var followerResults = (from f in ctx.follower where f.subject == subjectID select f.follower1).ToList(); //JdJ: dit gaat niet goed //haal dmv lijst de messages op /* var messageResults = ""; foreach (var item in followerResults) { messageResults += (from m in ctx.message where item == m.sender select new { m.message1 }); } */ //JdJ: nu statisch om toch het resultaat te laten zien var messageResults = (from m in ctx.message where m.sender == 24 select new { m.messdatetime, m.message1 }).ToList(); gv_lastmessage.DataSource = messageResults; //gv_lastmessage.DataSource = followerResults; gv_lastmessage.DataBind(); } else { Response.Redirect("/Account/Login.aspx"); } }
protected void gv_addfollower_SelectedIndexChanged(object sender, EventArgs e) { var ctx = new QuaackEntities(); var result = (from p in ctx.profile select p).ToList(); //Ophalen argumenten die vanaf de browser zijn meegestuurd. var x = this.Request.Form["__EVENTARGUMENT"]; //in __EVENTARGUMENT zit een regelwaarde voorgegaan door een dollarteken. //maw regel 1 van de gridview (en dus van de lijst result) indien erop geklikt, enz. en parse int regel = int.Parse(x.Substring(x.IndexOf("$") + 1)); tb_mobilenumber.Text = result[regel].mobilenumber; lbl_message.Text = "Mobile number"; }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { int subjectID = Convert.ToInt32(Session["profileID"]); var ctx = new QuaackEntities(); var result = (from f in ctx.follower join p in ctx.profile on f.follower1 equals p.profileid where f.subject == subjectID select new { p.username }).ToList(); gv_follower.DataSource = result; gv_follower.DataBind(); } else { Response.Redirect("/Account/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { int sendID = Convert.ToInt32(Session["profileID"]); var ctx = new QuaackEntities(); var result = (from l in ctx.message where l.sender == sendID select new { l.message1, l.messdatetime }).ToList(); gv_message.DataSource = result; gv_message.DataBind(); } else { Response.Redirect("/Account/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { int profileID = Convert.ToInt32(Session["profileID"]); var ctx = new QuaackEntities(); var result = (from p in ctx.profile where p.profileid == profileID select p).ToList(); gv_profile.DataSource = result; gv_profile.DataBind(); } else { Response.Redirect("/Account/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.IsAuthenticated) { QuaackEntities ctx = new QuaackEntities(); var queryResult = from r in ctx.profile where r.username == User.Identity.Name select r; foreach (var item in queryResult) { int profileID = item.profileid; Session["profileID"] = profileID; } } else { Response.Redirect("/Account/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { string value = Request.QueryString["id"]; if (value != null) { int myval = int.Parse(value); var ctx = new QuaackEntities(); var message = (from m in ctx.message where m.messid == myval select m.message1).FirstOrDefault(); if (message != null) { lbl_twitter.Text = message.ToString(); } else { lbl_twitter.Text = "Geen bericht ontvangen"; } } }
protected void gv_zoek_SelectedIndexChanged(object sender, EventArgs e) { var ctx = new QuaackEntities(); var result = (from p in ctx.profile select p).ToList(); //Ophalen argumenten die vanaf de browser zijn meegestuurd. var x = this.Request.Form["__EVENTARGUMENT"]; //in __EVENTARGUMENT zit een regelwaarde voorgegaan door een dollarteken. //maw regel 1 van de gridview (en dus van de lijst result) indien erop geklikt, enz. en parse int regel = int.Parse(x.Substring(x.IndexOf("$") + 1)); var id = result[regel].profileid; Session["profileID"] = id; //Roy, van hier aan jou. Je id in een session gezet. /* oude code string value = Request.QueryString["id"]; if (value != null) { int myval = int.Parse(value); var ctx = new QuaackEntities(); var q = (from i in ctx.profile where i.profileid == myval select i).FirstOrDefault(); if (q != null) { Response.Redirect("/OwnPage.aspx?id={0}"); } else { } */ }
public void displayReactions(List<message> reactions) { pan_Messages.Controls.Add(new LiteralControl("<ul>")); foreach (message reaction in reactions) { QuaackEntities qe = new QuaackEntities(); string username = (from user in qe.profile where user.profileid == reaction.sender select user.username).First().ToString(); pan_Messages.Controls.Add(new LiteralControl("<li>")); Label reactionLabel = new Label(); HyperLink userHyperLink = new HyperLink(); userHyperLink.Text = username; userHyperLink.NavigateUrl = "~/Quaacker.aspx?id=" + reaction.sender; pan_Messages.Controls.Add(userHyperLink); reactionLabel.Text = " reageert: " + reaction.message1; pan_Messages.Controls.Add(reactionLabel); pan_Messages.Controls.Add(new LiteralControl("</li>")); } pan_Messages.Controls.Add(new LiteralControl("</ul>")); }
void placeReactionButtonBtn_Click(Object sender, EventArgs e) { Button btn = (Button)sender; int parentMessageID = Convert.ToInt32(btn.CommandArgument); TextBox reactionControl = new TextBox(); int userId = (int)Session["profileID"]; foreach (Control c in pan_Messages.Controls) { if (c is TextBox) { if (c.ID == parentMessageID.ToString()) { reactionControl = (TextBox)c; } } } message m = new message(); m.messdatetime = DateTime.Now; m.sender = userId; m.parentmessid = parentMessageID; m.message1 = reactionControl.Text; m.removed = false; QuaackEntities qeB = new QuaackEntities(); qeB.message.Add(m); qeB.SaveChanges(); Response.Redirect(Request.RawUrl); }
public List<message> getReactions(int messageID) { List<message> result = new List<message>(); var qe1 = new QuaackEntities(); var reactionMessages = from qerms in qe1.message where qerms.parentmessid == messageID select qerms; foreach (var item in reactionMessages) { result.Add(item); } return result; }
protected void Page_Load(object sender, EventArgs e) { // Check of user ingelogd is... anders eerst redirect naar inlogpagina. if (User.Identity.IsAuthenticated) { ProfileId = (int)Session["profileID"]; string verifyChanges = Request.QueryString["verified"]; DateTime currentDate = DateTime.Now; DateTime verifyDate = Convert.ToDateTime(Request.QueryString["datetime"]); var qe = new QuaackEntities(); var profileResult = (from q in qe.profile where q.profileid == ProfileId select q).First(); if(!(profileResult==null)) { if ((ProfileId == Convert.ToInt16(verifyChanges)) && verifyDate >= currentDate) { if (!(Request.QueryString["profile"] == null)) { profileResult.profile1 = Server.UrlDecode(Request.QueryString["profile"]); } if (!(Request.QueryString["email"] == null)) { profileResult.email = Server.UrlDecode(Request.QueryString["email"]); } if (!(Request.QueryString["mobilenumber"] == null)) { profileResult.mobilenumber = Server.UrlDecode(Request.QueryString["mobilenumber"]); } if (!(Request.QueryString["avatar"] == null)) { profileResult.avatarlocation = Server.UrlDecode(Request.QueryString["avatar"]); } if (!(Request.QueryString["delete"] == null)) { profileResult.removed = Convert.ToBoolean(Server.UrlDecode(Request.QueryString["delete"])); profileResult.removeddatetime = DateTime.Now; lbl_DeleteProfile.Text = "Uw profiel is succesvol verwijderd"; FormsAuthentication.SignOut(); } qe.SaveChanges(); } var newProfileResult = (from q in qe.profile where q.profileid == ProfileId select q).First(); img_Avatar.ImageUrl = newProfileResult.avatarlocation; lbl_ProfileSketch.Text = newProfileResult.profile1; lbl_Email.Text = newProfileResult.email; lbl_MobileNumber.Text = (string)newProfileResult.mobilenumber; EmailAdress = newProfileResult.email; } } else { Response.Redirect("/Account/Login.aspx"); } }