public void UpdateHocSinh(HOCSINHDTO hs) { string query = string.Format("UPDATE HOCSINH set TenHocSinh = N'{0}', " + "NgaySinh = '{1}', DiaChi = N'{2}', " + "Email = '{3}', GioiTinh = N'{4}' " + "WHERE MaHocSinh = '{5}'", hs.TenHocSinh, hs.NgaySinh, hs.DiaChi, hs.Email, hs.GioiTinh, hs.MaHocSinh); SqlProvider.ExecuteNoneQuery(query); }
public void InsertHocSinh(HOCSINHDTO hs) { string prefix = "HS100"; int n = int.Parse(hs.MaHocSinh.Substring(5)); while (CheckIDisUse(hs.MaHocSinh)) { n++; hs.MaHocSinh = string.Format("{0}{1}", prefix, n); } string query = "INSERT INTO HOCSINH(MaHocSinh, TenHocSinh, GioiTinh, NgaySinh, DiaChi, Email) VALUES (N'" + hs.MaHocSinh + "',N'" + hs.TenHocSinh + "',N'" + hs.GioiTinh + "',N'" + hs.NgaySinh + "',N'" + hs.DiaChi + "',N'" + hs.Email + "')"; SqlProvider.ExecuteNoneQuery(query); }