public void insertGiaoVien(GiaoVien gv) { string query = string.Format("INSERT dbo.GIAOVIEN VALUES ( N'{0}' ,N'{1}' , '{2}' , N'{3}' , N'{4}' , N'{5}',N'{6}')", gv.HoTen, gv.GioiTinh, gv.NgaySinh.ToShortDateString(), gv.NoiSinh, gv.DiaChi, gv.ChuyenMon, gv.SoDienThoai); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void deleteGiaoVien(int id) { string query = string.Format("DELETE dbo.GIAOVIEN WHERE MAGIAOVIEN={0}", id); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void deleteMonHoc(int id) { string query = string.Format("DELETE dbo.MONHOC WHERE MAMONHOC={0}", id); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void SuaMonHoc(MonHoc mh) { string query = string.Format("UPDATE dbo.MONHOC SET TENMONHOC='{1}' WHERE MAMONHOC={0}", mh.MaMonHoc, mh.TenMonHoc); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void insertLOP(Lop l) { string query = string.Format("INSERT dbo.LOP VALUES ( N'{0}', N'{1}' , N'{2}' )", l.TenLop, l.SiSo, l.MaGVCN); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void insertMonHoc(MonHoc mh) { string query = string.Format("INSERT dbo.MONHOC VALUES ( N'{0}')", mh.TenMonHoc); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void SuaLop(Lop l) { string query = string.Format("UPDATE dbo.LOP SET TENLOP ='{0}' , SISO='{1}', MA_GVCHUNHIEM='{2}'WHERE MALOP= {3}", l.TenLop, l.SiSo, l.MaGVCN, l.MaLop); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void SuaHocSinh(HocSinh hs) { string query = string.Format("UPDATE dbo.HOCSINH SET HOTEN ='{0}' ,GIOITINH='{1}',NGAYSINH='{2}',NOISINH='{3}',DANTOC='{4}',TONGIAO='{5}' WHERE MAHOCSINH= {6}", hs.HoTen, hs.GioiTinh, hs.NgaySinh.ToShortDateString(), hs.NoiSinh, hs.DanToc, hs.TonGiao, hs.MaHocSinh); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void SuaGiaoVien(GiaoVien gv) { string query = string.Format("UPDATE dbo.GiaoVien SET HOTEN ='{0}' ,GIOITINH='{1}',NGAYSINH='{2}',NOISINH='{3}',DIACHI='{4}',CHUYENMON='{5}', SODIENTHOAI='{6}' WHERE MAHOCSINH= {7}", gv.HoTen, gv.GioiTinh, gv.NgaySinh.ToShortDateString(), gv.NoiSinh, gv.DiaChi, gv.ChuyenMon, gv.SoDienThoai, gv.MaGiaoVien); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void deleteHocSinh(int id) { string query = string.Format("DELETE dbo.HOCSINH WHERE MAHOCSINH={0}", id); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void insertHocSinh(HocSinh hs) { string query = string.Format("INSERT dbo.HOCSINH VALUES ( N'{0}' ,N'{1}' , '{2}' , N'{3}' , N'{4}' , N'{5}')", hs.HoTen, hs.GioiTinh, hs.NgaySinh.ToShortDateString(), hs.NoiSinh, hs.DanToc, hs.TonGiao); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void insertLOP(Lop l) { // string query = string.Format("INSERT dbo.LOP VALUES ( N'{0}', N'{1}' , N'{2}' )", l.TenLop, l.SiSo, l.MaGVCN); string query = string.Format("dbo.themLop @teblop = '{0}', @siso = {1}, @magv = {2}", l.TenLop, l.SiSo, l.MaGVCN); DatabaseConnect dtConnet = new DatabaseConnect(); dtConnet.ExecuteNonQuery(query); }
public void doiMatKhau(string username, string oldpassword, string newpassword) { string query = string.Format("UPDATE dbo.ACCOUNT SET PASSWORD='******' WHERE USERNAME='******'AND PASSWORD='******'", newpassword, username, oldpassword); dtconnect.ExecuteNonQuery(query); }
// them 1 mon hoc vao lop public void insertMonLop(int maLop, int maMon, int maGV) { string query = string.Format("INSERT dbo.LOP_MON ( MAMONHOC, MALOP, MAGIAOVIEN ) VALUES( {0}, {1}, {2} )", maMon, maLop, maGV); dtConnect.ExecuteNonQuery(query); }
public void updateBangdiem(BangDiem bd) { string query = string.Format("UPDATE dbo.BANGDIEM SET HOCKY={0}, DIEM15PHUT={1},DIEMMIENG={2},DIEM1TIET={3},DIEMHK={4},DIEMTB={5} WHERE MAHOCSINH={6} AND MAMONHOC={7} ", bd.HocKi, bd.DiemMieng, bd.Diem15ph, bd.Diem1tiet, bd.DiemCuoiKi, bd.DiemTB, bd.MaHocSinh, bd.MaMon); dtConnect.ExecuteNonQuery(query); }
public void PhanCong(int maMon, int maLop, int maGV) { string query = string.Format("UPDATE dbo.LOP_MON SET MAGIAOVIEN={0} WHERE MAMONHOC={1} AND MALOP={2}", maGV, maMon, maLop); dtConnect.ExecuteNonQuery(query); }