protected void Button1_Click1(object sender, EventArgs e) { using (var myDB = new ProjectEntities()) { int id = Int32.Parse(TextBoxDELETE.Text); var USER = (from x in myDB.User where (id == x.UserId) select x).SingleOrDefault(); USER.IsActive = false; myDB.SaveChanges(); } }
protected void ButtonAddEvent_Click(object sender, EventArgs e) { User user = (User)Session["current_user"]; using (var myDB = new ProjectEntities()) { Proposal p = new Proposal(); p.EventType = TextBoxEventType.Text; p.EventDetail = TextBoxDetails.Text; p.IsActive = true; p.TimeStamp = DateTime.Now; p.OwnerId = user.UserId; myDB.Proposal.Add(p); myDB.SaveChanges(); Response.Redirect("AddEvent.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { DateTime date = DateTime.Now.AddDays(-15); using (var myDB = new ProjectEntities()) { User loggeduser = (User)Session["current_user"]; if (loggeduser != null) { var events = (from x in myDB.Proposal where (x.TimeStamp > date) select x).ToList(); DataList1.DataSource = events; DataList1.DataBind(); } else { Response.Redirect("Login.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { User us = (User)Session["current_user"]; using (var myDB = new ProjectEntities()) { var user = (from u in myDB.User where (u.IsActive == true && u.UserId == us.UserId) select u).SingleOrDefault(); Label1.Text = user.FirstName + " " + user.LastName; Image1.ImageUrl = "~/images/" + user.UserPhoto; if (user.UserType == "admin") { lblWel.Text = "Welcome " + user.FirstName; } else { lblWel.Text = "Welcome" + user.FirstName; HyperLink1.Visible = false; } } }
protected void ButtonComment_Click(object sender, EventArgs e) { using (var myDB = new ProjectEntities()) { User loggeduser = (User)Session["current_user"]; int qId = Convert.ToInt32(Request["id"]); var newcmmnt = new Comment(); newcmmnt.EventId = qId; newcmmnt.UserId = loggeduser.UserId; newcmmnt.CommentText = TextBoxComment.Text; newcmmnt.IsActive = true; myDB.Comment.Add(newcmmnt); myDB.SaveChanges(); Response.Redirect("~/EventVoteAndComment.aspx?id=" + qId); } }
protected void Page_Load(object sender, EventArgs e) { User loggeduser = (User)Session["current_user"]; if (!IsPostBack) { if (Session["current_user"] != null) { if (Request["id"] != null) { int qId = Convert.ToInt32(Request["id"]); using (myDB = new ProjectEntities()) { var p = (from x in myDB.Proposal where (x.EventId == qId) select x).SingleOrDefault(); LabelEventType.Text = p.EventType; LabelEventDetail.Text = p.EventDetail; var c = (from x in myDB.Comment where (x.EventId == qId && x.IsActive == true) select x).ToList(); DataList.DataSource = c; DataList.DataBind(); var k = (from i in myDB.Vote where (i.PropId == qId && i.UserId == loggeduser.UserId) select i).SingleOrDefault(); if (k != null) { Button1.Visible = false; Button2.Visible = false; Label4.Text = "You voted already!"; } } } else { Response.Redirect("ListEvent.aspx"); } } else { Response.Redirect("Login.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { User user = (User)Session["current_user"]; User loggeduser = (User)Session["current_user"]; if (user != null) { using (var mydb = new ProjectEntities()) { var allusers = (from u in mydb.User where (u.IsActive == true) select u).ToList(); GridView1.DataSource = allusers; GridView1.DataBind(); } } else { Response.Redirect("Login.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { using (var myDB = new ProjectEntities()) { var loginuser = (from u in myDB.User where u.Username == TextBoxUserName.Text && u.Password == TextBoxPassword.Text select u).SingleOrDefault(); if (loginuser != null) { if (loginuser.UserType == "admin") { Session["current_user"] = loginuser; Response.Redirect("ListEvent.aspx"); } else { Session["current_user"] = loginuser; Response.Redirect("ListEvent.aspx"); } } else { Label4.Visible = true; } } }