public bool suaHangVe(HangVe hV) { SqlConnection sqlConnection = createConnection(); try { sqlConnection.Open(); string SQL = "UPDATE HANG_VE SET TenHV = N'" + hV.TenHV + "', GhiChu = N'" + hV.GhiChu + "' WHERE MaHV = '" + hV.MaHV + "'"; SqlCommand cmd = new SqlCommand(SQL, sqlConnection); // Query và kiểm tra if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception e) { throw e; } finally { // Dong ket noi sqlConnection.Close(); } return(false); }
public bool themHangVe(HangVe hV) { SqlConnection sqlConnection = createConnection(); try { sqlConnection.Open(); //SqlCommand cmd = new SqlCommand("INSERT INTO SAN_BAY(MaSB,TenSB) VALUES ('" + txtMaSB.Text + "',N'" + txtTenSB.Text + "')", con); string SQL = "INSERT INTO HANG_VE(MaHV, TenHV, GhiChu) VALUES ('" + hV.MaHV + "', N'" + hV.TenHV + "',N'" + hV.GhiChu + "')"; SqlCommand cmd = new SqlCommand(SQL, sqlConnection); // Query và kiểm tra if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception e) { throw e; } finally { // Dong ket noi sqlConnection.Close(); } return(false); }