protected void btnLogin_Click(object sender, EventArgs e)
{
db = new ScoreManageDataContext();
string username = txtUser.Value;
string password = txtPass.Value;
var myquery = from i in db.Accounts
join j in db.Students on i.Username equals j.ID
where i.Username == username && i.Password == password
select new { i.Username, j.FirstName, j.LastName };
if (myquery.Any())
{
Session["id"] = myquery.First().Username;
Session["username"] = myquery.First().FirstName + " " + myquery.First().LastName;
Response.Redirect("SVHome.aspx");
}
else
{
var myquery2 = from i in db.Accounts
join j in db.Lecturers on i.Username equals j.ID
where i.Username == username && i.Password == password
select new { i.Username, j.FirstName, j.LastName };
if (myquery2.Any())
{
Session["id"] = myquery2.First().Username;
Session["username"] = myquery2.First().FirstName + " " + myquery2.First().LastName;
Response.Redirect("LopHocPhanGV.aspx");
}
else
{
Response.Write("<script>alert('Đăng nhập thất bại mời thử lại')</script>");
}
}
}
protected void btnXem_Click(object sender, EventArgs e)
{
db = new ScoreManageDataContext();
string id = Session["id"].ToString();
var namhoc = DropNamhoc.SelectedValue.ToString();
var hocky = Convert.ToInt32(Drophocky.SelectedValue.ToString());
var monhoc = DropMonhoc.SelectedValue.ToString();
var query = from en in db.Enrollments
join sc in db.Scores on en.ID equals sc.IDEnrollment
join sct in db.SchoolTerms on en.IdSchoolTerm equals sct.ID
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where st.ID == id && sct.SchoolYear == namhoc && t.Name == monhoc
select new
{
t.Name,
sc.Diligent,
sc.MidTerm,
sc.Pratice,
sc.Exam,
Tongket = (((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + ((double)sc.Exam * 45 + (double)sc.Pratice * 15)) / 60).ToString().Substring(0, 4),
Diemhe4 = (((((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + ((double)sc.Exam * 45 + (double)sc.Pratice * 15)) / 60) * 4) / 10).ToString().Substring(0, 4),
sc.Evaluate
};
GridView1.DataSource = query;
GridView1.DataBind();
}
protected void btnkiemtra_Click(object sender, EventArgs e)
{
db = new ScoreManageDataContext();
AddModal.Visible = true;
var query = from st in db.Students
where st.ID == txtaddSV.Text
select st;
if (query.Any())
{
var query2 = from i in db.Students
join sc in db.Scores on i.ID equals sc.IDStudent
where sc.IDStudent == query.First().ID
select sc;
if (query2.Any())
{
thongbao.Text = "Sinh viên đã tồn tại trong lớp";
lbNameSV.Text = "";
btnThem.Visible = false;
}
else
{
thongbao.Text = "Bạn có muốn thêm sinh viên: ";
lbNameSV.Text = query.First().FirstName + " " + query.First().LastName;
}
}
else
{
thongbao.Text = "Sinh viên không tồn tại";
lbNameSV.Text = "";
btnThem.Visible = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
db = new ScoreManageDataContext();
string IDT = Dlist.SelectedValue.ToString();
var query = from l in db.Lecturers
join en in db.Enrollments on l.ID equals en.IDLecturer
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where l.ID == id && t.ID == IDT && st.ID == txtmasv.Text
select sc;
Score myscore = query.FirstOrDefault();
myscore.Diligent = Convert.ToDouble(txtcc.Text);
myscore.MidTerm = Convert.ToDouble(txtgk.Text);
myscore.Pratice = Convert.ToDouble(txtth.Text);
myscore.Exam = Convert.ToDouble(txtthi.Text);
double tongket = (Convert.ToDouble(txtcc.Text) * 0.1 + Convert.ToDouble(txtgk.Text) * 0.2 + (Convert.ToDouble(txtthi.Text) * 45 + Convert.ToDouble(txtth.Text) * 15) / 60) * 0.7;
if (tongket > 4.0)
{
myscore.Evaluate = "DAT";
}
else
{
myscore.Evaluate = "KHONG DAT";
}
db.SubmitChanges();
EditModal.Visible = false;
//Response.Redirect("QLDiemGV.aspx");
Dlist_SelectedIndexChanged(sender, e);
}
protected void Dlist_SelectedIndexChanged(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
string IDT = Dlist.SelectedValue.ToString();
db = new ScoreManageDataContext();
var query = from l in db.Lecturers
join en in db.Enrollments on l.ID equals en.IDLecturer
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where l.ID == id && t.ID == IDT
select new
{
st.FirstName,
st.LastName,
st.ID,
sc.Diligent,
sc.Pratice,
sc.MidTerm,
sc.Exam,
Tongket = ((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + (((double)sc.Exam * 45 + (double)sc.Pratice * 15) / 60) * 0.7).ToString().Substring(0, 4)
};
GridView1.DataSource = query;
GridView1.DataBind();
}
protected void btnCapnhat_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
db = new ScoreManageDataContext();
var query = from l in db.Students
where l.ID == id
select l;
Student myStu = query.First();
myStu.FirstName = txtFname.Text;
myStu.LastName = txtLname.Text;
//myStu.Gender = txtGioitinh.SelectedValue.ToString();
myStu.DateOfBirth = DateTime.Parse(txtNgaysinh.Text);
if (txtGioitinh.Text == "Nam")
{
myStu.Gender = true;
}
else
{
myStu.Gender = false;
}
myStu.Address = txtDiachi.Text;
myStu.Phone = txtDienthoai.Text;
db.SubmitChanges();
Response.Write("<script>alert('Cập nhật thành công'); window.location.href = 'SVHome.aspx';</script>");
}
protected void btnChange_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
db = new ScoreManageDataContext();
var query = from i in db.Accounts
where i.Username == id && i.Password == txtPass.Text
select i;
if (query.Any())
{
if (txtnewPass.Text == txtrePass.Text)
{
Account myAcc = query.First();
myAcc.Password = txtnewPass.Text;
db.SubmitChanges();
Response.Write("<script>alert('Đổi mật khẩu thành công'); window.location.href = 'PasswordSV.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!'); window.location.href = 'PasswordSV.aspx'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
db = new ScoreManageDataContext();
string id = Session["id"].ToString();
string user = Session["username"].ToString();
accname.Text = user;
var query = from st in db.Students
join c in db.Conducts on st.ID equals c.IDStudent
join sct in db.SchoolTerms on c.IDSchoolTerm equals sct.ID
where st.ID == id
select new { sct.SchoolYear, sct.Semester, c.ScoreOfConduct, c.Classification };
GridView1.DataSource = query;
GridView1.DataBind();
}
protected void DropNamhoc_SelectedIndexChanged(object sender, EventArgs e)
{
db = new ScoreManageDataContext();
string id = Session["id"].ToString();
var monhoc = from en in db.Enrollments
join sc in db.Scores on en.ID equals sc.IDEnrollment
join sct in db.SchoolTerms on en.IdSchoolTerm equals sct.ID
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where st.ID == id && sct.SchoolYear == DropNamhoc.SelectedValue.ToString()
select new { t.Name };
DropMonhoc.DataSource = monhoc;
DropMonhoc.DataTextField = "Name";
DropMonhoc.DataBind();
Page_Load(sender, e);
}
protected void btnXoa_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
db = new ScoreManageDataContext();
string IDT = Dlist.SelectedValue.ToString();
DeleteModal.Visible = false;
var query = from l in db.Lecturers
join en in db.Enrollments on l.ID equals en.IDLecturer
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where l.ID == id && t.ID == IDT && st.ID == svID.Text
select sc;
db.Scores.DeleteAllOnSubmit(query);
db.SubmitChanges();
Dlist_SelectedIndexChanged(sender, e);
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
accname.Text = username;
db = new ScoreManageDataContext();
if (!IsPostBack)
{
var query = from l in db.Students
where l.ID == id
select new
{
l.ID,
l.FirstName,
l.LastName,
l.DateOfBirth,
l.Gender,
l.Address,
l.Phone
};
txtMasv.Text = query.First().ID;
txtFname.Text = query.First().FirstName;
txtLname.Text = query.First().LastName;
txtNgaysinh.Text = Convert.ToString(query.First().DateOfBirth);
//txtGioitinh.SelectedValue.ToString();
string Gioitinh = Convert.ToString(query.First().Gender);
if (Gioitinh == "True")
{
txtGioitinh.Text = "Nam";
}
else
{
txtGioitinh.Text = "Nữ";
}
txtDiachi.Text = query.First().Address;
txtDienthoai.Text = query.First().Phone;
accname.Text = username;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
db = new ScoreManageDataContext();
if (!IsPostBack)
{
var query = from l in db.Lecturers
join s in db.Specializes on l.IdSpecialize equals s.ID
join m in db.Majors on s.IdMajors equals m.ID
join d in db.Departments on m.IDDepartment equals d.ID
where l.ID == id
select new
{
l.ID,
l.FirstName,
l.LastName,
l.Degree,
l.Position,
l.Phone,
l.Email,
s.SpecializeName,
mName = m.Name,
dName = d.Name,
};
txtMagv.Text = query.First().ID;
txtFname.Text = query.First().FirstName;
txtLname.Text = query.First().LastName;
txtTrinhdo.Text = query.First().Degree;
txtChucvu.Text = query.First().Position;
txtDienthoai.Text = query.First().Phone;
txtEmail.Text = query.First().Email;
txtChuyennganh.Text = query.First().SpecializeName;
txtNganh.Text = query.First().mName;
txtKhoa.Text = query.First().dName;
accName.Text = username;
}
}
protected void btnCapnhat_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
db = new ScoreManageDataContext();
var query = from l in db.Lecturers
join s in db.Specializes on l.IdSpecialize equals s.ID
join m in db.Majors on s.IdMajors equals m.ID
join d in db.Departments on m.IDDepartment equals d.ID
where l.ID == id
select l;
Lecturer myLec = query.First();
myLec.FirstName = txtFname.Text;
myLec.LastName = txtLname.Text;
myLec.Degree = txtTrinhdo.Text;
myLec.Position = txtChucvu.Text;
myLec.Phone = txtDienthoai.Text;
myLec.Email = txtEmail.Text;
db.SubmitChanges();
Response.Write("<script>alert('Cập nhật thành công'); window.location.href = 'ProfileGV.aspx';</script>");
}
protected void btnThem_Click(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string IDT = Dlist.SelectedValue.ToString();
db = new ScoreManageDataContext();
var query = from l in db.Lecturers
join en in db.Enrollments on l.ID equals en.IDLecturer
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where l.ID == id && t.ID == IDT
select en.ID;
Score mysc = new Score();
mysc.IDEnrollment = query.First();
mysc.IDStudent = txtaddSV.Text;
db.Scores.InsertOnSubmit(mysc);
db.SubmitChanges();
AddModal.Visible = false;
Dlist_SelectedIndexChanged(sender, e);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
db = new ScoreManageDataContext();
string id = Session["id"].ToString();
string username = Session["username"].ToString();
accname.Text = username;
var query = from l in db.Lecturers
join en in db.Enrollments on l.ID equals en.IDLecturer
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where l.ID == id
select new { t.ID, t.Name };
Dlist.DataSource = query.Distinct();
Dlist.DataValueField = "ID";
Dlist.DataTextField = "Name";
Dlist.DataBind();
Dlist_SelectedIndexChanged(sender, e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
db = new ScoreManageDataContext();
string id = Session["id"].ToString();
string user = Session["username"].ToString();
accname.Text = user;
var namhoc = from i in db.SchoolTerms
select i.SchoolYear;
DropNamhoc.DataSource = namhoc.Distinct();
//DropNamhoc.DataTextField = "SchoolYear";
DropNamhoc.DataBind();
var query = from en in db.Enrollments
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where st.ID == id
select new
{
t.Name,
sc.Diligent,
sc.MidTerm,
sc.Pratice,
sc.Exam,
Tongket = ((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + (((double)sc.Exam * 45 + (double)sc.Pratice * 15) / 60) * 0.7).ToString().Substring(0, 4),
Diemhe4 = ((((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + (((double)sc.Exam * 45 + (double)sc.Pratice * 15) / 60) * 0.7) * 4) / 10).ToString().Substring(0, 4),
sc.Evaluate
};
GridView1.DataSource = query;
GridView1.DataBind();
}
}
protected void Dlist_SelectedIndexChanged(object sender, EventArgs e)
{
string id = Session["id"].ToString();
string username = Session["username"].ToString();
string IDT = Dlist.SelectedValue.ToString();
db = new ScoreManageDataContext();
var query = from l in db.Lecturers
join en in db.Enrollments on l.ID equals en.IDLecturer
join sc in db.Scores on en.ID equals sc.IDEnrollment
join st in db.Students on sc.IDStudent equals st.ID
join t in db.Terms on en.IDTerm equals t.ID
where l.ID == id && t.ID == IDT
select new
{
st.FirstName,
st.LastName,
st.ID,
st.DateOfBirth
};
GridView1.DataSource = query;
GridView1.DataBind();
}
