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