public void updateModel(tblDocGiaModel docGia) { // sql = "Update tblDocGia set HOTEN=N'" + docGia.HoTen + "',NGAYSINH='" + docGia.NgaySinh + "',GIOITINH=N'" + docGia.GioiTinh + "',LOP='" + docGia.Lop + "',DIACHI=N'" + docGia.DiaChi + "',EMAIL='" + docGia.Email + "',GHICHU=N'" + docGia.GhiChu + "' where MADG='" + docGia.MaDocGia + "'"; //connectSer.ThucThiSQLTheoPhiKetNoi(sql); sqlCom = new SqlCommand(); sqlCom.CommandType = CommandType.StoredProcedure; sqlCom.CommandText = "USP_UpdateDocGia"; sqlCom.Parameters.Add("@MADG", SqlDbType.VarChar).Value = docGia.MaDocGia; sqlCom.Parameters.Add("@HOTEN", SqlDbType.NVarChar).Value = docGia.HoTen; sqlCom.Parameters.Add("@NGAYSINH", SqlDbType.VarChar).Value = docGia.NgaySinh; sqlCom.Parameters.Add("@GIOITINH", SqlDbType.NVarChar).Value = docGia.GioiTinh; sqlCom.Parameters.Add("@LOP", SqlDbType.VarChar).Value = docGia.Lop; sqlCom.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = docGia.DiaChi; sqlCom.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = docGia.Email; sqlCom.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = docGia.GhiChu; sqlCom.Connection = connectSer.Connect(); sqlCom.ExecuteNonQuery(); }
public void createModel(tblDocGiaModel docGia) { //string sql = "Insert Into tblDocGia(MADG,HOTEN,NGAYSINH,GIOITINH,LOP,DIACHI,EMAIL,GHICHU) values ('" + docGia.MaDocGia + "',N'" + docGia.HoTen + "','" + docGia.NgaySinh + "',N'" + docGia.GioiTinh + "','" + docGia.Lop + "',N'" + docGia.DiaChi + "','" + docGia.Email + "',N'" + docGia.GhiChu + "')"; //connectSer.ThucThiSQLTheoPhiKetNoi(sql); sqlCom = new SqlCommand(); sqlCom.CommandType = CommandType.StoredProcedure; sqlCom.CommandText = "USP_InsertDocGia"; sqlCom.Parameters.Add("@MADG", SqlDbType.VarChar).Value = docGia.MaDocGia; sqlCom.Parameters.Add("@HOTEN", SqlDbType.NVarChar).Value = docGia.HoTen; sqlCom.Parameters.Add("@NGAYSINH", SqlDbType.VarChar).Value = docGia.NgaySinh; sqlCom.Parameters.Add("@GIOITINH", SqlDbType.NVarChar).Value = docGia.GioiTinh; sqlCom.Parameters.Add("@LOP", SqlDbType.VarChar).Value = docGia.Lop; sqlCom.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = docGia.DiaChi; sqlCom.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = docGia.Email; sqlCom.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = docGia.GhiChu; sqlCom.Connection = connectSer.Connect(); sqlCom.ExecuteNonQuery(); }