protected void Button2_Click(object sender, EventArgs e) { using (var myDB = new ProjectEntities()) { User loggeduser = (User)Session["current_user"]; int qId = Convert.ToInt32(Request["id"]); var vote = new Vote(); vote.PropId = qId; vote.UserId = loggeduser.UserId; vote.IsActive = true; var voteresult = (from x in myDB.VoteResult where (x.PropId == qId) select x).SingleOrDefault(); if (voteresult != null) { voteresult.Result -= 1; myDB.Vote.Add(vote); myDB.SaveChanges(); } else { var newvrslt = new VoteResult(); newvrslt.PropId = qId; newvrslt.Result = -1; myDB.VoteResult.Add(newvrslt); myDB.Vote.Add(vote); myDB.SaveChanges(); } Response.Redirect("~/EventVoteAndComment.aspx?id=" + qId); } }
protected void ButtonUpdate_Click(object sender, EventArgs e) { using (var myDb = new ProjectEntities()) { User user_ = (User)Session["current_user"]; var user = (from x in myDb.User where (x.UserId == user_.UserId && x.IsActive == true) select x).SingleOrDefault(); user.Username = TextBoxName.Text; user.Password = TextBoxPassword.Text; user.FirstName = TextBoxFirstName.Text; user.LastName = TextBoxLastName.Text; user.Department = TextBoxDepartment.Text; user.BirthDate = Convert.ToDateTime(TextBirtDate.Text); user.Email = TextBoxEmail.Text; user.IsActive = true; if (fuUser.HasFile) { fuUser.SaveAs(Server.MapPath("~/images/" + fuUser.FileName)); user.UserPhoto = fuUser.FileName; } myDb.SaveChanges(); Response.Redirect("~/UpdatePage.aspx"); } }
protected void ButtonRegister_Click(object sender, EventArgs e) { using (var myDB = new ProjectEntities()) { var newuser = new User(); newuser.Username = TextBoxName.Text; newuser.Password = TextBoxPassword.Text; newuser.FirstName = TextBoxFirstName.Text; newuser.LastName = TextBoxLastName.Text; newuser.BirthDate = Convert.ToDateTime(TextBirtDate.Text); newuser.Email = TextBoxEmail.Text; newuser.Department = TextBoxDepartment.Text; if (fuUser.HasFile) { fuUser.SaveAs(Server.MapPath("~/images/" + fuUser.FileName)); newuser.UserPhoto = fuUser.FileName; } newuser.IsActive = true; newuser.UserType = "user"; myDB.User.Add(newuser); myDB.SaveChanges(); Response.Redirect("Login.aspx"); } }
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 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); } }