protected void Page_Load(object sender, EventArgs e)
{
string Username = HttpContext.Current.User.Identity.Name;
perlabEntities db = new perlabEntities();
var user = db.users.FirstOrDefault(p => p.username == Username);
if (user != null)
{
if (user.role == 1) // admin
{
RegisterHyperLink.Visible = true;
}
else
{
RegisterHyperLink.Visible = false;
}
}
else
{
RegisterHyperLink.Visible = false;
}
RegisterHyperLink.NavigateUrl = "Register";
OpenAuthLogin.ReturnUrl = Request.QueryString["ReturnUrl"];
var returnUrl = HttpUtility.UrlEncode(Request.QueryString["ReturnUrl"]);
if (!String.IsNullOrEmpty(returnUrl))
{
RegisterHyperLink.NavigateUrl += "?ReturnUrl=" + returnUrl;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
txtPlace.Text = String.Empty;
txtDeadline.Text = String.Empty;
txtCall.Text = String.Empty;
txtYear.Text = String.Empty;
txtSearch.Text = String.Empty;
txtTitle.Text = String.Empty;
txtLink.Text = String.Empty;
txtDescrip.Text = String.Empty;
}
string Username = HttpContext.Current.User.Identity.Name;
perlabEntities db = new perlabEntities();
var user = db.users.FirstOrDefault(p => p.username == Username);
if (user != null) // Not Login
{
if (Convert.ToInt32(user.role) != 1) // Not admin
{
Response.Redirect("~/Default.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
//protected string SuccessMessage
//{
// get;
// private set;
//}
//protected bool CanRemoveExternalLogins
//{
// get;
// private set;
//}
//private bool HasPassword(UserManager manager)
//{
// var user = manager.FindById(User.Identity.GetUserId());
// return (user != null && user.PasswordHash != null);
//}
protected void Page_Load()
{
if (!IsPostBack)
{
perlabEntities db = new perlabEntities();
string usrname = HttpContext.Current.User.Identity.Name;
var user = db.users.FirstOrDefault(p => p.username == usrname);
if (user != null)
{
if (user.role == 1)
{
// Register_user.Visible = true;
}
UserName.Text = user.username;
Password.Text = user.password;
Email.Text = user.email;
}
else
{
// Register_user.Visible = false;
Response.Redirect("~/Default.aspx");
}
}
}
//protected void ChangePassword_Click(object sender, EventArgs e)
//{
// if (IsValid)
// {
// //UserManager manager = new UserManager();
// //IdentityResult result = manager.ChangePassword(User.Identity.GetUserId(), CurrentPassword.Text, NewPassword.Text);
// //if (result.Succeeded)
// //{
// // Response.Redirect("?m=ChangePwdSuccess");
// //}
// //else
// //{
// // AddErrors(result);
// //}
// }
//}
//protected void SetPassword_Click(object sender, EventArgs e)
//{
// if (IsValid)
// {
// }
//}
protected void btn_Save_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
string usrname = HttpContext.Current.User.Identity.Name;
var user = db.users.FirstOrDefault(p => p.username == usrname);
if (user != null)
{
user.email = Email.Text;
if (db.users.Any(p => p.username == UserName.Text))
{
LResult.Text = "this username already exist!";
//;
LResult.ForeColor = Color.Red;
}
else if (!db.users.Any(p => p.username == UserName.Text))
{
user.username = UserName.Text;
}
if (Password.Text == Confirm_Password.Text)
{
user.password = Password.Text;
}
db.SaveChanges();
LResult.Text = "your information update successfully!";
LResult.ForeColor = Color.Green;
}
else
{
LResult.Text = "کاربری یافت نشد";
LResult.ForeColor = Color.Red;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
if (Request.QueryString.AllKeys.Any(p => p == "id"))
{
string idstr = Request.QueryString["id"];
int.TryParse(idstr, out id);
//perlabEntities db = new perlabEntities();
using (perlabEntities db = new perlabEntities())
{
var query = from p in db.people
where p.people_id == id
select p.publications;
foreach (publication item in query)
{
}
}
string username = HttpContext.Current.User.Identity.Name; //
// var user = db.users.FirstOrDefault(p => p.username == username);
// add.Enabled = user != null;
// var pro =db.publications.FirstOrDefault(p => p.p == id);
// if (pro != null)
}
}
public void BindGridView()
{
var db = new perlabEntities();
var result = from e in db.eventsfeeds
select new { e.event_id, e.title, e.link, e.place, e.deadline, e.call, e.year, e.descrip, e.active };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
}
public void BindGridView()
{
var db = new perlabEntities();
var result = from p in db.people
select new { p.people_id, p.name, p.link, p.email, p.gradstatus, p.type, p.active, p.descrip, p.picSrc };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
}
public void BindGridView()
{
var db = new perlabEntities();
var result = from n in db.newsfeeds
select new { n.news_id, n.title, n.news_day, n.link, n.descrip, n.active };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
}
public void BindGridView()
{
var db = new perlabEntities();
var result = from e in db.datasets
select new { e.data_id, e.filename, e.description, e.filepath };
datagrid.DataSource = result.ToList();
datagrid.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string Username = HttpContext.Current.User.Identity.Name;
perlabEntities db = new perlabEntities();
var user = db.users.FirstOrDefault(p => p.username == Username);
// if (user != null) // Login
//{
// if (Convert.ToInt32(user.role )!=1) // Not admin
// {
// Response.Redirect("~/Default.aspx");
// }
// else if (!FUImage.HasFile)
// {
//default
// }
if (!FUImage.FileName.EndsWith(".jpg") && !FUImage.FileName.EndsWith(".png"))
{
LResult.Text = "wrong preview format";
LResult.ForeColor = Color.Red;
}
else
{
string fileName = Path.GetFileName(FUImage.PostedFile.FileName);
FUImage.PostedFile.SaveAs(Server.MapPath(azmayeshgah.MyUtility.MyConfigs.PeopleImageDir) + fileName); // تبدیل آدرس نسبی به آدرس حقیقی و ذخیره عکس در آنجا
azmayeshgah.Models.person pe = new azmayeshgah.Models.person()
{
name = txtName.Text,
link = txtLink.Text,
email = txtEmail.Text,
gradstatus = dropGrad.SelectedItem.Text,
type = dropType.SelectedItem.Text,
active = dropActive.SelectedItem.Text,
descrip = txtDescrip.Text,
picSrc = fileName
};
db.people.Add(pe);
db.SaveChanges();
LResult.Text = "Successfully Saved";
BindGridView();
LResult.ForeColor = Color.Green;
}
// }
// else
// {
// Response.Redirect("~/Default.aspx");
// }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
dataset obj = new dataset();
var key = (txtSearch.Text);
var result = from da in db.datasets
where da.description.Contains(key)
select new { da.filename, da.description };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
newsfeed obj = new newsfeed();
var key = (txtSearch.Text);
var result = from ne in db.newsfeeds
where ne.title.Contains(key)
select new { ne.news_id, ne.title, ne.link, ne.active, ne.descrip };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
DeleteTxt();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
person obj = new person();
obj.people_id = int.Parse((txtSearch.Text));
var result = from p in db.people
where p.people_id == obj.people_id
select new { p.people_id, p.name, p.email, p.descrip };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
var db = new perlabEntities();
txtNewsId.Text = GridView1.SelectedRow.Cells[1].Text;
txtTitle.Text = GridView1.SelectedRow.Cells[2].Text;
txtLink.Text = GridView1.SelectedRow.Cells[3].Text;
dropActive.SelectedItem.Text = GridView1.SelectedRow.Cells[4].Text;
int newsID = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text);
var result = db.newsfeeds.FirstOrDefault(n => n.news_id == newsID);
txtDescrip.Text = result.descrip;
// LResult.Text = result.title + "hi";
}
protected void btnSearch_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
eventsfeed obj = new eventsfeed();
var key = (txtSearch.Text);
var result = from ev in db.eventsfeeds
where ev.descrip.Contains(key)
select new { ev.title, ev.descrip, ev.call, ev.deadline };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
DeleteTxt();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
person obj = new person();
obj.people_id = int.Parse((txtPeopleID.Text));
var result = (from p in db.people
where p.people_id == obj.people_id
select p).Single();
db.people.Remove(result);
db.SaveChanges();
BindGridView();
}
protected void Login_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
if (db.users.Any(p => p.username == UserName.Text && p.password == Password.Text))
{
FormsAuthentication.SetAuthCookie(UserName.Text, true);
Result.Text = "successfull log In";
Response.Redirect("~/Default.aspx");
}
else
{
Result.Text = "Wrong username or password";
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
dataset obj = new dataset();
obj.data_id = int.Parse((txtDataId.Text));
var result = (from p in db.datasets
where p.data_id == obj.data_id
select p).Single();
db.datasets.Remove(result);
db.SaveChanges();
BindGridView();
}
protected void Page_Load(object sender, EventArgs e)
{
//DropDownList ShowOption = new DropDownList();
//ShowOption.Visible = true;
UnderConstruct.Visible = false;
datagrid.Visible = false;
string Username = HttpContext.Current.User.Identity.Name;
perlabEntities db = new perlabEntities();
var user = db.users.FirstOrDefault(p => p.username == Username);
if (user != null)
{
BindGridView();
datagrid.Visible = true;
}
else
{
UnderConstruct.Visible = true;
}
//ShowOption.Items.Add("show under construction image ");
//ShowOption.Items.Add("show dataset option");
//if (ShowOption.SelectedItem.Text == "show dataset option")
// {
// if (user == null)// not logged in
// {
// Response.Redirect("~/Default.aspx");
// }
// if (Convert.ToInt32(user.role) == 0 || Convert.ToInt32(user.role) == 1)// logged in as user or admin
// {
// datagrid.Visible = true;
// //بتونه دیتاست ببینه و دانلود کنه
// }
// }
//else if (ShowOption.SelectedItem.Text == "show under construction image")
//{
// underConstruct.Visible = true;
//}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
newsfeed obj = new newsfeed();
obj.news_id = int.Parse((txtNewsId.Text));
var result = (from n in db.newsfeeds
where n.news_id == obj.news_id
select n).Single();
db.newsfeeds.Remove(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
eventsfeed obj = new eventsfeed();
obj.event_id = int.Parse((txtEventId.Text));
var result = (from p in db.eventsfeeds
where p.event_id == obj.event_id
select p).Single();
db.eventsfeeds.Remove(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
public IQueryable <Models.eventsfeed> Get_5event(int?eventID)
{
var _db = new perlabEntities();
{
var ev = _db.eventsfeeds.ToList();
IQueryable <Models.eventsfeed> query = (from even in ev
select new eventsfeed
{
title = even.title,
call = even.call,
link = even.link,
deadline = even.deadline,
place = even.place,
}).Take(5).AsQueryable();
return(query);
}
}
public IQueryable <Models.eventsfeed> Get_event(int?event_id)
{
var _db = new perlabEntities();
//string querystr = Request.QueryString["qusery"];
var eventlist = _db.eventsfeeds.ToList();
IQueryable <Models.eventsfeed> query = (from ev in eventlist
where ev.event_id == event_id
orderby ev.title
select new eventsfeed
{
title = ev.title,
link = ev.link,
descrip = ev.descrip,
}).AsQueryable().Take(5);
return(query);
}
public IQueryable <Models.newsfeed> Get_News(int?newsID)
{
var _db = new perlabEntities();
{
//string querystr = Request.QueryString["qusery"];
var newsfd = _db.newsfeeds.ToList();
IQueryable <Models.newsfeed> query = (from n in newsfd
select new newsfeed
{
link = n.link,
title = n.title,
descrip = n.descrip,
news_day = n.news_day,
}).AsQueryable();
//query = query.Where(p => p.name.Contains(querystr) && p.type == "Academic Staff");
return(query);
}
}
public IQueryable <Models.newsfeed> Get_news(int?news_id)
{
var _db = new perlabEntities();
//string querystr = Request.QueryString["qusery"];
var newslist = _db.newsfeeds.ToList();
IQueryable <Models.newsfeed> query = (from news in newslist
where news.news_id == news_id
orderby news.news_day
select new newsfeed
{
title = news.title,
link = news.link,
descrip = news.descrip,
}).AsQueryable().Take(5);
return(query);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string Username = HttpContext.Current.User.Identity.Name;
perlabEntities db = new perlabEntities();
var user = db.users.FirstOrDefault(p => p.username == Username);
if (user != null) // Login
{
if (Convert.ToInt32(user.role) != 1) // Not admin
{
Response.Redirect("~/Default.aspx");
}
else
{
azmayeshgah.Models.eventsfeed ev = new azmayeshgah.Models.eventsfeed()
{
title = txtTitle.Text,
link = txtLink.Text,
place = txtPlace.Text,
call = txtCall.Text,
deadline = txtDeadline.Text,
year = int.Parse(txtYear.Text),
active = (dropActive.SelectedItem.Text == "Yes")?true : false,
descrip = txtDescrip.Text,
};
db.eventsfeeds.Add(ev);
db.SaveChanges();
LResult.Text = "Successfully Saved";
BindGridView();
DeleteTxt();
LResult.ForeColor = Color.Green;
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
newsfeed obj = new newsfeed();
obj.news_id = int.Parse((txtNewsId.Text));
var result = (from n in db.newsfeeds
where n.news_id == obj.news_id
select n).Single();
result.title = txtTitle.Text;
result.link = txtLink.Text;
result.descrip = txtDescrip.Text;
result.active = (dropActive.SelectedItem.Text) == "Yes"?true:false;
result.descrip = txtDescrip.Text;
db.newsfeeds.Add(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
public IQueryable <Models.person> Get_MSc_students(int?PeopleId)
{
var _db = new perlabEntities();
//if (Request.QueryString.AllKeys.Any(p => p == "query"))
{
//string querystr = Request.QueryString["qusery"];
var persons = _db.people.ToList();
IQueryable <Models.person> query = (from user in persons
where user.type.Equals("M.Sc. students")
select new person
{
name = user.name,
room = user.room,
link = user.link,
email = user.email,
picSrc = user.picSrc == null ? "../image/no-image-icon-md.png" : "../Content/Pic/" + user.picSrc,
}).AsQueryable();
//query = query.Where(p => p.name.Contains(querystr) && p.type == "Academic Staff");
return(query);
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
eventsfeed obj = new eventsfeed();
obj.event_id = int.Parse((txtEventId.Text));
var result = (from p in db.eventsfeeds
where p.event_id == obj.event_id
select p).Single();
result.call = txtCall.Text;
result.link = txtLink.Text;
result.deadline = txtDeadline.Text;
result.active = (int.Parse(dropActive.SelectedItem.Text) == 1) ? true : false;
result.descrip = txtDescrip.Text;
db.eventsfeeds.Add(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
string Username = HttpContext.Current.User.Identity.Name;
perlabEntities db = new perlabEntities();
var user = db.users.FirstOrDefault(p => p.username == Username);
if (user != null) // Not Login
{
if (Convert.ToInt32(user.role) != 1) // Not admin
{
Response.Redirect("~/Default.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
