protected void ButtonSubmit_Click(object sender, EventArgs e)
{
using (var myDB = new webDbEntities())
{
int loggeduserid = Convert.ToInt32(Session["currentuser"]);
var loggeduser = (from u in myDB.user
where u.id == loggeduserid
select u).FirstOrDefault();
if (loggeduser != null)
{
user newuser = (user)loggeduser;
newuser.name = TextBoxFname.Text;
newuser.surname = TextBoxLastName.Text;
newuser.username = TextBoxUserName.Text;
newuser.email = TextBoxEmail.Text;
newuser.department = TextBoxDepartment.Text;
newuser.password = TextBoxPass.Text;
if (this.fluDosya.HasFile)
{
fluDosya.SaveAs(Server.MapPath("~/Resimler/" + this.fluDosya.FileName));
string fileName = Path.GetFileName(this.fluDosya.PostedFile.FileName);
Session["ImagePath"] = "Resimler/" + fileName;
newuser.photo = Convert.ToString(Session["ImagePath"]);
}
myDB.SaveChanges();
Response.Redirect("Profil");
}
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
using (var myDB = new webDbEntities())
{
var loggeduser = (from u in myDB.user
where u.email == TextBoxEmail.Text && u.password == TextBoxPass.Text
select u).FirstOrDefault();
if (loggeduser != null)
{
Session["currentuser"] = loggeduser.id;
Session["currentuser_rol"] = loggeduser.rol;
Session["Currentuser_email"] = loggeduser.email;
Session["Currentuser_name"] = loggeduser.name;
Session["Currentuser_surname"] = loggeduser.surname;
Session["currentuser_username"] = loggeduser.username;
Session["ImagePath"] = loggeduser.photo;
Response.Redirect("HomePage.aspx");
}
else
{
FailureText.Text = "Invalid username or password.";
ErrorMessage.Visible = true;
}
}
}
private void updaterow(int rollno, int markstatus)
{
using (var myDB = new webDbEntities())
{
int loggeduserid = Convert.ToInt32(Session["currentuser"]);
int activityid = rollno;
var loggeduser = (from u in myDB.like where u.user_id == loggeduserid && u.activity_id == activityid select u).FirstOrDefault();
if (loggeduser != null)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Daha önce like veya dislike vermişsiniz. Like veya dislike verdiğiniz değerler değişmedi.')", true);
}
else
{
string loggedusername = Session["currentuser_username"].ToString();
var likeekle = (from u in myDB.user where u.username == loggedusername select u).FirstOrDefault();
if (likeekle != null)
{
var newlike = new like();
newlike.activity_id = rollno;
newlike.user_id = loggeduserid;
if (markstatus == 1)
{
newlike.total = Convert.ToInt32(markstatus);
myDB.like.Add(newlike);
myDB.SaveChanges();
}
else
{
newlike.min = 1;
myDB.like.Add(newlike);
myDB.SaveChanges();
}
activity act = (from u in myDB.activity where u.id == newlike.activity_id select u).FirstOrDefault();
if (newlike.total == 1)
{
act.TotalLike++;
act.score++;
}
else
{
act.TotalDislike++;
act.score--;
}
myDB.SaveChanges();
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var myDB = new webDbEntities())
{
int userid = Convert.ToInt32(Session["currentuser"]);
var loggeduser = (from u in myDB.user
where u.id == userid
select u).FirstOrDefault();
var Kontrol = (from u in myDB.activity where u.title == DropDownList1.Text select u).FirstOrDefault();
if (loggeduser != null)
{
var comment = new comments();
comment.activity_id = Convert.ToInt16(Kontrol.id);
comment.user_id = userid;
comment.comment_text = TextBox1.Text;
myDB.comments.Add(comment);
myDB.SaveChanges();
Response.Redirect("activities.aspx");
}
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
using (var myDB = new webDbEntities())
{
var loggeduser = (from u in myDB.user
where u.email == TextBoxEmail.Text
select u).FirstOrDefault();
if (loggeduser != null)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), " ", "alert('Bu mail adresi kullanılıyor.')", true);
}
else
{
user newuser = new user();
newuser.name = TextBoxFname.Text;
newuser.surname = TextBoxLastName.Text;
newuser.username = TextBoxUserName.Text;
newuser.email = TextBoxEmail.Text;
newuser.birthdate = Convert.ToDateTime(TextBoxBirthDate.Text);
newuser.department = TextBoxDepartment.Text;
newuser.password = TextBoxPass.Text;
newuser.rol = 0;
if (this.fluDosya.HasFile)
{
fluDosya.SaveAs(Server.MapPath("~/Resimler/" + this.fluDosya.FileName));
string fileName = Path.GetFileName(this.fluDosya.PostedFile.FileName);
Session["ImagePath"] = "Resimler/" + fileName;
newuser.photo = Convert.ToString(Session["ImagePath"]);
}
myDB.user.Add(newuser);
myDB.SaveChanges();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), " ", "alert('Sign up Successful!')", true);
}
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
using (var myDB = new webDbEntities())
{
int loggeduserid = Convert.ToInt32(Session["currentuser"]);
var loggeduser = (from u in myDB.user
where u.id == loggeduserid
select u).FirstOrDefault();
var Activity_aynı_mı = (from u in myDB.activity
where u.title == TextBoxtitle.Text
select u).FirstOrDefault();
if (loggeduser != null)
{
if (Activity_aynı_mı != null)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), " ", "alert('Aynı Başlıkta etkinlik açamazsınız!')", true);
}
else
{
activity activity = new activity();
activity.type = TextBoxType.Text;
activity.title = TextBoxtitle.Text;
activity.activity_include = TextBoxActivity.Text;
activity.activity_by = Convert.ToInt32(Session["currentuser"]);
activity.date = Convert.ToDateTime(TextBoxDate.Text);
activity.TotalDislike = 0;
activity.TotalLike = 0;
activity.score = 0;
myDB.activity.Add(activity);
myDB.SaveChanges();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), " ", "alert('Activity added.')", true);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["currentuser"] != null)
{
if (!IsPostBack)
{
LinkButton lbMasterProfil = new LinkButton();
lbMasterProfil = (LinkButton)Master.FindControl("LinkButtonProfil");
LinkButton lbMasterActivities = new LinkButton();
lbMasterActivities = (LinkButton)Master.FindControl("LinkButtonActivities");
LinkButton lbMasterAddActivity = new LinkButton();
lbMasterAddActivity = (LinkButton)Master.FindControl("LinkButtonAddActivity");
LinkButton lbMasterLogout = new LinkButton();
lbMasterLogout = (LinkButton)Master.FindControl("LinkButtonLogout");
LinkButton lbMasterLike = new LinkButton();
lbMasterLike = (LinkButton)Master.FindControl("LinkButtonLike");
LinkButton lbMasterHomePage = new LinkButton();
lbMasterHomePage = (LinkButton)Master.FindControl("LinkButtonHomePage");
LinkButton lbMasterBestActivity = new LinkButton();
lbMasterBestActivity = (LinkButton)Master.FindControl("LinkButtonBestActivity");
lbMasterProfil.Visible = true;
lbMasterLogout.Visible = true;
lbMasterLike.Visible = true;
lbMasterHomePage.Visible = true;
lbMasterBestActivity.Visible = true;
lbMasterAddActivity.Visible = true;
lbMasterActivities.Visible = true;
Label lblWelcome = new Label();
lblWelcome = (Label)Master.FindControl("LabelWelcome");
lblWelcome.Text = Session["Currentuser_name"].ToString() + ' ' + Session["Currentuser_surname"].ToString();
lblWelcome.Visible = true;
if (Convert.ToInt32(Session["currentuser_rol"]) == 1)
{
LinkButton lbMasterAdmin = new LinkButton();
lbMasterAdmin = (LinkButton)Master.FindControl("LinkButtonAdmin");
lbMasterAdmin.Visible = true;
}
}
if (!Page.IsPostBack)
{
if (Session["Currentuser_email"] != null)
{
using (var myDB = new webDbEntities())
{
var allact = (from u in myDB.activity
select u).ToList();
DateTime currentdate = Convert.ToDateTime(DateTime.Now);
foreach (var x in allact.ToList())
{
DateTime dob = Convert.ToDateTime(x.date);
TimeSpan time = currentdate.Subtract(dob);
int control = time.Days;
if (control > 15)
{
allact.Remove(x);
}
}
GridView1.DataSource = allact;
GridView1.DataBind();
}
}
}
}
else
{
Response.Redirect("login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["currentuser"] != null)
{
if (!IsPostBack)
{
LinkButton lbMasterProfil = new LinkButton();
lbMasterProfil = (LinkButton)Master.FindControl("LinkButtonProfil");
LinkButton lbMasterActivities = new LinkButton();
lbMasterActivities = (LinkButton)Master.FindControl("LinkButtonActivities");
LinkButton lbMasterAddActivity = new LinkButton();
lbMasterAddActivity = (LinkButton)Master.FindControl("LinkButtonAddActivity");
LinkButton lbMasterLogout = new LinkButton();
lbMasterLogout = (LinkButton)Master.FindControl("LinkButtonLogout");
LinkButton lbMasterLike = new LinkButton();
lbMasterLike = (LinkButton)Master.FindControl("LinkButtonLike");
LinkButton lbMasterHomePage = new LinkButton();
lbMasterHomePage = (LinkButton)Master.FindControl("LinkButtonHomePage");
LinkButton lbMasterBestActivity = new LinkButton();
lbMasterBestActivity = (LinkButton)Master.FindControl("LinkButtonBestActivity");
lbMasterProfil.Visible = true;
lbMasterLogout.Visible = true;
lbMasterLike.Visible = true;
lbMasterHomePage.Visible = true;
lbMasterBestActivity.Visible = true;
lbMasterAddActivity.Visible = true;
lbMasterActivities.Visible = true;
Label lblWelcome = new Label();
lblWelcome = (Label)Master.FindControl("LabelWelcome");
lblWelcome.Text = Session["Currentuser_name"].ToString() + ' ' + Session["Currentuser_surname"].ToString();
lblWelcome.Visible = true;
if (Convert.ToInt32(Session["currentuser_rol"]) == 1)
{
LinkButton lbMasterAdmin = new LinkButton();
lbMasterAdmin = (LinkButton)Master.FindControl("LinkButtonAdmin");
lbMasterAdmin.Visible = true;
}
}
using (var myDB = new webDbEntities())
{
var A_mail = Session["Currentuser_email"].ToString();
if (!IsPostBack)
{
var loggeduser = (from u in myDB.user
where u.email == A_mail
select u).FirstOrDefault();
if (loggeduser != null)
{
TextBoxFname.Text = loggeduser.name;
TextBoxLastName.Text = loggeduser.surname;
TextBoxEmail.Text = loggeduser.email;
TextBoxDepartment.Text = loggeduser.department;
TextBoxUserName.Text = loggeduser.username;
ProfilResmi.ImageUrl = Session["ImagePath"].ToString();
}
}
}
}
else
{
Response.Redirect("login.aspx");
}
}
protected void DeleteUser(object sender, GridViewDeleteEventArgs e)
{
int r = Convert.ToInt32(e.RowIndex.ToString());
int butonubul = int.Parse(GridView1.DataKeys[r].Value.ToString());
int kullanıcı = Convert.ToInt32(Session["currentuser"]);
if (butonubul == kullanıcı)
{
Response.Redirect("admin");
}
else
{
using (var db = new webDbEntities())
{
user users = db.user.Where(x => x.id == butonubul).FirstOrDefault();
List <activity> aktivite_listesi = (from u in db.activity
where u.activity_by == butonubul
select u).ToList();
foreach (var Item in aktivite_listesi)
{
List <like> L_list = (from u in db.like
where Item.id == u.activity_id
select u).ToList();
foreach (var i in L_list)
{
db.like.Remove(i);
}
List <comments> C_list = (from u in db.comments
where Item.id == u.activity_id
select u).ToList();
foreach (var x in C_list)
{
db.comments.Remove(x);
}
}
db.SaveChanges();
List <like> likes_listesi = (from u in db.like
where butonubul == u.user_id
select u).ToList();
List <comments> comment_listesi = (from u in db.comments
where butonubul == u.user_id
select u).ToList();
foreach (var x in likes_listesi)
{
db.like.Remove(x);
}
db.SaveChanges();
foreach (var y in comment_listesi)
{
db.comments.Remove(y);
}
db.SaveChanges();
foreach (var Item in aktivite_listesi)
{
db.activity.Remove(Item);
db.SaveChanges();
}
db.user.Remove(users);
db.SaveChanges();
}
}
}
