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);
}