public void LoadDSDiem()
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_sql = "Select tbl_diem.Masv, Tensv, Tenmh, DiemC, DiemB, Diemthilan1, Diemthilan2, DiemTB, Xeploai, tbl_diem.Hocki, Namhoc From (tbl_diem inner join tbl_monhoc on (Monhoc=Mamh) inner join tbl_sinhvien on (tbl_diem.Masv = tbl_sinhvien.Masv )) order by Masv;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlDataReader sqlre = sqlcm.ExecuteReader();
int sott = 0;
string kq = "";
while (sqlre.Read())
{
sott++;
kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tensv"].ToString() + "</td><td>" + sqlre["Tenmh"].ToString() + "</td><td>" + sqlre["DiemC"].ToString() + "</td><td>" + sqlre["DiemB"].ToString() + "</td><td>" + sqlre["Diemthilan1"].ToString() + "</td><td>" + sqlre["Diemthilan2"].ToString() + "</td><td>" + sqlre["DiemTB"].ToString() + "</td><td>" + sqlre["Xeploai"].ToString() + "</td><td>" + sqlre["Hocki"].ToString() + "</td><td>" + sqlre["Namhoc"].ToString() + "</td><td><a title='Sửa điểm' href='QuanlyDiem.aspx?type=edit&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a>" + "</td><td>" + "<a title='Xóa điểm' href='QuanlyDiem.aspx?type=delete&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>";
}
sqlre.Close();
ltr_dsdiem.Text = kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
public void LoadScoreTable()
{
cls_connectDB cls_con = new cls_connectDB();
try
{
string sql = @"SELECT Mamh, Tenmh, DiemC, DiemB, Diemthilan1, Diemthilan2, DiemTB, Xeploai, tbl_diem.Hocki, Namhoc
FROM (dbo.tbl_diem inner join dbo.tbl_monhoc ON Monhoc = Mamh)
WHERE Masv = @masv;";
cls_con.connect_DB();
SqlCommand sqlcm = new SqlCommand(sql, cls_con.sql_con);
sqlcm.Parameters.Add(new SqlParameter("Masv", Convert.ToInt32(Request.QueryString["search"])));
SqlDataReader sqlre = sqlcm.ExecuteReader();
string kq = "";
int sott = 0;
while (sqlre.Read())
{
sott++;
kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Mamh"].ToString() + "</td><td>" + sqlre["Tenmh"].ToString() + "</td><td>" + sqlre["DiemC"].ToString() + "</td><td>" + sqlre["DiemB"].ToString() + "</td><td>" + sqlre["Diemthilan1"].ToString() + "</td><td>" + sqlre["Diemthilan2"].ToString() + "</td><td>" + sqlre["DiemTB"].ToString() + "</td><td>" + sqlre["Xeploai"].ToString() + "</td><td>" + sqlre["Hocki"].ToString() + "</td><td>" + sqlre["Namhoc"].ToString() + "</td></tr>";
}
sqlre.Close();
ltr_ct_diemsv.Text = kq;
}
catch (Exception ex)
{
Response.Write("Lỗi :" + ex);
}
finally
{
cls_con.close_DB();
}
}
private void LoadTencnDropDownList()
{
cls_connectDB cls_con = new cls_connectDB();
cls_con.connect_DB();
SqlCommand sqlcm = new SqlCommand("Select Macn, Tencn from tbl_chuyennganh order by Tencn", cls_con.sql_con);
SqlDataReader drd = sqlcm.ExecuteReader();
DropDownList2.DataSource = drd;
DropDownList2.DataBind();
}
private void LoadKhoahocDropDownList()
{
cls_connectDB cls_con = new cls_connectDB();
cls_con.connect_DB();
SqlCommand sqlcm = new SqlCommand("Select Makh, Tenkh from tbl_khoahoc order by Makh", cls_con.sql_con);
SqlDataReader drd = sqlcm.ExecuteReader();
DropDownList1.DataSource = drd;
DropDownList1.DataBind();
}
private void LoadMonHocDropdown()
{
cls_connectDB cls_con = new cls_connectDB();
cls_con.connect_DB();
SqlCommand sqlcm = new SqlCommand("Select Tenmh from tbl_monhoc order by Tenmh", cls_con.sql_con);
SqlDataReader drd = sqlcm.ExecuteReader();
DropDownList2.DataSource = drd;
DropDownList2.DataBind();
}
private void LoadSinhVienDropdown()
{
cls_connectDB cls_con = new cls_connectDB();
cls_con.connect_DB();
SqlCommand sqlcm = new SqlCommand("Select Masv, Tensv from tbl_sinhvien order by Tensv", cls_con.sql_con);
SqlDataReader drd = sqlcm.ExecuteReader();
DropDownList1.DataSource = drd;
DropDownList1.DataBind();
}
protected void timkiem_Click(object sender, EventArgs e)
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_key = txt_timkiem.Text.Trim().ToLower();
string st_sql = "Select Masv, Tensv, Ngaysinh, Gioitinh, Email, Diachi, Khoahoc, Tencn from (tbl_sinhvien inner join tbl_chuyennganh on (Chuyennganh = Macn)) Where Masv like '%' + @id + '%' OR lower(Tensv) like N'%' + @id + '%' order by Tensv;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlParameter sqlpa = new SqlParameter();
sqlpa.ParameterName = "@id";
sqlpa.Value = st_key;
sqlcm.Parameters.Add(sqlpa);
SqlDataReader sqlre = sqlcm.ExecuteReader();
int sott = 0;
string kq = "";
string gioitinh = "";
while (sqlre.Read())
{
if (sqlre["gioitinh"].ToString() == "True")
{
gioitinh = "Nữ";
}
else
{
gioitinh = "Nam";
}
sott++;
kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tensv"].ToString() + "</td><td>" + Convert.ToDateTime(sqlre["Ngaysinh"]).ToString("dd/MM/yyyy") + "</td><td>" + gioitinh + "</td><td>" + sqlre["Email"].ToString() + "</td><td>" + sqlre["Diachi"].ToString() + "</td><td>" + sqlre["Khoahoc"].ToString() + "</td><td>" + sqlre["Tencn"].ToString() + "</td><td><a title='Xem chi tiết' href='ChiTietXemDiem.aspx?search=" + sqlre["Masv"].ToString() + "'><i class='fa fa-id-card-o'style='color:#6495ED'></i></a></td></tr>";
}
sqlre.Close();
ltr_quanlysv.Text = kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
public void LoadInfoForm()
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_sql = "Select Masv, Tensv, Ngaysinh, Gioitinh, Email, Diachi, tencn, Khoahoc from tbl_sinhvien inner join tbl_chuyennganh on (Chuyennganh = macn) where Masv = @ma;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
sqlcm.Parameters.Add(new SqlParameter("Ma", Convert.ToInt32(Request.QueryString["search"])));
SqlDataReader sqlre = sqlcm.ExecuteReader();
sqlre.Read();
lbl_masv.Text = sqlre["Masv"].ToString();
lbl_tensv.Text = sqlre["Tensv"].ToString();
if (sqlre["Ngaysinh"] != DBNull.Value)
{
lbl_ngaysinh.Text = Convert.ToDateTime(sqlre["Ngaysinh"]).ToString("dd/MM/yyyy");
}
if (sqlre["Gioitinh"].ToString() == "True")
{
lbl_sex.Text = "Nữ";
}
else if (sqlre["Gioitinh"].ToString() == "False")
{
lbl_sex.Text = "Nam";
}
lbl_email.Text = sqlre["Email"].ToString();
lbl_diachi.Text = sqlre["Diachi"].ToString();
lbl_chuyennganh.Text = sqlre["tencn"].ToString();
lbl_khoahoc.Text = sqlre["Khoahoc"].ToString();
sqlre.Close();
}
catch (Exception ex)
{
Response.Write("Lỗi :" + ex);
}
finally
{
cls_con.close_DB();
}
}
public void LoadDSSinhVien()
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_sql = "SELECT Masv, Tensv, Ngaysinh, Gioitinh, Email, Diachi, Khoahoc, Tencn from tbl_sinhvien inner join tbl_chuyennganh on (Chuyennganh = Macn);";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlDataReader sqlre = sqlcm.ExecuteReader();
int sott = 0;
string st_kq = "";
string gioitinh = "";
while (sqlre.Read())
{
sott++;
if (sqlre["Gioitinh"].ToString() == "True")
{
gioitinh = "Nữ";
}
else
{
gioitinh = "Nam";
}
st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tensv"].ToString() + "</td><td>" + Convert.ToDateTime(sqlre["Ngaysinh"]).ToString("dd/MM/yyyy") + "</td><td>" + gioitinh + "</td><td>" + sqlre["Email"].ToString() + "</td><td>" + sqlre["Diachi"].ToString() + "</td><td>" + sqlre["Khoahoc"].ToString() + "</td><td>" + sqlre["Tencn"].ToString() + "</td><td>" + "<a title='Sửa điểm' href='QuanLySinhVien.aspx?type=edit&id=" + sqlre["Masv"].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a>" + "</td><td>" + "<a title='Xóa điểm' href='QuanlySinhVien.aspx?type=delete&id=" + sqlre["Masv"].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>";
}
sqlre.Close();
ltr_quanlysv.Text = st_kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
protected void timkiem_Click(object sender, EventArgs e)
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_key = txt_timkiem.Text.Trim().ToLower();
string st_sql = "SELECT * FROM tbl_monhoc Where Mamh like '%' + @id + '%' OR lower(Tenmh) like N'%' + @id + '%' order by Mamh;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlParameter sqlpa = new SqlParameter();
sqlpa.ParameterName = "@id";
sqlpa.Value = st_key;
sqlcm.Parameters.Add(sqlpa);
SqlDataReader re = sqlcm.ExecuteReader();
int sott = 0;
string st_kq = "";
while (re.Read())
{
sott++;
st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + re[0].ToString() + "</td><td>" + re[1].ToString() + "</td><td>" + re[2].ToString() + "</td><td>" + re[3].ToString() + "</td><td>" + re[4].ToString() + "</td>";
st_kq = st_kq + "<td><a href='QuanLyMonHoc.aspx?type=update&id=" + re[0].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a></td>";
st_kq = st_kq + "<td><a href='QuanLyMonHoc.aspx?type=delete&id=" + re[0].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>";
}
re.Close();
ltr_monhoc.Text = st_kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
protected void timkiem_Click(object sender, EventArgs e)
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_key = txt_timkiem.Text.Trim().ToLower();
string st_sql = "SELECT Macn, Tencn, tbl_khoa.Tenkhoa from tbl_chuyennganh JOIN tbl_khoa on tbl_chuyennganh.Khoa = tbl_khoa.Makhoa Where Macn like '%' + @id + '%' OR lower(Tencn) like N'%' + @id + '%' order by Macn;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlParameter sqlpa = new SqlParameter();
sqlpa.ParameterName = "@id";
sqlpa.Value = st_key;
sqlcm.Parameters.Add(sqlpa);
SqlDataReader re = sqlcm.ExecuteReader();
int sott = 0;
string st_kq = "";
while (re.Read())
{
sott++;
st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + re[0].ToString() + "</td><td>" + re[1].ToString() + "</td><td>" + re[2].ToString() + "</td>";
st_kq = st_kq + "<td><a href='QuanLyChuyenNganh.aspx?type=update&id=" + re[0].ToString() + "'>Sửa</a></td>";
st_kq = st_kq + "<td><a href='QuanLyChuyenNganh.aspx?type=delete&id=" + re[0].ToString() + "'>Xóa</a></td></tr>";
}
re.Close();
ltr_chuyennganh.Text = st_kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
protected void timkiem_Click(object sender, EventArgs e)
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_key = txt_timkiem.Text.Trim().ToLower();
string st_sql = "SELECT ac.id,ac.Tendn, ac.Matkhau,ac.Hoten,Case ac.Gioitinh when 0 then N'Nam' else N'Nữ' end,ac.Email,q.Tenquyen FROM tbl_acount ac JOIN tbl_qyen q ON ac.Quyen = q.id WHERE tbl_acount.id=@ma Where id like '%' + @id + '%' OR lower(Hoten) like N'%' + @id + '%' order by id;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlParameter sqlpa = new SqlParameter();
sqlpa.ParameterName = "@id";
sqlpa.Value = st_key;
sqlcm.Parameters.Add(sqlpa);
SqlDataReader re = sqlcm.ExecuteReader();
int sott = 0;
string st_kq = "";
while (re.Read())
{
sott++;
st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + re[0].ToString() + "</td><td>" + re[1].ToString() + "</td><td>" + re[2].ToString() + "</td><td>" + re[3].ToString() + "</td><td>" + re[4].ToString() + "</td><td>" + re[5].ToString() + "</td><td>" + re[6].ToString() + "</td>";
st_kq = st_kq + "<td><a href='QuanLyNguoiDung.aspx?type=update&id=" + re[0].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a></td>";
st_kq = st_kq + "<td><a href='QuanLyNguoiDung.aspx?type=delete&id=" + re[0].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>";
}
re.Close();
ltr_acc.Text = st_kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
protected void lbt_search_Click(object sender, EventArgs e)
{
cls_connectDB cls_con = new cls_connectDB();
try
{
cls_con.connect_DB();
string st_key = tbx_key.Text.Trim().ToLower();
string st_sql = "Select Masv, Tenmh, DiemC, DiemB, Diemthilan1, Diemthilan2, DiemTB, Xeploai, tbl_diem.Hocki, Namhoc From (tbl_diem inner join tbl_monhoc on (Monhoc=Mamh)) Where Masv like '%' + @id + '%' OR lower(Tenmh) like N'%' + @id + '%' order by Masv;";
SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con);
SqlParameter sqlpa = new SqlParameter();
sqlpa.ParameterName = "@id";
sqlpa.Value = st_key;
sqlcm.Parameters.Add(sqlpa);
SqlDataReader sqlre = sqlcm.ExecuteReader();
int sott = 0;
string kq = "";
while (sqlre.Read())
{
sott++;
kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tenmh"].ToString() + "</td><td>" + sqlre["DiemC"].ToString() + "</td><td>" + sqlre["DiemB"].ToString() + "</td><td>" + sqlre["Diemthilan1"].ToString() + "</td><td>" + sqlre["Diemthilan2"].ToString() + "</td><td>" + sqlre["DiemTB"].ToString() + "</td><td>" + sqlre["Xeploai"].ToString() + "</td><td>" + sqlre["Hocki"].ToString() + "</td><td>" + sqlre["Namhoc"].ToString() + "</td><td><a title='Sửa điểm' href='QuanlyDiem.aspx?type=edit&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a>" + "</td><td>" + " <a title='Xóa điểm' href='QuanlyDiem.aspx?type=delete&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>";
}
sqlre.Close();
ltr_dsdiem.Text = kq;
lbl_timkiem.Text = "Có " + sott + " kết quả";
}
catch (Exception ex)
{
Response.Write("Lỗi: " + ex);
}
finally
{
cls_con.close_DB();
}
}
