protected void btn_Dangky_Click(object sender, EventArgs e)
{
string id = "select Max(IDThanhvien) from THANHVIEN";
DataTable tb_id = ketnoi.getData(id);
int mathanhvien;
if (tb_id.Rows.Count == 0)
{
mathanhvien = 1;
}
else
{
mathanhvien = Int32.Parse(tb_id.Rows[0][0].ToString());
}
string tendangnhap = "select Tendangnhap from TENDANGNHAP where Tendangnhap='" + Session["Tendangnhap"].ToString() + "'";
DataTable tb_tendangnhap = ketnoi.getData(tendangnhap);
if (txt_hoten.Text == "")
{
Response.Write("<script>alert('Họ tên không được bỏ trống!')</script>");
}
else if (txt_tendangnhap.Text == "")
{
Response.Write("<script>alert('Tên đăng nhập không được bỏ trống')</script>");
}
else if (tb_tendangnhap.Rows.Count > 0)
{
Response.Write("<script>alert('Tên đăng nhập đã tồn tại')</script>");
}
else if (txt_matkhau.Text == "")
{
Response.Write("<script>alert('Mật khẩu không được bỏ trống')</script>");
}
else if (txt_matkhau.Text.Trim() != txt_nhaplaimatkhau.Text.Trim())
{
Response.Write("<script>alert('Mật khẩu nhập lại không trùng khớp')</script>");
}
else
{
string gioitinh;
if (rd_nam.Checked)
{
gioitinh = "Nam";
}
else
{
gioitinh = "Nữ";
}
string dangky = "insert into THANHVIEN values('" + (mathanhvien + 1) + "',N'" + txt_hoten.Text + "','" + txt_tendangnhap.Text + "','" +
txt_matkhau.Text + "',2,'" + txt_ngaysinh.Text + "','" + gioitinh + "',N'" + txt_noisinh.Text + "',N'" + txt_diachi.Text + "','" + txt_sodienthoai.Text + "', '" + txt_email.Text + "',N'" + dr_nghenghiep.Text + "')";
try
{
ketnoi.executeQuery(dangky);
Response.Write("<script> alert('Đăng ký thành công!'); </script>");
}
catch { Response.Write("<script> alert('Đăng ký không thành công!'); </script>"); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["chude"].ToString();
string sql = "select * from CHUDE_NGUPHAP where IDChude=N'" + id.Trim() + "'";
DataTable tb = ketnoi.getData(sql);
txt_tieude.Text = tb.Rows[0]["Tenchude"].ToString().ToUpper();
txt_tieude2.Text = tb.Rows[0]["Tenchude"].ToString().ToUpper();
string nguphap = "select * from NGUPHAP where IDChude='" + tb.Rows[0]["IDChude"].ToString() + "'";
Repeater1.DataSource = ketnoi.getData(nguphap);
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string chude = Request.QueryString["chude"].ToString();
string sql = "select * from TUVUNG a, CHUDE_TUVUNG b where a.IDChude = b.IDChude and b.Tenchude=N'" + chude + "'";
rpt_tuvung.DataSource = ketnoi.getData(sql);
rpt_tuvung.DataBind();
string sql_chude = "select * from CHUDE_TUVUNG where Tenchude=N'" + chude + "'";
DataTable tb = ketnoi.getData(sql_chude);
txt_tuvung.Text = tb.Rows[0]["Tenchude"].ToString().ToUpper();
txt_tieude.Text = tb.Rows[0]["Tenchude"].ToString().ToUpper();
}
protected void btn_capnhat_Click(object sender, EventArgs e)
{
int id;
string sql = "select Max(IDTinmoi) from TINMOI";
DataTable tb_id = ketnoi.getData(sql);
try
{
id = Int32.Parse(tb_id.Rows[0][0].ToString());
}
catch {
id = 0;
}
HttpFileCollection fileCollection = Request.Files;
for (int i = 0; i < fileCollection.Count; i++)
{
HttpPostedFile uploadfile = fileCollection[i];
string fileName = Path.GetFileName(uploadfile.FileName);
if (uploadfile.ContentLength > 0)
{
uploadfile.SaveAs(Server.MapPath("~/images/") + fileName);
string sql_tinmoi = "insert into TINMOI values('0" + (id + 1) + "',N'" + txt_tieude.Text + "','" + txt_ngaydang.Text + "',N'" + txt_rutgon.Text + "',N'" + txt_doanvan.Text + "','" + fileName + "')";
ketnoi.executeQuery(sql_tinmoi);
Response.Write("<script> alert('Thêm mới thành công!'); window.location.href='Admin_tintuc.aspx';</script>");
}
else
{
Response.Write("<script> alert('Thêm mới không thành công!'); window.location.href='Admin_tintuc.aspx';</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string dangky = "select * from THANHVIEN where Tendangnhap='" + Session["Tendangnhap"].ToString() + "'";
DataTable tb_dangky = ketnoi.getData(dangky);
txt_hoten.Text = tb_dangky.Rows[0]["Hoten"].ToString().Trim();
string gioitinh = tb_dangky.Rows[0]["Gioitinh"].ToString().Trim();
if (gioitinh == "Nam")
{
rd_nam.Checked = true;
}
else
{
rd_nu.Checked = true;
}
DateTime dt = DateTime.Parse(tb_dangky.Rows[0]["Ngaysinh"].ToString().Trim());
txt_ngaysinh.Text = dt.ToString("yyyy-MM-dd");
txt_noisinh.Text = tb_dangky.Rows[0]["Noisinh"].ToString().Trim();
txt_diachi.Text = tb_dangky.Rows[0]["Diachi"].ToString().Trim();
txt_sodienthoai.Text = tb_dangky.Rows[0]["Sodienthoai"].ToString().Trim();
txt_email.Text = tb_dangky.Rows[0]["Email"].ToString().Trim();
dr_nghenghiep.Text = tb_dangky.Rows[0]["Nghenghiep"].ToString().Trim();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string bangdiem = "select Convert(nchar(10), a.Ngaykiemtra,103) as Ngaykiemtra, * from BANGDIEM a, THANHVIEN b where a.IDThanhvien=b.IDThanhvien and b.Tendangnhap='" + Session["tendangnhap"].ToString() + "'";
Repeater1.DataSource = ketnoi.getData(bangdiem);
Repeater1.DataBind();
}
protected void btn_Dangky_Click(object sender, EventArgs e)
{
string kiemtra = "select * from THANHVIEN where Tendangnhap='" + Session["tendangnhap"] + "' and Matkhau='" + txt_matkhaucu.Text + "'";
DataTable tb_kiemtra = ketnoi.getData(kiemtra);
if (tb_kiemtra.Rows.Count > 0)
{
if (txt_matkhaumoi.Text.Trim() != txt_nhaplaimatkhaumoi.Text.Trim())
{
Response.Write("<script> alert('Mật khẩu không trùng khớp!')</script>");
}
else
{
string sql = "update THANHVIEN set Matkhau='" + txt_matkhaumoi.Text + "' where Tendangnhap='" + Session["tendangnhap"].ToString() + "'";
try
{
ketnoi.executeQuery(sql);
Response.Write("<script> alert('Mật khẩu đã được thay đổi!'), window.location.href='Default.aspx'; </script>");
}
catch
{
Response.Write("<script> alert('Mật khẩu thay đổi không thành công!')</script>");
}
}
}
else
{
Response.Write("<script> alert('Mật khẩu không chính xác!')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
double id;
string sql = "select MAX(IDNguphap) from NGUPHAP";
DataTable tb_id = ketnoi.getData(sql);
if (tb_id.Rows[0][0].ToString() == "")
{
id = 1;
}
else
{
id = Int32.Parse(tb_id.Rows[0][0].ToString()) + 1;
}
string insert = "insert into NGUPHAP values('" + id + "',N'" + txt_noidung.Text + "','','','" + dr_tennguphap.Text + "','Grammar')";
try
{
ketnoi.executeQuery(insert);
Response.Write("<script>alert('Thêm mới thành công'); window.location.href='Admin-Nguphap.aspx' </script>");
}
catch {
Response.Write("<script>alert('Thêm mới không thành công'); </script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string maxid = "select MAX(IDlienhe) from LIENHE";
DataTable tb_max = ketnoi.getData(maxid);
int id;
if (tb_max.Rows[0][0].ToString() == "")
{
id = 1;
}
else
{
id = Int32.Parse(tb_max.Rows[0][0].ToString()) + 1;
}
string lienhe = "insert into LIENHE values('" + id + "',N'" + txt_hoten.Text + "','" + txt_email.Text + "',N'" + txt_nghenghiep.Text + "','" + txt_sodienthoai.Text + "',N'" + txt_noidung.Text + "')";
try
{
ketnoi.executeQuery(lienhe);
Response.Write("<script> alert('Gửi thành công!');</script>");
}
catch {
Response.Write("<script> alert('Gửi không thành công!');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
string sql_kinhnghiem = "select Convert(nchar(10),Ngaydang,103) as Ngaydang, * from KINHNGHIEM where IDKinhnghiem='" + id + "'";
rpt_noidung.DataSource = ketnoi.getData(sql_kinhnghiem);
rpt_noidung.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string nguphap = "select * from NGUPHAP";
Repeater1.DataSource = ketnoi.getData(nguphap);
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql = "select * from LIENHE";
Repeater1.DataSource = ketnoi.getData(sql);
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql_cauhoi = "select convert(nchar(10),Ngaydang,103) as Ngaydang,* from TINMOI";
Repeater1.DataSource = ketnoi.getData(sql_cauhoi);
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql = "select * from TUVUNG a, CHUDE_TUVUNG b where a.IDChude = b.IDChude";
rpt_tuvung.DataSource = ketnoi.getData(sql);
rpt_tuvung.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dangnhapthanhcong.Visible = false;
if (Session["tendangnhap"] == null)
{
dangnhap.Visible = true;
dangnhapthanhcong.Visible = false;
dangky.Visible = true;
dangxuat.Visible = false;
thanhvien.Visible = false;
}
else
{
string hoten = "select Hoten from THANHVIEN where Tendangnhap='" + Session["tendangnhap"].ToString() + "'";
DataTable tb_hoten = ketnoi.getData(hoten);
txt_hoten.Text = tb_hoten.Rows[0][0].ToString();
thanhvien.Visible = true;
int phanquyen = Int32.Parse(Session["phanquyen"].ToString());
if (phanquyen == 1)
{
dangnhapthanhcong.HRef = "admin_thongke.aspx";
}
else
{
dangnhapthanhcong.HRef = "Chinhsua_Dangky.aspx";
}
lbl_username.Text = Session["tendangnhap"].ToString();
dangnhap.Visible = false;
dangnhapthanhcong.Visible = true;
dangky.Visible = false;
dangxuat.Visible = true;
}
string sql_diemthi = "select TOP 10 * from BANGDIEM a, THANHVIEN b where a.IDThanhvien = b.IDThanhvien order by Tongdiem DESC";
rpt_diemthi.DataSource = ketnoi.getData(sql_diemthi);
rpt_diemthi.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"].ToString();
string sql = "select * from TINMOI where Noidung like N'%" + id.Trim() + "%' or Tieude like N'%" + id.Trim() + "%'";
rpt_tinmoi.DataSource = ketnoi.getData(sql);
rpt_tinmoi.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["macauhoi"].ToString();
string sql_cauhoi = "select * from CAUHOI a, DAPAN b where a.IDCauhoi =b.IDCauhoi and b.IDCauhoi='" + id + "'";
Repeater1.DataSource = ketnoi.getData(sql_cauhoi);
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage master = this.Master as MasterPage;
master.BodyId = "grammar";
string sql = "select * from CHUDE_NGUPHAP";
rpt_tuvung.DataSource = ketnoi.getData(sql);
DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage master = this.Master as MasterPage;
master.BodyId = "Toeic";
string sql = "select * from GIAODIEN where IDGiaodien ='gioithieu'";
Repeater1.DataSource = ketnoi.getData(sql);
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage master = this.Master as MasterPage;
master.BodyId = "lv880";
string sql = "select * from DETHI where Loaide='880-990'";
rpt_dethi.DataSource = ketnoi.getData(sql);
rpt_dethi.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"].ToString();
string sql = "select * from NGUPHAP where IDNguphap='" + id + "'";
DataTable tb_sql = ketnoi.getData(sql);
txt_noidung.Text = tb_sql.Rows[0]["Noidung"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"].ToString();
string nguphap = "select * from NGUPHAP a, CHUDE_NGUPHAP b where a.IDChude = b.IDChude and IDNguphap='" + id + "'";
DataTable tb_nguphap = ketnoi.getData(nguphap);
dr_tennguphap.Text = tb_nguphap.Rows[0]["Tenchude"].ToString();
txt_noidung.Text = tb_nguphap.Rows[0]["Noidung"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"];
string sql = "select * from DONGHO where IdDongho='" + id + "'";
DataTable tb_dongho = ketnoi.getData(sql);
txt_loai.Text = tb_dongho.Rows[0]["Phan"].ToString();
txt_phut.Text = tb_dongho.Rows[0]["Phut"].ToString();
txt_giay.Text = tb_dongho.Rows[0]["Giay"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"];
string sql = "select * from THANHVIEN where Tendangnhap='" + id + "'";
DataTable dt = ketnoi.getData(sql);
txt_tendangnhap.Text = dt.Rows[0]["Tendangnhap"].ToString();
txt_matkhau.Text = dt.Rows[0]["Matkhau"].ToString();
dr_phanquyen.Text = dt.Rows[0]["Phanquyen"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql_noidung = "select COUNT(b.IDCauhoi) as soluong, c.IDNoidung from CHITIETNOIDUNG a, CAUHOI b, NOIDUNG c where a.IDNoidungchitiet=b.IDNoidung and a.IDNoidung=c.IDNoidung group by c.IDNoidung";
Repeater1.DataSource = ketnoi.getData(sql_noidung);
Repeater1.DataBind();
string sql_tintuc = "select COUNT(IDTinmoi) as soluong from TINMOI";
rpt_tintuc.DataSource = ketnoi.getData(sql_tintuc);
rpt_tintuc.DataBind();
string sql_kinhnghiem = "select COUNT(IDKinhnghiem) as soluong from KINHNGHIEM";
rpt_kinhnghiem.DataSource = ketnoi.getData(sql_kinhnghiem);
rpt_kinhnghiem.DataBind();
string sql_tuvung = "select COUNT(IDTuvung) as soluong from TUVUNG";
rpt_tuvung.DataSource = ketnoi.getData(sql_tuvung);
rpt_tuvung.DataBind();
string sql_nguphap = "select COUNT(IDNguphap) as soluong from NGUPHAP";
rpt_nguphap.DataSource = ketnoi.getData(sql_nguphap);
rpt_nguphap.DataBind();
for (int i = 0; i < Repeater1.Items.Count; i++)
{
Label lb = (Label)Repeater1.Items[i].FindControl("txt_soluong");
string sql = "select COUNT(a.IDNoidungchitiet) as soluong2, c.IDNoidung from CHITIETNOIDUNG a, NOIDUNG c where a.IDNoidung=c.IDNoidung group by c.IDNoidung";
DataTable tb_sql = ketnoi.getData(sql);
lb.Text = tb_sql.Rows[i]["soluong2"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["dethi"].ToString();
string sql_dethi = "select Tende from DETHI where Made='" + id + "'";
DataTable tb_dethi = ketnoi.getData(sql_dethi);
txt_dethi.Text = tb_dethi.Rows[0][0].ToString().ToUpper();
txt_dethi2.Text = tb_dethi.Rows[0][0].ToString().ToUpper();
string sql_Phutnghe = "select * from DONGHO where IDDongho='03'";
rpt_dongho.DataSource = ketnoi.getData(sql_Phutnghe);
rpt_dongho.DataBind();
string sql_docdientu = "select * from CAUHOI where IDNoidung='DoublePassage'";
Rpt_nghe.DataSource = ketnoi.getData(sql_docdientu);
Rpt_nghe.DataBind();
for (int i = 0; i < Rpt_nghe.Items.Count; i++)
{
Label a = (Label)Rpt_nghe.Items[i].FindControl("A");
Label b = (Label)Rpt_nghe.Items[i].FindControl("B");
Label c = (Label)Rpt_nghe.Items[i].FindControl("C");
Label d = (Label)Rpt_nghe.Items[i].FindControl("D");
try
{
string sql = "select * from DAPAN where IDCauhoi ='1_Double_" + (i + 1) + "'";
DataTable tb = ketnoi.getData(sql);
a.Text = tb.Rows[0]["NDDA"].ToString();
b.Text = tb.Rows[1]["NDDA"].ToString();
c.Text = tb.Rows[2]["NDDA"].ToString();
d.Text = tb.Rows[3]["NDDA"].ToString();
}
catch {}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Admin master = this.Master as Admin;
master.BodyId = "Gioithieu";
if (!IsPostBack)
{
string sql = "select * from GIAODIEN where IDGiaodien='gioithieu'";
DataTable dt = ketnoi.getData(sql);
txt_doanvan.Text = dt.Rows[0]["Noidung"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FileUpload1.Visible = false;
try
{
string id = Request.QueryString["id"].ToString();
string kinhnghiem = "select * from KINHNGHIEM where IDKinhnghiem='" + id + "'";
DataTable tb_kinhnghiem = ketnoi.getData(kinhnghiem);
txt_tieude.Text = tb_kinhnghiem.Rows[0]["Tieude"].ToString();
DateTime ngaysinh = DateTime.Parse(tb_kinhnghiem.Rows[0]["Ngaydang"].ToString());
txt_ngaydang.Text = ngaysinh.ToString("yyyy-MM-dd");
txt_rutgon.Text = tb_kinhnghiem.Rows[0]["Noidungrutgon"].ToString();
txt_doanvan.Text = tb_kinhnghiem.Rows[0]["Noidung"].ToString();
idhinhanh = tb_kinhnghiem.Rows[0]["Hinhanh"].ToString();
}
catch { }
}
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage master = this.Master as MasterPage;
master.BodyId = "Kinhnghiem";
try
{
string sql_tinmoi = "select convert(nchar(10),Ngaydang,103) as Ngaydang,* from KINHNGHIEM order by convert(nchar(10),Ngaydang,103) DESC";
rpt_tinmoi.DataSource = ketnoi.getData(sql_tinmoi);
rpt_tinmoi.DataBind();
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage master = this.Master as MasterPage;
master.BodyId = "Home";
try
{
string sql_gioithieu = "select * from GIAODIEN where IDGiaodien='gioithieu'";
rpt_Gioithieu.DataSource = ketnoi.getData(sql_gioithieu);
rpt_Gioithieu.DataBind();
string sql_tinmoi = "select TOP 3 convert(nchar(10),Ngaydang,103) as Ngaydang,* from TINMOI order by convert(nchar(10),Ngaydang,103) DESC";
rpt_tinmoi.DataSource = ketnoi.getData(sql_tinmoi);
rpt_tinmoi.DataBind();
string sql_kinhnghiem = "select TOP 3 convert(nchar(10),Ngaydang,103) as Ngaydang,* from KINHNGHIEM order by convert(nchar(10),Ngaydang,103) DESC";
rpt_kinhnghiem.DataSource = ketnoi.getData(sql_kinhnghiem);
rpt_kinhnghiem.DataBind();
}
catch { }
}