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