protected void Page_Load(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
db = new ConnectDataContext();
if (!IsPostBack)
{
var query = from a in db.GiangViens
join b in db.ChuyenMons on a.MaCM equals b.MaCM
where a.MaGV == id
select new
{
a.MaGV,
a.HoTen,
a.GioiTinh,
a.TrinhDo,
a.ChucVu,
b.TenCM
};
txtMagv.Text = id;
txtHoten.Text = query.First().HoTen;
txtGioiTinh.Text = query.First().GioiTinh;
txtTrinhdo.Text = query.First().TrinhDo;
txtChucvu.Text = query.First().ChucVu;
txtChuyenmon.Text = query.First().TenCM;
accName.Text = username;
}
}
protected void btnDangNhap_Click(object sender, EventArgs e)
{
db = new ConnectDataContext();
string username = txtUsername.Value;
string password = txtPassword.Value;
var myquery = from i in db.TaiKhoans
join j in db.SinhViens on i.TenDN equals j.Mssv
where i.TenDN == username && i.MatKhau == password
select new { i.TenDN, j.HoTen };
if (myquery.Any())
{
Session["id"] = myquery.First().TenDN;
Session["username"] = myquery.First().HoTen;
Response.Redirect("SinhVien.aspx");
}
else
{
var myquery1 = from i in db.TaiKhoans
join j in db.GiangViens on i.TenDN equals j.MaGV
where i.TenDN == username && i.MatKhau == password
select new { i.TenDN, j.HoTen };
if (myquery1.Any())
{
Session["id"] = myquery1.First().TenDN;
Session["username"] = myquery1.First().HoTen;
Response.Redirect("GiangVien.aspx");
}
else
{
Response.Write("<script>alert('Đăng nhập thất bại mời thử lại')</script>");
}
}
}
protected void btnCapnhat_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
db = new ConnectDataContext();
var query = from i in db.TaiKhoans
where i.TenDN == id
select i;
if (id == query.First().TenDN)
{
if (query.Any())
{
if (txtMKM.Text == txtNhaplai.Text)
{
TaiKhoan myAcc = query.First();
myAcc.MatKhau = txtMKM.Text;
db.SubmitChanges();
Response.Write("<script>alert('Đổi mật khẩu thành công'); window.location.href = 'Doimatkhau.aspx'</script>");
//Response.Redirect("PasswordGv.aspx");
}
else
{
Response.Write("<script>alert('Mật khẩu nhập lại không đúng');</script>");
}
}
else
{
Response.Write("<script>alert('Mật khẩu cũ sai!');</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string username = Session["username"].ToString();
string id = Session["id"].ToString();
accName.Text = username;
db = new ConnectDataContext();
if (!IsPostBack)
{
var myQuery = from i in db.MonHocs
where i.MaGV == id
select i;
DrMaHP.DataSource = myQuery;
DrMaHP.DataValueField = "MaMon";
DrMaHP.DataTextField = "TenMon";
DrMaHP.DataBind();
DrMaHP_SelectedIndexChanged(sender, e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
db = new ConnectDataContext();
if (!IsPostBack)
{
var query = from a in db.SinhViens
where a.Mssv == id
select a;
txtMssv.Text = query.First().Mssv;
txtHoTen.Text = query.First().HoTen;
txtGioiTinh.Text = query.First().GioiTinh;
txtNgaySinh.Text = query.First().NgaySinh;
txtLop.Text = query.First().Lop;
txtDiaChi.Text = query.First().DiaChi;
accName.Text = username;
}
}
